Ask Synergy Software Systems, Dubai about PowerPivot for SharePoint:

September 25th, 2012 by Stephen Jones Leave a reply »

A new architecture for SQL Server 2012 SP1 CTP4 PowerPivot that supports a PowerPivot server outside a SharePoint 2013 farm. The new architecture leverages Excel Services for querying, loading, refreshing, and saving data.

The PowerPivot server can still be installed on a server that also hosts SharePoint servers but it is not required. The new architecture is available when you deploy a new PowerPivot server with the slipstream version of SP1. The new architecture  is not available when you deploy the patch version of SP1 onto an existing PowerPivot.

SQL Server 2012 SP1 CTP4 introduces new features for Analysis Services running in Tabular mode, including optimized storage for measures and KPIs, extended data categorizations, extended characters, hierarchy annotation, and improved support when importing from Data Market data feeds. In some cases, Tabular model projects being deployed may not be compatible with an Analysis Services deployment server instance. With SP1 applied, you can specify Compatibility Level when creating new Tabular model projects, when upgrading existing Tabular model projects, when upgrading existing deployed Tabular model databases, or when importing PowerPivot workbook.

You can access a tabular model from within SharePoint using a new type of connection object called a BI semantic connection. A BI semantic connection provides an HTTP endpoint to Analysis Services databases that are deployed on a standalone server, or to an Excel workbook containing PowerPivot data in a SharePoint farm that includes PowerPivot for SharePoint. A BI semantic connection file is a SharePoint content item that specifies the server location of a model database, similar to how Office Data Connection (.odc) files store connection information to external data. Within a SharePoint environment, a BI semantic connection is a supported data source for Power View reports that you design and use in SharePoint. You can also use a BI semantic connection as a data source for PivotTables in Exce

You can now import PowerPivot in Excel 2013 workbooks into new Tabular model projects created in SQL Server Data Tools or directly in SQL Server Management Tools.

Advertisement

Trackbacks /
Pingbacks

  1. system administration

Leave a Reply

You must be logged in to post a comment.