Linked Measure Groups and Local Dimensions

Posted by ekoner on Stack Overflow See other posts from Stack Overflow or by ekoner
Published on 2009-08-17T07:37:30Z Indexed on 2010/05/18 2:41 UTC
Read the original article Hit count: 316

Filed under:
|
|

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.

© Stack Overflow or respective owner

Related posts about sql

Related posts about ssas