Skip to Content
0
Former Member
Nov 09, 2012 at 12:42 PM

Hierarchy Issue in Web Intelligence

21 Views

Hi All,

I am facing a strange issue in one of the Report in Web Intelligence. I have used a hierarchy something like below:

(Additional Info: I have created the Hierarchy in BI side and i used this in the Bex Query. Further i built the Webi Report on top of Bex Query.)

Country (Parent) --> (When it blows up for all the levels)

- State

- District

-Town

- Village.

However my requirement is I should collapse the children so that it should look like as below:

Country

+State (It should further blow up when i manually click on Plus sign on the State)

However in my report it is defaulting to +Country (Parent)

I have used Hierarchy Navigational option to expand the Parent Only and even then its not working as required.

Please help me to fix this as the users want to see only Country

+State

Note: We are using the Web Intelligence 14.0.4 & Build 819.

Please suggest how to fix this and also let me know if we need to install any patches to get rid of this error.

Thanks,

Srikanth