Print Page - Month/Year DatePicker Selection

Title: Month/Year DatePicker Selection
Post by: stancho on 24 Jan 2011 03:45:21 PM

Hi all,

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

Stancho

Title: Re: Month/Year DatePicker Selection
Post by: RobsWalker68 on 24 Jan 2011 04:12:11 PM

Hi,

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

Rgds

Rob

Title: Re: Month/Year DatePicker Selection
Post by: stancho on 26 Jan 2011 02:38:33 AM

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

Thanks,
Stancho

Title: Re: Month/Year DatePicker Selection
Post by: RobsWalker68 on 26 Jan 2011 05:50:13 AM

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

Title: Re: Month/Year DatePicker Selection
Post by: stancho on 15 Feb 2011 03:14:24 AM

Thanks Rob,

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stancho on 24 Jan 2011 03:45:21 PM