Skip to main content

Methods OACS Essbase app Restoration and LCM backups


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:-

  1. Export and Import Excel:-
    1. Navigate to OAC Classic modern interface Home page and from the Actions menu, select the option Export to Excel.

    2. On the Export to Excel dialog box, select the Parent-Child Export Build Method.Select Export Data and Export Scripts and  click OK.

    3. 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.
    4. 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.
    5. Now to import that excel export, go to Application Tab and select import. Select the Excel file and Click OK.



    6. 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.
  2. Import LCM Backup:-
    1. LCM Backup consists of all the artifacts, substitution variable and data.
    2. To restore apps in OAC classic import LCM backup is one of the options.
    3. First take the export LCM - export LCM will be explained in next topic.
    4. Go to Application Tab and Click Jobs.
    5. Select Import LCM.

    6. Select the export zip file and give the application name, now if want to overwrite the existing application, select Overwrite or if want a new application Click directly OK

LCM Backup can be taken in following ways:-

  1. Manual Backup:-
    1. From the Action Menu (Jobs) Select Export LCM

    2. Select the Application and Name for the Backup and if data is not need check the Skip Data option else keep it un-check and Click OK.

  2. CLI Utility:-
    1. Export LCM:- lcmExport [-verbose] -application appname [-zipfilename filename] [-localDirectory path] [-threads threadscount] [-skipdata] [-overwrite] [-generateartifactlist] [-include-server-level]

    2. Import LCM:-lcmImport [-verbose] -zipfilename filename [-overwrite] [-targetappName targetApplicationName] [-artifactlist artifactList]
    3. Please refer https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/cli-command-reference.html for further information on the CLI commands.
  3. Shell Script:-
    1. 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.
    2. https://www.mouritech.com/documents/articles/Creating-custom-Essbase-application-level-backup-in-OAC-Sudarshan-D.pdf 

Comments

Post a Comment

Popular posts from this blog

Business Intelligence

Business Intelligence You must be wondering what is the above imageor title is about. Yeah, it is about the first project I get into. Where the client was using all the above process to generate a report, which will help them to manage their financial planning. So now you must be having an idea that what this blog is about i.e; using Business Intelligence, EPM, ETL and ERP how the financial decisions are taken. Here the client uses the different processes to achieve their goals. So let’s dive in and try to understand the process.  Note - In this blog, you will get an overview of each process and its high-level architecture. Enterprise Resource Planning -  Firstly let's start with  Enterprise resource planning (ERP),  most of the companies store data through ERP. It is a process whereby a company manages and integrates the important parts of its business. ERP system stores both operational and non – operational data. An ERP management information system int
8 comments
Read more

Smart View connection

Smart View connection Before connecting Oracle smart view with essbase. You need to download it from oracle website and install it. installation is easy process..next next next ...finish... Below is the link for downloading smart view. https://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-2412371.html Smart-view Connection – Download Excel and Oracle Smart-view from the web. Open MS Excel – Go to File -> Options Go to Add-in                    Go to Mange and select COMM Add-ins and Click Go Select Oracle Smart View for office and Click OK After the above step you see a SMARTVIEW option in the last of Excel ribbon. Click it!    Now to connect the smart-view with the Essbase server. Click the Panel option. You see an Smart-view panel on the right side. Click the Shared Connections.    After clicking Shared Connections option on the Smart-View P
Post a Comment
Read more

Data Analytics – Introduction to Hyperion

A popular saying among industry professionals “ data is the new oil ” Implies that data, when harnessed (or, like oil, “refined”)  properly, can provide high value. Contents -   1 . Data Analysis.   2. Data Analytics.   3. Business Intelligence.   4. Enterprise Performance Management (EPM).   5. Oracle Hyperion Introduction - History.   6. Oracle Hyperion - Essbase and Planning.                                     - Planning , Budgeting , Forecasting.   7. Oracle Essbase Architecture. Data Analysis   Data Analysis is separating out a whole into parts, study the parts individually and their relationships with one another. For example - if we have a whole data set and we are doing analysis on it means we pull sample data set from the whole data and then learn more about it and how it is related to the other samples. Data Analytics Data Analytics is the principle or logic that drives the analysis. For example - As mentioned in before exampl
Post a Comment
Read more