I'm attempting to create my first Analysis Server database. This is being done in SQL Server 2008. Please don't assume anything, I'm really learning as I go along and am thinking I'm doing something "obvious" wrong...
So far I've created a Data Warehouse DB that contains my dimension and fact tables - this was created on an OLTP/Database Engine Server (Server name e275rd4). Using VS 2008, I created an Analysis Services Project and was able to successfully build
out my dimensions and cube DB. The problem I'm having is in trying to deploy this to my Analysis Server DB (server e275bidev02). When I first tried to deploy, my impersonation properties were incorrect, it was asking for a user name/password.
I changed this property to inherit, and now I'm getting an error on the very first dimension it's trying to create. The error message is:
Error 4 OLE DB error: OLE DB or ODBC error: Invalid column name 'dimLocationID'.; 42S22. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Location', Name of 'Dim Location' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Dim Location ID' attribute of the '
View Complete Post