on 12-21-2016 10:45 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.