1. Basic concepts
  • Print

Views: Basic Concepts

Let's define the necessary elements for the analysis and views on LITEBI.

- Dimension: Set of data that can group, filter or divide the information that is being analyzed. All this can be done through the hierarchy levels defined in the dimension.


- Levels: Every dimension has a base level. The base level is the level of the dimension with the maximum  level of detail and is used to link the shared dimension's data with the data of the cubes that use it. You can define other levels in the dimension that contain information about each member of the dimension and allow to build hierarchies of levels to explore the information of the dimension contained in a cube from different points of view.

- Hierarchies:  Built from pre-defined levels. You can set the desired order to further deepen  on the data in the reports. The deeper level will always be the base level.

- Cube: Set of data oriented towards analysis and reporting. The cubes are formed by a series of indicators and dimensions. Through the dimensions you will be able to analyze the values contained by indicators.

- Indicators: These are the values ​​displayed in reports.

- Dimensions: These are the dimensions on which later, when we explore the cube, we will be able to create reports. The dimensions of the cube can be shared or embedded:

Shared: These are the dimensions defined above, outside the cube, which can be shared by several cubes.

Embedded: These are dimensions that belong exclusively to a cube. They have a single hierarchy and may have as many levels as desired.


- Calculated Members (Formulas): The cubes can have calculated members that appear as another indicator or as a level within a hierarchy of the dimensions used. Calculated members are calculated values ​​based on formulas applied to parameters defined in the cube. They can be done in the cube or in a particular view.


- Sets: The sets are predefined groups of members of a dimension that can be defined and reused in the views of the cube. The sets can be a list of members, but also can also be calculated through formulas.