Drillthrough Functionality via Excel Add-in

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

We have the same problem (also using OWC controls). do you have the solution?
if yes, please, let me know.
Thanks

Carlos
tfcarlos@.hotmail.com
|||No I'm still stuck.

If anyone can help I would be very grateful...

Thanks

Jon Derbyshire|||I think Excell can't drillthrough over partitiones.
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).|||Why do you think that Excel cant drillthrough over partitions? Have you read this somewehere or are you just speculating?

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.|||I'm speculating.
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|||Thanks - I've been through and it appears that drillthrough was already definitely enabled...

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.|||I want to ask you.
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|||2000 version

drilldown in excel and PDF

I have a report that has the drilldown function in it with the +/-
sign. When I export the report to excel or PDF, the drilldown
functionality is lost and I am not able to view the info at the lower
level's.
If I expand all the drilldown's and export it, then all the info shows
but the +/- still doesn't show up in excel or PDF.
I am currently running RS SP2.
does anyone know the reason why it's doing this?That is the way those types are rendered. They do not have the drill down
capability.
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||Something has to be wrong...
For starters:
PDF files will ONLY show the report exactly how it looks - i.e. if some
components are collapsed, and others expanded, then that is EXACTLY what you
get when you export to PDF.
EXCEL on the other hand WILL show drill-downs and carry that
functionality into the excel workbook itself. I.e. You can after exporting
into Excel drill-down into your data or collapsed as if you were on the
report server web page viewing this report.
One of the issues with Excel drill downs is when people use a SubReport.
Subreports do not render into Excel at all. (Pisses me off of course) :) Are
you using a subreport?
=-Chris
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||no, all the data is part of the same report.
basically, the root level shows a customer's name and their financial
info and when the user clicks on the drilldown +/- it's supposed to
show the customer's address info. All of the info come from the same
dataset or query.
I wonder if it has anything to do with SP2.
Chris Conner wrote:
> Something has to be wrong...
> For starters:
> PDF files will ONLY show the report exactly how it looks - i.e. if some
> components are collapsed, and others expanded, then that is EXACTLY what you
> get when you export to PDF.
> EXCEL on the other hand WILL show drill-downs and carry that
> functionality into the excel workbook itself. I.e. You can after exporting
> into Excel drill-down into your data or collapsed as if you were on the
> report server web page viewing this report.
> One of the issues with Excel drill downs is when people use a SubReport.
> Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> you using a subreport?
> =-Chris
> "bevarg" <benovarghese@.gmail.com> wrote in message
> news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> >I have a report that has the drilldown function in it with the +/-
> > sign. When I export the report to excel or PDF, the drilldown
> > functionality is lost and I am not able to view the info at the lower
> > level's.
> > If I expand all the drilldown's and export it, then all the info shows
> > but the +/- still doesn't show up in excel or PDF.
> > I am currently running RS SP2.
> >
> > does anyone know the reason why it's doing this?
> >|||Has chris said it works fine with excel. Sometimes we miss out simple things,
Just in case , in excel the + sign ie grouping happens and it is extreme left
side of the sheet or the screen itself. hope you noticed this. If it is still
not there.
Amarnath
"bevarg" wrote:
> no, all the data is part of the same report.
> basically, the root level shows a customer's name and their financial
> info and when the user clicks on the drilldown +/- it's supposed to
> show the customer's address info. All of the info come from the same
> dataset or query.
> I wonder if it has anything to do with SP2.
>
> Chris Conner wrote:
> > Something has to be wrong...
> >
> > For starters:
> > PDF files will ONLY show the report exactly how it looks - i.e. if some
> > components are collapsed, and others expanded, then that is EXACTLY what you
> > get when you export to PDF.
> >
> > EXCEL on the other hand WILL show drill-downs and carry that
> > functionality into the excel workbook itself. I.e. You can after exporting
> > into Excel drill-down into your data or collapsed as if you were on the
> > report server web page viewing this report.
> >
> > One of the issues with Excel drill downs is when people use a SubReport.
> > Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> > you using a subreport?
> >
> > =-Chris
> >
> > "bevarg" <benovarghese@.gmail.com> wrote in message
> > news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> > >I have a report that has the drilldown function in it with the +/-
> > > sign. When I export the report to excel or PDF, the drilldown
> > > functionality is lost and I am not able to view the info at the lower
> > > level's.
> > > If I expand all the drilldown's and export it, then all the info shows
> > > but the +/- still doesn't show up in excel or PDF.
> > > I am currently running RS SP2.
> > >
> > > does anyone know the reason why it's doing this?
> > >
>

Drilldown Error

Hi,
I've one report with single level drilldown.
I've set this functionality through Detail/Summary parameter.
Now when i run the report by selecting Summary option,
reports run fine with showing collpased (+) sign against
toggle field.
Now when i try to drill down the report by clicking the (+) sign,
it gives following error
"One or more datasource credentials required to run the report have not been
specified. (rsCredentialsNotSpecified)"
I haven't set the credential during design time, report ask the user
name/password during run time.
Now what is the reason behind that error ? And what is the solution ?
--
Thanks & Regards
MalkeshI have the same problem, but only if the report is rendered from a snap shot.
"Malkesh" wrote:
> Hi,
> I've one report with single level drilldown.
> I've set this functionality through Detail/Summary parameter.
> Now when i run the report by selecting Summary option,
> reports run fine with showing collpased (+) sign against
> toggle field.
> Now when i try to drill down the report by clicking the (+) sign,
> it gives following error
> "One or more datasource credentials required to run the report have not been
> specified. (rsCredentialsNotSpecified)"
> I haven't set the credential during design time, report ask the user
> name/password during run time.
> Now what is the reason behind that error ? And what is the solution ?
> --
> Thanks & Regards
> Malkesh