We would need to see your workbook to troubleshoot, a packaged work, and details on your setup.
My first thought is that either the formula/filter logic is not what you expect, or it could be a localization setting if it works as expected on desktop, but does not work when published to Server.
I've created a trimmed down version of the report with just one example of a problem sheet. This one just displays the Report date (which should be yesterday) - see attached. Currently this is working fine - it normally takes a few days to stop working (I did say it was weird).
Not sure what you mean by a "packaged work"?
Set-up - see items in initial post - what else do you need:
- Backend DB is Netezza
I've checked out the localisation settings on the server and all looks normal.
Again, thanks for your post.
ReportDate.twb.zip 3.4 KB
sorry about my typo, I meant a packaged workbook a .twbx file. What you attached is just a workbook, the XML that defines that you want Tableau to do, there is no data in that file, so I cannot really open it.
You will need to either extract some data, or make up some sample data that represents your situation and reproduces your issue. If your issue cannot be reproduced with an extract or sample data, then I will not be able to help, and you will want to contact Tableau support for assistance http://www.tableausoftware.com/support/request
OK, Thanks Joe. Haven't been ignoring this, it just had its priority squashed by other stuff.
Have attached the .twbx file, and possibly a clue... When extracting the data for the twbx, got the following message:
I think this is down to the DB server being on UTC and the Tableau server on Local Daylight saving (1 hour difference between the two). Doesn't explain of course why it would return a different "Yesterday" at different points during the same day.
A quick update on the results I've been getting with the attached report:
Ran this hourly today (6/9/2012), and it's reported Yesterday as being 2/9/2012 6 times, and 27/8/2012 5 times.
ReportDateTest.twbx.zip 11.2 KB
yeah that seems very strange, it returns the correct yesterday for me today.
Maybe it is because you have an old version of Tableau, see https://licensing.tableausoftware.com/esdalt/ for installing the latest version.
I still say the best resource for you is Tableau Support, they could trace the logic in their code, or at least help you pinpoint the cause.
The solution to this problem was to include the "?:refresh=yes" parameter to the workbook/view name.
Specifically, with the assistance of Tableau support, we changed:
tabcmd export ReportDate/ReportDate --pdf -f c:\reports\ReportDate.pdf
tabcmd export ReportDate/ReportDate?:refresh=yes --pdf -f c:\reports\ReportDate.pdf
As expertly explained by Matt in tableau support:
"... the error was that the export command was using data from cache. This explains the odd behavior before where each hour a different result would appear. This was because the command was hitting a different cache each time. When a cache expired or did not exist, this would allow the query to be executed and 'yesterday' would finally evaluate correctly.
The resolution is to use a parameter at the end of the workbook/dashboard designation of ?:refresh=yes This invalidates the cache so that the export will not take any cached data and 'yesterday' should always evaluate correctly."