General Profiler

Unknown macro: {scrollbar}

There are 4 files to file that information:

Audit
Cubes
O3CubeService
Sessions

Audit

Generation: A file is created every time you log in or out or when a connection is rejected.

You log in (or out of ) O3 Server when the user opens (or closes) a view or a cube. In O3 Browser, two views on the same cube generate two sessions in O3Server.

A connection is rejected when the license does not enable the client attempting connection to O3 Server, either because the license does not allow further connections, or just because the information it contains is incorrect.

Field name	Type	Description
Date	dd/mm/yyyy	Date of the event
Hour	hh:mm:ss	Time of the event
Event	String	It indicates which was the event that generated the record. Values can be: open, close or reject.
Cube	String	In case you get an "open" it indicates the cube was opened, and if you get a "close", that it was closed. It remains empty if it is a "reject"
User	String	User who opened or closed a cube. It remains empty if it is a "reject".
Role	String	It indicates the Role with which the user accesses the cube in case of an "open" or the role that had been accessing the cube in case of a "close". It remains empty if it is a "reject".
Ip	String	IP Address from which the user is accessing in case of an "open" or the one they had been doing it from in case of a "close".
Duration	Integer	Time of session. Seconds that elapsed between the "open" and the "close". It only gets a value in the case of a "close", otherwise it is 0
Queries	Integer	Number of queries made by the user during the session. It only has a value in a "close" and is 0 otherwise.

Cubes

Generation: records are created at regular intervals.

At the end of every interval, a record is generated for each of the cubes published in O3 Server and that have at least one open session.

Field name	Type	Description
Date	dd/mm/yyyy	Snapshot Day
Hour	hh:mm:ss	Snapshot Time
Cube	String	Name of the cube the record corresponds to
Cube_sessions	Integer	Number of open sessions in that cube at that time
Used_cube_cache	Integer	Size of the cache used by that cube at that time. This is measured in blocks
Cube_size	Integer	Cube Size at that time. This is measured in blocks

O3CubeService

Generación: a record is generated at regular times.

Field name	Type	Description
Date	dd/mm/yyyy	Snapshot Day
Hour	hh:mm:ss	Snapshot Time
o3_sessions	Integer	Number of open sessions in O3 Server at that tiem.
Used_o3_cache	Integer	Size of the cache used in O3 Server at that time for the cubes with open connections (blocks)

Sessions

Generation: records are created at regular intervals.

At the end of each time frame, a record is generated for every session open in O3 Server at that time. For every query made, the values of some attributes, such as queries, blocks_accessed, etc. are updated, thus creating the record to be recorded.

Field name	Type	Description
id_session	String	It identifies the session. It is created by linking the username and the internal identifier of the session.
Date	dd/mm/yyyy	Snapshot Day
Hour	hh:mm:ss	Snapshot Time
Cube	String	Name of the cube the session corresponds to
User	String	User the session belongs to
Role	String	Role the user is logged in to the cube in the session
Blocks_accesed	Integer	Total number of blocks accessed to answer all the queries made since the last sampling. (i.e. in the time frame)
Blocks_fault	Integer	Total number of blocks that were not found in the cache and that were necessary to answer the queries made since the last sampling. (i.e. in the time frame)
Query_time	Integer	Total time of queries made since the last sampling. (i.e. in the time frame)
Queries	Integer	Total number or queries made since the last sampling. (i.e. in the time frame)

Unknown macro: {scrollbar}