Dynamic current month selection

I found some interesting knowlegde on getting the current month dynamicly as a filter in Cognos. Here are the steps how:

Expand your time dimension and select any month member (Members are the one with the blue rectangle icon).

Right click on the member and select Properties, and you will see there a property called Member Unique Name. This is usually structured like this: [cube].[dimension].[hierarchy].[level]->:[PC].[@MEMBER].[Name]

Once you have that, copy it. Look at the structure – we’re interested in the last bit – how is a month MUN constructed.
For our example, we’ll suppose it is built like this:[Sales].[Time].[Time].[Month]->[Time].[2010].[201003] (That’s March 2010, yyyymm).
So, you create a data item like this:
#'[Sales].[Time].[Time].[Month]->[Time].[‘+ timestampMask($current_timestamp,’yyyy’)+’].[‘+timestampMask($current_timestamp,’yyyy’)+timestampMask($current_timestamp,’mm’)+’]’#

Which will dynamically translate (Today) to [Sales].[Time].[Time].[Month]->[Time].[2014].[201402]

Item was written by Nimrod Avissar on Cognoise.com