Trouble Shooting DSA AD

Report has Old Data, Is Blank, Is Wrong

If you have questions about a Tableau report run by DSA AD start by

Obtaining the URL for the report from the .csv / Report & Distribution Command files / “batch” in the DSA AD folder.
Use the URL to run that report in Tableau Web Server. Examining the output.
If there is a problem with the report, make the fix on Tableau and verify that it works on Tableau before re-running the DSA AD batch.

Steps 1 and 2 above replicates what DSA AD does before it emails out the .PDF file.

To find the right .csv / Report & Distribution Command file you may need to look in the WTS or SQL Server Agent scheduler for the scheduled job and trace it back to the .csv file.

General Steps to Investigate a Problem

Issue: Reports run by DSA AD or DSA Cloud AD with a filter in the URL-Filters column stopped working correctly.

If the report was working recently then the problem is likely to lay in 1) the data in Tableau, 2) a change on the Tableau report run by DSA AD, or 3) a change in the DSA (Cloud) AD Report & Distribution Commands.

Steps to Investigate

Find the Report & Distribution Commands for the DSA (Cloud) AD batch in question.
Check the log files to see exactly what commands the DSA (Cloud) AD actually ran.
- For DSA AD users running DSA AD “on premises” the Report & Distribution Commands will be in a .csv file.
- For DSA Cloud AD the Report & Distribution Commands will be passed to DSA Cloud AD with ETL+.
Find the reference to the Tableau report in question on the Report & Distribution Commands
Open the report in Tableau in a web browser.
Manually set the filters in Tableau to match the filters on the Report & Distribution Command file.
Run the Tableau report

AD Output from DSA AD or Excel AD?

DSA AD produces PDF and .csv files from Tableau. Excel AD produces only Excel files.