Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Create an intersection of two hierarchies in the same UD

Hi all  What would be the best way to create an intersection of two hierarchies within the same UD? For example, assume these are Profit Centres in UD1.    I would like to be able to c...
Cube View
Reports
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hey Robb, thanks for the reply.

The problem with these solutions is that the subtotal's won't be correct? So we'd have to create manual subtotals in the cube views?

Krishna's avatar
Krishna
Valued Contributor
2 years ago

MarkBird  -  You can also try XFBR based on the Year selection the sub total will be return in the cube or you can utilize UD8. 

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    MarkBird  - I forgot to mention while using the XFBR when you select the year it has to loop through the members and add based on the Prefix.