Please suggest me any idea to achieve this in my Cube.
My cube Fact table has 2 measures and 7 dimension.

My fact table has two measures. One is Quantity and one is Revenue.
I have a dimension called "Product Dim".

For a selected ‘Product Dimension’ member as “ProductCode” = 200003, I
need to display the ‘Quantity ‘ measure as 0 and still display the
revenue measure.
For the rest of the “ProductCode”, I need to display the values in the
measure’ Quantitty’.
When I select ALL productcode , I need to display the summary of
‘Quantity’ not including the selected ProductCode= 200003.


Thanks,
Norman Chen


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Create 'Calculated cell' (use wizzard in MSAS)
- dim measure : single measure = quantities
- dim product : single member = 200003
next screen
- mdx expression = 0

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...