HANA parent-child Hierarchy

[Former Member]

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

[gsr20]

Hi,
Did you find the solution to the problem? I am facing the similar issue.

Appreciate if you could share the solution.

Thanks !

[former_member751591]

Thanks for coming to SAP Community for answers. Please post your question as a new question here:

Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members.

Please note, that your post here won't be answered.