Business Objects Webi Hierarchy
Wisdom jobs sap business object webi developer interview questions and answers have been framed specially to get you prepared for the most frequently asked questions in many job interviews.
Business objects webi hierarchy. Bics connection to the bex query. Let s learn sap business objects this is for private purpose not for public. To achieve this first drag the state city store name and revenue into the report.
As shown below the first screenshot is a basic webi report created on efasion universe. Bex query with hierarchy hierarchy node variable. Bw hierarchy node value selected in a prompt shows full path in html viewer only the value in all other viewers editors.
Once you run the query the object will be added to the list of available objects in a webi document. Hierarchies and drilling are inter related wherein hierarchies should be defined in universe to do drilling in the report. Once you have hierarchy at universe you can add that object to result objects in query panel.
Hide hierarchy objects in webi boe sp2 14 it was working now after system was upgraded to 16 17 is not available. Here we add the plan id and date objects. The hierarchies appears as below.
This blog shows a small trick on how the table data can be displayed in a hierarchy format. The requirement is client may require display of hierarchical structure. We have two tabs one using the hierarchy structure and the other using the flat structure.
Give a name to the folder and then add the required objects from the left hand pane to the right hand pane. Now that the flat structure is coming up. Hi david i was going through the custom hierarchy using in sap webi report.