Skip to Content
0

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

Dec 21, 2016 at 10:45 PM

201

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vijay Dasari Jul 04, 2017 at 07:20 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded