MDX - DISTINCT SUM

  • Hi!

    I'm starting in the MDX world and i need some help.

    I need to do a calculated measure, but i don't know how to do it.

    Any help will be welcome.

    That's my cube:

    BUD_FACT_LANCAMENTO:

    -Measures

    Budgeted Balance

    Balance Held

    -Attributes

    History

    Batch

    Line

    BUD_DIM_COST_CENTER

    -Attributes

    Cost Center 1

    Description 1

    Cost Center 2

    Description 2

    Cost Center 3

    Description 3

    BUD_DIM_ACCOUNT

    -Attributes

    Account 1

    Description 1

    Account 2

    Description 2

    Account 3

    Description 3

    Account 4

    Description 4

    Account 5

    Description 5

    When i drill down to the lowest level the following structure is shown:

    Cost Center 3 Account 5 History batch Line Budgeted Balance Balance Held

    20401 500101001 TEST 001 001 10 5

    20401 500101001 TEST2 001 002 10 5

    When i go one level up the following structure is shown:

    Cost Center 3 Account 5 Budgeted Balance Balance Held

    20401 500101001 20 10

    But the Budgeted Balance is 10, cause is the same cost center and account

    The attributes Cost Center 1, 2 and 3 are the levels of the cost center

    Cost Center 3 = 20401

    Cost Center 2 = 204

    Cost Center 1 = 2

    The account attributes have the same rule

    Someone can help me please?

    Thanks in advance!

Viewing 0 posts

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