【SSAS】SQL Server Analysis services | 【数据分析 (一) 】名词解释

Words Definition

SSDT:

SQL Server Data Tools

SSAS:

SQL Server Analysis services

Analysis Services project

A project based on an Analysis Services multidimensional model template。

Solution

Includes one or more projects

Project

• A collection of related objects.
• Projects exist within a solution
• A project has one or more data sources
• Project source databases are frequently hosted on one or more remote computers

Data source view

• A single, unified view of the metadata from the specified tables and views that the data source defines in the project.
• Enables to work with the metadata during development without an open connection to any underlying data source.
• Based on one or more data sources.

Steps of define a deta source view based on multiple data source

1. Define a data source view that is based on a single data source.(Primary data source)
2. Then add tables and views from a secondary data source
3. When designing dimensions that contain attributes based on related tables in multiple data sources, you might need to define a Microsoft SQL Server data source as the primary data source to use its distributed query engine capabilities.

Cube Wizard

• Define the measure groups and dimensions for a cube.

Attributes

• Are commonly based on fields from a data source view.
• Include fields from any table in the data source view.

Deploying/ Processing

Deploying an Analysis Services project creates the defined objects in an instance of Analysis Services.

Processing the objects in an instance of Analysis Services copies the data from the underlying data sources into the cube objects.

Improve the preformance through Hierarchy structure

Hierarchies:

support navigation and aggregation at various levels

Formats:

specific measure

Define calculations and relationships:

speeds up dimension, partition, and query processing

Named calculation

• A SQL expression(calculated column, a table in a data source view)
• Enable extending the relational schema of existing tables in a data source view without modifying the table in the underlying data source.
• Refer as a property of an attribute.

Composite KeyColumns

• Contains the column/ columns that represent the key for the attribute.
• Create uniquely identify an attribute.