CREATE GLOBAL CUBE does not support cascading many-to-many dimension relationships
The CREATE GLOBAL CUBE statement does not support cascading many-to-many dimension relationships. It gives an error even if all measures and all dimensions are included. A single many-to-many dimension relationship is supported, but if more m2m relationships are chained together, the CREATE GLOBAL CUBE doesn't work.
Upvotes: 5<=-=Oct 13 2008 11:19AM=-=>
Thanks a lot for reporting the problem.
The current version of Analysis Services does not support what you are trying to do. We will take a look at your suggestion for the next release.
The Analysis Services Team