Essbase - (Dimension|Outline) Build

Essbase Overview

About

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file.

When you build, you always need a rules file to perform action as:

  • Adding dimensions and members to the database
  • Changing existing dimensions and members in the database

You can load data without updating the outline, update the outline without loading data, or load data and build dimensions simultaneously.

Process for Building Dimension

To load dimensions and members into an Essbase database, follow these steps:

Set up the data source

Set up the data source. If you are not using a rules file, you must set up the data source outside Essbase. If you are using multiple data sources, see Essbase - Performing Deferred-Restructure/Incremental Dimension Builds

Set up the dimension build rules file

Set up the dimension build rules file if necessary : Essbase - Essbase-friendly/free-form Data Sources (Don't Need a Rules File during data load)

Perform the dimension build

Perform the dimension build

Support

After you correct the possible problems, you can reload the records that did not load by reloading the error log. See Loading Dimension Build and Data Load Error Logs.

Automation tools to build dimension

After you create a dimension build rules file, you may want to automate the process of updating dimensions.

Tool Topic Location
Essbase - Administration Service (EAS) Performing a Data Load or Dimension Build Oracle Essbase Administration Services Online Help
Essbase - MaxL import dimensions Oracle Essbase Technical Reference
Essbase - EssCmd BUILDDIM Oracle Essbase Technical Reference

Example with MaxL

You can automate the loading of dimensions by creating a Essbase - MaxL Script. The import database consists of the following elements:

spool on to "$arborpath\\LoadDims_log.txt";
login $1 $2

/* ********************** */
/* Load Dimension Build Information */
/* ********************** */

import database 'Bigcorp'.'Sales' dimensions from server data_file 'Configpc.txt'
  using server rules_file 'Parchil' on error write to 'c:\dimbuilderr.txt';

import database 'Bigcorp'.'Sales' dimensions from server data_file 'Linepc.txt'
  using server rules_file 'Parchil' on error write to 'c:\dimbuilderr.txt';

import database 'Bigcorp'.'Sales' dimensions from server data_file 'Cuschan.txt'
  using server rules_file 'Parchil' on error write to 'c:\dimbuilderr.txt';

Syntax:

IMPORT DATABASE APPLICATION NAME.DATABASE NAME DIMENSIONS
FROM (input data file information)
LOCAL | SERVER /* Location of the data file
FILE TYPE /* Type of data source whether a Text files, Excel File, or Lotus File
DATA_FILE
FILE PATH 'Path of the file
USING (Information about the Rule File)
LOCAL | SERVER ' Location of the rule file
RULE_FILE
RULE FILE NAME ' Name of the rule file like Markt
ON ERROR APPEND TO (error File information)
WRITE | APPEND
ERROR File name ' Path for error file as c:/log/DimError.log

Spreadsheet files

Restriction from UNIX computer

When using spreadsheet files to load data or build an outline in Essbase, the spreadsheet files must reside on a Windows computer, regardless of the tool you use. Spreadsheet files that reside on a UNIX computer or are transferred via FTP to a UNIX computer are not supported. If Essbase Administration Server is installed on a UNIX computer, data loads and dimension builds from client-side spreadsheet files are not supported.

Remove formatting

To avoid rules file, data load, and dimension build errors, remove formatting in Microsoft Excel data source files; for example, in Excel, set color to “Automatic” and “No Fill,” and remove font settings such as bold and italic.





Discover More
Essbase Overview
Essbase - (Dimension|Outline) Build

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file. When...
Essbase Overview
Essbase - (Load|Build) Cube Processes

To create a Essbase database, you must before calculation load data. Two processes are involved : first, a load of the member field to build the dimension known as a dimension build second, a load...
Essbase Overview
Essbase - Build Method

The build method has to be choose to perform a dimension build. The build method that you select : depends on the type of data in the data source and determines the algorithm that Essbase uses...
Essbase Overview
Essbase - Checking Error Log

If a data load or dimension build fails, the error log can be a valuable debugging tool. See Understanding and Viewing...
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Essbase Data Source Kinds Of Fields
Essbase - Data fields

Data fields are a component of data source which contain also : , Either the data source or the rules file must contain enough information for Essbase to determine where to put each data value....
Essbase Overview
Essbase - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
Essbase Data Source Kinds Of Fields
Essbase - Dimension Field

Dimension Field is a component of a which can contain also : , Dimension fields identify the dimensions of the database, such as Market. Use dimension fields to tell Essbase the order of the...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...



Share this page:
Follow us:
Task Runner