Sunday, March 11, 2012

Error in Metadata manager with Many-to-Many relationship

Hello,

For a while I've been trying, unsuccessfully, to get a many-to-many relationship to work. With so much help from this NG, I'm finally very close (I think).

But now, I am getting the following error when I deploy my cube... "Errors in the metadata manager." The 'Time' many-to-many dimension in the 'AwardBridge' measure group requires that the granularity of the 'AwardDimension' dimension is lower than that of the 'Facts' measure group."

While I get what the error is telling me, I don't know where to look for the granularity issue. It is unclear to me why this occurs when I think I have everything at the same granularity level.

Any help is greatly appreciated.

Thank you.

-Gumbatman

Crack open the Dimension Usage tab and take a look at the relationship between the directly-related dimensions and the bridge and 'Facts' measure groups. You can confirm the level in the dimension at which the relationships are formed.

B.

No comments:

Post a Comment