I would like to create a trace with SQL Profiler to view the TSQL script that SQL Server uses when processing a cube. I have create a MOLAP cube, one fact table and approximately 5 dimension tables. When processing the cube, Analysis Services will have to link the fact table and dimensions in order to generate the aggregations. I would like to view this SQL. I have seen this when using database monitoring application like QUEST while processing a cube before. I could then like to copy the SQL script and paste into SQL Managenent Studio. I then filter the data, remove dimension, etc to help troubleshoot Cube problems. But when I try and use SQL Profiler, I can see the individual dimensions that have been processed, but can't find the script where all the tables are joined together? I am sure that this has to take place in order to generate the aggregations. I have selected all the available events, but have not found what I am looking for?
