question

jhowe avatar image
jhowe asked

ssas mdx line quantity divided by SUM

how do I create the new column in MDX? The dimensions selected are not important. I just want the line amount / sum for the data selected. I am new to MDX ![alt text][1] [1]: /storage/temp/3484-capture.png
ssassqlservermdxsqlserver2012
capture.png (32.8 KiB)
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
Is this in an MDX query or are you talking about adding a calculated member to a cube?
1 Like 1 ·
jhowe avatar image jhowe commented ·
Hi sorry for delay I didn't get a notification. This is calculated member to a cube. This question is also on stack overflow nobody has been able to figure it out yet. Thanks for your help! http://stackoverflow.com/questions/37810702/ssas-mdx-line-quantity-divided-by-sum/37812615?noredirect=1#comment63152244_37812615
0 Likes 0 ·
jhowe avatar image jhowe commented ·
Can someone help me with this please.
0 Likes 0 ·

1 Answer

·
Scot Hauder avatar image
Scot Hauder answered
Not ideal, but unless you can find a way to remove the Measure Dimension from root() you may have to do this: iif((root([YourFinancialSiteNameDim]), root([YourItemIdDim]), root([YourForecastOffsetDim]), root([YourDateDim]), [Measures].[Sales Line Amount AC BudgetSF])=0,null, [Measures].[Sales Line Amount AC BudgetSF]/ (root([YourFinancialSiteNameDim]), root([YourItemIdDim]), root([YourForecastOffsetDim]), root([YourDateDim]), [Measures].[Sales Line Amount AC BudgetSF]))
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.