■ Data Analysis/SSAS (Cube)

SQL Trace (Save to file)

Wonbae Kim 2016. 10. 25. 03:59

Click [XMLA] menu on SQL Tabular instance

 

 

Copy & Paste the below text.. and Click [F5] button

 

If you can see below error message.. then you should create folder (SSASExtendedEvents)

 

[F5] Try again..

You can see the below success message.

 

Click [MDX] menu on SQL Tabular instance

 

SELECT * FROM $system.discover_traces

 

You can see as the below image.

 

 

 

 

When you open the file, you can look like the below image.

 

 

Copy & Paste the below text.. and Click [F5] button

 

You can see as the below image.

 

Once you are ready to stop the trace, execute the following XMLA:

 

Create Jobs Schedule: Usage hits for Excel BI(Tabular)