Home > SQL Server, SSAS, Whitepaper > BISM at a glance

BISM at a glance

As we know, there will be some changes in the business intelligence product in the upcoming release of SQL Server code name Denali. I am going to show you couple of pictures that would excite you to learn more about BISM (Business Intelligence Semantic Model).

Latest white paper is added at the end of this article.

A model for all end users

BISM Architecture

I assume these pictures might have given you a new perspective of the future BI. And also, I would like to give you some overview of the BISM architecture in this article.

Because of the change in the architecture we will be having Hybrid model instead UDM (Unified Dimension Model). This model automatically converts existing UDM to BISM and with many more features. I am just awaiting for see the new face of the future BI. Meanwhile, Experts like Chris Web and other industry leader are talking more about the new model and other stuff.  You can Bing it to learn more.

Let’s talk about the 3 model in the BISM.

1. Data model

BISM hybrid model supports Multi-dimensional and Tabular data model based on the application requirements. For instance, Excel will use multi-dimensional mode and for ad-hoc reporting interface such as Crescent will use tabular.

2. Business logic and Queries

In this layer, we can define the business module with the help of MDX (Multi-dimensional Expression) and DAX (Data Analysis Expression).

3. Data Access

Data can be pulled from plenty of data sources. Data will be retrieved and managed using chached and passthrough respectively.

We can use any of two storage engines for the cached, MOLAP and VertiPaq.

We can use ROLAP or DirectQuery for the passthrough mode.

There will be more updates in BISM. So, please check this site often for more details.

Learn more about BISM in MSDN blog.

Introducing the BI Semantic Model in Microsoft® SQL Server® 2012 – White paper

Thanks for reading. For more technology updates, please visit SQLServerRider.com Facebook page and like it. Also, Subscribe E-Mail to post in the website for instant access to SQLServerRider articles.

  1. Ivan
    June 16, 2011 at 10:14 am

    Good Post!!

  2. Ashish
    September 24, 2011 at 4:05 am

    NIce Post Ayyappan …keep them coming!

  1. August 17, 2011 at 10:53 pm
  2. October 27, 2011 at 10:26 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: