cancel
Showing results for 
Search instead for 
Did you mean: 

Parent-Child Hierarchy variable of HANA not working in BO WebI 4.2?

Former Member
0 Kudos

Hi!

We are using HANA SPS12 and BO4.2.

We have a parent-child hierarchy defined in HANA within a Calculation View1 (dimension).

This view is then star-join with a fact table in another Calculation View2. In Semantic, we define a variable with Attribute of Hierarchy Table field ParentID; select the defined Hierarchy in Hierarchy box.

- Do 'Data Preview'. When Variable is to be entered in the Dialog box, we can see the ParentID, the hierarchy structure and description. We can select a parent ID and related data are properly retrieved in HANA.

Next, login to BO 4.2 WebI and create a document with datasource of Calculation View2. In the 'Set Variable', we can see the whole hierarchy, select the same parent ID we have checked in HANA.

No data is retrieved in WebI.

Is it a limitation in BO WebI? We need to have this functionality available in WebI. We have BO WebI 4.1 with BW 7.3 Bex Query; where data can be queried in WebI comfortably with hierarchy variable of either parent or child. We want to move to native HANA and this is limiting our goal. Any suggestions/questions are welcomed!

thank you

-eric

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member258843
Discoverer
0 Kudos

Hello Eric,

We also have the same exact requirement as yours ! Did you get any solution by now ? Please do let me know in that case, would be of great help !

Thanks,

Vijay