Problem with Drill Down Reports in OLAP Reports.

  • I am using Reporting Services in SQl 2000, and front end as ASP.NET. I have few OLAP Cube reports in the application. How can i know what query is being fired when a report is drilled down. How to know the associations in the cube specified for the drilldown. any help is greatly appreciated.

    Thanks in advance.





  • Assuming you mean drillthrough options, the user needs ability to run drillthrough query (security option). To see which fields returned when drilling thro' just open the cube in the designer and take a look, its pretty straight forward. In 2000 the drillthrough queries the underlying data while in 2005 it shows the member properties of dimension group. If you need to see the query being run you can run the profiler..

    Phil Nicholas

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply