Dimensional Data Prompts - Many Prompts & One Data Item

[qberta01]

Hello,

I would like to allow users to select up to 4 product types. So I created 4 separate prompts.

I do this in a relational report as follows (for the actual data query):

[ProductType] in (?P1?, ?P2?, ?P3?, ?P4?)

This does not work in the dimensional report. For one value, I know I can use:

([Dimension].[Hierarchy].[Level].[ProductType] ->?p1?)

However,

([Dimension].[Hierarchy].[Level].[ProductType] ->?p1?, ?p2?)

does not work.


Maybe I am going about this the wrong way? I am new to the dimensional aspect of Cognos - so I apologize in advance.

I am using version 10 for BI.

thx,

Q.

 

[blom0344]

You are aware that a prompt can be a multi-select?

Ties Blom