Percent of parent row as indicator in rpd (OBIEE 12c)

user4480831

Hi community,

I have a requirement to create an indicator in repository as percentage of parent row in a hierarchy , you can see below the final result should be:

I know the possibility to show values in pivot table as percentage of a parent row, but the point is to calculate in the repository because I need to calculate AGO values based on % indicator.

Does anyone know a possibility to implement this in OBIEE 12c?

Thanks is advance.

AICoelho

[Deleted User]

Create a level-based measure which aggregates "Value" on the "Country" level. Then divide "Value" / "Value (Country Total) and you're done.

Gianni Ceresa

Hi,

The issue is that you expect the formula to be smart enough to understand at which level it is all the time and so identify the parent level accordingly.

That's asking too much ...

You can manage to "% of region in country", "% of country in continent" and "% of continent in total" but it will be separate things, not a single column acting as the 3 in the same time.

That's why the pivot option you mention is extremely powerful and nice to use (even if I can also understand you need to calculate that).

So do you really look for a single column? Or looking for multiple columns, one for each level?

[Deleted User]

True. If he wants it all the way up it won't work "just like that".

.....unless he's using a cube

user4480831

Yes, I need a single column

Gianni Ceresa

So you already have your answer ...

user4480831

It´s not possible do that in OBIEE..

Thanks for your answers!