How to delete last greean request of delta cube -0UCSA_C01.

[Former Member]

Hi,

In delta cube (0UCSA_C01). After waiting 4 hrs I made yello request focefully green. Data of this request is in cube.I want to delete this request ,because no of added record is less than transfered record.How i can delete this data from cube. will repeat delta request work.Please write steps for deleting this request from cube.

Regards,

Anand Mehrotra.

[Former Member · Accepted solution]

Hi,

1. Go to your Infopackage monitor and make the status as "Red".

2. Then go to your Infocube Manage, and delete the request from here.

3. Next, go to your infopackage and schedule it.

Here, it will give a pop-up asking "Request Again".

4. Select "Request Again".

Your delta will be repeated now.

Hope this helps...

[Former Member · Accepted solution]

Thanks Apeksha M.

Just i want reconfirm that , this request data is already in cube . This cube has 4 years live data . If i make this request Red will it remove this data from cube. At this stage PSA Request is also red.

Regards,

Anand Mehrotra.

[Former Member · Accepted solution]

Hi,

Deleting a particular request wont delete the entire data from your cube.

It will only delete the data that has been updated in that particular request.

Also, when you do a repeat of the request, the data in that delta can be retrived again.

[Former Member]

Hi Anand,

If you want to delete the request from the cube just follow these steps.

1. Make the QM status to red for that request.

2. Delete the request from the Cube.

3. If you are loading the delta to this cube from any DSO, then you have to delete the Data Mart Status of the corresponding request in the DSO.

4. Then if you schedule the request again, system will you ask you for the Request again option, if you select that option delta will be reloaded to that cube.

In General, If you are loading delta to the cube, It is not necessary that Transfered and Added records should be same.

Veerendra.

[Former Member]

Thanks veerendra for quick reply.

Regards,

Anand Mehrotra.