Updating sql data cube in sql2016 bye dating good i kissed marriage
We recently upgraded from SQL Server 2016 CU8 to SQL Server 2016 SP2.
After upgrading, SSIS packages which perform cube processing functions throw the following error: Error Code: 0 Description: Could not load file or assembly 'Microsoft. Adomd Client UI, Version=184.108.40.206, Culture=neutral, Public Key Token=89845dcd8080cc91' or one of its dependencies. This has happened on two servers we upgraded in our lower environments.
Code developed in Visual Studio to process cubes stopped working.
Cubes need a date dimension in order to analyze historical information.
I will also demonstrate many features of SSAS, along the way, that can assist you to build cube dimensions, and features needed by the date dimension.
I will build the example (see the link at the head of the article) based on Adventure Works DW database.
We could create a few more dimensions, but our objective here is to focus on the date dimension. The project needs to be tested and deployed to a SSAS server instance installed in multidimensional mode.
You need to configure the sample project, inside the solution, pointing to a SSAS instance in your environment.