We received Errors in the OLAP storage engine: An error occurred while processing the ” partition of the ‘XYZMeasureGroup’ measure group for the ‘Cube’ cube from the CubeDatabase database.
When you get this error look for errors:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactTable, Column: DimKey, Value: 1234.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DimAttrKey of Dimension: Dim from Database: Database, Cube: Policy, Measure Group: XYZMeasureGroup, Partition: XYZPartition, Record: 112233.
Also the above errors in SSDT are with warning ! and not with error X.
We did ROLAP processing and this error was fixed.
Thanks to this blog.