Setting up the environment

As explained in the introduction, the proper way of implementing metadata-driven calculations in the cube would be to store the metadata information in the MDM system. For explaining the concept, we will simplify things and use a common Excel file, which should be available to everyone. The data in that Excel file needs to be loaded into SQL Server first, it can't go straight to the cube. Therefore, we need to set up the environment that enables the data manipulation and loading process.

Getting ready

Data manipulation will be done in Excel, so make sure you have it installed on your dev machine, where you're learning and testing all this and make sure it is a 64-bit version or you might have problems with the driver later. ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.