BI business intelligence training series-(3) Introduction to SSAS and business intelligence ssas

BI business intelligence training series-(3) Introduction to SSAS and business intelligence ssas
Introduction:

A client tool provides the ability to design, create, and manage multidimensional datasets from a data warehouse, and access the OLAP data client.

The solution is as follows:

Related Concepts: dimensions:

Dimensions can be understood as the basis for Division. Simply put, dimensions are the data perspective. A dimension is linked to a database table through attributes. A dimension is actually a set of attributes. These attributes are provided by the table columns in the data source.

A primary key in a data table is called a key attribute. In addition to the key attribute, other attributes also have their own level or level, called the attribute hierarchy. For example, in the "calendar time" hierarchy, the "day" level should be related to the "month" level, and the "month" level should be related to the "quarter" level. Relevant examples will be introduced later. The relationships between them are called attribute relationships.

For example, the data in the database can have multiple dimensions, including order date, customer, and product. The database also has tables corresponding to the data.

As mentioned above, attributes are provided by columns in the Table. Therefore, attributes such as the Calendar Quarter and Calendar Semester in the table correspond to fields in the table.

The attribute relationship between them is

How to Set a hierarchy?

 Click the arrow to edit the property relationship.

Multi-dimensional data:

 It consists of basic information, dimensions, and measurement value groups.The measurement value is mapped to columns in the fact data table. A measurement value group is a measurement value set in a multi-dimensional dataset. For more information about instances, see.

Summary:

Compared with SSIS, SSAS involves many concepts and is complex. Therefore, you still need to design more business and practices to be comfortable.