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

Default value in Financial Period Prompt

Started by colt, 07 May 2010 10:05:15 AM

Previous topic - Next topic

colt

Hi,
in my report I have a Prompt to chose Financial Period which is part of the DATE Dimension within a cube.
I want this prompt to default to the last closed period. That means if actual date is in MAY, the last
closed period is 04. Due to Budget-Data, there are also future Periods within the selection of the prompt.
Therefore it's not just a question of sorting data descending and taking the first entry.
Default value should be valid for all ouptut-formats. (HTML,PDF,...)

Any ideas how to solve this ?