This content has been marked as final. Show 1 reply
OLAP supports ragged and skip level hierarchies, but not when there are MVs. This is due to restrictions in the the MV rewrite system. So my guess, based on the error message, is that you have a ragged hierarchy. It is also possible that there is some other compatibility issue, such as a skipped level, since this error is not always specific.
One way to diagnose the issue would be to clear the dimension (and hence the cube) before enabling the MV. When you maintain the dimension you will almost certainly get the same kind of error, but the offending dimension members should be listed in the CUBE_DIMENSION_COMPILE table. Obviously you must not do this unless you are prepared to rebuild your cube.