Skip to Content
avatar image
Former Member

HANA parent-child Hierarchy

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers