View

From Olapedia

Jump to: navigation, search

A View is a way of seeing the data in an OLAP cube. In structure, they are broadly similar to a pivot table in Excel.

View Structure

There are three parts to creating a view:

  1. Arranging the dimensions. That is, which of the dimensions will be Title Dimensions (where only a single element can be selected), which will be Row Dimensions, and which will be Column Dimensions (where each of the elements selected generates a separate row or column of data).
  2. Selecting the elements which contain the data that you want to see from the cube's dimensions. This is called creating a Subset of the dimension.
  3. You also need to decide whether the selection should zero suppress the view; that is, prevent the display of rows or columns which contain no data at all. In TM1 versions prior to 8.3.1, zero suppression affected both rows and columns together. Since that version, rows and columns can be zero suppressed independently. (Page 26, 8.3.1 Release Notes.)

The body of the view will display data from the cube at the intersection of the selected dimension elements.


Views As Data Sources

Views can also be used as a Data Source for ETL tools. Such views typically consist entirely of Row Dimensions for flat processing of a single value per record. Sometimes a single Column Dimension (typically a Measures dimension) is used to process multiple values per record.

TM1 does not distinguish between views which are created for data analysis purposes, and those which are intended as a Data Source for TurboIntegrator. There is a school of thought that Cognos should create such a distinction and separate data source views from analytical views, given that data source views are seldom suitable for viewing and are often too large to be displayed. There has been little if any indication that Cognos is inclined to address this issue, however.

Personal tools