adding new member Item to Dimension in the ETL Package

  • Hi ,

    I have a situation here....my dimension is follows

    ex: market dimension

    market 1ID market2ID market1 market 2

    100 104 professional education 1

    101 105 professional education 2

    102 106 professional education 3

    home dimension

    home ID home

    113 Home

    some of the measures are stored at this level ex:measure1

    YR-Home-Professional -education1

    measure 2 is stored at

    YR-Home-Professional only (i.e it doesn't exists for education1 2 3 levels i.e market level 2 )

    I know we can change the dimension in the database as

    market 1ID market2ID market1 market 2

    100 104 professional education 1

    101 105 professional education 2

    102 106 professional education 3

    103 107 professional professional

    that is creating level 1 member item at level 2

    Can we have ETL to do the above thing (creating level 1 member item at level 2) such that when I pick up measure 2

    if I browse the cue it should come up as

    YR-Home-Professional-Professional -measure 2value

    instead of YR-Home-Professional-measure2 value

    so I have to insert records in dimension table with some specific ID like 999 or any ID which I can identify for creating level 1 member item at level 2 and have the same record in the fact table ,but we also need to insert keys for all other dimensions and surrogate key should be genrated..

    can some one help me how to implement this .....and further how to update values for measure2

    thank you

Viewing 0 posts

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