Query a pivot cache

[dmcgimpsey]

Hi Folks:

I have run up against the 65,536 row limit on a query that my user (2003) has been running for some time now.

The query is a web-query (.iqy) and it queries a sharepoint list to retrieve a list of file members under a directory structure.

I cannot recreate the web query since the installation has really limited the functionality of the sharepoint interface, but the query still runs.

In order to read all the records, I have pointed the web-query to dump the records to a pivot table.

There are four fields in the pivot cache, but I can only display the count, since there are too many unique occurances to display any of the data.


I am wondering if I can build a query that goes after the pivot cache and only returns the value of a specific field if it contains a specific string - ie: ".xls"

In otherwords, I want to query the pivot cache that is based on external data ie: web query

Thanks

Don