Essbase - Combinations/Intersections

Essbase Overview

About

Combination is also known as :

  • intersection,
  • dimension intersection.

Cube Combination

Notation

In Essbase, combinations are denoted by the cross-dimensional operator “→”

So :

  • July → Product A denotes the data block for July and Product A.
  • The intersection of July, Product A, and France is written July → Product A → France.





Discover More
Essbase Overview
Essbase - Cell

A cell is a part of a data block and represent a combination of the dense dimension members. Essbase orders the cells in a data block according to the order of the members in the dense dimensions of the...
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 Database With All Sparse Standard Dimensions
Essbase - Dense and Sparse Selection Effect on the data storage (performance)

The choice between sparse and dense dimension have a great influence on the storage and therefore on the performance of Essbase. data blockeach unique combinationsparse standard dimension membersdense...
Measures Dimension Dynamic Calc Tags
Essbase - Dynamic Calculations

When you design the overall database , you may want to define a member as a Dynamic Calc member. When you a member as Dynamic Calc, Essbase calculates the of that member when you retrieve the data, instead...
Essbase Data Source Kinds Of Fields
Essbase - Member fields (or member combinations field)

Member fields is a componeent of a data source which also contain : dimension field, data field. Member fields identify the members or member combinations of the specified dimensions. Use member...
Essbase Overview
Essbase - Members

Members are the individual components of a dimension. For example: the members of a Region dimension can be East, West, South, and Total US. Product A, Product B, and Product C might be members...
Essbase Short Cycle
Essbase - The OLAP Design Cycle (to create an optimized database)

A contains two types of values : the values that you enter or load (input data) and the values that are calculated from the input data (calculated data) Then a typical conforms to the following...
Essbase Overview
Essbase - Type of Database Data

A block storage database contains two types of values: Values that you enter, called input data Values that are calculated from input data, called calculated data intersectionmembersdimension ...



Share this page:
Follow us:
Task Runner