| Wiki Markup |
|---|
{scrollbar}
|
...
In
...
order
...
to
...
carry
...
out
...
analysis
...
of
...
O3
...
Server
...
statistics
...
through
...
the
...
use
...
of
...
O3
...
Browser,
...
two
...
models
...
that
...
let
...
you
...
build
...
an
...
analysis
...
cube
...
for
...
the
...
server
...
in
...
general
...
and
...
an
...
analysis
...
cube
...
for
...
each
...
of
...
the
...
cubes
...
published
...
in
...
it
...
are
...
provided.
...
These
...
models
...
are
...
found
...
in
...
the
...
"server"
...
directory
...
below
...
the
...
O3
...
setup
...
directory.
...
The
...
models
...
are:
...
Model |
|---|
...
Name | Description |
|---|---|
ServerPerformance.mdl |
...
It |
...
lets |
...
you |
...
build |
...
the |
...
O3 Server |
...
general |
...
analysis |
...
cube |
...
through |
...
the |
...
use |
...
of |
...
the |
...
4 |
...
log |
...
files |
...
:
|
...
|
...
|
...
|
...
CubeQueriesPerformance.mdl |
...
For |
...
a |
...
given |
...
cube, |
...
it |
...
lets |
...
you |
...
build |
...
its |
...
analysis |
...
cube. |
...
|
...
order |
...
to |
...
do |
...
so, |
...
it |
...
uses |
...
the |
...
Queries.log |
...
file |
...
corresponding |
...
to |
...
the |
...
cube |
...
you |
...
wish |
...
to |
...
analyze. |
...
When
...
you
...
use
...
the
...
ServerPerformance.mdl
...
model,
...
it
...
is
...
necessary
...
to
...
generate
...
the
...
four
...
files
...
mentioned
...
above.
...
Once
...
the
...
log
...
files
...
have
...
been
...
generated,
...
and
...
through
...
the
...
use
...
of
...
the
...
aforementioned
...
models,
...
you
...
may
...
go
...
on
...
to
...
build
...
(or
...
rebuild)
...
the
...
analysis
...
cubes.
...
The
...
building
...
or
...
rebuilding
...
of
...
cubes
...
is
...
performed
...
through
...
the
...
use
...
of
...
O3
...
Builder
...
(as
...
expected)
...
with
...
a
...
special
...
parameter
...
"-profiling"
...
and
...
using
...
a
...
.srv
...
file
...
with
...
data
...
about
...
the
...
server
...
for
...
which
...
statistics
...
are
...
to
...
be
...
calculated.
...
The
...
buildings
...
are
...
always
...
complete,
...
that
...
is
...
to
...
say
...
no
...
incremental
...
loads
...
are
...
performed
...
on
...
these
...
cubes.
...
As
...
a
...
consequence,
...
in
...
order
...
to
...
build
...
the
...
statistics
...
analysis
...
cubes
...
the
...
following
...
command
...
should
...
be
...
used:
...
Builder
...
-profiling
...
<file>.srv
...
Where
...
the
...
<file>.srv
...
file
...
must
...
contain
...
the
...
following
...
data:
...
| Code Block |
|---|
serverHost = <host>
serverName = O3Server
[cubeName = <statCube>]
[profCubeName = <cube>]
model = <path>/CubeQueriesPerformance.mdl | model=<path>/ServerPerformance.mdl
user = <username>
password = <password>
{code}
|
Please
...
see
...
the
...
section:
...
"Generating
...
the
...
configuration
...
file
...
for
...
O3
...
Builder
...
"
Property | Description |
|---|---|
ServerHost | Name or IP address of the machine currently running the O3 Server from which statistics will be taken. |
ServerName | Name of the O3 Server. (This value must always be 'O3Server'). |
CubeName | It is optional and must only be used in case the cube with statistic information (<statCube>) to be built or rebuilt, is published in O3 Server. |
ProfCubeName | This parameter must only be included when you attempt to build a cube with statistics coming from other cube published in O3 Server. |
Model | The model to use for the building of the statistics cube. If you wish to build an O3 Server general statistics cube, the ServerPerformance.mdl model must be assigned as value, and if you wish to create a statistics cube for any given cube published in O3 Server, the CubeQueriesPerformace.mdl model must be assigned as value, and the cube to analyze must be specified through the use of the profCubeName parameter mentioned before. |
User | It is the user through which connection to O3 Server is made. |
Password | Password of the user through which connection to O3 Server is made. |
The following example of .srv file is used to create the O3 Server general statistics cube in the maching called MyHost and published as O3ServerStats in the same server.
| Code Block |
|---|
serverHost = MyHost
serverName = O3Server
cubeName = O3ServerStats
model = <path>/ServerPerformance.mdl
user = admin
password = admin
{code}
|
By
...
using
...
this
...
second
...
example
...
of
...
.srv
...
file
...
a
...
statistics
...
cube
...
of
...
the
...
cube
...
published
...
in
...
O3
...
Server
...
under
...
the
...
name
...
"Demo"
...
is
...
built.
...
Besides,
...
this
...
statistics
...
cube
...
is
...
published
...
in
...
O3
...
Server
...
under
...
the
...
name
...
DemoStats.
...
| Code Block |
|---|
serverHost = MyHost
serverName = O3Server
cubeName = DemoStats
profCubeName = Demo
model = <path>/CubeQueriesPerformance.mdl
user = admin
password = admin
{code}
|
The
...
administrator
...
shall
...
provide
...
a
...
file
...
of
...
this
...
type
...
for
...
each
...
of
...
the
...
files
...
in
...
their
...
O3
...
Server
...
for
...
which
...
they
...
wish
...
to
...
create
...
the
...
corresponding
...
statistics
...
analysis
...
cube,
...
by
...
modifying
...
the
...
cubeName
...
and
...
profCubeName
...
respective
...
values.
...
If
...
the
...
statistics
...
cube
...
you
...
are
...
building
...
is
...
not
...
published
...
in
...
O3
...
Server,
...
the
...
cubeName
...
parameter
...
will
...
not
...
be
...
included
...
in
...
the
...
.srv
...
file.
...
In
...
this
...
case,
...
the
...
Builder
...
standard
...
parameter
...
(-cube=<path>/<cubeName>) can
...
be
...
used
...
to
...
specify
...
the
...
path
...
where
...
to
...
save
...
the
...
built
...
cube
...
and
...
the
...
name
...
to
...
give
...
to
...
it.
...
If
...
this
...
parameter
...
is
...
not
...
specified,
...
O3
...
Builder
...
will
...
use
...
its
...
default
...
settings,
...
and
...
create
...
the
...
cube
...
in
...
the
...
same
...
directory
...
where
...
the
...
.mdl
...
file
...
used
...
is
...
located,
...
giving
...
it
...
the
...
same
...
name,
...
and
...
.cube
...
extension,
...
of
...
course.
...
As
...
for
...
any
...
cube
...
building
...
process
...
from
...
ascii
...
files,
...
it
...
is
...
necessary
...
to
...
specify
...
the
...
location
...
of
...
the
...
files
...
used
...
as
...
data
...
source, (
...
in
...
this
...
case,
...
the
...
log
...
files
...
generated
...
by
...
the
...
O3
...
Server
...
Profiles
...
service)
...
By
...
default,
...
when
...
O3
...
Builder
...
receives
...
the
...
-profiling
...
option
...
and
...
logs
...
in
...
to
...
the
...
O3
...
Server
...
specified
...
in
...
the
...
.srv
...
file
...
received
...
as
...
parameter
...
to
...
build
...
a
...
given
...
statistics
...
cube,
...
it
...
automatically
...
extracts
...
the
...
location
...
of
...
the
...
log
...
files
...
it
...
needs
...
for
...
the
...
building
...
from
...
the
...
O3
...
Server
...
setup.
...
If
...
by
...
any
...
reason
...
it
...
is
...
necessary
...
to
...
build
...
statistic
...
cubes
...
from
...
log
...
files
...
in
...
a
...
different
...
location
...
to
...
the
...
specified
...
in
...
the
...
O3
...
Server
...
setup,
...
the -cgf=<file>.cfg
...
option
...
of
...
O3
...
Builder
...
should
...
be
...
used.
The
...
command
...
to
...
use
...
in
...
these
...
cases
...
will
...
be:
| Code Block |
|---|
builder \-profiling \-cfg=<file>.cfg <file>.srv |
As
...
a
...
rule
...
the
...
-cfg
...
option
...
lets
...
you
...
specify
...
new
...
values
...
for
...
the
...
parameters
...
of
...
the
...
model
...
you
...
are
...
using
...
to
...
build
...
the
...
cube.
...
In
...
this
...
case
...
the
...
models
...
have
...
a
...
set
...
of
...
parameters
...
that
...
specify
...
the
...
path
...
to
...
the
...
log
...
files
...
needed
...
for
...
the
...
building
...
and
...
it
...
is
...
therefore
...
possible
...
to
...
modify
...
them
...
this
...
way.
...
The
...
<file>.cfg
...
fiile
...
must,
...
as
...
a
...
consequence
...
have
...
the
...
following
...
format:
...
| Code Block |
|---|
O3_CUBE_SERVICE_PATH = <path>/O3CubeService.log
AUDIT_PATH = <path>/Audit.log
CUBES_PATH = <path>/Cubes.log
SESSIONS_PATH = <path>/Sessions.log
QUERIES_PATH = <path>/<cubename>Stats.log
{code}
|
The
...
values
...
of
...
parameters
...
must
...
include
...
the
...
path
...
and
...
logfile
...
name.
...
The
...
first
...
4
...
parameters
...
are
...
necessary
...
when
...
the
...
server
...
general
...
statistics
...
cube
...
is
...
built,
...
whereas
...
the
...
last
...
one
...
is
...
necessary
...
if
...
you
...
are
...
building
...
a
...
statistics
...
cube
...
for
...
a
...
specific
...
cube.
...
...
| Child pages (Children Display) |
|---|
| Wiki Markup |
|---|
{scrollbar} |