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 dimensional data ased on prompt

Started by Sep2013, 15 Aug 2013 08:36:28 PM

Previous topic - Next topic

Sep2013

Hi guys,

I am using leaf members of 3 hirrarchies(Product,brand and market) in the prompt page using the following function:

filter( members ([Profitability Report].[Products] ),
count(1 within set children(currentMember([Profitability Report].[Products]  )  )  ) = 0 )

Now in my report query i need to use product, brand and market chosen on the prompt page to slice or filter my data on crosstab.
How do I use a slicer/context filter to get correct data?

I have tried using a data item similar to prompt query using the following funtion:
Product leaf Memeber=filter( members ([Profitability Report].[Products] ),
count(1 within set children(currentMember([Profitability Report].[Products]  )  )  ) = 0 )

and used this in slicer with formula Product leaf memebers in ?Products?

But when I add another 2 slicers for brand and market, it shows me "-" dashes on the report output