Reporting on Administration Activity

The administration activity audit records information on tasks performed in the system, for example, who is creating, changing, deleting models, dimensions, and security.

This report applies to the environment or model level.

Features

You can set the following report options:

Option	Description
Date and Time	You can choose start and end dates for the report or display the full history of the selected activities ( Anytime).
Task Selection	The following options are available: Task Name You can enter the following tasks: COPY ENVIRONMENT DELETE ENVIRONMENT CREATE MODEL COPY MODEL MODIFY MODEL DELETE MODEL CREATE DIMENSION COPY DIMENSION MODIFY DIMENSION DELETE DIMENSION PROCESS DIMENSION Note The functional tasks are case-sensitive. When you enter the functional tasks, the system tries to anticipate your entry as you type in partial text. Task Area Environment - Report on activity at the environment level Model - Report on activity at the model level Task Group All - Report on activity for both user types (Admin and User) Admin - Reports the activity selected in the Task Type field (described below). Admin activity shows both the previous and new values. User - Reports work status changes Process - Reports business process flow activity Business Rule - Reports business rule activity Task Type All - All activity types Add - Only add activity Change - Only activity that involves changes within the system Delete - Only delete activity Current, which includes audit records of activity that has not yet been archived Archived, which includes audit records of activity that has already been archived Current and archived, which is the combination of both options
Task Parameters	These fields are optional and are used for additional information. You typically use them in reporting, but not for filtering. Modified Object Parameter Value Field Value Pre-Task Value Post-Task Value User Modified Object and Parameter Value are at the audit header record. Field Value, Post-Task Value, and Pre-Task Value are at the detail record.

Option

Description

Date and Time

You can choose start and end dates for the report or display the full history of the selected activities ( Anytime).

Task Selection

The following options are available:

Task Name

You can enter the following tasks:
- COPY ENVIRONMENT
- DELETE ENVIRONMENT
- CREATE MODEL
- COPY MODEL
- MODIFY MODEL
- DELETE MODEL
- CREATE DIMENSION
- COPY DIMENSION
- MODIFY DIMENSION
- DELETE DIMENSION
- PROCESS DIMENSION
Note
The functional tasks are case-sensitive. When you enter the functional tasks, the system tries to anticipate your entry as you type in partial text.
Task Area
- Environment - Report on activity at the environment level
- Model - Report on activity at the model level
Task Group
- All - Report on activity for both user types (Admin and User)
- Admin - Reports the activity selected in the Task Type field (described below). Admin activity shows both the previous and new values.
- User - Reports work status changes
- Process - Reports business process flow activity
- Business Rule - Reports business rule activity
Task Type
- All - All activity types
- Add - Only add activity
- Change - Only activity that involves changes within the system
- Delete - Only delete activity
Current, which includes audit records of activity that has not yet been archived
Archived, which includes audit records of activity that has already been archived
Current and archived, which is the combination of both options

Task Parameters

These fields are optional and are used for additional information. You typically use them in reporting, but not for filtering.

Modified Object
Parameter Value
Field Value
Pre-Task Value
Post-Task Value
User

Modified Object and Parameter Value are at the audit header record. Field Value, Post-Task Value, and Pre-Task Value are at the detail record.

Report Contents

The report header shows the date and time of the report, and the number of records returned. It also shows the options that you selected for Task Selection and Task Parameters, as described above.

In the report, the columns correspond to report criteria above, with additional items:

Task Name - Name of the task
Date and Time - Date and time of the task
Model - The name of the model in which the task occurred
User - Name of the user who performed the task
Modified Object - The name of the modified object.
Machine ID - The IP address of the machine on which the task was performed
Machine Name - The name of the machine on which the task was performed
Parameter Value - Additional information
Task Group - Task group for which the task was performed
Task Type - Type of task performed
Field Value - Details of the task performed, for Create Member if a dimension member was created.
Pre-Task Value - Value in the field before the task was performed. For new dimension members, this is blank. For deleted dimension members, this shows the ID of the deleted member. For modified dimension members, this shows the value of the modified property or hierarchy before the change, or blank if there was no value before processing.
Post-Task Value - Value in the field after the task was performed. For new dimension members, this shows the ID of the created member. For deleted dimension members, this is blank. For modified dimension members, this shows the value of the modified property or hierarchy before the change, or blank if the value was removed.

Comments in Reports

Comments are shown in the Comments column when you display a report. The cells in the column show the number of comments, and hovering your mouse over the entry in the cell shows a tooltip with metadata about the most recent comment; cells with no comments are simply blank. Click the link to see the comments ordered by date/time. Comments are not shown in the print form of reports because the comment length is unlimited and printing has a fixed character limit. When exporting reports, the most recent comment is exported.

Report Filters

You can filter a report by entering a filter value in a column heading. You can combine filters by entering filter values for multiple columns.

Sorting a Column in a Report

You can sort the columns in a report in ascending or descending order by clicking a column heading.

Activities

To view an administration activity report, go to System Reports, and from the list of reports, choose Administration Activity. Set the appropriate reporting options and display the report.

In the report, the columns correspond to the parameters in the above table.