【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 solutionA project has one or more data sourcesProject 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

Define a data source view that is based on a single data source.(Primary data source)Then add tables and views from a secondary data sourceWhen 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.

---