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

8. Your Tabular
BISM Model is now ready to be used. Let us now look at how to deploy it. Right-click on the AdventureWorks_BISM solution and select Properties. Youwill have to change
the Server name from Localhost to current instance name which is
localhost\SQLDenali in this demonstration.



9. Right click
on the Solution and Select Deploy. This will deploy all the tables to the SQL
Server Analysis Services BISM Instance.



10. Open SQL Server
Management Studio and connect to the Analysis Services BISM Instance. You will find
the AdventureWorkds_BISM Tabular database created with all the connections and


11. Right click on
AdventureWorks_BISM database and select browse. This will open the same cube
browser as for SSAS. Browse the measure and Product Category. Browsing the BISM
model is almost identical to browsing a cube in SSAS.


12. Create a BISM Connection
in your SharePoint site using the same database model. You can now use another
new feature of PowerView reports in SQL Server 2012. PowerView allows you to
create ad hoc reports in SharePoint by just dragging the appropriate dimension
or measure.

Semantic Model is very easy to create and understand. It can be used to develop
PowerPivot reports. The main advantage of using BISM over PowerPivot
is that PowerPivot reports store all the data in
excel files which makes the files very large and hard to manage. While in case of BISM, the
data is maintained in SQL Server which makes the reports very easy to manage and control.
We can link views to BISM model to load limited data when designing the model which will reduce the load time. Later, we can alter the views to select all the
data and refresh the tables from SQL Server Management Studio.

Pages: 1 2


4 Responses to “Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012”

  1. Great intro article…thanks for sharing!

  2. Thanks! I’d like to see an article contrasting this new mode to traditional multidimensional to explain why someone would or would or would not want to use this over the traditional analysis server mode/project. Now that we know how to install it, an article about differences, pros and cons would be great!

  3. About time!,

    Business Objects had their Semantic Layer called Universe since 1990.

    We actually had the Microsoft people come to my company and try to bad mouth the “centralized and monolithic” concept of the Business Objects Universe.

    Oh Well…

  4. Thanks You so much for your aticle.

    Could you please add more articles on the similar topics in sql server 2012

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |