Records Missing In DSO

[Former Member]

Hi guys,

I am loading Flatfile to the cube.

In my FF i am having 761 records. However after loading it to the cube i am just getting 66 records.

Kindly guide me how to resolve this.

Objects i am using are

Month

Measuring Point

GL Accounts

Plant

UOM

Rate

Value

Currency

Regards,

Kavitha

[former_member231968]

Hello

I assume you have not missed the records while loading it from DSO to CUBE.. rather the data get aggregated while loading from DSO to Cube based on your Dimensions.. for example.. if you have materials in you dimensions .. then you will have records aggregated with particular materials.. so for better understanding , please cross check the values.. with you DSO and CUBE..

Kumar

[Former Member]

Hi Kumar,

Please check my question properly.

I am loading data to DSO and not to cube.

Please give me suggestions on this.

Regards,

Kavitha

[Former Member]

Hi Kavitha,

Perform a few checks as below:

1. In your flat file, select below columns and find the duplicate rows. If your flat file have duplicates then in DSO you will surely have less records- use Excel features here by (select all 4 columns and click on remove duplicates - you should not have any duplicates if you want all 761 records)

Month

Measuring Point 

GL Accounts

Plant

2. Try to remove the DSO from the model and load data directly to Cube and check the results.

Please let us know results then we can think of further solution.

Thanks

Amit

[former_member188594]

Hi Kavitha,

Please check if there are any filters in the data selection in your dataflow.

Thanks & Regards,

Chandrasekhar R Kalluru

[Former Member]

Hi ,

There is no filter in the dataselection.

Regards,

kavitha

[Former Member]

Kavitha,

Have you tried adding all fields in key fields?

If you do not obtain 761 records, then that is because there are exactly the same fields in different lines.

If not, then you must have missed a routine somewhere between the PSA and the DSO...

Regards,

Ashvin