XML4Analysis & DrillThrough 
Author Message
 XML4Analysis & DrillThrough

XML/A is capable of executing DRILLTHROUGH, however the limitation is that
the result set will contain only one rowset (i.e. from the first partition).
XML/A standard doesn't currently have mechanism for returning multiple

The failure that you see might be related to permissions as you suggested.
You can ask for CUBEs schema rowset and check the value of the
IS_DRILLTHROUGH_ENABLED column to verify that.


Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

> Hi Everyone,
> Can anyone tell me if the XML for Analysis ISAPI is
> capable of executing DRILLTHROUGH statements?
> I've tried but get the following error:

> <faultcode>XMLAnalysisError.80020009</faultcode>
> <faultstring>An error occurred while processing the
> request.</faultstring>
> <faultactor>XML for Analysis Provider</faultactor>

> Is this a permissions issue or is the ISAPI incapable of
> executing the MDX.

Mon, 19 Jul 2004 02:32:21 GMT
 [ 1 post ] 

 Relevant Pages 

1. XML4Analysis & DrillThrough

2. Drillthrough, Excel XP, & Office Web components

3. drillthrough & ASP

4. xml4Analysis ChildCount Property

5. xml4Analysis Drillthru Error

6. XML4Analysis + Ragged Hierarchies

7. Drillthrough en Cubos Virtuales


9. How to drillthrough using an MDX

10. Unspecified error returns when drillthrough a Virtual cube

11. Drillthrough for a virtual cube fails

12. Excel Drillthrough Timeout

Powered by phpBB® Forum Software