Posts tagged "OLAP"
Have been trying to deploy this OLAP cube to Analysis Services using the Business Intelligence Development Studio. However, I ran into the following error multiple times.
OLE DB error: OLE DB or ODBC error: Login failed for user ‘SSAS_SVC_ACCOUNT’.; 28000.
Turns out that if you are using the Analysis Services service account to access the Data Warehouse (and deploy the cube), you need to grant (at least) read access to the service account for the Data Warehouse database in SQL Server.
For more information, check out the link below that addresses a similar issue.
