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