This content has been marked as final. Show 4 replies
In the initial part of your question you mentioned about migration, If that is from one environment to another, You can do a DB backup and restore. This migrates everything from one environment to the other.
Coming to your other questions,
1) Metadata Export: You need to use migration utility to do this, So all the Properties, Exports, Imports etc get migrated. I am talking about DRM metadata. You may have different meaning when talking about Essbase or Planning.
2) Mapping to EPMA dimension tables: I am assuming that you will be maintaining hierarchies in DRM and changes should reflect in EPMA. You need to create Exports depending on your needs. It can be directly in Tables or Flat files, EPMA needs to pick these files on a regular basis.
3) Security: I think you cannot migrate DRM Security in Migration Utility. I do not have tool in hand so please try that while you do the Migration Utility for metadata. (not sure)
I just noticed your Subject about DEV to PROD, which you mentioned clearly.
In that case you can do a complete DB backup and restore process.
You will need to install DRM on PROD, Stop the services on both the servers, migrate the DB.
Once you complete that you need to do some checkpoints like the connections etc should be reflecting the PROD connections and so on.
Edited by: Likith Lanka on Apr 11, 2012 11:50 AM
I do not have any document that explains from end to end but this might help you. This link is explaining the older version but most of things work similarly.
Also look at Page 121 of the Oracle documentation. It is explained well. I think this should work for you.
Edited by: Likith Lanka on Apr 27, 2012 7:23 AM