HCI DS Data Flow conversion
I'm extracting data from a Hana Database and importing it in IBP.
The problem I'm having is that for the Keyfigures in the database are grouped by document and in IBP I need to imported them grouped by month.
So for example I have
So What I need to obtain is:
I'm trying to use global variables to append the values while I read the rows, but I wasn´t able to assign values. The "=" is only used for comparissions:
$GlobalSUM = $GlobalSUM + "TEST"."REVENUE"
Does anybody knows how to do this?
Another alternative is also welcome.