I am useing MS Analysis Server 2000 for building the Cubes & to display the result I am using MS-Excel 2000. In the cube which I have made, I have given the enabled the Drill Through option & I am able to see the row level data in the data pane of that cube in Analysis Server when I am choosing 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.
My question is, Is there any setting I have to do? Any other option are available to visualise the row data?
Please help me out.
Thanks in advance.
TapKs
My question is, Is there any setting I have to do? Any other option are available to visualise the row data?
Please help me out.
Thanks in advance.
TapKs