Skip to Content
author's profile photo Former Member
Former Member

Backing up cube definition and dimensions

Dear Experts

I have a 2-system landscape BI.

So, we cannot tell what could happen if transport from DEV to PRD.

So, I like to check with you if my idea is feasible.

I want a fallback plan.

I have new dimensions using new infoobjects. Existing dimensions are untouched.

I am afraid something may go wrong as there are lots of data in PRD cube which is compressed.

How can I reverse back if something goes wrong while transporting the cube definitions including the new dimensions?

The DEV is already modified and unlike the PRD.

If need to reverse back, can I change the DEV by removing the new dimensions and infobjects and then transporting these to PRD to reverse the situation?

Or can I do this to reverse back :

1. Transport connection > export the infocube using Infocube option in transport connection. Save this into a transport request number.

But will this prevent the import of request containing the new dimensions since this is a repair in PRD? If I release this request does it overcome this problem?

2. If importing new dimension gives problem, I reverse to pre-import situation by importing the request I exported from PRD back into PRD.

Please advise if this is feasible.

Thanks very much.

Pascal

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 18, 2013 at 05:10 PM

    Hi Pascal,

    Adding new dimensions to a cube will not cause anything to fail in PRD. Data for the fields in the new dimension will be populated going forward. If you are still concerned and would like a backup/reverse strategy, then you could do the following.

    1) Revert the changes made to the cube in Dev, copy and create another cube, create transformation between the actual cube and its copy. Create a DTP too. Move this config to PRD, and load the copied cube. This is to create a backup of data.

    2) Now you can add new dimensions to the actual cube in Dev, and move it to PRD. If anything fails, you can always revert the changes in Dev to have the original structure, and move it to PRD. You can load data from the backup cube.

    Well, this is my take on the situation, there could be an efficient way of doing it so lets see what our experts have to say 😊

    Thanks,

    Ranga.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.