Skip to main content

Posts

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
Post a Comment
Read more
Recent posts

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 (and hopin
1 comment
Read more

OACS Essbase Security Filters

Setting up security filters manually and using Maxl script in OAC Essbase and assigning it to Users and Groups. As you know security is most important thing in any field likewise in OACS also. So in this blog I will show you how to create security filter’s in OAC Essbase and restrict the user to see the data. I will be doing in two ways. 1        Manually 2        Using MaxL So, let’s get started. First let’s have a brief discussion about the Filter’s. Filter are used to control security access over the cube data. It can be assigned to a user or group. Depending on the security role of a user determines whether you can create, assign, edit, copy, rename, or delete a filter. Filters have two important things – Access and Member specification. Access – Access are of four types in OAC Essbase 1.      None - No data can be retrieved or updated 2.      Read - Data can be retrieved but not updated 3.      Write - Data can be retrieved and updated 4.      Me
2 comments
Read more

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