Skip to Content
0

HANA parent-child Hierarchy

Feb 01, 2017 at 04:33 PM

154

avatar image

Hi everybody,

I use HANA Studio to develop views and BO Analysis 2.4 as front-end.

I try to resume:

when you have a parent-child hierarchy and you try to put another attribute the hierarchy doesn't work anymore, each level of hierarchy displays all the rows of all its child and then a child shows up after them. i.e., parent displays duplicates of child 's rows.

below is the example:

Hierarchy TEST

CREATE TABLE:

CREATECOLUMNTABLE"DWH_AMM_T"."ZZZ_HIER" (

"ID"VARCHAR(1) NOTNULL ,

"Cmmt_Item"VARCHAR(1),

"parent"VARCHAR(1) ,

"controlling_area"VARCHAR(1),

"cost"INTEGER,

PRIMARYKEY INVERTED VALUE ("ID")) UNLOADPRIORITY 5 AUTO MERGE

Import file “ZZZ_HIER.csv” (TAB delimited flat file)

Create a Calculation View “ZZZ_HIER_CA”:

Create a Parent-child Hierarchy:

Log in with BO Analysis v.2.4:

The hierarchy works fine without any attributes:

But when I pull in any attribute ( Controling area in below example) :

Expected Behavior

I even tried to add the attribute in “Edit Hierarchy”

But the result is the same.

I found another thread never resoved "HANA Hierarchy behavior in front end tools- when another attribute is pulled in" here:

https://archive.sap.com/discussions/thread/3935196

Thank you for your attention

if0lj.png (6.2 kB)
te1dt.png (20.3 kB)
j9zof.png (12.3 kB)
c3dpm.png (21.3 kB)
mhynh.png (9.4 kB)
dvgxz.png (13.7 kB)
ig9xj.png (2.9 kB)
wvpkl.png (12.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers