Cube in Report Studio - filter

Cognos 8 Business Intelligence Report Studio
1

Hi ,

Could you please help me with filtering of data from report studio when using cube/Olap package.

Example :

I have report in which I need to filter data based on the country.

There are three country A,B and C.

In a report I just want to show data with A and B data excluding C.

Here I am using cube as source in report studio.

Thanks in Advance

Bachi

2

Try this FILTER(set([Country A],[Country B],[Country C]))

Read more about dimensional functions here: http://www.ibm.com/developerworks/data/library/cognos/page82.html

3

or make a prompt in the prompt page