I am using OWC to perfrom a drill through. The drill through works fine on Food Mart cubes. If I change to connect to a cube which is built from Oracle I get an empty record set (record count = 0 ). I do not get any errors. Has anyone been able to get the DRILLTHROUGH MDX command to work with an Oracle backend? Please let me know
kc

Hi,

I have seen a bug in this area when HOLAP or ROLAP was used together with
Microsoft oledb provider forfor Oracle and drilltrough. This bug will be
fixed in MDAC2.7sp2 could you check if you use Microsoft oledb provider f
for Oracle if yes could you try if it works with ODBC?

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

I changed the provider in Analysis Manager to ODBC and I see the same behavior. I have version 2.71.9030 of MDAC.
Thanks for your help
Kristen