If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter in DMR

Started by daya007, 02 Aug 2010 04:19:34 PM

Previous topic - Next topic

daya007

Hi I have a time dimension which has hierarchy as Total Year->Years->Quarters->Months
How can i dynamically filter time dim so that it shows current month.

peritas-chris

You will need to base it on some sort of rule.  Are you just trying to find the last month in the time dimension (ie the latest month)?  If so, you can use the tail() function (among others) to get the last member in a specific level.  Any more information you have would help me suggest a solution. Thanks!