[go: up one dir, main page]
Scribd
Upload
190 views36 pages

Hyperion Essbase

Essbase is a multidimensional database that allows business users to analyze business data from multiple perspectives and consolidation levels. It stores data in a multidimensional array. Essbase supports two storage types: block storage and aggregate storage. The database includes objects like the database outline, rules files, calculation scripts, and security definitions. Dimensions can be standard or attribute, and members have properties like storage type that determine how data is stored and calculated. Data is loaded into Essbase using a data source mapped with a rules file, and calculations are performed using member formulas, scripts, and business rules.

Uploaded by

i am hacker
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
190 views36 pages

Hyperion Essbase

Essbase is a multidimensional database that allows business users to analyze business data from multiple perspectives and consolidation levels. It stores data in a multidimensional array. Essbase supports two storage types: block storage and aggregate storage. The database includes objects like the database outline, rules files, calculation scripts, and security definitions. Dimensions can be standard or attribute, and members have properties like storage type that determine how data is stored and calculated. Data is loaded into Essbase using a data source mapped with a rules file, and calculations are performed using member formulas, scripts, and business rules.

Uploaded by

i am hacker
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 36

Oracle Hyperion Essbase Introduction

Introduction to Hyperion Essbase


What is Essbase?
It is a multidimensional database that enables Business Users to analyze Business data in multiple
views/prospective and at different consolidation levels. It stores the data in a multi dimensional array.

The term Essbase came from Extended SpreadSheet dataBASE

Minute->Day->Week->Month->Qtr->Year
Product Line->Product Family->Product Cat->Product Sub Cat
Essbase Architecture
5
Storage type
Essbase support two storage type :
Block storage (BSO)
Aggregate storage (ASO)
Database Objects
Database outline
Rules files
Calculation scripts
Report scripts
Security definitions
Linked reporting objects
Partition definitions
Database Outline

Tree structure for dimension hierarchies


Consolidations and mathematical relationships between members
Outline Editor
Dimension Types

Standard Dimensions
Attribute Dimensions
Standard Dimensions

 Standard dimension - Standard dimensions represent the core components of a


business plan and often relate to departmental functions.
 Essbase allocate storage only for the standard dimensions. These are of two types.
 Dense dimension: The probability of the data availability is high for the
members in this dimension. Example: Period, Accounts
 Sparse dimension: The probability of the data availability is low for the
members in this dimension. Example: Product, Entity etc.
Data Blocks

 Data Block Size: Multiplication of Stored members in Dense Dimensions (Data


Cells) * 8 KB
Ex: If we have the Dimensions in a data base as (4D, 2D, 4S and 10S) – D: Dense
and S: Sparse Data Block size = (Dense*Dense)*8 = (4*2)*8B= 64 B
 Potential Number of Blocks - Maximum number of blocks (derived by multiplying
the number of members of one sparse dimension by the number of members of
another sparse dimension and so on) Multiplication of Stored members in Sparse
Dimensions gives the potential number of blocks.
In the above example potential number of blocks = (Sparse*Sparse) = 4*10 = 40
blocks
Data Storage and Accessing data

 Essbase use two types of internal structures to store and access data: Page Files
and Index system.
 Page file contains actual data means data-blocks and cells
 Essbase stores data values in data blocks.
 Essbase creates data blocks for each unique combination of sparse dimension
provided atleast one data value exists for the combination.
 The dense dimension combination forms the data cells in the data blocks. The
data cell contains the data value.
Index System

 Essbase creates an index entry for each data block.


 The index represents the combinations of sparse standard dimension members.
 It contains an entry for each unique combination of sparse standard dimension
members for which at least one data value exists.
 Each unique data value can be considered to exist in a cell in a data block. When
Essbase searches for a data value, it uses the index to locate the appropriate data
block.
 Then, within the data block, it locates the cell containing the data value.
 The index entry provides a pointer to the data block.
 The index handles sparse data efficiently because it includes only pointers to
existing data blocks.
Attribute Dimensions
Outline Terms: Generations

Generation defines a member’s location within the outline hierarchy from


the top of the dimension.
Outline Terms: Levels

Level defines a member’s location within the outline hierarchy from


the bottom of the dimension.
Outline Terms: Genealogy

Genealogy names relationships between members in the outline.


Dimension Types (Functionality)

 The dimension type is a property that adds special functionality to a dimension.


 The dimension types are None, Account, Time, Attribute, Country and Currency.
 None – Specifies no dimension type
 Accounts – Contains Items that you want to measure and provide the Essbase built in
accounting functionality available. This helps in Time Balance Properties and
Variance Reporting .
 Account Type : Revenue, Asset, Liability, Equity and Saved Assumption
 Time – It contains members that describe how often you collect and update data
 Attribute – Used to classify the members in other sparse dimension
 Country – Provides the entity details. We can specify currency used in each member
 Currency – Separates local currency from base currency. This is only used for
currency conversion applications.
Time Balance Property
Variance Reporting Calculation
Defining Member Calculation
Consolidation Property and Operators
Member Data Storage Properties

 Data storage properties define where and when consolidations are stored. The
default storage property is Store Data.
 Store Data - The member stores data. Store data is the default storage property.
 Dynamic Calc - The data associated with the member is not calculated until
requested by a user. The calculated data is not stored; it is discarded after the
request is completed.
 Dynamic Calc and Store - The data associated with the member is not calculated
until it is requested by a user. The calculated data is then stored.
 Shared member - The data associated with the member comes from another
member with the same name. Essbase does not store any values in the shared
members.
 Never share – This member data storage property does not allow members to be
shared implicitly. Implied sharing is a relative concept.
 Label Only - Although a label only member has no data associated with it, a label
only member can display a value. Scenario dimension is an example for Label
Only.
Enhancing Reporting Capabilities
Label Only Members
Shared Members
Member Aliases
Dimension Building

 Building dimensions is the process of loading dimensions and members to an


Essbase database outline by using a data source and a rules file.
 You can also use Outline Editor to add dimensions and members manually.
 Rules file is mandatory for dimension building. We cannot load the master data
without a rules file.
 The key objects in the dimension building are mentioned below.
Data Source, Rules File, Data Prep Editor
Process for creating a Dimension build rules file

 A. Select the data source file


 B. Define the delimiter and Header details
 C. Associate the outline
 D. Define the dimension build settings
 E. Define the fields settings
 F. Validate the Rules file
 G. Save the Rules file
Data Loading

 The process of adding data values to an Essbase database from a data source,
such as a Microsoft Excel spreadsheet or SQL database.
 If the data source is not perfectly formatted, you need a rules file to load the data
values.
Free-Form Data Loading

 You can load a data source directly if it contains all information required to load its
data values into the database.
Loading Data with the Rules File

 You can format the data source to map its data to the database.
 You can store the rules in a rules file.
 You can apply the rules to many data sources.
Calculations in Essbase

The data in Essbase can be calculated with the below options.


 Outline Calculations
 Member formula
 Calculation Script
 Business Rules
Smartview
35
Thank You
Sricharan

36

You might also like