Transaction data upload in an Infocube.

[Former Member]

Hi all:

I am in NW2004s. I have an Infocube which is loaded with transactional data from a File DataSource. The source file has 4.731 records but once the data is loaded, there is only 3.491 records in the Fact Table. Anything I could check?

[dielom · Accepted solution]

Hi Francisco,

Data might be aggregated when you load it into the cube.

If you have this lines into the file:

char1 char2 kf1

AA AA 4

AA AA 5

When you load, you'll get:

AA AA 9.

Also if you are not loading all fields, you'll get data aggregated:

char1 char2 kf1

AA AA 3

BB AA 4

and you load only char2, you get:

char2 kf1

AA 7

Hope this helps.

Regards,

Diego

[Former Member · Accepted solution]

Hi Diego:

Thanks, I'll ckeck what you said. Anyway, I am getting the data from an OLTP system (ERP) which creates this output every night. I have checked the source table in DB2 and there is no 2 records with the same information (Summary table).

Any idea?

[dielom · Accepted solution]

Hi Francisco,

Check what Hemant said. There might be some filters in the transformations. How many extracted records do you see in the InfoPackage monitor? In the infopackage monitor (and DTP moniutor if you are using BI7) you should be able to see where those records are "left behind".

Regards,

Diego

[Former Member · Accepted solution]

Ok. I'll check the TR for the Transformation. Thanks

[Former Member]

Hi Fransico,

Please check the update rules.

Some records could have been filtered there .

Reward with Points if helpful.

Regards

Hemant Khemani