I don't have an answer to your question but I have a suggestion for you: try the Tableau Software Performance Analyzer Tableau Software Performance Analyzer | InterWorks, Inc.
I'm sure that this toll will help you to find the problem.
Also to add to what Ramon has suggested 'Tableau Software Performance Analyzer' which is Interworks product works for v7.0 of Desktop only. If you are using v8.0 and above of Desktop tableau has it's own Performace Recording which can be found by navigating from Help menu.
1 of 1 people found this helpful
Open the .twb file in a text editor such as Notepad ++ or Windows Notepad and search for name='[Calculation_4451204104717709].
When found, you should hopefully see the name of the formula on the left side of the same row beginning with caption='[The name visible in Tableau Desktop].
In case your Tableau format is not TWB but TWBX
If your file is in the .twbx format, you need to rename it with a .zip suffix and thereafter open the zip file, copy the .twb file, and paste the .twb file in a folder outside the zip file. Thereafter you open the .twb file with a text editor.
Jóhan a.k.a. Kettan
Ps. A .twb file doesn't include data and therefore not sensitive unless its metadata is sensitive, such as data source properties, names of calculated fields, hard coded texts,... or simply for common "copyright" reasons.
In your case it is probably no need to share it, because I believe my explanation will be is sufficient.
When trying to extract the queries from Performance recording dashboard I only find the trimmed one but not complete query and to find the complete query I assume we need to look into logs.
Are you aware of which logs to be looked into to extract complete query...?
I just wanted to extract the query run it against a database and check the time taken over DB side to execute the query and check the results with Tableau.
Can you help me to understand this...?
I think there seems to be a miscommunication here? Kettan isn't saying to find the queries in Tableau desktop, but in the .twb/.twbx file. Just right click the file and open it with notepad or notepad++, and you should be able to follow through with the steps which Kettan provided. Or maybe I am misunderstanding now.
Thanks for helping clarifying the issue.
It might be a misunderstanding, because even if the original question was titled Interpreting performance recording, it had little to do with performance recording. The only thing the questioner needed was the "human" name of the calculated field Calculation_4451204104717709 which the performance recorder returned.
To get the full query, try this:
On the performance recording workbook, select a worksheet such as "Query". Right Click on the Queries data source and select 'View data...' If you copy the query you need from the grid, you should be able to past it into a text editor to get the whole query. Keep in mind, that if your data sources are Tableau data extracts, you won't be able to run these queries on your database engine. This only works if your workbook is using live connections to your data.
Thank you for your response. But Pasting the query to text editor selected from View data I can only get the portion of the query been displayed but not complete query. PFB sample query for reference.
SELECT (CASE WHEN (("#tableau_9_context"."surv_year" = (CASE WHEN (CASE WHEN CURRENT_DATE IS NULL THEN CAST(NULL AS INTEGER) ELSE CAST(EXTRACT(MONTH FROM CURRENT_DATE) AS INTEGER) END = 1) THEN (CASE WHEN CURRENT_DATE IS NULL THEN CAST(NULL AS INTEGER) EL
Any further help is really appreciated. Thank you!
Ahh. Now I remember running into this issue. I think what I did was opened up the log files and searched for the beginning of the query to find it. My log files are in C:\Users\******\Documents\My Tableau Repository\Logs (on Windows 7.)
You should be able to find the query, but each row will have log metadata at the beginning of it, so you'll need to clean up the text.
Could you tell me do I need to create logs and then check for the query since upon opening the workbook and checking for query in the log file I couldn't find any. Can you tell me which specific date logs to be looked into...?
My performance recording workbook is of PROD environment and I'm opening the workbook using Tableau Desktop in PROD.
Tableau Desktop should be creating the logs automatically. I usually open the workbook in Tableau Desktop, close Tableau and then go look in the logs folder at the most recent files. Note you shouldn't need performance recording on to see the query in the logs.