Hi,

Is it possible to view the SQL that Analysis Services 2000 or
2005 actually uses when building a cube. I am getting wrong result sets
when I run the same cube model in AS 2000 and AS 2005 and was wondering
if there was any way to get holf of the actual sql the tool uses to
capture data from the table.

Thanks

SQL Profiler can be used against an AS 2005 server (or the SQL Server) --
and it will show the SQL queries sent during processing.

For AS 2000, you can see the queries used for processing in the processing
dialog if you use Analysis Manager.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

<tsachin (AT) gmail (DOT) com> wrote