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

multiple entries of months on prompt

Started by ajhuzky, 19 Mar 2009 07:54:29 AM

Previous topic - Next topic

ajhuzky

Hi!

Maybe someone can help me how I can remove multiple items in a single prompt.
Example: Months --> prompt shows like this
                       January
                       January
                       January
                       February
                       ....
up to                December

What I need is January up to December. Is it a Report Level issue or a Dimensional Model issue?

Hope someone can help..  :(

thanks!

DanSev

This depends on the query you are using to populate the prompt. If you are pulling this data from a detailed table (many records for each month), you'll end up with many instances of the month. Also if you are displaying 'Month', but passing/using a different value it will display month for each distinct instance of the other value.

You can

A) Make a prompt with static choices (one for each month)

B) Have the query that is running the month only contain the month and values rolled to the month, and pass only the month or a value on a monthly scope to the filter in the report.