Skip to Content

Backup reports to--and restore reports from--a file?

My users save their AOLAP and Webi reports to either of two public folders. I'd like to perform weekly backups of the reports in these two folders -- in case users need to restore a report to an earlier version.

Is it possible to create a backup of such reports, writing them to a file (perhaps an .LCMBIAR file) ... and then restore any of the reports, if needed?

I don't need to backup security or dependencies.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 14, 2017 at 09:11 AM

    You can try the below option if you have less number of reports/objects:

    1. Create a promotion management job, refer below:

    https://blogs.sap.com/2013/12/20/promotion-management-in-sap-business-objects-bi-platform-40/

    https://blogs.sap.com/2012/10/25/promotion-management-in-bi40/

    2. Now schedule this job depending on your need by clicking on schedule on the right bottom corner.

    3. After clicking on schedule, give appropriate recurrence details and schedule it.

    One more option would be to write a script for the same. Refer to 1634962 for more details on LCM CLI usage. A sample

    CLI.properties file is attached to this kbase.


    Regards,

    Deepak

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2017 at 12:26 PM

    Thanks! Originally, I was doing a Live-to-Live backup, using the CMC's Promotion Management interface. When this stopped working a few months ago, SAP Support told me it was due to the number of reports in the folders (about 5,000)...and that PM jobs are not meant to be used when there are more than a 100 objects.

    My team lead has asked me to consider backing up to an .LCMBIAR file instead of doing a Live-to-Live backup. I hadn't considered using the PM interface to create an .LCMBIAR file. In any case, I reviewed your three references (and other references) but haven't been able to conclusively determine whether it's possible to restore an individual report (perhaps by its ID or CUID) from an .LCMBIAR file. Do you know?

    Add comment
    10|10000 characters needed characters exceeded