nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE / Essbase Integration - Group By Values in Different Generations

1977947

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.