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 man...
8 comments
Read more

Docker with Essbase

Oracle Essbase with Docker What is Docker: Docker is a tool which put together an application and all its dependencies together in the form of containers. This containerization aspect of Docker ensures that the application works in any environment. Docker is an open – source project that automates the deployment of application inside software container. Docker containers wrap up a piece of software in a complete file system that contains everything it needs to run. Docker vs VMs with reference to Essbase: Traditionally we were using VMs, Following are some issues in VMs with compare to Docker. • Large image size: Essbase VMs tend to have in at 50-70GB, depending on what all is installed. • Difficulties starting up services: When moving between networks, such as from home to a client network to the coffee shop or wherever, I frequently run into networking issues that are hard to troubleshoot and usually resolved by restarting the entire VM (...
1 comment
Read more

Hyperion Essbase - Administration Services

Administration Services in Essbase. In this blog i m going to briefly discuss about Hyperion Essbase Administration Services. It is this core part of Essbase for managing data in the database. Introduction about Administration Services in Essbase  –   It’s a cross-platform administration tool for Essbase It consists of three tiers Administration Services Architecture – ·         Client Tier (Administration Services Console) – it’s a Java-based client console also called as EAS console (Essbase Administration Services Console). It’s a UI to manage Essbase Environment.              Middle Tier (Administration Server) – it’s a Java-based server maintains communication, session, and security information between console and Essbase server. It uses HTTP and TCP/IP protocols to communicate.        Database Tier (Essbase Servers) – One or more Essbase servers ...
1 comment
Read more