Hello everyone

I want to create normal (non analytic) grid/table report with SQL Server Table Data Source in Performance Point Dashboard but I unfortunately all report types I can see are:

- Analytic Chart and Grid (must be Analysis Services Data Source)

- Strategy Map, KPI Details, Reporting Services, Excel Services.

Non of the above does not support creation of normal table report connected to a normal view or table. How can I create normal report? 

Note: I DO NOT want to create excel services.

• Moved by Heidi Tr - MSFTModerator Monday, April 25, 2011 6:56 PM wrong queue (From:Planning)

HI avion007,

Unfortunately you cannot achieve this using dashboard designer.

If you want to create report using data residing in SQL tables, you need to use the BIDS(Business intelligence development studio) or Visual Studio. using the SQL query/stored procedure OR using the wizard, you will be able to create report based on the SQL table data source.

Once you create and deploy the report to the server, you can then use the Dashboard Designer to use that report to one of your dashboards. dashboard designer only helps you display the already deployed SSRS report as part of the dashboard or link it with other objects of the dashboard.

Hope this helps.

Without creating the report in SSRS or Excel to reference ahead of time the only other options I could see would be to create a scorecard out of the data or leverage the SDK to create your tabular report layout that you want to reference if you are going to continue to leverage tabular data.

If you want an example of using the SDK take a look at the code example here on the MSDN site - http://archive.msdn.microsoft.com/ppsSdkRefSample

So if I got it right... Tabular reports can be only made using excel services and reporting services on SharePoint?

 

The options available out-of-the-box for PerformancePoint are to leverage Excel Services or SSRS.  There is no option to simply create a tabular report in PerformancePoint from a tabular source.  If you want that you would need to create one and you can do that leveraging the SDK.  Tabular sources are just not going to provide you the functionality that PerformancePoint was designed for which is to leverage Multidimensional data sources.

yea avion007, that was exactly my answer to your query.

you have to use one of the two options to create report first, and then you can use Performance point to create consolidated dashboard using those reports and deploy it to your server.

Hope this now clears your confusion.

 

Hi Dan,

The mentioned ppsSdkRefSample has been retired.. Please, could you tell me where can I find the PerformancePoint Services SDK sample..

The SharePoint 2010 and 2013 reference this SDK Samples (the same link)

Thanks in advance