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

mdx prompt data item showing up prior to prompt page

Started by Cannondale23, 10 Apr 2010 08:53:09 AM

Previous topic - Next topic

Cannondale23

I have the following expression [Shipments].[Time].[Calendar Year to Month].[Month]->?Month_di? in a data item I use it as a value prompt then in the page as a nested item to create YTD and LYTD calcs in the report layout all works well, but it also comes up prior to prompt page, is there a way to make this prompt part of the prompt page ? 
thanks

CognosPaul

Are you using the query that expression is in anywhere in the prompt page?

MFGF

That would be my suspicion too.  The value prompt should not refer to your data item - only to the parameter ?Month_di?, and should use a query to retrieve the original month members.

MF.
Meep!

Cannondale23

Gentlemen,
Thank you for your reply, it works perfectly.