We have a sharepoint site and there is a filter to filter the contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.And there is one Excel Web access Web part used to display excel data. When I go to Modify shared web part for this Excel Web access web part the Workbook tab points to an Excel sheet on site for example www.abc.com\xwz\PQ.xls
.. But when I open this Excel sheet from the site where it is poining to which is XYZ\PQ.xls, It has different values then what is displayed on the site.
I have different sites , where this same excel sheet is refered to under Workbook tab for different Excel web access web part but it displays the data different for each Excel web part. I am unable to figure out where is this data coming from? There is a .odc connection to OLAP db on server but I am kind of lost to find if there are any tables under this OLAP DB and don't see any tables. This data has to be coming from a Excel sheet?? which may be I am unable to find. or its coming from OLAP DB? Please provide few suggestions how this Excel web access part works. Thanks