Skip to Content

How to delete workbook in EPM?


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).



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 22, 2016 at 01:48 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 11:56 AM

    Sorry, but not clear!

    Please provide screenshots to understand your issues.

    Also provide screenshots of UJFS.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 12:24 PM

    Logged into EPM, at the workbook selection screen:

    Right click on BPC00 - Central Planning.xlsm and select 'delete' 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?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 01:19 PM

    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):


    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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!