Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HCI DS Data Flow conversion

Hi mates,

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

PORTDATEREVENUE
PORT105-05-201610
PORT115-05-201611
PORT107-06-201613
PORT205-05-201615
PORT222-05-201617

So What I need to obtain is:

PORTMONTHREVENUE
PORT10521
PORT10613
PORT20532

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.

Thanks,

R.O.

Tags:
Former Member
replied

Yes, you have it. The 3rd one.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question