The data source view does not contain a definition for the table or view ‘dbo_Fact_xxxx’. The Source property may not have been set. Last week i was working on redeploying an existing cube to another server. While doing so i…

Restore Cube using XMLA
Solution- There are several ways to restore cube from one server to another. This time, we will restore cube using XMLA. This will create the file which we will use to deploy the cube. Open the file on SSAS server on…

Client unable to establish connection; Encryption not supported on the client
Task – Hook up the cubes to the SSAS which have been created previously. Errors on Processing the Cube Client unable to establish connection; 08001; Encryption not supported on the client A Connection could not be made to the DataSourceID…