SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle query convert from parent/child recursive to level columns

YannisVMay 13 2015 — edited May 14 2015

Dear Gurus,

I have a dimension table extracted from Hyperion with my COA in a parent/child layout:

parent,child

acc01,acc001

acc001,acc0001 etc.

I need to convert it to:

level2,level1,level0

acc01,acc001,acc0001 etc.

Please advise, need the table for feeding Tableu schema for reporting.

Regards

yannis

This post has been answered by Etbin on May 14 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2015

Added on May 13 2015

11 comments

2,202 views