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

Month/Year DatePicker Selection

Started by stancho, 24 Jan 2011 03:45:21 PM

Previous topic - Next topic

stancho

Hi all,

How can I have a date prompt for selecting only month (and year) but NOT a date?

Stancho

RobsWalker68

Hi,

For Month and or Month Year then use a value prompt instead of the date prompt

Rgds


Rob


stancho

Yep
you mean to have 2 parameters for both year and month instead of one for date.

Thanks,
Stancho

RobsWalker68

Hi,

You have a number of ways to do this and yes you could create two prompts if you wanted for the year and the month name/number. 

Alternatively, you could create an item that concatenates the year and month together e.g. 2011 January and use that to supply the value prompt.  You will also need a sort key for the ordering.

Ideally place the Year Month in either your date dimension or create the concatenation in the relevant query subject in Framework Manager.

Rgds

Rob

 

stancho

Thanks Rob,

maybe the best decision is using two prompts....