Error while processing OLAP cube in SQL Analysis Services

This article describes the resolution for the issue that is faced while processing the OLAP cube in SQL Analysis Services. While processing the dimension in the cube sometimes the dimension gets hanged or it throws the error “– 2147221411: Process operation failed”. Problem Summary When you try to process the shared dimension of a OLAP cube in SQL Server 2000 Analysis server, It takes time for the dimension to get processed but after a long span of time also if the dimension does not get processed or ...