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
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.