SQL Server Analysis Services 2012 Cube Development Cookbook

Combining tables using calculated columns

To begin working with calculated columns, we'll make a modification to the Tabular Model design created in the previous chapter. In a business intelligence solution, we often combine data from multiple source tables to simplify the structure and make it easier for users to navigate and report on information. Previously, we used a T-SQL query to join the Product Subcategory and Product Category table information to populate a single table in the semantic model. To gain experience with a different table design technique and develop new skills, we will change the approach.

Getting ready

You're going to make a design modification to the Tabular Model you created in Chapter 9, Using Tabular Models. If you would ...