Total Pageviews

Wednesday, June 18, 2025

EPBCS Trainings

 


                Job Support/Job Assistance 

       1. EPBCS Job Support
       2. EPBCS Job Assistance 

                   Hyperion Job Market

       

                        H1b PROCESS


              EPBCS TUTORIAL


=======================






Tuesday, June 3, 2025

Loading Data using Rules file, Free form method, Excel lock& send methods.

                   

                                        LOADING DATA INTO ESSBASE DATABASE

To load data into the database, we must build all dimensions first. The data will be loaded into a 

page file and indexes also will get created. When page file reaches 2 GB, it creates another file 

and so on. Same with index file. The files are created in the following path.


ARBORPATH/APP/app-name/db-name/ESS00001.PAG

ARBORPATH/APP/app-name/db-name/ESS00001.IND


Loading data can be done using any of the following methods.


1. Loading data using rules file

2. Free form data loading

3. Through excel lock and send (or through analyzer





Build the Dimensions using the Rule File

 


                                                  Build the Dimensions using the Rule File.


RULES FILES: Rules files are used to build the dimensions and to load data into Essbase database.


 * Rules files are stored with.RUL extension on the server.

 * To create the rules file, right-click on the rules file and click create Rules file.


Building Dimensions using Rules files: We can create the hierarchies in the outline manually or 

using rules files. There are 3 ways to build the rules files.


1. Generation reference method

2. Level reference method

3. Parent-child reference method

Consolidation properties

                                                 ESSBASE

+ Addition

- Subtraction

* Multiplication

÷ Division 

Ignore

^ Never

Sunday, June 1, 2025

Glossary Essbase

Application is a folder structure that contains one or more databases and related files. 

 Database is a folder that contains objects such as outline, rules files, calculation scripts, report scripts, and multidimensional data.

Outline: An empty outline is created as soon as the database is created. Double click on the 

outline and click Add children to add dimensions. Outline consists of Hierarchies.

 Dimension: consists of members. A hierarchy is nothing but a structural relationship among members. It gives parent parent-child relationship among members. The outline will also give consolidation operators. 

  Note: The name of the outline can be changed only by renaming the database. The name of the outline 

cannot be changed directly.

Parent is a member that has a branch below it. 

    Eexample, Margin is a parent member for  Sales and Cost of Goods Sold.

Child is a member that has a parent above it. 

      Example: Sales and Cost of Goods Sold are children of the parent Margin.

Siblings are child members of the same immediate parent, at the same generation. 

 Example: Sales and Cost of Goods Sold are siblings (they both have the parent Margin), but Marketing (at the same branch level) is not a sibling because its parent is Total Expenses.

Descendants are all members in branches below a parent. 

 Example: Profit, Inventory, and Ratios are descendants of Measures. The children of Profit, Inventory, and Ratios are also descendants of Measures.

Ancestors are all members in branches above a member. 

     Example: Margin, Profit, and Measures are ancestors of Sales.

The root is the top member in a branch. Measures is the root for Profit, Inventory, Ratios, and the 

children of Profit, Inventory, and Ratios.

Leaf members have no children. They are also referred to as detail members, level 0 members, 

and leaf nodes. 

   Example: Opening Inventory, Additions, and Ending Inventory are leaf members.

Generation refers to a consolidation level within a dimension. 

    A root branch of the tree, i.e., Dimension, is generation 1. Generation numbers increase as you count from the root toward the leaf member. 

Levels refer to a consolidation level within a dimension. The leaf member is at Level 0, and the 

parent member of level 0 is at level 1, and so on

Create Application, Database

                                 Application, Database CreationEssbase

An application is a folder structure that contains one or more databases and related files. 

To create an Application, log on to the Essbase server using the EAS console (Through the EAS server). 

  • Double-click on the Essbase server 
  • Right-click on the application
  • Click Create new application.
  • Enter application name. 

               The application name can take a maximum of 8 characters. 

DATABASE: A database is a folder that contains objects such as outline, rules files, calculation scripts, report scripts, and multidimensional data.

    To create a Database

Double click on the applications and right click on the database. Enter the Database name. The 

The database name can take a maximum of 8 characters for non-Unicode applications. 

==================


Friday, May 30, 2025

Calculations- Essbase


                                                              CALCULATIONS- ESSBASE

                                                                         BLOCK SIZE

                                              

Block Size: It is the multiplication of the store Dense Dimension Member (DDM) from each Dimension *8 bytes.

A-     Dense

A1- Store

A2- Store

   Total Dense Members: 2

B-     Dense

B1- Store

B2- Store

B3- Store

B4- Store

     Total Dense Members- 4

                                       Block Size: 2*4*8 Byte=64 Bytes