Transfromer Hierarchy

[cognos05]

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.