Search code examples
sqlsql-serversql-server-2012ssascube

SSAS -> Cube Deployment -> Unable to deploy cube without processing each dimension individually?


I have noticed that when creating my cubes if I create my cube via the cube wizard and then instantly go and attempt to deploy my cube I encounter a bunch of odd errors regarding attribute keys not being present (basically referential integrity issues) If I go through and individually process each of my 15+ dimensions (no errors occur), and then deploy my cube it works without error. I am just wondering if anyone else has experienced this or if this is just something due to the order in which the dimensions are being processed.


Solution

  • Are you using referenced dimensions? Are you processing the cube in one job, full process, single transaction? Do you have RI errors in the underlying data?