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!
View Complete Post