Post reply

To create range based on measure columns

  • September 24, 2009 at 12:09 am

    #215611

    Currently am updating range/banding based on the measures in relational table.

    have created the predefined master to update the range/banding

    lower upper Range

    -10000 0 A <=0
    0 100 B >0 <=100
    100 200 C >100 <=200
    200 300 D >200 <=300
    Based on the above master will update the range in the below table usnig JOIN.

    Like this am having 10 banding columns based on various measures and these columns will be used only in cubes.

    ACCT AMOUNT RANGE
    1110 A <=0
    112 85 B >0 <=100
    113 150 C >100 <=200
    114 225 D >200 <=300 My Question is whether the range can be created in cube using MDX (Without updating in relational table) Also which one will be better whether to update in relational table or applying at cube level Pls provide me the query to create at cube level Thanks..Gugan

  • September 25, 2009 at 2:46 am

    #1058384

    There are 2 options when creating a range.

    1. Create a table in your DW to store the range. This approach very usefull when you have a dynamic range. Change in range will be treat like a change in fact or dimension

    2. Create a range in OLAP cube. By creating range in OLAP cube, you will enforce the range as a business rule, therefore if you want to change the rule, you should reprocess the cube (full process)

    To create a range that you want, simply add a calculated column in your fact table (on dsv). Use a case condition to create a range. Then create a degenerated dimension (fact dimension) from this colomn. Voila .... now you have range in your OLAP cube

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

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