Page Comparison

{scrollbar}

----
There are 4 files to file that information:
* Audit
* Cubes
* O3CubeService
* Sessions

h2. 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. |

h2. 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_name || _Type_\\ || _Description_ ||
| Date | dd/mm/yyyy | SamplingSnapshot Day\\ |
| Hour | hh:mm:ss | SamplingSnapshot 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.(blocks) \\
 This is measured in blocks |
| Cube_size | Integer | Cube Size at that time. (blocks)\\\\
 This is measured in blocks |

h2. O3CubeService

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

|| _Field Name_ \\ name || Type || _Description_ ||
| Date | dd/mm/yyyy | SamplingSnapshot Day. |
| Hour | hh:mm:ss | SamplingSnapshot time\\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) |

h2. 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_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 | SamplingSnapshot Day. |
| Hour | hh:mm:ss | SamplingSnapshot 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)\\ |

----
{children}
{scrollbar}