Linked Measure Groups and Local Dimensions
- by ekoner
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.
