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

Create filter on Database Object

In this example we have a set of data in a table witch has multiple of rows for each date.

In the Cognos report we want to filter the data for a specific date (or value).

We can solve this by adding a filter on the business view object in the Framework Manager (FM). This filter is a prompt witch pops up on opening the report. Continue reading