SQL Server Performance

Help required in MDX

Discussion in 'Analysis Services/Data Warehousing' started by Praveen, Dec 26, 2004.

  1. Praveen New Member

    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.
  2. satya Moderator

  3. Raulie New Member

  4. Praveen New Member

    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
  5. Raulie New Member

    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

Share This Page