21 03 2013
Unable to load first class Dao provider type – PerformancePoint Services error code 10201
If you’re doing development against PerformancePoint Services API, whether in a custom ASP.NET site, a Console Application, make sure you have the Bpm configSection within your web.config (or App.config).
You want to add the following configSection to your config file:
1 2 3 4 5 |
<configSections> <sectionGroup name="Bpm"> <section name="FCODaoProviders" type="System.Configuration.DictionarySectionHandler" /> </sectionGroup> </configSections> |
And you also want to include this under the root element of your config file, to let your application know which Dao providers to load for the various objects PerformancePoint can handle:
1 2 3 4 5 6 7 8 9 10 11 |
<Bpm> <FCODaoProviders> <add key="DashboardSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.DashboardSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="DataSourceSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.DataSourceSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="FilterSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.FilterSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="IndicatorSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.IndicatorSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="KpiSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.KpiSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="ReportViewSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.ReportViewSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add key="ScorecardSPDao" value="Microsoft.PerformancePoint.Scorecards.Store.Dao.ScorecardSPDao, Microsoft.PerformancePoint.Scorecards.Store, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> </FCODaoProviders> </Bpm> |
It probably goes without saying, but if you’re running this contextless of SharePoint you’ll need to fake your HttpContext and point it to instances of SPWeb and SPSite (plenty of tutorials out on the web to do this). Oh, and with the rest of SharePoint code, it can only run on a SharePoint server. There is no client API for PerformancePoint in SharePoint 2010 and I doubt there is one for 2013. If you need you can create a service proxy that runs in SharePoint and gets the data you need.
SharePoint 2010 Server Search Only Crawling Top Level Site SharePoint WebPart with Definable or Dynamic Filter Connections
Thank you. Thank you. Thank you.
It is rare to find anyone else doing PerformancePoint API calls.
Hi please I need an urgent help I want to disable or hide export to excel and export to power point fron the webpart menu in the dashboards I have on sharepoint 2013. Thanks a lot
Hi,
Please check this StackOverflow question: http://stackoverflow.com/questions/1499885/reportviewer-hide-pdf-export
You want to remove the XML
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/></code>
and the equivalent one for PowerPoint in the directory:
Hi Jimmy ,
Let me describe my situation I am running SQL server analysis services and i have my dashboards created on dashboard designer and published to sharepoint. But when I access My sharepoint site and see my dashboards this is where i want to remove export to excel and powerpoint. My question is where should i add this code of line that you mentioned?
Thanks
JP
If you’re referring to the options within the SSRS report, you need to remove the option from the SSRS Config file as I described.
It’s normally located in this directory:
DRIVE:\Program Files\Microsoft SQL Server\\Reporting Services\ReportServer
However, if you mean the standard PerformancePoint Charts, you’ll have to use jQuery to locate the menu options and remove them. I don’t have an environment to hand but if you look for “removing DOM elements using jQuery”, and find out about jQuery Selectors you should be able to get somewhere.
THANK AGAIN jimmy so Is there any specific version of Jquery to download.?