I am creating a static Dimension with an hierarchy having 7 levels. Sometime all the levels values are same, sometime only two consecutive level values are same. I think this issue can be resolved through namespace but i didn't found any document or method to apply that namespace in our dimension. Is it possible for someone to provide any document to implement namespace and also explain the logic how it works.
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.)
You should make the members have different names and you can easily do that before doing member load. A simple ETL or sql script would do that. That will simplify life a lot. Also, the namespace issues would cause issues in many other places.
We used namespace for 3 levels at static dimension having 7 levels. Its difficult to use namespace when all the levels have same Value. The only option i found feasible is to append the values with different prefix at different levels.