2 Replies Latest reply on Feb 21, 2013 10:17 AM by anoop.sharma

    Interpreting tableau log file

    anoop.sharma

      Hi, I was trying to understand what tableau does in background by going through Log file as i was creating simple tables and charts. It seems for the sample file i used (sample store sales.xls), Tableau should create SQL to extract data and then do manipulations. But i found it is doing so in different manner. For eg. in the sample_store_sales file supplied i was trying to find Sales by Year using Sales Measures and Order Date dimension. The following was the log entry. Please help me in interpreting it. Is this SQL or something different? How can i learn more about it?

       

      DATA INTERPRETER: Executing primary query.

      2013-02-21 18:59:14.177 (208c): <QUERY protocol='06974688' session_id='5'>

      2013-02-21 18:59:14.177 (208c): (restrict

      2013-02-21 18:59:14.177 (208c):   (aggregate

      2013-02-21 18:59:14.177 (208c):     (project

      2013-02-21 18:59:14.177 (208c):       (table [Extract].[Extract])

      2013-02-21 18:59:14.177 (208c):       (

      2013-02-21 18:59:14.177 (208c):         ([yr_Order Date_ok]

      2013-02-21 18:59:14.177 (208c):           (year [Order Date])

      2013-02-21 18:59:14.177 (208c):           )

      2013-02-21 18:59:14.177 (208c):         )

      2013-02-21 18:59:14.177 (208c):       )

      2013-02-21 18:59:14.177 (208c):     (

      2013-02-21 18:59:14.177 (208c):       ([yr_Order Date_ok] [yr_Order Date_ok])

      2013-02-21 18:59:14.177 (208c):       )

      2013-02-21 18:59:14.177 (208c):     (

      2013-02-21 18:59:14.177 (208c):       ([sum_Sales_qk]

      2013-02-21 18:59:14.177 (208c):         (sum [Sales])

      2013-02-21 18:59:14.177 (208c):         )

      2013-02-21 18:59:14.177 (208c):       )

      2013-02-21 18:59:14.177 (208c):     )

      2013-02-21 18:59:14.177 (208c):   ([yr_Order Date_ok] [sum_Sales_qk])

      2013-02-21 18:59:14.177 (208c):   )

      2013-02-21 18:59:14.177 (208c): </QUERY>

       

      Below is what Tableau created using GUI:

       

      Tableau Table.jpg