Home > Software > Tableau
Interview Questions   Tutorials   Discussions   Programs   Videos   Discussion   

Tableau - In tableau v8.2, where do we see the query that is being used to generate a report?




1433
views
asked sirisha January 6, 2015 07:44 AM  

In tableau v8.2, where do we see the query that is being used to generate a report?


           

4 Answers



 
answered By sachin-1214   0  

check the data in log file on path :- My Documents\My Tableau Repository\Logs and find a file titled log.txt

flag   
   add comment

 
answered By Sobila   0  

To find the query being run, look in My Documents\My Tableau Repository\Logs and find a file titled log.txt. The section between the begin and end query tags is the query that was passed to the database.

flag   
   add comment

 
answered By   0  

This is how it will look, and also sent you an e-mail regarding this with detailed explanation.

2011-08-04 13:46:16.161 (2198): DATA INTERPRETER: Executing primary query. 2011-08-04 13:46:16.171 (2204): 2011-08-04 13:46:16.171 (2204): SELECT [Superstore APAC].[Customer Segment] AS [none:Customer Segment:nk], 2011-08-04 13:46:16.171 (2204): [Superstore APAC].[Product Category] AS [none:Product Category:nk], 2011-08-04 13:46:16.171 (2204): [Superstore APAC].[Product Sub-Category] AS [none:Product Sub-Category:nk], 2011-08-04 13:46:16.171 (2204): SUM([Superstore APAC].[Sales]) AS [sum:Sales:qk] 2011-08-04 13:46:16.171 (2204): FROM [dbo].[Superstore APAC] [Superstore APAC] 2011-08-04 13:46:16.171 (2204): GROUP BY [Superstore APAC].[Customer Segment], 2011-08-04 13:46:16.171 (2204): [Superstore APAC].[Product Category], 2011-08-04 13:46:16.171 (2204): [Superstore APAC].[Product Sub-Category] 2011-08-04 13:46:16.171 (2204): 2011-08-04 13:46:16.238 (2204): [Time] Running the command took 0.0659 sec. 2011-08-04 13:46:16.238 (2204): [Time] Running the query took 0.0662 sec. 2011-08-04 13:46:16.240 (2204): [Time] Getting the records took 0.0007 sec. 2011-08-04 13:46:16.240 (2204): Building the tuples took 0.0001 sec. 2011-08-04 13:46:16.240 (2198): [Count] Query returned 68 records (Q10).

flag   
   add comment

 
answered By sirisha   0  
Hi Mounika, I checked the log.txt in the logs folder. But I couldn't find any query in that. Is that represented in any other format?
flag   
   add comment

 
answered By   0  

To find the query being run, look in My Documents\My Tableau Repository\Logs and find a file titled log.txt

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert