hi,

i need to display the drill through data of the analysis
manager as a report using reporting services... had any
one done this before ??? is this possible ..

thanks in advance.

I assume you mean that you want to mimic the drill through capability of the
cube browser that ships as part of Analysis Manager as a Reporting Services
report. If that's the case, there's some discussion of this topic in

http://msdn.microsoft.com/library/de...lapasandrs.asp

Check the section on DRILLTHROUGH

--Sean

Sean Boon
Microsoft Office BI


"albert einstein" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Yes, I have done this through the use of cell level
actions. If your OLAP front end tool honors cell level
actions, then it is very possible.

In short, you would set up a parameterized reporting
services query that is fed the co-oridinates from the
Analysis Services action.

It isn't the easiest thing in the world to do, but it is
VERY cool...

Dave
OLAP Business Solutions