Skip to Content
0
Jun 04, 2020 at 10:34 AM

CV Join based on hierarchy nodes

77 Views Last edit Jun 04, 2020 at 10:35 AM 2 rev

Hi Experts,

I have a Calculation View create in graphical form, where we join one table (this has final amounts for KPI's) with another union of CV's (has amount received from sources) with left outer join. so at output we identify Original value - Final Value and delta between them. we use this output in BW reports to show.

Now we want to have values from left table at higher nodes inside hierarchy, is there any possibility to derive values from my right CV's based on hierarchy to identify?

Below is data: Table 1 and Table 2 which I have and want Final Output as a output of a query. Here Item is a hierarchy in final output.

Attachments

capture.png (10.4 kB)