Key Objects in Hiearchy-WEBI

[vedpal_yadav]

Hi

In the Webi Reports based on the OLAP Universes since we have hiearchy flattening we had Key objects at various levels of the hiearchy.
But if we use the BEX as a source for creating the WEBi Reports we can only see a single Hiearchy object with the waterfall Icon.
The Hiearchy object contains only the text at various levels in the hiearchy.

In my scenario the report structure is based on the Universe & some Key objects at various depth of hiearchy are used in columns of the report.
So I need to Key objects in the reports apart from the text objects.

Is there some way I can get the Key Objects at various levels of the hiearchy when using the BEX as a source for Webi. In case someone might have tried to achieve the same.

Regards,
Ved

[Former Member · Accepted solution]

you can insert a new column and insert the key object there.

I think otherwise you will loose the hierarchical layout and interactivity.

[vedpal_yadav · Accepted solution]

Hi Victor,

Thanks for the reply. Your suggestion was very helpful.

When I pull the Key Object at the Top level in the hiearchy in the adjoining column and when expand the hiearchy object which displays only the text. I am able to the see the key in the adjoing cell for that level of the hiearchy.

Regards,

Ved