Home > BISM, Power View, Power View, SQL 12 > Add a BI Semantic Model Connection Content Type to a Library

Add a BI Semantic Model Connection Content Type to a Library

I had hard time in performing these steps in the absence of Screen Shots, so thought of adding this post with Screen Shots.

A BI semantic model connection is created in SharePoint and provides redirection to business intelligence semantic model data in a PowerPivot workbook or Analysis Services tabular model database on a network server. Before you can create a BI semantic model connection in SharePoint, you must extend a document library to allow the creation of a .bism file. This step only needs to be performed once for each library, but you will need to repeat it for any library from which you want to create .bism files. Best practices recommend that you create a centralized library for storing .bism files so that you can manage permissions in one place.

If you already use SharePoint Data Connection Libraries, the BI Semantic Model Connection content type is automatically added to that library template. You can skip the steps in this section if you use a data connection library that already lets you create new BI semantic model connection documents.

You must have at least the Manage Lists permission to add and configure a content type. This permission is built into the Design permission level and above.

  • Open the document library for which you want to enable the BI Semantic Model Connection content type.
  • On the SharePoint ribbon, in Library Tools, click Library.
  • Click Library Settings.

clip_image002[10]

  • In General Settings, click Advanced settings.

clip_image004[8]

Click Yes and OK

clip_image006[8]

On the same page under content type click

clip_image008[5]

Add Different Content Types

clip_image010[7]

To verify you added the content type, go back to the library and click New Document on the Documents area of the library ribbon. You should see BI Semantic Model Connection File in the New Documents list-

clip_image012[10]

Click on BISM Connection – SSAS tabular Instance –

clip_image014[5]

or you can use PowerPivot workbook

PowerPivot Workbook.

Format – workbook URL – http://localhost/PowerPivot Gallery/Book1.xlsx

clip_image016[5]

Add a BI Semantic Model Connection Content Type to a Library (PowerPivot for SharePoint)

References –

Advertisements
  1. June 11, 2013 at 2:02 am

    I just put the link of your blog on my Facebook Wall. excellent
    blog indeed.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: