olap 多维分析
An Online Analytical Process (OLAP) cubes are used as an analytical tool. An OLAP Cube is a multi-dimensional database that is optimized for reporting purposes.
联机分析过程(OLAP)多维数据集用作分析工具。 OLAP多维数据集是为报表目的而优化的多维数据库。
Let’s get started with Cubes in their pictorial representation. For that, I have put the below screenshot from
让我们以Cubes的图形表示形式开始。 为此,我从放了以下屏幕截图
The above OLAP cube has measures, Sales Amount, Sales Cost, Sales Qty and Profit Margin. These measures are analyzed using Product Categories, Time dimensions. If we further analyze, Time Dimension, we will see that year and month are the main attributes in the Time Dimension.
上面的OLAP多维数据集具有度量,销售金额,销售成本,销售数量和利润率。 这些度量使用产品类别,时间维度进行分析。 如果我们进一步分析“时间维度”,我们将看到年和月是“时间维度”的主要属性。
In the Microsoft BI family, SQL Server Analysis Service (SSAS) supports cubes.
在Microsoft BI家族中,SQL Server Analysis Service(SSAS)支持多维数据集。
Let us open SQL Server Data Tools (SSDT) and create anAnalysis Services Multi-Dimensional and Data Projectis created as shown in the following screen.
让我们打开SQL Server数据工具(SSDT)并创建Analysis Services多维,然后创建数据项目,如以下屏幕所示。
Following is the Solution Explorer for the sample project created in the previous screen.
以下是在上一个屏幕中创建的示例项目的解决方案资源管理器。
Let us create a data source for the sample project. We will be using theAdventureWorksDWsample database in this article.
让我们为示例项目创建一个数据源。 我们将在本文中使用Adventure