Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE / Essbase Integration - Group By Values in Different Generations

Question
1
Views
0
Comments
1977947
1977947 Rank 3 - Community Apprentice

OBIEE 11.1.1.7 / Essbase 11.2.4

I am creating a report with a bar chart to show some values of Revenue which will be grouped by Entity coming from the Entity Dimension.

Y-Axis will have value of metric such as Revenue.

X-Axis will show Entity such as Entity 1, Entity 2, Entity 3, Entity 4, Entity 5.

My problem is that Entity 1 is on Generation 2 of the hierarchy of the Entity Dimension whilst Entity 2, Entity 3, Entity 4 and Entity 5 are on Generation 3 of the Entity Dimension. Is there  some where to display these on the X-Axis as if they were all in the same Generation of the hierarchy.

Thanks in Advance.