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

In the prompt each name is showing multiple times

Started by jd, 06 Jan 2011 11:50:07 AM

Previous topic - Next topic

jd

in my promps each name is showing multiple times. prompts are based on cube based data source.

MFGF

If you go to the query populating the prompt values, how are the items defined?  Have the properties of the query been modified at all?

MF.
Meep!

S2000

My best guess is that the source dim is an SCD so each name does appear multiple times with a different skey, or perhaps there are multiple records with the same name but different bkeys.

Try opening the table in a database, or a create a report with auto grouping turned off to look at the true contents of the table.