I am in the midsts of planning for an upgrade from MOSS 2007 to SPS 2010, and we are looking for quick-wins for the client, one of which 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 screen, though, (if I wanted to build a KPI here) the only KPI name/actual I can use is "Attachments". There is no way to add any other values to this, such as status, etc. This is confusing to me, and I'm not sure why.
Furthermore, assume I do not make any KPIs, nor measure filters/member columns (which, incidentally, I can select valid/existing fields from the list), I get to the editor of my new score card, but I have no controls to drag over. On top of all of that, the bottom side of the detail pane (Data Source) has a drop down menu, and its set to "No Data Source" with nothing else to choose from. Conversely, when I use the contoso datawarehouse, I can see the name of the data source in that drop down.
So, I have been searching around for a tutorial, any advice, or just a point in the right direction. I was hoping you'd be able to help me.
The real question is, how do I get my SP List to show up in that data source drop down once I am in the 'create scorecard' mode of DashboardDesigner. Like I said, I am able to select the data source when I am using the Analysis Services DB, and I am able to grab the fields. If I were able to see the SP List in the data sources of the detail view of the scorecard, I'm assuming I'd be able to grab the controls.