I hope you are using service/faceless accounts and not personal ones!
I'm assuming you can download and look at the data source information of both workbooks. This would tell you what you need to know because they should be the same, right?
Well... in theory... but we just can't get a query form the Oracle View to match the Workbook, so we are wondering if the extract is either not pointing to that view, or doing a custom SQL, or pointing somewhere else.
How can we verify that the extract is actually pointing to that view?
Emanuel Villa wrote:
Well... in theory... but we just can't get a query form the Oracle View to match the Workbook...
How fast is the data source being updated? Real-time like a transactional db? And how often is the extract executed?
< edit > Moved to the Server Administration forum.
Everyday 3 am.
That option (convert to custom SQL) doesn't show on my workbook.
Sorry John, but not really sure what am I looking at or how to use this workbook?
Can you elaborate on it please?
Thanks in advance.
Sure! This is a workbook that I connected to my own Tableau Server's repository, which is just a postgres database.
Data Engine Extracts: Notice it's "true" for all the records? That's because I put a simple filter to show only workbooks that have an extract.
Name (Workbooks): Name of workbooks that has an extract.
DbName: Name of database that has an extract.
DbClass: What kind of database, e.g. sql, oracle, excel, etc.
Friendly Name: The name of person that created the extract.
You can connect to your own Tableau Server's postgres database to see the same thing. Just change my workbook's datasource server to your Tableau Server (if it's a single server install) or any worker that has a Repository process.
Check out these links:
Go through the articles and give it a try. If you still need help, I can walk you through it via WebEx. You can email me at email@example.com.
Yes, exactly what I needed.
Thanks a lot. Really appreciate it.
Oh boy, now I'm confused!
John, I connected your workbook to my production server and am looking at the Owners (the Friendly Names) and they are totally incorrect! Many of the "Owners" haven't even logged on to the Server...ever!
What am I missing? I am using a Live connection.
Verifying datasources+ (workgroup)
... FROM "public"."data_connections" "data_connections" INNER JOIN "public"."workbooks" "workbooks" ON ("data_connections"."owner_id" = "workbooks"."owner_id") INNER JOIN "public"."system_users" "system_users" ON ("data_connections"."owner_id" = "system_users"."id") INNER JOIN "public"."users" "users" ON ("system_users"."id" = "users"."id")
Example of issue. From Desktop sheet:
From Tableau Server:
As another example of something screwy going on, there was a user that had never logged in and also left the company so I deleted them from the Tableau Server. The owner information then switched to one of the existing owners (person already in the report)!
Server is 9.0.4. Was first installed some time in 2012 so it's been updated a few times I wonder if something was corrupted during an upgrade?
Desktop is 9.1.1.
I can't explain your situation Your theory of corruption seems plausible, though.