Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012

The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.

The tabular model has its roots in the relational model and can be easier to comprehend for users without a BI Development background. For further details on BISM model you can go through the blogs on msdn at http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx.

Now let us look at how to create a BISM model.