COGNOiSe.com - The IBM Cognos Community

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,

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,

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