Error 24 OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.SSAS_XYZ'.; 42S02. 0 0 Error 25 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer Region', Name of 'CUSTOMER' was being processed. 0 0 Error 26 Errors in the OLAP storage engine: An error occurred while the 'Midea GROUP' attribute of the 'CUSTOMER' dimension from the 'SSAS' database was being processed. 0 0 Error 27 Server: The current operation was cancelled because another operation in the transaction failed. 0 0 like this i am getting for all dimension in my solution.Please guide me what is causing the issue.How to rectify it.TIA.

I checked again and this object is being used in one of the named queires Named Query that i am currently not found the DB.Let me check on that.But why i am getting the remaining errors likeError 25 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer Region', Name of 'CUSTOMER' was being processed. 0 0 Error 26 Errors in the OLAP storage engine: An error occurred while the 'Midea GROUP' attribute of the 'CUSTOMER' dimension from the 'SSAS' database was being processed. 0 0 Error 27 Server: The current operation was cancelled because another operation in the transaction failed. 0 0Can you please help me on this.TIA.

I checked again and this object is being used in one of the named queires Named Query that i am currently not found the DB.Let me check on that.But why i am getting the remaining errors likeError 25 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer Region', Name of 'CUSTOMER' was being processed. 0 0 Error 26 Errors in the OLAP storage engine: An error occurred while the 'Midea GROUP' attribute of the 'CUSTOMER' dimension from the 'SSAS' database was being processed. 0 0 Error 27 Server: The current operation was cancelled because another operation in the transaction failed. 0 0Can you please help me on this.TIA.

ok check the datasource information, go to the database and see if that object exists first and you've access to it using the account you use to deploy the cube.that should be the first step.

Error 27 Errors in the OLAP storage engine: An error occurred while processing the 'Sales' partition of the 'MEASURES' measure group for the 'SSAS' cube from the SSAS database.

It is also showing some message when i mouse over on 'MEASURES' saying.."Slpit Large partitions,with more than 20 million rows or that are over 250 MBin size into smaller partitions to improve the performanace"

Is this causing to fail the deployment.other than this it is not showing any other message.TIA.

Error 27 Errors in the OLAP storage engine: An error occurred while processing the 'Sales' partition of the 'MEASURES' measure group for the 'SSAS' cube from the SSAS database.

It is also showing some message when i mouse over on 'MEASURES' saying.."Slpit Large partitions,with more than 20 million rows or that are over 250 MBin size into smaller partitions to improve the performanace"

Is this causing to fail the deployment.other than this it is not showing any other message.TIA.

it seems like you've overlapping partitions. Can you check the source queries for partitions in the cube (you can go to partition tab for that). Make sureno two partitions include overlapping set of data for a given measure group ie check the WHERE conditions

I checked Partitions tab and there are 7 partitions created and out of them only 1 partition has WHERE clause that to it is using YEAR comparision, rest all partitions are using VIEWS in its FROM clause.

I checked Partitions tab and there are 7 partitions created and out of them only 1 partition has WHERE clause that to it is using YEAR comparision, rest all partitions are using VIEWS in its FROM clause.

Can you please guide me, what is causing issue.TIA.

check the where conditions within the view and make sure they dont overlap.