Query data within a PivotCache programmatically
 

I want to be able to query the underlying data within a pivotcache
programmatically. My data source changes daily and I want to be query
the data held in the pivotcache snapshot from code.

The Recordset property looks promising but so far I haven't had any joy
getting anything to work.

As drill down is doing what I want to be able to do, are there
properties exposed that will allow me to do something similar?

I would prefer not to have to set pivottable filters and criteria if at
all possible to do the same.

Any advice folks?