Use of workbook as a multi-dimensional data source in performancepoint services!

Performancepoint services in Microsoft SharePoint Server 2010 is a performance management service that can be used to monitor and analyze services. By providing a flexible and easy-to-use dashboard, scorecard, report, and key performance indicator (KPI) building tool, the performancepoint service helps everyone in the Organization make informed business decisions that match the company's goals and policies. The scorecard, dashboard, and KPI help promote the implementation of the responsibility system. Integrated analysis helps employees quickly switch from monitoring information to analysis information and share information across the organization in a timely manner.

Before performancepoint services is added to SharePoint Server 2010, Microsoft Office performancepoint Server 2007 runs as an independent server. Currently, for Excel services in Microsoft SharePoint Server 2010, the performancepoint function is provided as an integration part of the Sharepoint Server Enterprise Edition license. Performancepoint services retains popular features in earlier versions and provides many enhancements and new features.

In addition to the balanced scorecard data source, you can use a relational database or a Sharepoint list. The data sources used to analyze tables and analysis charts are multidimensional. In this way, you can perform drill-up, drill-down, block-down, and other analysis functions, the SQL Server Analysis Service is required for use. The data in the dashboard designer uses the workbook as a multi-dimensional data source. The specific steps are as follows:

1. Add an SQL Server Analysis Service data source to the dashboard designer, for example:

2. Custom connection string, such as provider = msolap; datasource = http: // contoso/documents/powershortt_sample.xlsx, for example:

3. The effect of using the workbook in the analysis graph table, for example:

In this way, you can create a multi-dimensional data mart even if you do not develop the SQL Server Analysis Service. You can also develop analysis tables and analysis charts using the workbook data source to implement the same functions, which is very easy to implement and develop, there is no need for advanced technologies to effectively use resources!

 

This blog is original in software life. You are welcome to repost it. For details, refer to http://www.cnblogs.com/nbpowerboy/archive/2013/04/27/3047892.html. Assume or use it for commercial purposes, but you must keep the signed software life (including links) in this article ). If you have any questions or authorization negotiation, please leave a message for me.