Parent -Child hierarchy issue in SAP HANA (while creating SAP WebI Report on CV).

[Former Member]

Hello People,

I have created a Parent-Child hierarchy in a graphical calculation view.I use this CV in SAP BO WebI tool, while consuming this CV I am not able to search the parent and child nodes and I am not able get output data in SAP WebI report when I use the CV.

Please let me know if there is any workaround for this Parent-Child hierarchy scenario.

Below are the steps and details i have taken to create the hierarchies and join with transaction table.

Pic 1 : Data available in my hierarchy table. table name is H2

Pic2: Transaction Table Data H2_FACT

Step1: Since my Transaction table has only Location as Id as shown in Pic2 H2 table I am creating a self-join on H2 table to get the TXTSH description to be dispalyed on my BO Report.

Pic3: CV_H2_HIER_DIM

Pic4: I have created a Parent Child hierarchy between NODENAME and NODENAME1 each one of the Attribute from Projection 1 and 2.

PCH - Parent-Child hierarchy.

Step 2 :I have created a CV combining the hierarchy CV and Transaction Table.

Join condition is Nodename and Location

Pic3:

Pic6: I have created a Variable as per the below picture using the PCH - parent-child hierarchy in the View/Table for Value help.

I can do a data preview at HANA side and I am able to select the Parent and Child nodes as shown in the below 2 pictures. But when i expose this CV to SAP BO WebI tool I am not able to do search on the Prompt Variable that is created on variable V_LOC and the output is not listed in WebI.

Pic7

Pic8

[former_member182563]

Hi Vinoth,

I have the same requirement now, do you find any solution for the above scenario??