Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX Query - Little TROUBLE with a calculated member Expand / Collapse
Author
Message
Posted Saturday, January 19, 2013 9:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 4:07 PM
Points: 90, Visits: 186
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...
Post #1409207
Posted Sunday, January 20, 2013 8:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
Is this a duplicate post of this? http://www.sqlservercentral.com/Forums/Topic1409208-17-1.aspx

Mack
Post #1409284
Posted Monday, January 21, 2013 10:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 4:07 PM
Points: 90, Visits: 186
CIAO.
Yes it is ...sorry for that !!!!

I hope you apologize me...

Thanks
Post #1409647
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse