如何获得特定维度的预定义过滤器列表? [英] How to have a list of pre defined filters for a specific dimension ?
问题描述
大家好,
我是使用Excel Pivot Table的SSAS表格多维数据集的用户,我们有600个实体的维度。我们还使用MDS进行实体的主数据管理。
I'm a user of SSAS Tabular cube with Excel Pivot Table and we have a dimension with 600 entities. We are also using MDS for masterdata management of our entities.
我需要您对此商业案例的建议:
I need your advice for this business case :
- 用于控制分析需要,我们需要取消选择100个不相关的实体=>大量点击取消选择实体
- For controlling analysis need, we need to unselect 100 entities that are not relevant => lot of clicks to unselect entities
- 对于操作分析,则取消选择50个实体=>大量点击取消选择
- For operations analysis, then it's 50 entities to unselect => lot of clicks to unselect
但是,要选择或取消选择的实体列表不是固定的,它几乎每两周或每月更改一次,如果可能,应由最终用户更新,而不是如果用户想要重现之前的过滤器/分析,则需要保存/存档SSAS管理员以获得更大的灵活性和以前应用的过滤器
。
However, the list of entities to select or unselect is not fixed, it changes nearly every 2 weeks or monthly, if possible it should be updated by end users and not SSAS admin for greater flexibility and previous filters applied need to be saved / archived if users want to reproduce their previous filter / analysis.
那么,用户是否有办法定义"过滤器快捷方式"?这可以与我们所有的SSAS用户共享,例如:
So, is there a way for the users to defined a "filter shortcut" that could be shared with all our SSAS users, like this :
- 预先定义的过滤器"运营实体Jan 2019" =>选择490个实体
- Pre defined filter "Operations entities Jan 2019" => 490 entities selected
- 预定义过滤器"控制实体2019年1月" =>选择了490个实体
- Pre defined filter "Controlling entities Jan 2019" => 490 entities selected
- 预先定义的过滤器"2019年2月的运营实体" =>选择了495个实体
- Pre defined filter "Operations entities Feb 2019" => 495 entities selected
- 预先定义的过滤器"2019年2月的运营实体" =>选择了480个实体
- Pre defined filter "Operations entities Feb 2019" => 480 entities selected
谢谢!
推荐答案
在这种情况下,我会在维度表中添加一列或多列来对实体进行分类。 ETL可以处理分组。
In a case like this, I would add a column or columns to the dimension table for categorizing the entities. The ETL can handle the grouping.
表格模型在该维度表中将有一列或多列。然后,您可以通过新列使用过滤器或切片器,只需单击一下即可取消选择100或50组。
The tabular model would have an additional column or columns in that dimension table. Then, you could have a filter or slicer by the new column that can un-select that group of 100 or 50 in one click.
这篇关于如何获得特定维度的预定义过滤器列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!