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

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 store and process multidimensional database information. Essbase servers can be installed sepa
1 comment
Read more