Post reply

Need All Members Value - MDX

  • April 30, 2015 at 8:52 am

    #296539

    Hello,

    I need an MDX for the below situation:

    I Have Vehicle dimension and Sales Fact table and the data is below:

    Vehicle Dimension

    Vehicle KeyVehicleTypeCompany

    1Maruthi 800 CarMaruthi

    2Maruthi AltoCarMaruthi

    3Swift CarMaruthi Suzuki

    Sales Fact

    Vehicle KeyDate KeySaleValue

    110-Jan-15 100

    111-Jan-15 200

    112-Jan-15 300

    210-Jan-15 400

    312-Jan-15 600

    Output

    MONTHVehicleSales TypeSales (Car Sales)

    JanMaruthi 800 600 1600

    JanMaruthi Alto 400 1600

    JanSwift 600 1600

    I need to get the Type Sales which is sum of all the Cars.

    Thanks,

    Srinadh

  • May 5, 2015 at 5:46 am

    #1795556

    Without knowing how your attributes and hierarchies are defined (or what they're called) or having any code that you may have tried it's a bit hard to help. However I feel confident that if you read the following documentation then you should find your answer......

    https://msdn.microsoft.com/en-us/library/ms144768.aspx

    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply