Loading a cube using a DTP

[Former Member]

We have to load a cube B from another cube A.

In 3.X flow we were using a info package which would load the targer cube through a PSA.

In 7.x flow, we are using a DTP. The data Source is Cube A and teh data target is Cube B.

Cube A has 1,53,000 records.

When data is loaded using the info package, all the added records in the source cube is transfered to the target. There are 56,000 records added to the target.

When loading through the DTP, it fetches only 44,000 records.

i have checked the transformation and the update rules for the DTP and the info package..There is no difference.Also there are no routines used.

Can any body suggest what the problem could be and how to rectify it?

[Former Member]

Hello ,

please check the primary fields for the sending cube and receiving must be same , if you need to get the same number of records when you extract from one cube to another

hope i am correct

Regards

Sandy

[Former Member]

Archana,

It is very possible for the DTP to bring less number of rows, because the newly brought records which are not loaded to any target from the PSA only will be brought by your DTP. I think your process is correct and if you want to make sure, delete the PSA and do a full load using a info package to the PSA, then load it using DTP and the records should match.

Good luck,

Alex.

[former_member205352]

In BI 7.0 :

Even I have faced such kind of issue not sure if its some problem with code which displays records in manage screen.

And I can find such issues in SDN too.

Let us know if you figure out this.

But the good thing is when I check in the datatarget the data there and the one in below target matches.

You can check if the data matches between the two using the request id.

[Former Member]

I agree with Praveen. Same happened in my case too.

the records displayed in the manage was different but when I checked the Rowcount in the infocube using Listcube I got the desired results.

[Former Member]

Hi Archana,

I would rephrase your query for my understanding.

you are loading data from one info cube A to B through infopackage using BW 3,5 concept and getting 56000 records

if you load it via DTP then you get 44000 records,

Also you have compared update rules and Transformation, if they are same then only thing is chek out for filter options in DTP there might be some filter which is filtering these records .

Thanks

Rahul

[Former Member]

Hi Rahul,

The problem is there is no filter set in the DTP or are any routines to filter the data.

But still the problem persists.

[Former Member]

how did u do both the loads and do you have both dataflows (3.x and 7.0) at the same time?

[Former Member]

I have been using the info package so far. We are now migrating to 7.0 flow.

the info package loads from a datamart.

After clearing all the delta's from the target i loaded with the infopackage(Full load) to check the data.

Again I cleared the requests from the source to the target and triggered the DTP.

Here i noticed that thet no. displayed in the transfered records and the added records columns in the manage screen of the target are different for the 2 loads.