Business Intelligence Semantic Model (BISM)

Analysis Services cubes as we know them today and SSAS+MDX are dead

Microsoft announce in November 2010. Very disappointed because from last 2+ years I am working on SSAS and loving this technology always try new things in SSAS.  

Like me all MSBI Developers now thinking to stay with SSAS+MDX Queries or go with other

Data warehousing technology so from couple of day reading new things.

But Its big reprieve for all those ware worried,  ;-) ;-) ;-)

Microsoft announce the road map for SSAS and good news comes for all the MSBI Developer that SSAS+MDX is Alive with “Denali” as Business Intelligence Semantic Model (BISM) is being introduced in Analysis Services.

What introductions coming in SQL Server “Denali” and the new class of BI applications and update on Analysis Services – Idea & Guideline as Below.

1-It is the foundation of the Microsoft BI stack, serving as the semantic model for Microsoft BI tools including Excel, SharePoint Insights and Reporting Services.

2-This will do this by embracing the relational data model and bringing it together with the multidimensional model under a single unified BI platform – providing the best of both worlds.

3-Business Intelligence Semantic Model is being introduced in Analysis Services for SQL Server “Denali” with the goal to fulfill this vision. Combination of

·         First multidimensional modeling which is capable of tackling the most advanced of BI applications

·         Second one the other hand, the relational data model is widely understood and accepted by developers and IT professionals around the world.

4-When you upgrade your Analysis Services project or server to SQL Server “Denali”, every cube automatically becomes a BI Semantic Model.

5- All client tools in the Microsoft BI stack – Excel, PowerPivot, SharePoint Insights and Reporting Services operate on this model.

6- MSBI professionals can create the model in Visual Studio and deploy it to an Analysis Services server.  Interestingly, the model can also be created by business users with PowerPivot for Excel and shared via PowerPivot for SharePoint.

7-PowerPivot and Analysis Services are two different products but both use the BI Semantic Model under the covers.  

·         PowerPivot - Targets business users and In the case of PowerPivot, the model is embedded inside an Excel workbook

·         Analysis Services - Targets BI professionals and IT and In the case of Analysis Services, the model is stored and managed on the server.

8-UDM (Unified Dimensional Model) is no longer used with SQL Server “Denali” and is subsumed by the BI Semantic Model.

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)

Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2