Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 04, 2017 at 07:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded