Wednesday 25 December 2013

Moving Essbase Objects between Applications



 Moving Outlines between Databases:

To copy a complete outline from one database to another database:

  • Open an Outline.
  • Select File, and then Save as.
  • In the Save As dialog box, specify the file system location or the Essbase location to which to save the outline.
  • In the message about replacing the existing file, select yes.

Moving Databases between Applications:

To copy a complete database from one application to another application:

Use the following methods,

 MaxL Script:
Create or replace database ‘App_Name’.’New_DB_Name’ as App_Name.’Old_DB_Name’  

ESSCMD:
>>COPYDB “App_Name” “DB_Name” “App_Name” “New_DB_Name”

EAS Console:
Right click the DatabaseàCopyàEnter New Database Name

No comments:

Post a Comment