Hi,
I'm using the Analysis Services Excel Add-In to query a Cube built with partitions.
When using the drilldown functionality for my current\default partition the function seems to work fine.
However, when I try to drilldown on data in the other partitions, the following error message appears:
"Unable to Drillthrough on this Cell"
Would someone please be able to shed some light on this
Many Thanks
Jonathan Derbyshire
Jonathan_Derbyshire@Hotmail.com
Drillthrough Functionality via Excel Add-in
fredx21
But I found the solution:
In addition to enabling drillthrough at the cube level, you can also modify the options on each individual partition in cubes that contain more than one partition. You can access a dialog box analogous to the one in Figure B through the Partition Wizard—to access the Partition Wizard, right-click the partition and select Edit from the context menu—by clicking the Advanced Settings button and Drillthrough Options. The resulting Partition Drillthrough Options dialog box lets you change the columns and filter to use when creating drillthrough data from that partition. The ability to set drillthrough options on individual partitions means that if you execute a drillthrough operation on a cell that aggregates data from more than one partition, each partition returns its own result set and the columns in those result sets can differ from one another. Application developers need to be aware of this behavior so that they can display the results accordingly. The administrator's next task, configuring drillthrough security, requires that you use the Cube Role Manager dialog box and click the Drillthrough setting for the role you want to grant access to. Each role has a security setting, called Allow Drillthrough, that you can select to let that role execute the queries that perform a drillthrough operation. After you enable drillthrough and configure security, you can implement drillthrough for applications.
Text From Implementing Drillthrough for Developers in http://www.windowsitpro.com/Articles/Print.cfm ArticleID=41679
Jason Bock
if yes, please, let me know.
Thanks
Carlos
tfcarlos@hotmail.com
noisemaker
I'm not sure but if you have more than 1 partition you can't drillthrough. Did you try to execute the drillthrough query against an ado connection
It's a large cube
Do you have to show many columns in drillthrough
Because you can make some calculated measures to solve this (be carefull with the result).
Vanessa Grimes
If anyone can help I would be very grateful...
Thanks
Jon Derbyshire
mthomasq3
sortadan
Are you using sql 2000 or sql 2005
If you are using sql 2005, are you connecting from excel in the server or in a remote computer
If you are connecting from a remote computer, what have you installed in the computer to making it works
I can't connect from a remote computer with excel to AS 2005.
Thanks in advance
Viperious
I can drillthrough - but only on the current/default partition...
Its a Medium to large cube.
Drillthrough shows about 20 columns, but I've tried limiting it to 5 and still the same error.
Trae
It still doesnt enable me to drillthrough as I wish. I've posted my question on the site you provided in an attempt for more help.