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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

PerformancePoint 2010 - SharePoint Lists as a data source

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

I am in the midsts of planning for an upgrade from 2007 to 2010, and we are looking for quick-wins for the client, one of which obviously being PerformancePoint 2010 integration with SPS 2010. So i am tooling around, following some basic tutorials of creating scorecards/kpis/filters/dashboards all from the contoso sample data, which is all fine and well, but my client doesn't have a datawarehouse, and doesn't plan on moving to one.

This puts me in the situation where I need to be able to create these pieces from SP Lists instead of an analysis services DB/DW. I go through and create the data connection, and all seems to be working fine...In the data connection windows, I can click the View tab and preview the data, and actually see all the data thats in the task list I've created and linked to (all demo data, just created a couple of tasks and etc).

Now the trouble comes when I try to create a simple scorecard based off of this list. When I am in the Create tab, and click Scorecard, (Use Tabular > SP List) I can select my data source (Task Tracking Data Source) and thats all well and good.

I then go to the SharePoint Site tab (on the select data source on the wizard), I am able to select my Task Tracking Data source as well. When I get to the KPI scre

View Complete Post

More Related Resource Links

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Video: SharePoint 2010 Lists, List Data, and CAML

This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

Surface data in external lists in Sharepoint Foundation 2010



I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it. 

I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List.  When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database names and click OK with the Connect with User's Identity radio button still selected and I get the error message: login failed for user ''. The user is not associated with a trusted SQL Server connection.  I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services.  Can anybody help with this?

How to open More then one lists of sharepoint 2010 as a tables in access 2010 data base


Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

Mohammad Siddiqali

PerformancePoint 2010 - Denied Access to Existing Data Source


We have SharePoint 2010 farm using Kerberos for authentication that works fine for almost all scenarios, except this last issue we see with PerformancePoint and the Dashboard Designer.

When our Data Connections library is empty I can start the Dashboard Designer and create a New Data Source. Clicking on Save the data source is saved in the correct location (default PPS library).

However, once I do an action that requires the Dashboard Designer to read the list of data sources from this library I get an access issue. This could be by trying to create a report using the saved data source or by closing the Dashboard Designer and opening it again to create a data source.

This error is logged in the ULS log and Event Viewer:

The user "domain\loginname" attempted to access an item in the following location: http://sp-server/PWA/ProjectBICenter/Data Connections for PerformancePoint


Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Quick Note: Create Silverlight Graphs with SharePoint 2010 Data by Using LINQ

In this exercise, you will learn how to create Silverlight applications to retrieve SharePoint 2010 list data using LINQ.

Developer Training: User Interfaces and Lists in SharePoint 2010

Learn about the new user experience in SharePoint 2010 and how you can use the new UI in your customizations. This training module also discusses improvements in list handling, including list relationships and new form-rending options.

Developer Training: Data Access in Technologies in SharePoint 2010

Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.
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