Thursday, January 26, 2012

Publish a BISM Tabular Model Database Connection on SharePoint 2010

Once you built a BISM Tabular Model project and deployed to SSAS,  you may want to publish it on the SharePoint 2010. A BISM connection allows business end users to access the underline model on SharePoint with addtional security control. It could also utilize the SharePoint quick launch commands to open the Excel Workbook or Power View Report.  For more information about how to create a BISM Tubular Model project, see my previous blog entry Create a SSAS BISM Tabular Model Project.

 

Add the BI Semantic Model Connection Content Type to the SharePoint Library

  • Go to the SharePoint Library site that will host the connection file, click the Library in the Library Tools.
  • Click the Library Settings
  • In the General Settings section, select the Advanced settings
image
  • In the Content Types, Select the Allow management of content types to be Yes, then click OK
  • In the Content Types section, Click on the Add from existing site content types
  • Add the BI semantic Model Connection
image
  • After click on the OK button, you can see the BI Semantic Model Connection added in the Content type table
image

 

Set Up Permissions

  • Grant the Tubular Model Analysis Service administrative permissions to the SharePoint Service Account.
  • Grant the user who is going to use the connection with the Read permission on the Tabular Model database
    • Add a Role with Read permission
    • Adding the user to the Role

 

Create the Connection File on SharePoint

  • Go to the library page, click on the Documents in the Library Tools.
  • Click on the down arrow on the New Document and select the BI semantic Model Connection.
image
  • On the New BI Semantic Model Connection page, specify the server name and database name and then Click OK.
image
  • On the library page, you should be able to see the new connection file.

image


Use the BISM Connection in SharePoint

Now you may use Excel or Power View to consume the BISM connection file as the data source. 
  • If you create the file in PowerPivot Gallery, you could click on either the Open New Excel Workbook or Create Power View Report link on the right upper corner to open the application.
image
  • If you create the file in the Shared Documents page, you could click on the Down Arrow on the File Name to launch either the Excel or the Power View Report.

image

Additional Reference
http://technet.microsoft.com/en-us/library/hh230813(SQL.110).aspx
http://technet.microsoft.com/en-us/library/gg492136(SQL.110).aspx

2 comments:

  1. Many new models has been uploaded here so that the old users can lead with this files and spreed this to another client.





    ATI video cards

    ReplyDelete
  2. Thanks a lot for posting the steps ... saved me lot of time.

    ReplyDelete