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

最新推荐文章于 2024-09-16 07:53:15 发布

阿文PIONEER

最新推荐文章于 2024-09-16 07:53:15 发布

阅读量1k

点赞数

分类专栏： SASS 文章标签： SASS Data Analysis 数据分析

本文链接：https://blog.csdn.net/yawen9790/article/details/90490067

版权

SASS 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

本文介绍了SQL Server Analysis Services (SSAS) 的核心概念，包括SQL Server Data Tools (SSDT)、Analysis Services项目和数据源视图。通过数据源视图实现多个数据源的统一视图，利用Cube Wizard定义度量组和维度，并讨论了如何通过层次结构优化性能，以提高数据分析效率。

摘要由CSDN通过智能技术生成

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

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 source
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