October 9, 2008 at 8:23 pm
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