SSAS: Errors in the metadata manager. The dimension with ID of…
Crazy error today. In Analysis Services, (SSAS), some jobs got hung, sync command got hung, and what ended up happening is a cube on the default instance was totally unusable.
Try to delete, rename, resync, redeploy, anything, and I would get the error..
Errors in the metadata manager. The dimension with ID of..
Couldn’t do anything. The solution? I had to stop the SSAS service, go to the OLAP data directory under my SQL install and remove the folder for that cube. I then started the SSAS Service, and the SSAS Database was gone (finally!). I redeployed and reprocessed and everything is working again. Whew :)
Simlar Posts
- Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
- SSAS: Deploying Cube OLE DB Error – Login Failed
- SSAS 2005: Cube Perspectives Are Good, But Something Is Missing…
- Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
- SSAS 2005/2008: Creating Sub-Cubes Using XMLA, Variables, and Named Query Where Statements
