Creates gantt based on extended events for processing tabular cube
If you want find bottlenecks in processing tabular cube with this simple code you can analyse progress of table processing inside tabluar cube
- Open SSMS
- Connect to your tabluar instance
- Open and execute XMLA exev_tabular_processing_session.xmla (provide path where XEL file will be stored)
- Star processing your tabular cube (full, table)
- In SSMS open file "xel2gantt.sql" (provide path where XEL file has been stored)
- Execute sql file -> have fun with gantt graph