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 Question

Started by cognos05, 07 Apr 2021 09:05:56 AM

Previous topic - Next topic

cognos05

Hi Experts,

I need to have a query item in olap ,


Give me all the territories whose any o the children have a sale of greater than 5000
                     Sale
Terrritory1    10000
Account1        4000
Account2       6000

Territory2      6000
Account3     3000
Account4     3000

so this should return me only territory1



Filter( Territoy Level, how to check for each of its childen sale >5000 )

Filter(Territory Level, tuple(sales)>5000) will only heck for the territory ,but i need to check for childrens any one of sale greate than 5000 .

Thanks,

cognos05

FIlter (Level, Basedonitschidrensale)

SO on my filter condition , i can mostly use only tuple function which will allow only one member,so if i have to check the sale of each children of the level ,is there any other olap function that will allow iteration .

Thanks,

oscarca

I would write something like this: filter(descendants([Territory],1),[Sale] > 5000)