基于时间条件的自动过滤属性成员 [英] Automatic filter attribute member based on time condition

问题描述

我正在使用SSAS中的多维立方体并在Excel中进行分析

I am working with Multidimensional cubes in SSAS and analysed in Excel

是否可以在显示特定年份时触发自动过滤器。例如，在2010-2018年的医院数据表中，有一个医院'医院A'，在2017年的2年内没有任何入院措施。 2018.
如果显示任何年份（过滤掉），那么我希望将医院A过滤掉。如果那些年份都没有过滤掉，则过滤'开'。

Is it possible for an automatic filter to be triggered when certain years are displayed. For example, in a table of hospital data for YEARs 2010-2018, there is a HOSPITAL 'Hospital A' that does not have any ADMISSION measures for 2 years of 2017 & 2018. If any of those years are displayed (filtered on) then I would like Hospital A to be filtered 'off'. And filter 'on' if none of those years are then filtered off.

推荐答案

pm pmor1503

Hi pmor1503

根据您的描述，您似乎想隐藏数据 当没有特定年份的数据时，对吗？

According to your description, it seems that you want to hide data  when there is no data for specific years, right?

 在Excel中，它会自动显示非空的数据。我有一个日期维度（日历表），它基于订单日期与事实表相关，而产品表与基于产品密钥的事实表相关。因此，当您创建度量并且
在Excel中进行分析时，它将显示如上所示的结果。

 In Excel, it will show data which is not empty automatically. I have a date dimension(calendar table) which be related to fact table based on order date, and product table is related to fact table based on product key. So when you create measure and analyse it in Excel, it will show result like above.

这篇关于基于时间条件的自动过滤属性成员的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！