SQL Server Performance Forum – Threads Archive

Help required in MDX

Hi All,
I am excuting following MDX (on FoodMart 2000) and got following result. select
{ [Measures].[Units Shipped], [Measures].[Units Ordered] } on columns,
NON EMPTY [Store].[Store Name].members on rows
from Warehouse Units ShippedUnits Ordered
Store 61075911699
Store 72458726463 Now I want to write MDX that will return above result with last column as total as Units ShippedUnits Ordered
Store 61075911699
Store 72458726463
Total3534683162 Any help will be apprciated. Thanks and Regards,
Praveen Patil.

Hope this DBjournal articlehttp://www.databasejournal.com/features/mssql/article.php/10894_1495511_3 about MDX may help you. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Like this…. SELECT
{ [Measures].[Units Shipped], [Measures].[Units Ordered] } on columns,
NON EMPTY {[Store].[Store Name].members,[Store].[All Stores]} on rows
from Warehouse There is not too many books out there on MDX unfortunately, but here is one I found helpful. http://www.amazon.com/exec/obidos/tg/detail/-/0471400467/002-6638398-9219216?v=glance
Raulie
Hewlett-Packard Company

Thanks Raulie. But if I take Time dimension in the row which does not contain All level. Time dimension has levels year, quarter and month. I want total at each level in page size of 10. Any help will be appreciated. Thanks and Regards,
Mr. Praveen Patil

Hi, Now is this a totally different question? In your original question you did not mention a time dim you just wanted a Grand Total of all Stores at the end. All Dimensions include the ALL member by default however if yours was hidden for some reason you can substitute [time].[(all)] for another level. You should look up Time functions in BOL (YTD(), PeriodToDate() etc.) Also if you could post some code like in the original post above it would help.
Raulie
Hewlett-Packard Company

]]>