链接的度量组和局部维度

发布于 2024-08-02 11:18:42 字数 594 浏览 3 评论 0原文

仔细思考我一直在读的东西。

根据Chris Webb

链接的度量值组只能是 与相同尺寸一起使用 数据库作为源度量组。

所以我认为这意味着只要两个多维数据集共享一个数据库,链接的度量值组就可以与维度一起使用。因此,我创建了一个新的多维数据集并添加了本地度量值组、本地维度和链接度量值组。但是,我无法在链接的度量值组和本地维度之间创建关系,即使它们位于同一数据库中也是如此。我收到以下消息:

当前的正常关系 数据库之间非链接(本地) 维度和链接的度量组 无法编辑。这些关系 只能通过创建 向导。该对话框可用于 删除这些关系。

我看到我可以转到原始多维数据集并在那里添加维度,但是下面的消息是否意味着我有其他选择?

我只知道这将是一件简单而琐碎的事情!感谢您的阅读。

Mulling over something I've been reading up on.

According to Chris Webb,

A linked measure group can only be
used with dimensions from the same
database as the source measure group.

So I took this to mean as long as two cubes share a database, a linked measure group can be used with a dimension. So I created a new cube and added a local measure group, a local dimension and a linked measure group. However, I can't create a relationship between the linked measure group and the local dimension even though they are within the same database. I get the message below:

Regular relationships in the current
database between non-linked (local)
dimensions and linked measure groups
cannot be edited. These relationship
can only be created through the
wizard. This dialog can be used to
delete these relationships.

I see that I can go to the original cube and add the dimension there, but does the message below mean I have an alternative?

I just know it's going to be something simple and trivial! Thanks for reading.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

千里故人稀 2024-08-09 11:18:42

如果您尝试执行我认为您正在执行的操作,请先添加另一个多维数据集(您尝试链接到原始的多维数据集),然后转到链接的维度选项卡并进行链接,它应该可以工作。
请务必在进行链接后检查您的聚合,因为如果您的两个多维数据集以不同的方式使用该维度,即使它们本质上都访问相同的维度,通常情况下它们也会变得愚蠢。

If you are trying to do what I think you're doing then add the other cube first (the one you tried to link to the original) and then go to the linked dimensions tab and do the linking and it should work.
Be sure to check your aggregation after you do the linking because often-times that can get goofy if your two cubes use that dimension in different ways even though they are essentially both accessing the same dimension.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文