.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

PerformancePoint And Excel Services config

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint
 

I am having a prolem with Performance Point Services I have created and configured the Secure Store Service Application, generated the Keys Configured the Unattened in Performance Point Services Application and configured the Excel services as per http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx 

and I am getting this error in the error log

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListCollection()

at Microsoft.PerformancePoint.Scoreca


View Complete Post


More Related Resource Links

PerformancePoint And Excel Services config

  

I am having a prolem with Performance Point Services I have created and configured the Secure Store Service Application, generated the Keys Configured the Unattened in Performance Point Services Application and configured the Excel services as per http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx 

and I am getting this error in the error log

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListCollection()

at Microsoft.PerformancePoint.Scoreca

PerformancePoint Dashboard using Excel Services - How to export or print?

  
I have a PPS dashboard in 2010 that has an Excel services report with a nice graph and grid.  I do not see an "export to Excel" toolbar or a print function.  In the old 2007 Sharepoint, the Excel services report had a menu which allowed the user to export to excel (copy / paste) or OPEN in Excel.  (actually open the pivot table) How do I expose that menu bar in 2010?  Thanks.

Exporting a PerformancePoint Excel Services Report to Excel

  

Have an Excel services PivotTable in a PPS 2010 dashboard.  When the user selects the "Export to Excel" option they receive this error.

I do not see any options in the webpart to show the old toolbar that used to show up in the Excel Services views.  (It had an option to open the pivottable in Excel or export a "snapshot" to Excel)

How do users export Excel Services reports to Excel?

Error

The selected view does not support an export to the selected format.

 

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: c189d209-c218-4606-aad4-2f280d5c6977

Date and Time: 9/20/2010 10:26:17 AM


Excel Services: Develop A Calculation Engine For Your Apps

  

The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007


Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services

  

Excel 2003 lets you dynamically integrate the data provided by different Web services. It also lets you take advantage of the latest capabilities in Office 2003 to customize list views, graphs, and charts, and to catalog bulk items online or offline. Find out how you can makle the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API.

Alok Mehta

MSDN Magazine February 2005


SharePoint 2010: Excel Services Resource Center

  
Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Sample: Business Connectivity Services Excel 2010 Add-In

  
Download a sample add-in that shows how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Interacting with the Excel Web Services API for SharePoint Server 2007

  
Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Video: Excel Services and SharePoint 2010 Business Intelligence

  
In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

Video: PerformancePoint Services and SharePoint 2010 Business Intelligence

  
PerformancePoint Services is all about surfacing data to users in a dashboard format to allow users to create business decisions based on the dashboard information. (Length: 11:51)

Generating Multiple Excel Sheet using Reporting Services 2005.

  
<p> Hi, I'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet. Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code... Thanks in advance, JP  </p> 

Excel Services in the 2010a Image -- Excel Servcice in General ( no success)

  
On the WebApp that hosts the Project service portion of the demo (finweb) has anyone gotten Excel Services to work ?  I get a bunch of internal errors when I attempt to use this service..  I am also having problems getting Excel Service to work (in general) -- are there any particular small animals that need to be sacrificed in order to get Excel Services to work? I'm using Kerberos on a single box ( been through the Kerberos whitePaper) -- On my development server, I am authenticating OK (Fiddler) but the page that is returned ends abruptly before the grid is created. It's not the browser because I can view the samples at WssDemo...   Suggestions -- I've done a couple of re-installs all the back to IIS -  All science is either physics or stamp collecting

Excel Services XLSX shows different results when accessed via Sharepoint UX vs REST

  
I have an Excel services report that connects to Project Server 2010 data via an ODC.  Looks great when I view the XLSX through the browser via the Sharepoint doc library; everything refreshes, no warnings, all is good.    But when I access this same file via the Excel Services REST call: https://myserver/_vti_bin/ExcelRest.aspx/ProjectBICenter/My%20Reports/Initiative%20Status%20Report.xlsx/model/PivotTables('InitiativeStatusSummary')?$format=html I get an older version of the report -- not refreshed with the latest data.   I have the file set to "refresh data when opening the file" in the data connectioon properties.     What am I missing?

Performace point/Excel services OLAP cubes

  
Running Sharepoint 2010 Ent fresh install.  I have created a new site and performance point service as instructed in the following tutorial. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx I have then uploaded an Excel document which pulls data from OLAP cubes.  The Excel doc as a standalone works fine.  After it has been uploaded users can open it as normal etc but when changing slicers and trying to pull info from the cubes I get the following error.. An error occurred durning an attempt to establish a connection to the external data source.  The following connections failed to refresh: "Name of out cubes here" I have been playing with the secure store and generating keys etc to no avail.  I have tried exporting the .odc file from the Excel document and uploading it to the data connections library/dashboard site but this doesnt help The anoying thing is that I had it working once and then the next day it failed for no apparent reason and even after a fresh install I cant get it to work again.  Any pointers or tutorials would be greatly appreciated! Andy
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend