Masuk
 
AwalPerpustakaanWikiPelajariUnduhDukunganKomunitasForum
Resources for IT Professionals >
> 
> 
Performace point/Excel services OLAP cubes

Unanswered Performace point/Excel services OLAP cubes

  • 01 September 2010 15:56
     
     
    Masuk untuk Memilih
    0

    Running Sharepoint 2010 Ent fresh install.  I have created a new site and performance point service as instructed in the following tutorial.

    http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx

    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!

    Andy

     

Semua Balasan

  • 01 September 2010 18:43
     
     
    Masuk untuk Memilih
    0

    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.

    Scot

     
  • 01 September 2010 19:28
     
     
    Masuk untuk Memilih
    0

    Hi Scot,


    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
     
     
    Masuk untuk Memilih
    0

    "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
     
     
    Masuk untuk Memilih
    0

    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?