Fix It: The query could not complete because the data source is not in a performancePoint trusted location

Hi Folks,

If you are running PPS Dashboards and reports in your BI center site and when you are trying to view your dashboard/scorecards/reports and you have got this error:

" The query could not complete because the data source is not in a performancePoint trusted location"

The cause of this error is:

1) You system admin only listed specific trusted data sources in your farm.

To adjust this by adding your data connection library that is being used by your dashboard, do the following:

- Open central adminstration.

- Click on Manage service applications.

- Click on PerformancePoint service Application.

- Click on Trusted Data Source Locations, You will see "Only Specific Location" is selected and your data connection library is not listed

- Add your Data Connection library to the list, for example:

http://MESP2010:17949/Data%20Connections%20for%20PerformancePoint/

- Click on validate icon to make sure that you are putting a valid path.

- Click on Ok.

- Refresh your dashboard,scorecards or reports and everything will start working again.

Hope this helps.

Regards,

Mostafa Arafa

twitter.com/mostafaelzoghbi

System Services/ Service Applications in SharePoint 2010

Hi All,

In this post, I’d like to share some thoughts about SharePoint 2010 terms in regard of planning your SharePoint Farm. I will show in details the differences between some terms such as: System Services, Application Services, Cross-farm services, Single-farm services, Services associated or not to a service applications and How to configure each of them in your SharePoint Farm.
If you are familiar with SharePoint 2007, Service applications are the equivalent to Shared Services in SharePoint 2007.
1) System Services: In SP 2007, some common services were combined under Shared Services service (search, user profile…etc.), in SP 2010, each service is a standalone application, called Service Application. In SP 2010 you can configure each service application alone. Some of these system services are associated or not with a service application.
To configure System Services in SP 2010, follow these steps:
1) Open SP 2010 Central Admin
2) Select System settings
3) Click on Manage services on server
You will be able to select the servers within the farm and Start/Stop them
2) Web Application and system services: Once you create a web application in your farm, all system services are associated to your web application, You can configure which service application would you like to associate with your web application, to do so:
1) Open SP 2010 Central administration
2) Select Application Management
3) Click on Manage configure service application association
4) Click on your web application and select the required system services required
5) Select custom from the drop down list to start configure the system services associated with your web application

3) Cross-farm services vs. Single-farm services:
Cross-farm services: are the services that can be shared across different farms within the organization such as: User Profile, Managed Metadata, BCS, Search, SSS and Web Analytics.
Single-farm services: are the services that can be configured only within only one farm such as: State service, Master data services, Performance Point, Excel Services, Access Services, Word Services, Word Viewing, Power Point and Visio Service.



Regards,
Mostafa Arafa
twitter.com/mostafaelzoghbi

Error when trying to connect to or download PerformancePoint designer

Hi all,

I was getting an error message when i'm trying to connect to Performance point server, and the error message wasn't descriptive at all, this is the error message :

" ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://ServerName/DesignerInstall/ resulted in exception. Following failure messages were detected: + Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected.
"
If you don't have performance point server on your machine and you are not able to download it below shows how can you do this.

To do this, get the download from your server, this is the path:

C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\DesignerInstall

Take 3.0 folder, and install the designer on your desktop.

After installation, you will have another problem, you can't connect to your server because you didn't install it from the browser, to fix this do the following:














Replace localhost:4000 with your server name and click ok.

Then you can click on Refresh to get all the contenct on your designer.

Hope it helps.


Regards,
Mostafa arafa