Skip to Content
avatar image
Former Member

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

PORT DATE REVENUE PORT1 05-05-2016 10 PORT1 15-05-2016 11 PORT1 07-06-2016 13 PORT2 05-05-2016 15 PORT2 22-05-2016 17

So What I need to obtain is:

PORT MONTH REVENUE PORT1 05 21 PORT1 06 13 PORT2 05 32

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 17, 2016 at 06:10 AM

    Hi Robert,

    I would extract the month from the date and use an aggregation query to group by month and sum by volume.

    https://hcids.hana.ondemand.com/DSoD/help/index.html#8d164f078d59499d99736fcbe50ca8f4.html

    Regards

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2016 at 08:56 PM

    When I run this kind of maapings I get:

    Parameter <($GlobalSUM = ($GlobalSUM + ("TEST"."REVENUE")))> of function <ifthenelse> must be a value expression, not a comparison,

                                                                   which uses one of { =  >  <  <>  >=  <= }.

    Add comment
    10|10000 characters needed characters exceeded