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




Array

No comments yet... Be the first to leave a reply!