Regarding InfoCube restore in SAP BW system ( on IBM i )

[Former Member]

Hi All,

Need your advise for restore of InfoCube ( logical data corruption in PROD).

So I have query regarding the restore of an infocube from BW system. Business need restore one of the infocube into production bw system, due to some issue. How I can achive only infocube restore on DB2 on i for SAP. SAP BW expert can advise about best approach from SAP BW way. Thanks in advance.

[former_member195641]

Hello Raja,

please check first if you can rebuild the cube from any internal source (DSO, PSA or other cubes) of your system. Well, it's more likely that you do not have all the data available anymore.

Another relatively easy way is to create a clone of your current BW system based on the last DB backup (you have to use a different SID and/or a different host). After configuring the clone, RFC and transport configuration you will be able to transport that cube or to load the data again from this new remote data source. This requires to have enough disk capacity to hold this BW clone.

After all, this work will not be covered by SAP's Develoment Support but is consulting (e.g. as offered by Volker).

Best regards,

René Lang

SAP BW on IBM i Development

[marco_simon2]

Hi Subramaniyan Raja,

maybe you might get a good point to start if you had a look into the how-to you can find here:

http://scn.sap.com/docs/DOC-15995

We had a similar problem twice and were able make the needed data available again.

One of the cases was an real-time cube for the BI-IP, which was the only source of the data in question - hence we did not have much options to get the data from anywhere else.

But once again - as mentioned by the pre-posters: It's completly on your own risk.

Best regards,

Marco

[Former Member]

Thanks.

[Former Member]

Thanks.