Skip to main content

Posts

Showing posts from April, 2020

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:- Export and Import Excel:- Navigate to OAC Classic modern interface Home page and from the Actions menu, select the option Export to Excel. On the Export to Excel dialog box, select the Parent-Child Export Build Method.Select Export Data and Export Scripts and  click OK. 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. Now to import that excel export, go to Application Tab and sel