I need to generate a report in OBIEE, which is composed of three different cubes.
The metrics shown in the report are distributed in three different cubes.
The cubes do not have the same number of dimensions each other. But the dimensions that match members have the same name and number of members. For example, Customer, Executive, segment, period. I wonder if there is any way in admintools of combine the dimensions of a cube and leave as a single source of data. From already thank you for your help.