This content has been marked as final. Show 5 replies
In iop, dimension members are addressed by (dimension name, namespace, member name). By default, the namespace name is the name of the dimension, which works fine when all member names in a dimension are unique. If they are not, you'll need to either create namespaces, or make the member names unique.
Say you have a calendar dimension with years 2011 and 2012. To add member q1 to both 2011 and 2012 you could split q1 into, q1.2011 and q1.2012, making the name unique. No need to mess with namespaces in this case. If your dimension is called "fiscal", your fully qualified member names would be
Alternatively, you could qualify q1 with namespaces, say "2011" and "2012". Then your members would be called
To implement, go to the datasource to dimension map editor in the ui and
- edit 'hierarchy level maps',
- edit the 'namespace' field,
- click on the 'column' radio button (rather than 'value'),
- select the column from the datasource which is the parent of the level in question
(in the example above, it would be the year column)
Thing to be careful of here is that once you build your dimension using namespaces, you'll have to qualify your member names everywhere they are used (eg, rowsource-to-cube maps, etc.)
Thanks for Your Prompt reply.
I did the same. For Eg. I have 4 levels in my dimension A>B>C>D .
A is the highest and D is the lowest level.
My B and C levels have the same value for few cases.
for Ex. B member is TEST1 and C member is also TEST1 . The zoom in should look like :
. . . D
. . TEST1
when I am creating hierarchy the way you suggest I gave B as namespace from the LOV or Radiobutton , while defining B>C level.
what would be the namespace for A>B level ? (Presently namespace is DIM_DM for all the levels)
What would be the Namespace for C>D level ?
Edited by: user7918731 on Apr 8, 2011 2:33 PM