Introduction:-
Application
Restoration or backups is important and critical in any organization. OAC
classic has couple of methods through which Essbase app restoration and LCM
backups can be achieved. Below mentioned methods can be automated through any
scheduling tool like Autosys or Windows task scheduler.
Lets begin!
Restoration of application can be done in following ways:-
- Export and Import Excel:-
- Navigate to OAC Classic modern interface Home page and from the Actions menu, select the option Export to Excel.
- It will export the complete application in a Excel sheet file, on opening you will find different sheets for each dimension and a tab for the data.
- It will create a zip file for the data under Files.The interesting factor about the data file is it creates a column for each dimension.
- Once you Click OK, job will be created and it will be shown at Jobs Tab. After completing the importing, application can be seen at Application Tab.
- Import LCM Backup:-
- LCM Backup consists of all the artifacts, substitution variable and data.
- To restore apps in OAC classic import LCM backup is one of the options.
- First take the export LCM - export LCM will be explained in next topic.
- Go to Application Tab and Click Jobs.
- Select Import LCM.
LCM Backup can be taken in following ways:-
- Manual Backup:-
- From the Action Menu (Jobs) Select Export LCM
- CLI Utility:-
- Export LCM:- lcmExport [-verbose] -application appname [-zipfilename filename]
[-localDirectory path] [-threads threadscount]
[-skipdata] [-overwrite] [-generateartifactlist] [-include-server-level]
- Import LCM:-lcmImport [-verbose] -zipfilename filename [-overwrite] [-targetappName targetApplicationName] [-artifactlist artifactList]
- Please refer https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/cli-command-reference.html for further information on the CLI commands.
- Shell Script:-
- We can take export and import LCM backup through Shell script, Please refer to the below blog for detail information about the process and commands for shell script.
- https://www.mouritech.com/documents/articles/Creating-custom-Essbase-application-level-backup-in-OAC-Sudarshan-D.pdf
Comments
Post a Comment