Hi to all.
I use SSAS 2008 R2 and i built a cube.
In this cube i have a little trouble with a calculated member i have to do.
My new calculate member is named AllSalesAmountOfWholeCompany
I need to calculate the total amoun of sales of all company.
I'd like to be able my users, to display in the same moment sales amount fo a single store of the company and in the same row the total amount of all company...
(A buyer asked me that and i found interesting to do !!!)
I built calculate member in MDX and i was able to do that BUT my trouble is to hide the row of stores that has SALES AMOUNT as NULL or 0.....(In the example member BOLOGNA Store...)
How can i do that ???? Inside Calculation member definition or where ????
I have the same problem in Excel and SQL SERVER MANAGEMENT STUDIO too...
I suppose i have to force NULL or 0 my calculated member AllSalesAmountOfWholeCompany, in this way, Excel will display only stores with a Sales Amount > 0.
But i tried i was not able,,,i am not a super MDX man ,,,i know
DIM STORES --- Sales Amount of a Month ---- AllSalesAmountOfWholeCompany
Turin Store ----- 100 --- 120.000
Bologna Store ----- NULL ---- 120.000
Venice Store ----- 300 ---- 120.000
Here is my MDX that it works correctly
( [Company].[All Company].[COMET],
Thanks in advance...