Enables spreadsheet update logging, clearing the logs at the end of the archiving process.
SSAUDITR appname [ dbname [ log_path] ]
appname | Application name. |
dbname | Database name. Optional. |
log_path | Full directory path where you want the information stored. Optional. Do not provide a log_path value unless you have also provided a value for dbname. |
Default behavior:
ARBORPATH\app\appname dbname.
Use the value xxxxx
to indicate "all" for any argument.
You can issue up to ten (total) SSAUDITR and/or SSAUDIT statements per application.
SSAUDITR enables Analytic Services to log successfully completed spreadsheet update transactions. The resulting logs can be used as a source of input data upon recovery after archive operations or other server interruptions.
SSAuditR demo
Enables logging with refresh (clear) for all databases belonging to the Demo application. The log is stored in the default directory.
SSAUDIT, which does not clear the logs after archive.
alter database begin|end archive
(MaxL)
BEGINARCHIVE (ESSCMD)
ENDARCHIVE (ESSCMD)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |