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

Source: Internet
Author: User

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.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.