MS SQL Server OLAP - Strange Scenario

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Strange Scenario

Prasad

2005-08-30, 1:23 pm

Hi,

I have a cube with 'customer', 'product', 'geography' and 'Measure'
Dimensions.

I want to get a count of customers that has geography = 'EAST'
and product = 'HMO'.

There is no Measure involved in this scenario.

Please let me know the MDX Expression to achieve this. I tried creating a
calculated member under 'Measure' with [Product].members.count.

It always give the same number no matter what i change for other dimensions
in the cube browser.

Thanks in advance,

Sam.

Sponsored Links