DTP loading 0 Records.

[Former Member]

Hello all. I am loading data from cube to cube using DTP. Source cube has 1000 rows. DTP runs without error but does not extract any rows and hence does not load any either.

I am not using any routines or formulas in the transformations.

Any suggestions.

Thanks.

[Former Member · Accepted solution]

Hi,

I hope the request in the cube must be active... One more thing - In the extraction mode of the DTP, if you have used 'Delta', can you once try with 'Full'?

[Former Member · Accepted solution]

Mayank. I tried both Delta & Full. There are no filters.

Funny thing is, it just loaded with delta update after two hours of trying. I didn't do anything different.

I will keep this thread open so that I can try loading data a couple of times again and see if DTP stops loading data again.

Thanks.

[Former Member · Accepted solution]

Interesting..can you check Monitor for that particular request which didnot load data - Header Tab - Selections - Check if it shows any requests number.

If a request is already loaded, Delta DTP will not fetch that request again.

What SP are you running ?

[Former Member · Accepted solution]

Thanks Beekay. I deleted those requests. And for now DTP is loading data as it should.

I will come again if the problem occurs.

We are on Patch 12.

Thanks.

[Former Member]

Hi,

Do you have any filters in the DTP?