Cognos - value prompt to display months from january to december

393 Views Asked by At

For a monthly report need to display the months January to December in the value prompt. Could you please advise how to achieve this.

1

There are 1 best solutions below

3
On

Welcome Immi

I do not know what data items are available on the package you are using

However, you can create static values with a value prompt Look in properties for the value prompt, static. Select the ellipsis Then add the values

Depending on the version of Cognos, you can search the data items (worst case do this manually, maybe you will luck out and there is a query subject for dates). Look around and see if months is in the package. If they exist, add them to the value prompt query subject and give it a try

Also to consider, your take may require 13 month accounting, displaying the month name won't work in that case.

As far as value prompts there is a display value and a use value The month name can be the display value and if you need for filtering the month #, that can be the use value.

https://www.ibm.com/docs/en/opw/8.0.0?topic=prompts-adding-static-choices-prompt