Copy of a model

[srshekars]

Hi,

We have a need to copy a model along with its transaction data from one system to another system. Will it be possible. If yes, please let me know the details.

For Eg., We have a XYZ model in ABC system in environment PQR, now we wants to copy the model along with its transaction data to DEF system.

Thanks,

Sekhar

[Former Member · Accepted solution]

Hi Sekhar,

Model doesn't exist in a system; it exists in an Environment. So, the question is - do you have Environment PQR in system DEF? If you have - how did it got there?

Regards,

Gersh

[srshekars · Accepted solution]

Hi Gersh,

Thanks for correcting me.

The issue is we implemented a note for Large Key figure in our Dev system for Consolidation model. It failed and resolved it by implementing another note.

As the SDATA deleted after copying it to LSDATA (KEYFIGURES), the finance wants to have a proof that all the data gets copied before deleting. We have the same Conlidation model in another system (Quallity) with the same environment (both systems refreshed recently from PROD). We need to copy that model from Quality to DEV. We have RFC connection from QA to DEV. We can create a TR and move Structure of the Model but not Transaction data. So, Checking that is there any possibility to copy from QA to DEV.

Thanks,

Sekhar

[former_member186338 · Accepted solution]

Export to text file / Import from text file?

Vadim

[Former Member · Accepted solution]

Hi Sekhar,

So, you need to copy just Transaction data from one box to another, not structure of the Model since both of them came from Production, right?

Since it's a one time deal I can see 2 options: via flat file and using BPC load. Which option to choose probably depends mainly on number of records in the Model.

With small record number export and import would be a straightforward solution. Or UJBR just for that one Model.

If that Model has plenty of data then it makes sense creating a Virtual Provider in the target system based on Base cube in the source system. Then load from that VP to your target Model.

Regards,

Gersh

[srshekars · Accepted solution]

Hi Gersh,

Need some more info on UJBR. We took backup data of only one model in the environment ABC (Dev system 1), and in other system (Dev system2) also we have the same Environment which is a copy of the DEV1 system. We wants to restore only a model XYZ which we took back up. Is it possible to restore it in the same environment in the dev2 system (only the model XYZ). Or will it overwrite the entire environment. This is different model which is not available in dev2 system.

Thanks,

Sekhar

[former_member186338 · Accepted solution]

UJBR is used to restore full environment, not a separate model.

Vadim

[Former Member · Accepted solution]

This is not true any longer.

Latest version of UJBR allows backup/restore of separate Models and even selected category members.

[Former Member · Accepted solution]

Hi Sekhar,

I assume that if you were able to backup just 1 Model you either implemented OSS Note 2047143 or on corresponding SP.

Then when you restore you have to populate only Application ID and uncheck all other check boxes.

Now I didn't understand your requirement.  From one hand side you said that DEV2 is copy of DEV1. From another hand side you said that DEV2 doesn't have Model XYZ which is in DEV1. How is that possible?

You can't restore single Model if it's not there in the Environment. You have to restore metadata first to bring the Model, but you can restore metadata of 1 Model only.

Regards,

Gersh

[srshekars · Accepted solution]

Hi Gersh,

Thanks for the info. DEV2 is the copy of DEV1, we recently develoed this new model in DEV1. We made some developments in DEV2. Both are on different TRACKS.....AD track and BAU track. So, both have different development systems.

Thanks,

Sekhar

[Former Member · Accepted solution]

If it's created after copy is made  - it's not a copy anymore.

So, only 2 options left: export/import and BW load.

[former_member321653]

Hi Sekhar,

1. Try Using UJBR to take backup of your environment from source system and then restore the environment into destination system.

2. Then create required model in your environment with same specification as source model.

3. Load data from copied environment model to newly created model using "BW transactional Load" data manager package.

Hope this will help.

Regards,

Rahul Y

[Former Member]

Hi Sekhar,

I think there is two easiest way to copy the transaction data from one server to another server.First you can you use data manager package for export the transaction data from source system to a flat file and then import the flat file to target system .Another way is you can export the transaction data to a flat file in source system BW workbench and then upload flat file to target system through data manager package.

Khokan