Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: adam_mc on 09 May 2014 09:03:52 AM

Title: RESOLVED: Create Set based on "not in" Prompt
Post by: adam_mc on 09 May 2014 09:03:52 AM
set([Division] ->?parm_Division?) gets me the set of Divisions selected in the Prompt.

What is the syntax to get the set of Divisions not selected.

Thanks in advance,
Adam.
Title: Re: Create Set based on "not in" Prompt
Post by: Lynn on 09 May 2014 09:09:36 AM
Try the except function. Something along the lines of this I think:

except ( [Division], set([Division] ->?parm_Division?) )
Title: Re: Create Set based on "not in" Prompt
Post by: adam_mc on 09 May 2014 12:23:09 PM
I'd actually tried that, but I kept getting myself confused between Hierarchy and Member levels.
Once I got that part clear, it works perfectly.

Thanks Much!
Adam.
Title: Re: RESOLVED: Create Set based on "not in" Prompt
Post by: Lynn on 09 May 2014 12:28:23 PM
Great you figured it out! It is also very nice that you respond back and also update your subject to indicate resolved!! It is a little politeness that not all members bother to do.
Title: Re: RESOLVED: Create Set based on "not in" Prompt
Post by: MFGF on 09 May 2014 12:47:51 PM
Agreed! It gets an applaud from me :)

MF.
Text only | Text with Images