I’ve been busy. Too busy to blog. This makes me sad.
Tomorrow I have 25+ hours on a plane. This would also normally make me sad, but I’m going to turn apples into ponies. Or something.
Do you have any interesting / hard questions you want to ask Tableau Server that you’ve found difficult to answer? Can they be answered (you think) via Tableau’s workgroup database? Post them here over the next 24 hours only. I need questions. Hard ones.
Here’s a moderately complex one for the paranoid:
How do I generate a list of users who have used the View Data functionality and then actually downloaded rows to their machine?
…and that’s it. Got a fun “to do” list while on the plane. My hands are going to hurt 🙂
Here are two questions (perhaps rhetorical):
1. How do I run an audit of user permissions granted to a workbook and who granted these permissions
2. How do I run a metadata report that identifies what underlying database tables a report uses (we think we have a solution for this by parsing pg_largeobject), it will be on my blog one of these days.
ooo, I like both of these.
I am curious, how many employees work at Hadoop?
Spezia, I’m coming for you. I know where you live. And the answer is 579. https://en.wikipedia.org/wiki/Cloudera
I have this rash on my arm. Does it look infected?
No, Chadd.
That black, creeping mass on your arm that seems bigger ever morning is just fine. In fact it’s good luck. Give it a name and then carry on.
1. What Dashboards does user X have access to?
2. Some workaround so site admins can only access data to about their site since the ISMEMBER() function requires a literal string.
Explain more on #2? It seems to be more about changing runtime behavior than reporting. Maybe I’m missing something?
“you may also be interested in…”
For each user, for the top X number of dashboards they most frequently view, what are the other dashboards based on the same or similar content?
How do you find out which workbook uses more CPU to render Visualisation ?
There is no easy way to do this. Said information is not captured in the Workgroup database, and other approaches to monitoring (like TabMon) don’t track CPU utilization by workbook. I think Palette software (http://palette-software.com/) has a solution around this, but of course it’s not free.
Do we need to set something to be able to access workgroup? After installing 9.3 and using dbpass to set the external access. I am not able to connect to workgroup. It says “incorrect password” where I am 100% I am giving the correct one I had set using dbpass.
In earlier version we had a lot of config file which starts with datacollector.postgres.### none of them are in 9.3 config file. Which makes me thing may be I need to manually use tabadmin set to introduce them. Is it true?