Dear All, I Have Created Query And Attached It To Newly Created cube.
I Transfer The Cube successfully. But whenever i click process button It Gives Folowing Error. Method 'processCube' in COM object of class '{A4D49012-F5A5-4d86-8978- 863A41277677}' returned error code 0x80131500 (<unknown>) which means: Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Invalid object name 'DBO.OLAPBAC31_SALESTABLE'.; 42S02. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'basic_OLAPBAC31_', Name of 'basic_OLAPBAC31_' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Branch' attribute of the 'basic_OLAPBAC31_' dimension from the 'OLAPITL' database was being processed. Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Invalid object name 'DBO.OLAPBAC31_SALESTABLE'.; 42S02. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'basic_OLAPBAC31_', Name of 'basic_OLAPBAC31_' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Customer' attribute of the 'basic_OLAPBAC31_' dimension from the 'OLAPITL' database was being processed. Please Suggest Solution For This. Thanks In Advance Mahesh