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.

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar11.png

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar12.png

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

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar13.png

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar14.png

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 Tables.

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar15.png

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.

Description: https://people.avanade.com/personal/divya_agrawal/Blog/Lists/Photos/120711_1256_GettingStar16.png

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.

BI 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




Related Articles :

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 |