MDX Query - Little TROUBLE with a calculated member

• maretix

  Hall of Fame

  Points: 3835

  More actions

  January 19, 2013 at 9:25 am

  #288188

  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 Store 2...)

  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

  Store 1 100 120.000

  Store 2 120.000

  Store 3 300 120.000

  Here is my MDX that it works correctly

  SUM

  (

  {

  ( [Azienda].[All Azienda].[COMET],

  [Codice_Filiale].[Codice_Filiale].[Cod Filiale]

  )

  }

  ,[Measures].[Importo Venduto])

  Thanks in advance...

• Mackers

  SSCrazy

  Points: 2935

  More actions

  January 20, 2013 at 8:44 am

  #1579030

  Is this a duplicate post of this? http://www.sqlservercentral.com/Forums/Topic1409208-17-1.aspx

  Mack

• maretix

  Hall of Fame

  Points: 3835

  More actions

  January 21, 2013 at 10:40 am

  #1579328

  CIAO.

  Yes it is ...sorry for that !!!!

  I hope you apologize me...

  Thanks