January 6, 2014 at 9:48 am
Hi All,
When i Deploying the cube ,i am getting some error.
can you please help me below issues,
1)Database [MultidimensionalProject1] : The database has no Time dimension. Consider creating one.
2)Internal error: The operation terminated unsuccessfully.
3)OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
4)Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dev EDW', Name of 'Dev EDW'.
5)Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'PRODUCT', Name of 'PRODUCT' was being processed.
6)Errors in the OLAP storage engine: An error occurred while the 'PID' attribute of the 'PRODUCT' dimension from the 'MultidimensionalProject1' database was being processed.
Server: The current operation was cancelled because another operation in the transaction failed.
January 6, 2014 at 10:24 am
You are using the service account to process the cube, but this account doesn't have permission to read data from the source.
3)OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.
4)Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dev EDW', Name of 'Dev EDW'.
The error is quite straight forward.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply