Alternative of connect by root in HANA

[Former Member]

Dear All,

I need the alternative of connect by root in HANA. My requirement is to convert following

INPUT:

ID           Parent ID      Product

1               2               A    

2               3               B

5               3               C

Output

ID     Product

1     A

2     A    

2     B

3     A

3     B

3     C

5     C

I also tried to implement hierarchies in Attribute view but i think that it can only be consumed in MDX or excel. I want such output in database

[former_member184768 · Accepted solution]

Hi Sanjeev,

I published a document addressing your requirement. Please check the document and let me know if it works for you.

Regards,

Ravi

[Former Member · Accepted solution]

Thnx Ravindra. your solution was what i needed.