An Administrator can Regen Report Data and query a dataset using the TS Database Analyzer functionality.

 

ReGeN Report Data

Regen Report Data is available for the Provision, Estimated Payment, and Interim datasets. To run the Regen Report Data option, select Reporting > Administration > Regen Report Data. This recalculates all system calculations to refresh report data. Although, rarely necessary, this option ensures you that all reports have the most current data.

 

TS Database Analyzer

TS Database Analyzer is available for the Provision, Estimated Payment, and Interim datasets. To run the TS Database Analyzer option, select Reporting > Administration > TS Database Analyzer.

•To use the functionality, you must agree to the following statement: ONESOURCE Tax Provision does not support or warrant the accuracy or validity of any numbers produced by this tool. You must agree that you will not rely on the results of queries run within to support any tax provision calculations.

•The functionality is designed for users who have a working knowledge of database and database queries (SQL).

•The query analyzer lets you run ad hoc queries against the database. It does not allow you to change the database data. Query scripts cannot contain DELETE, UPDATE, CREATE, INSERT, ALTER or TRUNCATE statements.

•Export Query results to Excel by selecting Export.

•Report-Ready views contain pre-calculated, report-ready results. Views contain both local and reporting currency numbers. You must use Query filters.

•The TS Database Analyzer option does not appear in the reporting menu unless you activate the system parameter, SHOW_DATABASEANALYZER, with a paramvalue of 1.