Summing up key figure in Cube - data load from ODS

[prem_kool]

Hello Gurus,

I am doing a data load from ODS to cube.

The records in ODS are at line-item level, and all needs to be summed up at header level. There is only one key-figure. ODS has header and line-item fields.

I am loading only header field data ( and not the item-field data) from ODS to Cube.

I am expecting only-one record in cube ( for all the item-level records) with all the key-figures summed up. But couldn't see that.

Can anyone please explain how to achieve it.

I promise to reward points.

=====

Example to elaborate my point.

In ODS

Header-field item-field quantity

123 301 10

123 302 20

123 303 30

Expected record in Cube

Header-field Quantity

123 60

====================

Regards,

Pramod.

[prem_kool · Accepted solution]

Hello Oscar and Paolo.

Thanks for the reply. I am using BW 7.0

Paolo suggested:

>>If you don't add item number to cube and put quantity as adition in update rules >>from ODS to cube it works.

I did that still I get 3 records in cube.

Oscar Suggested:

>>What kind of aggregate do you have for your key figure in update rules (update >>or no change)?

It is "summation". And it cannot be changed. (Or at least I do not know how to change it.)

There are other dimensions in the cube - which corresponds to the field(s) in ODS.

But, I just mentioned these two (i.e. header and item-level) for simplicity.

Can you please help?

Thank you.

Pramod.

[Former Member · Accepted solution]

Hi,

Try this:

Compress and then check the records in the cube.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Do you have any other IO diferent from the three specified before and which was different for each item?. Else you will have one aggregated values.

[Former Member · Accepted solution]

Ok, so you posted an example of what you have in the ODS and what you'd expect in the Cube, can you post an example of what you actually get in the Cube, the 3 rows must be different by something.

[prem_kool]

Thank you everyone for the input. The problem is solved. Points awarded.

[prem_kool]

The resulting data - I get in an infocube is

Header Field Quantity Bill-type

123 10 abc

123 20 <space>

123 30 <space>

[Former Member]

There lies the problem, all dimensions will act as a Primary Key in cube, in ods only those defined as key

[former_member378832]

Hai,

U should remove "Bill-type" characteristic from your Info Cube. Then try to load the data again.

It should be one records.

Cheers,

Wawan S

[Former Member]

If you have in cube any char which value can be distinct one position from another you will have several entries for the same header.

[Former Member]

Sorry, not helpful

Message was edited by:

Björn Grahlher

[Former Member]

That's how it should go.

But in this example the ODS is made of two infoobjects and one key figure and the cube of 1 dimension made of one infoobject and one key figure.

What kind of aggregate do you have for your key figure in update rules (update or no change)?

[Former Member]

If you don't add item number to cube and put quantity as adition in update rules from ODS to cube it works.