Through the profiler service, information generated by each cube published in O3Server is stored in files like the one described below. (One file is generated by each cube).
Generation: one record is created each time a query is performed on a cube.
Field Name |
Type |
Description |
Date |
dd/mm/yyyy |
Date of the query |
Hour |
hh:mm:ss |
Time of the query |
Precalc |
String |
It states if any redundancy level has been calculated. Its values can be: True or False. |
query_level |
|
Level the query was made at. |
View |
String |
If the user has accessed the cube through a view, it states the name of such view. |
User |
String |
User who made the query. |
Role |
String |
Role through which the user who has made the query accessed the cube. |
Ip |
String |
IP Address Dirección IP desde la cual está accediendo el usuario que realizó la consulta. |
query_time |
Integer |
Tiempo de la consulta en milisegundos. |
distance |
Integer |
Distancia entre el query_level y precalc realizada como diferencia de vectores. |
blocks_accesed |
Integer |
Cantidad total de bloques accedidos para resolver la consulta. |
blocks_fault |
Integer |
Cantidad total de bloques que no se encontraron en caché y fueron necesarios para resolver la consulta. |
used_cube_cache |
Integer |
Tamaño de la caché usada por el cubo en el instante de la consulta medida en bloques. |