BI training series-(3) SSAS Introduction

BI training series-(3) SSAS Introduction
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:

Export/b7dv + export/release + export/gudi1yLXIoaPWrrrzu + HT0M/gudjA/dfTvenJ3KGjy/export + export = "http://www.2cto.com/uploadfile/Collfiles/20150426/20150426091145501.png" alt = "\">

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.