April 26, 2006 at 9:19 am
ive inherited an app, its an olap app with cubes. one way in which people view the data is to use an excel pivot report. i cannot see how excel gets its data from the cube. i didnt create any conections for it, it defo isnt calling any sprocs, so where do i see how excel is calling its data from the cube?
April 26, 2006 at 9:27 am
To connect excel pivot table to cube.
In excel go to data, Import external data, Import data.
the you have to either create an odc, or use an existing one, an odc is basically an odbc connection string in a file.
Once the pivot table is using the odc, and connected to the cube you do not need to do anything other than refresh the data.
From what I can tell there is no way to tell what odc file was used, or what cube the excel file is connected to. Still trying to figure that one out.
April 26, 2006 at 9:42 am
the thing is though, i never created an odc connection. the report just worked on my pc, i thought id have to create the connection myself. can excel carry a connection with it onto a pc??
April 27, 2006 at 4:44 am
Yes, it can hold the connection info in the workbook. You can get to it programmatically (ie VBA/macro) , you could also try opening the workbook and holding ALT-SHIFT-F11 (takes you to the script editor) where you should be able to see the connecton string. On other machines (or the machine where the report was created) there should be an *.oqy file, this also contains the connection info. Note that changes the *.oqy file changes the details only for new reports from that connection.
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply