Tag Info

Hot answers tagged

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

Hei Bart. Check out http://blogs.msdn.com/b/performancepoint/archive/2011/08/03/cascading-filters-in-performancepoint-services.aspx


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

Click on your Data Source under your Data Connections in Dashboard Designer. Go to the View tab and click the column you want to have counted. Under the details pane you can change the Aggregation, the default is Sum, click the drop down list and you should have Count there.


2

I'd reckon you're better building an OLAP cube out of the raw data using SQL Server Analysis Services, then surfacing that through PerformancePoint or PowerPivot. Within the OLAP cube you could build calculated measures written in MDX to apply the algorithm you need.


2

You can delete the SecureStore application and re-create it. Be careful though, as you'll have to recreate all the entries for other applications, like Excel Services (if there are any that is).


2

I use "Microsoft SharePoint 2010 Performance Point Services UNLEASHED" ISDN: 0672330946 I've used it and it goes into detail not only how to set up your SharePoint server in general, but shows you about Dashboard Designer, KPIs, Reports, Analytics, Managing PPS, Filters, and Security. It has good pictures and walkthroughs.


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 ...


2

There is a good guide on TechNet that guides you through all the BI stack install on SharePoint 2013. Basically what is needed is an SSRS install in SharePoint mode http://technet.microsoft.com/en-us/library/96ce12ba-0ce1-40dd-94a3-0c7fcd7f9010


2

Explanation There are multiple causes for this error message. The common factor behind all of them is that Excel Services cannot get a valid Windows user identity from a claims token in SharePoint. In the case of Excel workbooks that contain PowerPivot data, this error occurs when any of the following conditions exist: •The Claims to ...


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

There are few videos available on Microsoft site: 1- SharePoint Server 2010 business intelligence insights training -> Module 3 | PerformancePoint Services in SharePoint Server 2010 2- Up to Speed with PerformancePoint Dashboard Designer These can give you a good start-up, and for further knowledge you can buy the book... I have the e-book link for the ...


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

There is a hotfix available that corrects this problem I believe. Encountered the same issue (only the first dimension is available in Dashboard Designer). http://support.microsoft.com/kb/2589344?wa=wsignin1.0 The hotfix corrected the problem for me. David


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

All of the UI elements rendered by PerformancePoint can be styled with CSS. This is probably more supportable and sustainable in the long run. Is there any reason CSS would not be an option?


1

This is probably most definitely something introduced with the SQL Server cumulative updates. However, just to be sure, can you check the version number of SharePoint you have installed? PPS' integration is quite basic, it just creates an IFrame with a generated URL to the SSRS ReportView of the needed report, with all the parameters passed through the ...


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

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

I've used ssrs within Sharepoint and it is great. It's very easy to use within the SP environment. This may help: http://technet.microsoft.com/en-us/magazine/ff686706.aspx good luck.


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, ...



Only top voted, non community-wiki answers of a minimum length are eligible