Question Re: How to delete workbook in EPM? in Financial Management Q&A

How to delete workbook in EPM?

Former Member — Tue, 22 Nov 2016 11:43:55 GMT

Running embedded BPC 10.1, using EPM within Excel.

We would like to delete some workbooks from our live environment as a tidy up. Some are no longer required whilst some have been inadvertently duplicated by users copying and pasting between folders.

Error we get when we try to delete from the EPM addin suggests having to put an entry into RSBPC0_TR_DELETE table. Full error below:

No request avaiable for deletion. Register it in RSBPC0_TR_DELETE

Can anyone elaborate on this message and indicate what needs to be done to allow us to delete?

Might be worth noting that some of the forms we want to delete dont exist in our development system (or we may want to keep them there), so doing a deletion in dev and transporting up isnt really an option (if that is the approach that would need to be taken).

Thanks

Re: How to delete workbook in EPM?

former_member186338 — Tue, 22 Nov 2016 11:56:01 GMT

Sorry, but not clear!

Please provide screenshots to understand your issues.

Also provide screenshots of UJFS.

Re: How to delete workbook in EPM?

Former Member — Tue, 22 Nov 2016 12:24:44 GMT

Logged into EPM, at the workbook selection screen:

Right click on BPC00 - Central Planning.xlsm and select 'delete' option...click Yes to confirm.

Receive this error

Thanks 🙂

Forgot to mention, I tried UJFS transaction in BW but it doesnt exist apparently. Am I missing something?

Re: How to delete workbook in EPM?

Former Member — Tue, 22 Nov 2016 12:32:31 GMT

I think UJFS doesnt work with Embedded....just saw!

Re: How to delete workbook in EPM?

former_member186338 — Tue, 22 Nov 2016 12:39:36 GMT

Ups, yes! No idea how documents are stored in embedded 😞

Re: How to delete workbook in EPM?

former_member186338 — Tue, 22 Nov 2016 12:40:48 GMT

Sorry, I have no idea how document storage is organized in embedded...

Re: How to delete workbook in EPM?

Former Member — Tue, 22 Nov 2016 12:57:57 GMT

😞

Will probably raise a ticket with SAP and see what they say. Will try to remember to update this once I have a response, just for anyone looking in future.

Re: How to delete workbook in EPM?

Former Member — Tue, 22 Nov 2016 13:19:28 GMT

Sap Note 2253295 on this issue (however the issue I have with this is that I just want to delete instances of duplicated workbooks, the below approach sounds like you have to first delete the workbook in development then transport up, which I dont really want to do):

Solution

The deleted BPC objects, like workspace, data access profile etc , cannot be collected via the Transport Connection in the transaction code RSA1, so you need to register a transport request according to the following steps before deleting a BPC object:

1. Create a workbench request via the transaction code se38

2. Run transaction code se16, input table name "RSBPC0_TR_DELETE" then click the button "Create Entries" or press F5

3. Input the transport request created in the step 1 and click "Save"

You can delete BPC object after finishing the steps above, otherwise you will get error message "No request available for deletion. Register it in RSBPC0_TR_DELETE." . Releasing the request will transport the deletions to the target system.

Please be noted that the above steps are only required for deleting transported objects, for the objects that have never been transported , the steps are not necessary and can be deleted directly.

Re: How to delete workbook in EPM?

former_member186338 — Tue, 22 Nov 2016 13:48:19 GMT

I do not like the idea to transport templates... Looks like you need to do it only once!

Re: How to delete workbook in EPM?

Former Member — Wed, 23 Nov 2016 06:30:34 GMT

Thanks for sharing this John....But as far as I can see they havent asked to transport the request...have they? You just have to collect those objects in a request for deletion! Create one specific request for collection of deletion objects but dont transport it!