Tip

This module is part of the OpenERP software, the leading Open Source enterprise management system. If you want to discover OpenERP, check our screencasts or download OpenERP directly.

Olap Schemes Management (olap)

Module:olap
Name:Olap Schemes Management
Version:5.0.0.1
Author:Tiny
Directory:olap
Web:http://www.openerp.com
Official module:
 no
Quality certified:
 no

Description

Base module to manage Olap schemas. Cube designer.

Dependencies

  • base

Reports

None

Views

  • bi.load.db.form (form)
  • Parameters Configuration (form)
  • bi.auto.configure.form (form)
  • olap.schema.tree (tree)
  • olap.schema.form (form)
  • olap.cube.table.form (form)
  • olap.cube.tree (tree)
  • olap.cube.form (form)
  • olap.dimension.tree (tree)
  • olap.dimension.form (form)
  • olap.hierarchy.tree (tree)
  • olap.hierarchy.form (form)
  • olap.level.tree (tree)
  • olap.level.form (form)
  • olap.measure.tree (tree)
  • olap.measure.form (form)
  • olap.saved.query.tree (tree)
  • olap.saved.query.mdx (mdx)
  • olap.saved.query.form (form)
  • olap.query.logs (tree)
  • olap.query.logs.form (form)
  • olap.query.logs (mdx)
  • olap.query.logs.form (form)
  • olap.fact.database.tree (tree)
  • olap.fact.database.form (form)
  • olap.database.tables.tree (tree)
  • olap.database.tables.form (form)
  • olap.database.columns.tree (tree)
  • olap.database.columns.tree.m20 (tree)
  • olap.database.columns.form (form)
  • olap.application.tree (tree)
  • olap.application.form (form)
  • olap.application.table.tree (tree)
  • olap.application.table.form (form)
  • olap.application.field.tree (tree)
  • olap.application.field.form (form)

Objects

Object: Olap Fact Database (olap.fact.database)

connection_type:
 Connection type, selection, required
connection_url:Connection URL, char, readonly
name:Fact name, char, required
db_password:Database password, char, required
Password for the login.
table_ids:Tables, one2many
db_port:Database port, integer, required
Port to be used in connection
db_name:Database name, char, required
Name of the database to be used for analysis.
db_login:Database login, char, required
Login for the database name specified.
loaded:Loaded, boolean, readonly
type:Database type, selection, required
db_host:Database host, char, required
Give hostname to make connection to the database.

Object: Olap Schema (olap.schema)

name:Schema name, char, required
app_detect:Connection URL, char, readonly
database_id:Database Connection, many2one, required
note:Schema description, text
ready:Ready, boolean, readonly
state:Schema State, selection, readonly
cube_ids:Cubes, one2many
loaded:Loading Datastructure, boolean, readonly
configure:Configuring Datastructure, boolean, readonly

Object: Olap Database Tables (olap.database.tables)

hide:Hidden, boolean
name:End-User Name, char, required
fact_database_id:
 Database Id, many2one, required, readonly
table_db_name:Table Name, char, required, readonly
active:Active, boolean
columns:Columns, one2many

Object: Olap Database Columns (olap.database.columns)

hide:Hidden, boolean
name:Column Name, char, required
related_to:Related To, many2one, readonly
table_id:Table Id, many2one, required, readonly
active:Active, boolean
type:Type, selection, required, readonly
column_db_name:Column DBName, char, required, readonly
primary_key:Primary Key, boolean

Object: Olap cube table (olap.cube.table)

available_table_ids:
 Available Tables, many2many, readonly
line_ids:Database Tables, one2many, required
schema_id:Schema id, many2one
name:Table name, char, required
column_link_id:Relational Column, many2one, required

Object: Olap cube table (olap.cube.table.line)

field_id:Link Field, many2one
cube_table_id:Cube Table, many2one, required
table_id:Database Table, many2one, required

Object: Olap cube (olap.cube)

measure_ids:Measures, one2many
name:Cube name, char, required
dimension_ids:Dimensions, one2many
query_ids:Queries, one2many
schema_id:Schema, many2one, readonly
table_id:Fact table, many2one, required
Table(s) for cube.
query_log:Query Logging, boolean
Enabling this will log all the queries in the browser

Object: Olap query logs (olap.query.logs)

query:Query, text, required
result_size:Result Size, integer, readonly
user_id:OpenERP User, many2one
cube_id:Cube, many2one, required
time:Time, datetime, required

Object: Olap dimension (olap.dimension)

name:Dimension name, char, required
cube_id:Cube, many2one, required
hierarchy_ids:Hierarchies, one2many

Object: Olap hierarchy (olap.hierarchy)

name:Hierarchy name, char, required
sequence:Sequence, integer, required
dimension_id:Dimension, many2one, required
primary_key_table:
 Primary key table, char
table_id:Fact table(s), many2one, required
Table(s) to make hierarchy on the cube.
level_ids:Levels, one2many
primary_key:Primary key, char

Object: Olap level (olap.level)

column_id_name:Column ID, char, required
name:Level name, char, required
sequence:Sequence, integer, required
table_name:Table name, char, required
The name of the table on which the column is defined. If False, take the table from the hierarchy.
hierarchy_id:Hierarchy, many2one, required
type:Level class, selection, required
column_name:Columns Name, many2one, required

Object: Olap measure (olap.measure)

value_sql:SQL Expression, char
You can provide valid sql expression. Make sure it have function with fully qualified column name like (sum,avg ...)(tablename.columnname (+,- ...) tablename.columnname)
name:Measure name, char, required
cube_id:Cube, many2one, required
datatype:Datatype, selection, required
formatstring:Format string, selection, required
Let you specify how the measure to be displayed in cube browser
value_column:Fact Table Column, many2one
agregator:Agregator, selection, required
table_name:Table name, char
The name of the table on which the column is defined. If False, take the table from the cube.
measure_type:Measure Type, selection, required
Select between auto column or sql expression for the measures
value_column_id_name:
 Column ID, char

Object: Olap application (olap.application)

query:Application Query, text
field_ids:Fields, one2many
name:Application name, char, required
table_ids:Tables, one2many

Object: Olap application table (olap.application.table)

application_id:Application Id, many2one, required
is_hidden:Hidden, boolean
table_name:Table name, char, required
name:Application table name, char, required

Object: Olap application field (olap.application.field)

field_name:Field name, char
is_hidden:Hidden, boolean
table_name:Application table name, char
name:Application field name, char, required
application_id:Application Id, many2one, required

Object: olap.saved.query (olap.saved.query)

user_id:User, many2one
name:Query Name, text
cube_id:Cube, many2one, required
schema_id:Schema, many2one, required
time:Time, datetime, required
query:Query, text, required

Object: bi.load.db.wizard (bi.load.db.wizard)

db_name:Database Name, char, readonly
fact_table:Fact Name, char, readonly

Object: bi.auto.configure.wizard (bi.auto.configure.wizard)

name:Fact Name, char, readonly

Object: Olap Server Parameters (olap.parameters.config.wizard)

host_port:Port, char, required
Put the port for the server. Put 8080 if its not clear.
host_name:Server Name, char, required
Put here the server address or IP Put localhost if its not clear.