cancel
Showing results for 
Search instead for 
Did you mean: 

Strange behaviour using Non Cumulative Key Figures on BW 7.40 SP08 with HANA

Former Member
0 Kudos

Hi Gurus,

Tried to design one flow using non cumulative key figure.

Here is my design :

NCUM kf designed that way :

My cube is designed that way :

I used Sender Accouting Department (equal to plant from a functionnal view) and Calmonth in extra -> maintain caracteristics for NCUM

My infocube content has 2 lines (infocube is compressed). Here is the content :

I then designed a simple query that way in BEX :

Query result without any filters is like that :

From my point of view i should have :

  • 1 Euro in 12.2014
  • 1 Euro in 01.2015
  • 1 Euro in 02.2015
  • 2 Euro in 03.2015


Looks like systems multiplies my amounts by the number of days... I'm getting confused with that results.

Do you know if i'm missing some implementation point ?

Waiting for your help gurus.

Thanks,

Christian

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

UP ?

FCI
Active Contributor
0 Kudos

Hi Kris,

I think NCUMKF should be designed with an aggregation exception of type "Last value" (you set it to summation).

Have a look at the 0IC_C03 standard stock cube.

Regards,

Frederic

Edit : Aggregation should be set to SUM and Aggregation exception to Last value

Former Member
0 Kudos

Thanks, that was the missing implementation point.

Regards

Answers (0)