how does excel pivot table/report connect to my cube?

  • i am supporting an app using msinsight to create reports from cubes. msinsight can export the reports as excel reports. these reports can be updated by clicking the "update" button. i need to find where the connection for the excel file to the cube is stored. it is not in my ODBC connections, and i cant find it in the code of my excel report. i was told here it will be in a file with the extension   ".oql" or something like that, but i cant find that file anywhere either. where can i find the connection string so that i can alter it?

     

    Thanks all

  • on further investigation i believe the connection data is stored in a file with extension ".mso" but i cant find this file. can anyone advise where or how i can find this file?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply