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