How to count tuples with specific value?

Hi, all

How can we count the number of tuples with specific value? (e.g, I want to get the number of tuples with value of 'measure_name'<600, how can we achieve this?)

Thank you and I am looking forward to hearing from you shortly.

With kind regards,

Yours sincerely,

Hi, experts here,

Please help me out!

Thanks.

With kind regards,

Yours sincerely,

|||

Hi there,

i've hab the same problem like you. I've solve this with a lookupcupe query.

1. Create a CalcMeasure in your Cube like

IIF (Measures.SalesOrders > 600, 1,0)

2. Do a MDX Query like

With

....

Member Measures.MySalesOrders as lookupcube("CUBENAME","SUM({Dimension.Members}, Measures.SalesOrders)")

3. Thats it. There is a different to query the Measure SalesOrders direct wihtout a Lookupcube. Try it with and without. It very important to use the SUM function. In other way it will aggregate all values.

Please try it out. I'm very pleased to hear from you.

Kind Regards

Andy

-

http://www.andyloewen.de

|||

Hi, Andy,

Thanks for your kind suggestions.

I have struggled ages to figure this out. But it is still not working.

Now I am going to try an alternative which is a named calculations within the data source view, and get the count for that named calculation member.

Thank you.

With kind regards,

Yours sincerely,