基于两个时间层次结构的两个独立度量 [英] Two independent measures based on two time hierarchies

问题描述

我有一个带有事实表的简单多维数据集，该事实表除其他外具有一个日期字段，并将其与一个具有2个层次结构的时间维度相连.

我想做的是创建一种度量，该度量将仅按一个时间层次结构进行过滤，而将第二个度量针对第二时间层次结构进行过滤.

基本上是这样:

Measure1 ----> Cannot be affected by filtering of time_hierarchy2 and gets filtered only by time_hierarchy1

与Measure2相同.

到目前为止，我无法尝试执行此操作，因为每当我在多维数据集浏览器过滤器区域中添加时间层次结构时，当我希望它们独立时，它会同时影响这两个度量. 这可能吗?

解决方案

以您描述当前数据模型的方式，这是不可能的.在Analysis Services中，如果您要查看维度使用情况标签，则会注意到该维度可以衡量组的使用情况.对于单个度量与维度的关系，在浏览多维数据集时，该度量将受到相关维度的所有属性/层次结构的影响.

如果可行的选择是在您的事实中拥有单独的TimeKey，则可以建立角色扮演维度，并从您的事实到Time维度具有多个约束.

另一个选项可能类似于我最近将此设置拆分为多个事实，每个事实都具有对时间维度的单个引用，因此我可以在同一时间轴上将不同的度量绘制到同一图形上. 如何避免角色扮演维度

I've got a simple cube with a fact table which has a date field among others and connected it with a time dimension which has 2 hierarchies.

What I want to do is create one measure that will be filtered only by the one time hierarchy and a second one for the second time hierarchy.

Basically this:

Measure1 ----> Cannot be affected by filtering of time_hierarchy2 and gets filtered only by time_hierarchy1

And the same for Measure2.

With what I've tried so far I can't do this because whenever I add a time hierarchy in the cube browser filter area, it affects both measures while I want them to be independent. Is this possible?

解决方案

In the way you have described your current data model this is not possible. Within Analysis Services if you were to review the Dimension Usage tab you will notice the dimension to measure group usage. For a single measure to dimension relationship the measure will be affected by all attributes/hierarchies of the related dimension when browsing the cube.

If a viable option would be to have a separate TimeKey in your fact you may establish a Role Playing Dimension and have multiple constraints from the your fact to Time dimension.

Another option could be similar to where I recently split this setup into multiple facts each with a single reference to the Time dimension so that I could the plot separate measures to the same graph on the same time axis. How to avoid Role Playing Dimension

这篇关于基于两个时间层次结构的两个独立度量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！