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!

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 |