Hi All,
I have below input table with members in Parent/Child format with aggregation and data present at Level-0 members.
Can some one help with PL/SQL code to aggregate data to the upper level members based on the aggregation symbol for each row.
Input Table:
Parent | Child | Level | Aggregation | Data |
Top | ACC | 2 | + |
ACC | ACC1 | 1 | + |
ACC1 | ACC1_1 | 0 | + | 400 |
ACC1 | ACC1_2 | 0 | + | 350 |
ACC1 | ACC1_3 | 0 | - | 150 |
ACC | ACC2 | 1 | - |
ACC2 | ACC2_1 | 0 | + | 50 |
ACC2 | ACC2_2 | 0 | + | 150 |
Output Table:
Parent | Child | Level | Aggregation | Data |
Top | ACC | 2 | + | 400 |
ACC | ACC1 | 1 | + | 600 |
ACC1 | ACC1_1 | 0 | + | 400 |
ACC1 | ACC1_2 | 0 | + | 350 |
ACC1 | ACC1_3 | 0 | - | 150 |
ACC | ACC2 | 1 | - | 200 |
ACC2 | ACC2_1 | 0 | + | 50 |
ACC2 | ACC2_2 | 0 | + | 150 |
Thanks,
Taiyab