Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

adding new member Item to Dimension in the ETL Package Expand / Collapse
Author
Message
Posted Thursday, October 9, 2008 8:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 28, 2011 12:43 PM
Points: 6, Visits: 71
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




Post #583694
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse