Updating sql data cube in sql2016 bye dating good i kissed marriage

posted by | Leave a comment

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=, 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.

Leave a Reply

slow dating in bath