什么是多维OLAP多维数据集，并给出具有3个以上维的示例多维数据集 [英] What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

问题描述

当我刚接触SSAS时，一直在阅读有关多维OLAP多维数据集的文章，并努力理解多维数据集的概念，据说多维数据集"一词虽然建议三个维度，但一个多维数据集最多可以包含64个方面.您能解释一下在多维数据集上怎么可能吗 (不是3-Dim示例x，y，z平面)?请不要只提供学习链接，也请期待一些解释.

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you please explain how is this possible on cube (other than 3-Dim example x,y,z planes)? Please don't give only links to study but also expecting some explanation.

推荐答案

不要将多维数据集视为三维结构(尽管有名称).数据仓库中的维"只是一个可变的值，可用于访问仓库中的数据.您可以将它们视为关键部分，但是可以轻松地将其单独或组合访问(不同于经典表中的主键).

Don't think of a cube as a three-dimensional structure (despite the name). A "dimension" in a data warehouse situation is simply a varying value that you can use to access data in your warehouse. You could think of them as key parts but ones that can be accessed individually, or in combination, quite easily (unlike primary keys in a classical table).

例如，您可能在仓库中具有以下维，用于保存客户和销售数据.

As for an example, you may have the following dimensions in a warehouse for keeping customer and sales data.

• 客户ID.
• 状态(位置).
• 年份.
• 月.
• 一个月中的一天.

这种布局(一个5D多维数据集")将使跨州边界并且全年(甚至在每月的不同时间)具有不同购买方式的客户可以轻松地执行查询.

That layout (a 5D "cube") would allow queries to be easily performed fo customers that cross state boundaries and that may have different purchasing patterns throughout the year (and even at different times of the month).

所有这些关键部分都只是指向特定客户在特定位置，特定年份的特定月份中特定月份的某月某天的单个销售数字.

All of those keyparts would just point to a single sales figure for the day of month in a specific month in a specific year in a specific location for a specific customer.

有关如何访问该数据的示例.假设您要查看所有客户的购买模式每月如何变化，这些变化是多年来的平均水平.您可以这样做来查看哪些客户在这几年的特定时间为您带来了最多的收入，例如，您可以在此之前的一个月左右针对他们进行广告投放.

An example on how to access that data. Let's say you wanted to see how all customer's buying patterns changed on a monthly basis, averaged over all the years. You would do this to see which customers generated the most revenue for you at specific times of the yearso you could, for example, target your advertizing at them in the month or so before then.

您将使用客户ID和月份来提取信息，有效地折叠"状态，年份和月份的维度(换句话说，对这三个维度的销售数据求和以得到二维结果，客户与月).

You would use the customer ID and month to extract information, effectively "collapsing" the state, year and day-of-month dimensions (in other words, sum up the sales figures for those three dimensions to get a two-dimensional result, customers vs. month).

这篇关于什么是多维OLAP多维数据集，并给出具有3个以上维的示例多维数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！