How can I see what internal commands PowerPivot executes in its engine?
To see what internal commands (XMLA, MDX, etc) PowerPivot executes behind the scene in it engine, you should enable PowerPivot trace and then review it. Start Excel and go to PowerPivot menu and then click on the “Settings” button. New window will pop up “PowerPivot Options and Diagnostics”. At the bottom of this screen you will see a check-box “Enable PowerPivot Tracking for the current Excel session”. As soon as you click on that check-box, you will get a warning “After the PowerPivot window is opened, tracing will start”: After you will click OK, you will notice that “Trace File Location” property in the “PowerPivot Options & Diagnostics” window changed, but it is not specified yet: Now close “PowerPivot Options & Diagnostics” window and open PowerPivot window. From this point anything you will do in PowerPivot will be recorded in the PowerPivot trace. To see trace file name go back to “PowerPivot Options & Diagnostics” screen. At this point “Trace File Location” property now should
