You can query the transaction log (tm1s.log) to view the records of all the logs
currently in the TM1® server data directory. When you query the
transaction log, TM1 combines all the log files into one
logical file that satisfies the query parameters. For example, if you query for all the records
starting on Jan. 2, 2002 at 2:30 PM GMT, TM1 returns all the
records in all the transaction logs with a time stamp of 20020102143000 or later.
Procedure
- Select the server in Server Explorer.
- Click View Transaction
Log.
The Transaction Log Query dialog box opens.
- Click the right arrow in a parameter field to set the parameters
for the query.
There are four parameters you can set:
| Parameter
|
Description
|
| Starting Time
|
Queries all the records written to the transaction
log on or after the starting time.
Start date and time for
the query. The date and time format is MM/DD/YYYY HH:MM:SS GMT. The
default start date and time is 00:01:00 GMT on the date you launch
the query.
|
| End Time
|
End date and time for the query. The date and
time format is MM/DD/YYYY HH:MM:SS
The default is __/__/____ __:__:__, which is an open end date and time. If you accept the
default, TM1 queries all the records up to the time you
launch the query.
|
| Clients
|
The client(s) against which you apply the query.
You
can query against either a single client or all the clients. The default
is all clients (*).
|
| Cubes
|
The cube(s) against which you apply the query.
You
can query against either a single cube or all the cubes. The default
is all cubes (*)
|
- Click OK.
The query
returns a table with all the transaction records that satisfy the
parameters you set. The table displays in the Transaction Log Query
Results dialog box.
By default, records are sorted in ascending
order by LOGTIME.
- To sort on a different column, click the column heading.
To change the order of a column sort, click the column heading a second
time.
- Click
to search the records in the query results table.