Skip to Content
avatar image
Former Member

BPC Cube DATA archive - as data is growing

In a model, the data has grown tremendously. Though deletion/ clearing of old data helps in reducing the size, but requirement is how to Archive the data of the model.( not asking for Audit log Archival)

Request you to discuss a) the possibilities of Data archival for the BPC Model.

b) automation of archival c) How to use archived data for reporting purpose in future.

Thanks

Srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 15, 2017 at 08:55 AM

    If you want to use archived data for reporting then you need a copy of your environment on the same or different server. You can copy data to this environment using standard load from BW...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2017 at 07:16 AM

    Hi Srinivas,

    Please go through below note for SAP recommendations for BPC housekeeping. https://launchpad.support.sap.com/#/notes/1705431

    Point a - Hopefully the above note answers this.....

    point b - If you go with the above note then ask the BASIS person for automation......otherwise if moving to other model then you can create a process chain in BW to trigger after a period of time.

    point c - If you require the archive data for reporting purpose in future then I would recommend to export all the data to a flat file and then upload it to a new BPC cube or use destination app! Or you could transfer all the data to a BW standard cube and use the BEx report for future reporting.

    I hope you are using Lite Optimization process after data loads to remove the unwanted data and compress the cube

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Srinivas,

      I also dont have much knowledge about the BW data archiving process. So its best if you consult a BW consultant or SAP Support for this.

      To transfer from BPC to a BW cube as already stated you can export the data to flat file and then upload it to BW cube.

  • Feb 15, 2017 at 02:16 PM

    How often do you want to archive data? Once per year?

    Then transferring data using standard /CPMB/LOAD_INFOPROV_UI from BPC cube to another BPC cube is a simple option. Just perform Light Optimize with Zero Elimination before transfer to close yellow request.

    Add comment
    10|10000 characters needed characters exceeded