Excel add-in: no drill through

[fmientjes]

I created a cube in which I can drill through (in analysis manager).
In Excel I use Pivot table to access the same cube. Unfortunately I cannot use drill through: "Cannot show details for current item"
Drill-down works.
User rights are set to as much as possible.

Idea's?
Frans

 

[pokeyshnj]

Excel does not natively support drill through to cubes.

You have to write custom MDX code in excel and pass
it to the olap server and parse through the recordsets
that it will return. You can do this with ADO and/or adomd.

Unfortunately this is not a trivial thing to do.