Post reply

MDX to calculate sum on Dimension Attribute Member value

  • February 5, 2015 at 6:31 am

    #145659

    Hi ,

    I am having a DimProject with the TypeID , Capacity attributes.

    factOut contains measure.OutPutVal.

    my Data is something like

    ProjectID , TypeID , Capacity

    1 1 100

    2 1 100

    3 1 100

    4 2 100

    5 2 100

    I need OutPut

    TypeID TotalCapacity

    1 300

    2 200

    Thanks for the help

    VD

  • February 5, 2015 at 7:51 am

    #1775695

    vineet_dubey1975 (2/5/2015)

    Hi ,

    I am having a DimProject with the TypeID , Capacity attributes.

    factOut contains measure.OutPutVal.

    my Data is something like

    ProjectID , TypeID , Capacity

    1 1 100

    2 1 100

    3 1 100

    4 2 100

    5 2 100

    I need OutPut

    TypeID TotalCapacity

    1 300

    2 200

    Thanks for the help

    VD

    Facts will naturally be aggregated for dimension members, assuming that your properties have been set for that measure to Sum and if the attribute relationships in your dimension is correct.

    You wouldn't need any specific function in your mdx query. Why don't you give it a try and post your attempts...it makes it easier to help that way as opposed to just give you the solution.

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

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