SSAS，尺寸数值过滤 [英] SSAS, dimension numeric value filtering

问题描述

我正在SSAS中使用多维模型，看似很简单.

I am using the multiple dimensional model in SSAS with a seemingly simple requirement.

我有一个带有价格属性的产品尺寸表.使用Excel数据透视表，我要过滤此Price属性，例如大于$ 1000".但是数据透视表中的过滤器仅是一个字符串，因此我不能执行任何数值比较操作，而只能执行等效的字符串，例如"$ 1,000.00".

I have a Product dimension table with a Price attribute. Using Excel pivot-table, I want to filter this Price attribute, for example "greater than $1000". However the filter in the pivot table is a string only, hence I can not do perform any numerical comparison operations, but rather for equivalent strings, e.g. "$1,000.00".

我的问题类似于此线程，我想知道是否有我错过的解决方案/解决方法?

My problem is similar to this thread, and I wonder if there is a solution/work around that I missed?

最诚挚的问候，

CT

推荐答案

如您所链接的线程中所建议，您可以为价格创建度量，然后对其进行过滤.此计算量度的定义类似于

As suggested in the thread that you link, you could create a measure for the price, and then filter that. The definition of this calculated measure would be something like

[Product].[Product].Properties("Price", TYPED)

假设维度以及属性都命名为"Product"，并且属性的价格定义为名为"Price"的属性.

assuming the dimension as well as the attribute are named "Product", and the attribute has the price defined as a property named "Price".

(您在BIDS中将一个属性定义为从产品"属性到价格"属性的关系.)

(You define a property in BIDS as a relationship from the Product attribute to the Priice attribute.)

这篇关于SSAS，尺寸数值过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！