Combine data from two cubes (problem with navigational attributes)
I'm strugling with the following challenge:
I need to combine the objects from two cubes for a report, but they're navigational attributtes in one of them.
Cube 1 Orders
- IO ORDER__0EQUIPMENT (navigational attr)
- IO ORDER__0FUNCT_AREA (navigational attr)
Cube 2 Counter
I want to report on:
What's the best way to create this?
Thanks in advance!
I will reward usefull replies!