SYMPTOM:
When users are trying to import a MDX cube using Strategy, they are able to select the cube from the “Available Cubes” list and move it to the “Selected Cubes” list without issues.
Once the MDX Cube is shown on the right-hand side of the screen, users can proceed to “Save and Close” the MDX Cube Catalog. A new question will be shown in order to know if the user wants to review the mappings for that cube.
As soon as the users select “No” in order to proceed with the cube saving process, they get the error shown below:
CAUSE:
This issue can be faced if the user has too many hierarchies created under a particular element in the cube. This error has been received when users have more than 1,000 hierarchies. In this case Strategy is getting out of memory trying to import and create thousands of hierarchies at the same time.
ACTION:
This problem is faced when user's MDX cube source design involves a lot of hierarchies created under a specific dimension. Strategy can handle a very high number of hierarchies, however this kind of design (thousands of hierarchies) is oriented to support transactional systems rather that OLAP structures. Users should be able to compact the structure (maybe by deleting redundant hierarchies or by modifying the underlying design) in order to support OLAP processing.
KB35875
