Chapter 16

A First Look at Tabular BISM

What's in this chapter?

  • Understanding BISM tabular mode
  • Setting workspace and deployment servers
  • Importing data into your tabular model
  • Working with your model in the tabular designer
  • Adding relationships and calculations to your model
  • Browsing and deploying your tabular model
  • Administering tabular instances in SSMS

In Chapter 1 you learned about the Microsoft Business Intelligence Semantic Model (BISM). You learned that it was made up of two components: multidimensional mode BISM and tabular mode BISM. Tabular mode BISM is a new business intelligence (BI) approach first implemented in the initial release of PowerPivot in SQL Server 2008 R2. Previous chapters discussed the details of many aspects of the multidimensional side of the Business Intelligence Semantic Model and Chapter 15 provided a brief overview of PowerPivot, including the new features in the SQL Server 2012 version. This chapter takes a first look at the tabular side of the Business Intelligence Semantic Model outside the scope of PowerPivot. This functionality is new in Analysis Services 2012.

After the Analysis Services team shipped Analysis Services 2008 R2 and PowerPivot, they started planning the next release of the product that would ship with SQL Server 2012. They received a lot of positive feedback on PowerPivot and started to think about how they could make the PowerPivot model available to corporate BI developers. Initially, the team wasn't sure about how to do that. ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.

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