Hot answers tagged performancepoint
7
Getting started with business intelligence in SharePoint Server 2010 has a good comparison.
Also there is document "choosing the right Microsoft BI Tool.doc" (search on internet) which can help you. Below is captured from the document.
2
Does that solution work for external lists as well? If not, here's a solution done with a SQL View:
-- Create a view that will combine all of my rows that were inserted on the same date and
-- provide a column with the number of other rows with that date
select day_of_submission, sum(1) as [Count]
from my_table
group by day_of_submission
2
Unfortunately, as you've discovered, it isn't possible out of the box.
You can upgrade to SharePoint 2013 and PerformancePoint Services 2013 which now includes filter search. See What's New in PerformancePoint Services 2013. Not exactly the same as auto-complete, but pretty dang close.
Or, you could look at creating your own filter using the SDK. See ...
1
That is a known issue with SharePoint Designer. If you read Maintain, edit, and update PerformancePoint dashboards you'll see the following warning:
Do not click Edit in SharePoint Designer. You cannot use Microsoft SharePoint Designer to edit dashboard pages that contain PerformancePoint Web Parts. Otherwise, data connections to those Web Parts might ...
1
You can probably use third party web parts such as the Nevron chart and gauge webparts. They can be installed on any site collection so you should be able to use them with PPS as well.
Regarding the “time slider” – you should be able to implement a slider control that passes date time values as parameters to the chart and gauge webparts. There is online ...
1
Found the solution to this :)
What I did was when I create the connection using SPConnectWebParts, I use TransformableBIDataProviderTransformer object, e.g.
var list = new List<TransformProviderConsumerRecord>();
var transformer = new TransformableBIDataProviderTransformer();
var tpcRecord = new TransformProviderConsumerRecord();
...
1
Just as a note (in case the above link dies at some point in the future), link directly to the ClickOnce installer for PerformancePoint Dashboard Designer by using the link: https://webapp/sitecollection/_layouts/ppsma/1033/designer.application
This will install PPDD in your start menu (under SharePoint) for easier future access.
Note, that if you include ...
1
It was a security issue with IE bloacking the dashboard designer from launching.
Here is credit to the article I found the solution in:
http://performancepointblog.com/2011/01/how-to-manually-install-performancepoint-dashboard-designer/
1
You could do a foreach statement on the lists to see which one has the PerformancePoint content types in the SPList.ContentTypes property: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splist.contenttypes.aspx
1
Unfortunately, SharePoint Online does not support much BI features at this moment. Here is some more info on the subject:
http://alanwhitehouse.wordpress.com/2011/08/05/office-365-and-business/
http://community.office365.com/en-us/f/154/t/8112.aspx
1
Do you use an unattended account?
I don't know if the Unattended Account is actually used in the create reports wizard, that would explain why you get the choices there, since your user have access to the library. But I'm pretty sure(90%) that the Unattended Account is used when creating a new Data Source. And the Unattended Account needs access to the ...
1
I did a webinar on this topic : http://bit.ly/AvFhgj "Choosing an MS Visualisation technology"
Angie: You can use combine PPS scorecards with RS reports on a Sharepoint page to get this interactivity. I also did a webinar on this :)
http://bit.ly/FPmRkK
1
You gave your own answer when you said "dimensions":
Build a Cube in SSAS (SQL Server Analysis Services) that uses your raw data as it's datasource.
P.S. (the actual word used in SSAS describing a way of looking at data / filtering data is: a "dimension" :-D)
Excel (2010) in combination with this cube and Powerpivot, or SP2010 + Perf. Point (and ...
1
If you are not hiring a consultant to do this work for you, I suggest reading through a couple of books on the capabilities and configuration of SharePoint Business Intelligence. Here's a couple of examples:
Microsoft SharePoint 2010 Business Intelligence Unleashed
Pro SharePoint 2010 Business Intelligence Solutions
1
With advance reports performance is major concern, I will go with Performance Point its very powerful but you can only build KPI by selecting Sharepoint List as data source, when you want advance charts you have to build SSAS cubes, but you cannot directly build SSAS cube on top sharepoint as sharepoint is not a relational database, so you will end up doing ...
1
Powerpivot worked well for a Executive Portal I developed. Consider that solution. For the right problem, it is one hellava solution.
Agree with James Love about PPS.
Disagree with Michael about Enesys. Enesys data connection to Infopath library did not fulfill the intended need. May work well for basic lists, though.
Watch out for the rendering delays of ...
1
PerformancePoint without any other data sources is very limited.
If you have a SharePoint environment, find out if you can have access to an instance of SSAS on the SQL Server. You'll then be able to either locate a cube you have access to, or copy over the AdventureWorks SSAS database.
PerformancePoint comes to life when you have analytical data sources ...
1
Regarding your question about KPIs: "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."
If you load the data source and then click the View tab, you can set the column ...
1
I do have permission on the list. It looks like it MAY be an issue that SP only allows you to create KPI off of numeric data fields, and since attachments is boolean that is the only option I have. That still does not solve the problem of trying to get the data source(sp list) and its fields/cols to display when I'm designing a scorecard or report. Sorry, ...
1
PerformancePoint analytic reports only consume OLAP data (i.e. from SSAS or PowerPivot).
6/13/2011 - And this page has a code example for programmatically creating an analytic chart: http://msdn.microsoft.com/en-us/library/microsoft.performancepoint.scorecards.store.spdatastore.createreportview.aspx
1
Todd Carter's post "The Wizard Likes His GUIDs" provides a PowerShell script that is supposed to create GUID-less database names. There is no explicitly set database name in his script but perhaps it uses the service application name?
You might also like to try AutoSPInstaller but I can't see PerformancePoint deployed at all in that.
Only top voted, non community-wiki answers of a minimum length are eligible
