After changing partitions to MOLAP mode, the Deployment process fails due to an internal error.
This error means there's invalid data in the MOLAP partition. The message above tells us that the error occurred in the OPEX-Accounts partition of the Actuals cube.
Go to the target model and check all the MOLAP partitions one by one.
Tip: Select the Errors Only checkbox to help you quickly identify invalid data within the partition.
There are two types of invalid data:
- The Dimension Member doesn’t exist in the model hierarchy
- The Dimension Member doesn’t exist in the Dimension at all
If it is the first case, you’ll see a yellow exclamation icon (shown above). To fix this error, you just need to add the member back to the hierarchy used by the model.
The second type error will display as a red icon:
Fixing this error can be complicated. You'll need to remove all the invalid records, so data loss will occur. Confer with business users before deleting anything. Also, you may need to find out what causes the issue and fix it from the root. Most times the root cause is either:
- Members have been mistakenly removed from the Dimension
- Invalid mMmbers have been inserted into the partition through a SQL rule.
We highly suggest following our best practices for data integration to reduce the likelihood of having invalid data in the system.