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: 318
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