I am using MS Analysis Server 2000 to build cubes. To display the result I am
using MS-Excel 2003. In the cube which I have made, I have enabled the Drill
Through option and selected all fields to drill through in the cube. I am
able to see the row level data in the data pane of that cube in Analysis
Server when I right-click a celle and choose the Drill Through option. But I
am facing the problem in Excel for the same i.e. I am not getting the row
level data. On doubleclick in an excel pivot-cell I get the error "Cannot
show detail data for that section"

I used to be able to do this when the pivot data was generated from another
sheet of the excel workbook. I would like to do the same when data is stored
on sql server/ analysis server

What am I missing here.

Thanks in advance.

Tore

Hi Tore,
To let me better understand your scenario, I would like to know the
following questions:
1. Did you install Microsoft Office 2003 SP2 on your computer?
2. Could this issue be reproduced on your other cube?

Now I am performing research on this issue and trying to reproduce your
issue. I may need more time to get back to you. I appreciate your patience.

If you have any questions or concerns, please feel free to let me know.
Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

On Sep 7, 1:32 am, Tore <t...@newsgroup.nospam> wrote:
> I am using MS Analysis Server 2000 to build cubes. To display the result I am
> using MS-Excel 2003. In the cube which I have made, I have enabled the Drill
> Through option and selected all fields to drill through in the cube. I am
> able to see the row level data in the data pane of that cube in Analysis
> Server when I right-click a celle and choose the Drill Through option. But I
> am facing the problem in Excel for the same i.e. I am not getting the row
> level data. On doubleclick in an excel pivot-cell I get the error "Cannot
> show detail data for that section"
>
> I used to be able to do this when the pivot data was generated from another
> sheet of the excel workbook. I would like to do the same when data is stored
> on sql server/ analysis server
>
> What am I missing here.
>
> Thanks in advance.
>
> Tore

You need a VBA macro to do that.
Just to make it clear:

Excel 2003: needs a macro you can see here:
http://www.sqlmag.com/Articles/Artic...82/pg/1/1.html
Excel 2007: no macro required to drillthrough an AS2005 cube - not
sure about AS2000 cube

Marco Russo
http://www.sqlbi.eu
http://sqlblogs.com/blog/marco_russo

Hi Tore,
Sorry for delaying this response. I applied for a test machine with Office
2003 for performing this test at last weekend since my computer just had
Office 2007 installed.

From my research, it is indeed a product limitation in Excel 2003 and its
previous editions; however this issue does not occur in Excel 2007. In my
Excel 2007, I can directly double click a measure for drillthrough.
A good news is that Microsoft published an Add-in so that you can use the
drillthrough capabilities in Excel 2002/2003.
Using the Excel Add-in for SQL Server Analysis Services
http://office.microsoft.com/en-us/ex...265551033.aspx

I tried the tool in a simple scenario (FoodMart Sales cube) and it worked
fine. The following is my test steps:
1. Select Cube Analysis -> Manage Connection..., create a new OLAP
connection for the report;
2. Select Cube Analysis -> Build Report;
3. In the Layout pane, select Row and Column Headers;
4. Click View Data Pane, select the connection, select Dimension as
Customers, set Display as Member Tree, select All Customer from Browse list
and drag it to the Rows header area; and then select Measures dimension,
select the Unit Sales, Store Sales and Store Cost, and drag them to the
Column Headers area;
5. Then you can drill through the dimension at any level via selecting a
measure and then selecting Cube Analysis -> Navigation->Drillthrough.

For more details of the Add-in, you may refer to Cube Analysis Help under
Help menu.

Hope this helps. If you have any other questions or concerns, please feel
free to let us know. Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Thanks, I think this will di the job for me.

Regards

Tore

Thanks, I will look into it.

Tore

Hi Tore,
Regarding this issue, we have not received your response. Could you please
let us know if the suggestions are helpful?

We really appreciate your posting back if this issue persists or if you
have any questions or concerns. Thanks for using Microsoft MSDN Managed
Newsgroup and have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

I have got the answers I need, thank you.

Regards

Tore

"Charles Wang[MSFT]" wrote:

> Hi Tore,
> Regarding this issue, we have not received your response. Could you please
> let us know if the suggestions are helpful?
>
> We really appreciate your posting back if this issue persists or if you
> have any questions or concerns. Thanks for using Microsoft MSDN Managed
> Newsgroup and have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>