Enables spreadsheet update logging, appending to existing logs after archiving.
SSAUDIT 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) SSAUDIT and/or SSAUDITR statements per application.
SSAUDIT 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.
SSAudit xxxxx xxxxx c:\sslog
enables logging for all applications and databases, storing the log in the path c:\sslog
. This example assumes that you do not have duplicate database names (see Notes).
SSAUDITR, which clears the log after archive.
alter database begin|end archive
(MaxL)
BEGINARCHIVE (ESSCMD)
ENDARCHIVE (ESSCMD)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |