Why is records number different?

[Former Member]

Hi expert,

I have loaded R/3 GL data into a cube(0FIGL_C01) successful. But one thing confused me very much which is: the transfered and added records' number is different. In my case, transfered records are 117991, but the added are 87929. I have checked the detail message in Monitor, where the data deduction of update to cube took place after update rule, before the update rule all the data number are same( the system generated 2 data packages for this single request, in each packge the different records number added to cube with transfered happened just after the update rule), this means something happened in update rule, right? but I checked the update rule, there's no any routine exist. So could you please tell me what does any operations cause this result?

[Former Member · Accepted solution]

This is because if there are more records with same characteristics, they are summarizzed when are written in the cube.

No matter.

Hope it helps.

Regards

[Former Member · Accepted solution]

Hi Paolo,

Thank you very much for your reply. In my understanding of your explanation, if Chars in a cube for example: company code, business area, G/L account, currency type, fiscal year, fiscal year/period, and KFs like Total Debit Postings,Total credit postings, Cumulative Balance. If two records from R/3 which all the chars are same, then only one record will be keeped in the cube but the value of KFs will be added. Am I correct? But if somehow, someone load the data(Full load) one more time, what will be the result?

thank you in advance

Message was edited by:

Ryan Zhang

[Former Member · Accepted solution]

You have right understood. If you load the same data twice in a cube you'll get double amount. So you need to pay attention in loading in full mode or you have to go for init and than delta load.

Regards