DTP - Processing only selected PSA requests

[chris_robertson]

We made a change to inventory data which uses non cummulative values. To make the cube change we delete the cube's contents and transported the changes. Now I'm trying to reload the cube from the PSA tables. I reloaded the 2LIS_03_BX data source and compressed with no marker values option not selected.

Now I need the load only the initialization of 2LIS_03_BF & 2LIS_03_UM so that I can compress them with option no marker values selected. Then I can reload all of the daily delta updates for these two and compress them with no marker values option not selected.

The problem is that when I submit the DTP to reprocess either of these two data sources, I get a single request in the cube that includes the initialization and all the delta updates. That makes it impossible to compress them with the different options. Is there any way I can submit the DTP process and tell it to only load a specific PSA request?

Thanks,

Chris

[Former Member · Accepted solution]

Hi Chris,

Hope the process is difficult, but might be an alternative approach. If you were able to change the technical status of all the delta requests to Red (but not for INIT request) and run the DTP, it will pick only the INIT request and after successful loading and compression, you can change the request status to green and can schedule the DTP again which will pick the deltas.

Regards,

Raja Vuppala.

[Former Member]

Probably a cumbersome way. You could build a generic extractor on the PSA table and use info package selections to select your requests

[chris_robertson]

On the DTP screen there is an option to 'Get All New Data Request By Request'. It almost reads like it would process the PSA requests one at a time. Does any one know about the options?

[Former Member]

If you want to process only a set of PSA requests, you can specify those requests in the "Filter" section in the Extraction tab.

In your case, ''Get All New Data Request By Request' should work.

Depending on the support pack on which you are on, this has different behavior. Before NW SP 13, even after enabling this flag, it reads only the first new request and not the subsequent ones. To get all the subsequent ones you have to re-run the same DTP again and again.

Post NW SP 13, when you select this flag, you will get an additional flag "Retrive until no more new data" . If u set both these flags together, it should serve your purpose.

hope it helps

[chris_robertson]

Since the use of this cube is young and I only have five delta requests that would need to have the status changes, I will use that approach for now. The option to get only one request sounds like a better long term solution (i.e. when I have hundreds of requests to reload).