AggregateFunction中的SSAS设置为None？ [英] What does the SSAS setting None in AggregateFunction do?

问题描述

据了解，Microsoft的解释将度量标准的AggregateFunction设置为None，除非您以最低级别查看数据，否则将使该值无效。 （即，数据元素是立方体中一个确切单元格中的值的副本）。

我已经在粮食产品ID和销售日期创建了一个事实表，并将AggregateFunction属性设置为几个度量（它们是某种类型的百分比）无，并且我在多维数据集中的每个级别都空白，甚至是产品/销售日期级别（我正在使用Excel连接到多维数据集并通过数据透视表钻取）。

我确定有一些简单的东西，我失踪了，但我看不到什么。

解决方案

当度量的聚合功能设置为无时，SSAS不会计算任何维度中全部成员的度量。换句话说，对于措施，我们将只有只有叶级值，而且只对与该事实直接相关的维度。

您可以在这篇文章中找到更详细的说明。

As I understand Microsoft's explanation setting the AggregateFunction of a measure to "None" should null out the value unless you are viewing the data at the lowest possible level. (i.e. the data element is a copy of the value in one exact cell in the cube).

I've created a fact table at the grain product id and sales date, and have set AggregateFunction property of a few measures (they are percentages of some sort) to "None", and I nulls at every level in the cube, even the product/sales date level (I am using Excel to connect to the cube and drilling through a pivot table).

I'm sure that there is something simple that I am missing, but I don't quite see what.

解决方案

When Aggregate Function of a Measure is set to 'None', SSAS does not calculate the measure for the 'All' member in any dimension. Put in other words, we will have only leaf-level values for measures and that too only for dimensions that are directly linked to that fact.

You can find more elaborate explanation in this post.

这篇关于AggregateFunction中的SSAS设置为None？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！