Hi,
I have a dimension with four levels. The members at level 3 are not unique
among level members but unique among siblings. That is something like this:
L1A-----L2AA---L3A-----
Quote:
|_L3B-----
-----L2AB---L3A----
_ L3B----
L1B-----L2BA---L3A-----
|_L3B-----
-----L2BB---L3A----
_ L3B---- |
Is there any option in the Analysis Server by which I can analyze the sales
at level1 and 3 of the dimension bypassing the second level. That is
something like this:
L1A---L3A-----
Quote:
_L3B-----
L1B---L3A-----
_L3B----- |
Where L1A--->L3A would be showing me the sum of the sales of the hierarchies
L1A---->L2AA--->L3A----- and
L1A---->L2AB--->L3A-----
Similary L1A--->L3B would be showing me the sum of the sales of the
hierarchies
L1A---->L2AA--->L3B----- and
L1A---->L2AB--->L3B-----
Same the case with the second member of the first level
--
Thanks
Akber.