Loading Data - Adding Members to Dimension

Adding Members to Dimension

After creating the rule file for creating the members in the Essbase. Now we load data in the Essbase.

So hold on tight... Data incoming....

Loading Data - Adding Members to Dimension -

· Save and Close all the Outline Editor.

· Right Click on your Database. Go to Load data

· Now Select the Mode, Data source, Rules File and Click OK

Note: If data is loaded successfully, It show Success else it will show Warning. Error file can be find in Path Mentioned in the Error File at the time of loading the data.

· Once the members are loaded. You can notice the outline is changed. Members are added in the dimensions.

Comments

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

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 b...

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

Hyperion At Ease

Search This Blog