01 September 2010 15:56
Running Sharepoint 2010 Ent fresh install. I have created a new site and performance point service as instructed in the following tutorial.
I have then uploaded an Excel document which pulls data from OLAP cubes. The Excel doc as a standalone works fine. After it has been uploaded users can open it as normal etc but when changing slicers and trying to pull info from the cubes I get the following error..
An error occurred durning an attempt to establish a connection to the external data source. The following connections failed to refresh: "Name of out cubes here"
I have been playing with the secure store and generating keys etc to no avail. I have tried exporting the .odc file from the Excel document and uploading it to the data connections library/dashboard site but this doesnt help
The anoying thing is that I had it working once and then the next day it failed for no apparent reason and even after a fresh install I cant get it to work again. Any pointers or tutorials would be greatly appreciated!
01 September 2010 18:43
My guess is that the user is not mapped to the credentials in the Secure Store Service. Each user must be mapped eith individually or through a group.
01 September 2010 19:28
Thanks for your reply. Could you give me a brief run down on the best practice way of doing this or point me to a resource with instructions?
01 September 2010 19:30
"Could you give me a brief run down on the best practice way of doing this or point me to a resource with instructions?"
You go into the Secure Store Service Application and set the members for your SSS ID that is being used to pass the credentials.
SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force
03 September 2010 14:49
Hi Clayton, thanks for the reply.
I have added the users that need to access the files in the secure store service that I created (set permissions) and also added the user account to the set credentials option. I am still getting the same error, any further ideas?