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

crosstab report issue

Started by tupac_rd, 27 Jun 2008 11:28:33 AM

Previous topic - Next topic

tupac_rd

Hi gurus,

I have a crosstab report whose "Crosstab rows" is populated by a query item which is a list of values starting from Jan 2001, Feb 2001, Mar 2001 and so on all the way to Nov2010, Dec 2010.
Now I have to filter the crosstab query based on 2 prompts.

1st prompt (single select) would be year month combo from the same query item above. Lets say the value is ?p1? = Dec 2007.

2nd prompt(multiselect) is  year.  for eg., ?p2?=2006.

For the above 2 prompt selections, the query should display values from Jan 2006 to Dec 2007. I know how to do this if year selected is only 2006, but the way prompt filter is set up the prompt is becoming single select. I need to change the filter expression so that the 2nd prompt is multiselect. So if the users select multiple years say 2005 and 2006, then the query should bring back Jan 2005 to Dec 2007.

please let me know how to do this.

Thanks
dd

blom0344

multiselect prompts require a different syntax in the filter expression:



[somenamespace].[someyearitem]
in ?select_year?


MDXpressor

Your filter probably ready with the operator as an equal ([year]=?year prompt?) as stated above, you need to change that operator to the 'in' operator ([year] in (?year prompt?)).  The other thing of importance is to change your prompt page (if you actually created one).  If the prompts are not being dynamically generated, they are likely still on Multi Select = No.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien