Skip to Content
avatar image
Former Member

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

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

pic1.png (47.3 kB)
pic2.png (13.8 kB)
pic3.png (23.8 kB)
pic4.png (25.4 kB)
pic5.png (29.5 kB)
pic6.png (32.7 kB)
pic7.png (11.6 kB)
pic8.png (16.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 05 at 08:03 PM

    Hi Vinoth,

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

    Add comment
    10|10000 characters needed characters exceeded