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

filter!

Started by Jeka, 17 Sep 2008 11:41:00 AM

Previous topic - Next topic

Jeka

Hi Guys,
I know in Relational Model i can put the filter something like Ledger = 'Actuals'
and the report will only show data for actuals

How can i do exactly the same for CUBE based report?
I have Dimension called Ledger with two members Actual and Budget.

And i want the report to return only 'Actuals'?

Thank-you!
Nikki

billylodz

in Query add Filter - drop level you want to filter, add = and next drop member 'Actuals' from Members of this level

Jeka

Thank-you for the reply. I just calculated measure with total([measure]..... and set that as the default measure for the crosstab.