Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying MDX with Microsoft SQL Server 2016 Analysis Services Cookbook
  • Table Of Contents Toc
MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition

By : Li, Tomislav Piasevoli
5 (3)
close
close
MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

5 (3)
By: Li, Tomislav Piasevoli

Overview of this book

If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success.
Table of Contents (11 chapters)
close
close

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. SQL Server, Excel, and the driver must be of the same version, 64-bit.

For the data loading process, we will set up a linked server connection to the Excel file using a special free driver, which needs to be downloaded and installed first. Once...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
MDX with Microsoft SQL Server 2016 Analysis Services Cookbook
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon