I am working on a project where we have to define an Organization Dimension (we defined a standard dimension not parent-child for performance reasons).
The company I am working for is using codeblocks at the lowest level of the hierarchy (combination of business unit, operating unit, etc...).
We created two user-defined hierarchies on that dimension
- One organizing the codeblocks Geographycally (we have attributes like Area, Subarea, CountryGroup, Country)
- One organizing the codeblocks from a Service perspective (ServiceLine, Subserviceline)
The table looks like:
Codeblock, Area, SubArea, CountryGroup, Country, ServiceLine, SubserviceLine, ...
An additional business requirement we have is to define plenty of very small hierarchies besides those two main hierarchies.
One example would be to have a hierarchy that combines values for Country(Switzerland) and Country(Germany). Of course it would be possible to create calculated members in the MDX Script but we have the requirement to be able to drill down from the sum to
the individual countries. Since calculated members are not allowed to have children, they are not an option.
We would like to avoid using a parent-child dimension (I know the possibility of using a parent-child with multiple hierarchies).
One ugly option I found is to add dum
View Complete Post