HI ,
I have a product dimension with five levels and lowest level is material .
Now users want to see ana lternate hierarchy which would be having fewer materials from the first hierarchy with different groupings .
EX:
Hierarchy1
10>101>10100>1010000>101000000>Product1
10>101>10100>1010000>101000001>Product2
10>101>10100>1010001>101000101>Product2
Hierarchy 2 - This is more of a consolidation rather than hierachy
FocusProduct->101000000
FocusProduct->101000101
I dont have all materials from parent hierarchy but the hieracrhy has same level.
So this creates orphans and if I exclude then it excludes the material on parent hierarchy as well ,
What I am doing here is trying to basically group few items so users can easily see their sales by custom grouped manner.
so how can i achieve this , they wanted this in analysis studio rather than in a standard report.