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