Connexion
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique > Forums - Accueil > SharePoint - Business Intelligence (pre-SharePoint 2010) > Excel 2007 error at drillthrough when opening workbook from Sharepoint 2007
Poser une questionPoser une question
Rechercher dans les forums :
 

QuestionExcel 2007 error at drillthrough when opening workbook from Sharepoint 2007

  • vendredi 29 août 2008 10:08Helmut Trappl Médailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateur
     
    Connectez-vous pour voter
    0
    Connectez-vous pour voter

     
    Hi!

    I have a problem when opening an Excel 2007 workbook with connection to Analysis Services 2005 from Sharepoint 2007.

    Following scenario:

    1. Create an Excel 2007 workbook with Pivot table connecting to AS 2005 cube
    2. Save this workbook to Sharepoint 2007
    3. Open this workbook directly frrom Sharepoint
    4. try to add/remove measures to the pivot table or drill down to another hierarchy level in the rows --> it works
    5. try to make a drillthrough on a figure --> An error appears:
    The query did not run or the database table could not be opened.
    Check the database server or contact your database administrator. Make sure the external database is available and hasn’t been moved or reorganized, then try the operation again.
     

    Workaround:
    6. Save the workbook locally.
    7. Close Excel and reopen the locally saved workbook. --> the Drillthrough works!
     
    Does anybody know this behaviour?

    The problem only arises, when you open the workbook directly from Sharepoint!

    Any help would be appreciated.

    Thanks,
    Helmut

     

Toutes les réponses