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 |