COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 06 Jan 2011 11:50:07 AM

Title: In the prompt each name is showing multiple times
Post by: jd on 06 Jan 2011 11:50:07 AM
in my promps each name is showing multiple times. prompts are based on cube based data source.
Title: Re: In the prompt each name is showing multiple times
Post by: MFGF on 07 Jan 2011 04:07:01 AM
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.
Title: Re: In the prompt each name is showing multiple times
Post by: S2000 on 07 Jan 2011 04:11:55 AM
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.