BI Business Intelligence Training Series--(iii) Getting started with SSAS

Introduction:

A client-side tool that provides the ability to design, create, and manage cubes from the Data Warehouse, as well as provide client access to OLAP data.

The solution is as follows:

Related concepts:Dimensions:

dimensions can be understood as the basis for division, simply to see the point of view of the problem of data. A dimension is a collection of attributes, which are provided by the columns of a table in the data source, through attributes and the database's table hooks.

The primary key in the data table, we call Key Properties . In addition to the key attribute, other properties have their own level or level, called the hierarchy of attributes . For example, in the calendar time hierarchy, the day level should be related to the month level, the month level should be related to the quarter level, and so on. Then there will be an introduction to the relevant examples. The relationship between them is called attribute relationships.

For example, data in a database can have multiple dimensions, with order dates, customers, products, and so on. The database also has tables that correspond to the data that is stored.

The preceding attribute is provided by the columns in the table, so properties such as the Calendar Quarter,calendar semester correspond to the fields in the table.

The attribute relationship between them is

How do I set up hierarchies?

Click the arrow to edit the attribute relationship.

Multidimensional data:

Consists of basic information, dimensions, and measure groups. a measure is mapped to a column in the fact table. a measure group is a set of measures in a cube. See examples.

Summarize:

compared to SSIS, the contents of the SSAS section involve more and more complex concepts. Therefore, it is necessary to design business and practice, to be handy.

BI Business Intelligence Training Series--(iii) Getting started with SSAS