2
.. i18n: .. module:: olap
3
.. i18n: :synopsis: olap
12
.. i18n: .. raw:: html
15
.. i18n: <link rel="stylesheet" href="../_static/hide_objects_in_sidebar.css" type="text/css" />
20
<link rel="stylesheet" href="../_static/hide_objects_in_sidebar.css" type="text/css" />
22
.. i18n: .. tip:: This module is part of the Open ERP software, the leading Open Source
23
.. i18n: enterprise management system. If you want to discover Open ERP, check our
24
.. i18n: `screencasts <http://openerp.tv>`_ or download
25
.. i18n: `Open ERP <http://openerp.com>`_ directly.
27
.. tip:: This module is part of the Open ERP software, the leading Open Source
28
enterprise management system. If you want to discover Open ERP, check our
29
`screencasts <http://openerp.tv>`_ or download
30
`Open ERP <http://openerp.com>`_ directly.
32
.. i18n: .. raw:: html
34
.. i18n: <div class="js-kit-rating" title="" permalink="" standalone="yes" path="/olap"></div>
35
.. i18n: <script src="http://js-kit.com/ratings.js"></script>
39
<div class="js-kit-rating" title="" permalink="" standalone="yes" path="/olap"></div>
40
<script src="http://js-kit.com/ratings.js"></script>
42
.. i18n: olap (*olap*)
43
.. i18n: =============
44
.. i18n: :Module: olap
46
.. i18n: :Version: 5.0.0.1
47
.. i18n: :Author: Tiny
48
.. i18n: :Directory: olap
49
.. i18n: :Web: http://www.openerp.com
50
.. i18n: :Official module: no
51
.. i18n: :Quality certified: no
60
:Web: http://www.openerp.com
62
:Quality certified: no
72
.. i18n: Base module to manage Olap schemas. Cube designer.
76
Base module to manage Olap schemas. Cube designer.
78
.. i18n: Download links
79
.. i18n: --------------
84
.. i18n: You can download this module as a zip file in the following version:
86
You can download this module as a zip file in the following version:
88
.. i18n: * `trunk <http://www.openerp.com/download/modules/trunk/olap.zip>`_
90
* `trunk <http://www.openerp.com/download/modules/trunk/olap.zip>`_
98
.. i18n: * :mod:`base`
118
.. i18n: * Businesss Intelligence
119
.. i18n: * Businesss Intelligence/Configuration
120
.. i18n: * Businesss Intelligence/Configuration/Fact Databases
121
.. i18n: * Businesss Intelligence/Configuration/Known Application
122
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes
123
.. i18n: * Businesss Intelligence/Configuration/Tools
124
.. i18n: * Businesss Intelligence/Cube Browser
125
.. i18n: * Businesss Intelligence/Cube Designer
126
.. i18n: * Businesss Intelligence/Configuration/Tools/Clear Logs
127
.. i18n: * Businesss Intelligence/Server Parameters
128
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Schema
129
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Cubes Table
130
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Cubes
131
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Dimension
132
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Hierarchy
133
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Level
134
.. i18n: * Businesss Intelligence/Configuration/Olap Cubes/Olap Measures
135
.. i18n: * Businesss Intelligence/Configuration/Tools/Olap Saved Query
136
.. i18n: * Businesss Intelligence/Configuration/Tools/All Logs
137
.. i18n: * Businesss Intelligence/Configuration/Tools/All Logs/My Logs
138
.. i18n: * Businesss Intelligence/Configuration/Fact Databases/Databases
139
.. i18n: * Businesss Intelligence/Configuration/Fact Databases/Tables
140
.. i18n: * Businesss Intelligence/Configuration/Fact Databases/Columns
141
.. i18n: * Businesss Intelligence/Configuration/Known Application/Application
142
.. i18n: * Businesss Intelligence/Configuration/Known Application/Application Table
143
.. i18n: * Businesss Intelligence/Configuration/Known Application/Application Field
145
* Businesss Intelligence
146
* Businesss Intelligence/Configuration
147
* Businesss Intelligence/Configuration/Fact Databases
148
* Businesss Intelligence/Configuration/Known Application
149
* Businesss Intelligence/Configuration/Olap Cubes
150
* Businesss Intelligence/Configuration/Tools
151
* Businesss Intelligence/Cube Browser
152
* Businesss Intelligence/Cube Designer
153
* Businesss Intelligence/Configuration/Tools/Clear Logs
154
* Businesss Intelligence/Server Parameters
155
* Businesss Intelligence/Configuration/Olap Cubes/Olap Schema
156
* Businesss Intelligence/Configuration/Olap Cubes/Olap Cubes Table
157
* Businesss Intelligence/Configuration/Olap Cubes/Olap Cubes
158
* Businesss Intelligence/Configuration/Olap Cubes/Olap Dimension
159
* Businesss Intelligence/Configuration/Olap Cubes/Olap Hierarchy
160
* Businesss Intelligence/Configuration/Olap Cubes/Olap Level
161
* Businesss Intelligence/Configuration/Olap Cubes/Olap Measures
162
* Businesss Intelligence/Configuration/Tools/Olap Saved Query
163
* Businesss Intelligence/Configuration/Tools/All Logs
164
* Businesss Intelligence/Configuration/Tools/All Logs/My Logs
165
* Businesss Intelligence/Configuration/Fact Databases/Databases
166
* Businesss Intelligence/Configuration/Fact Databases/Tables
167
* Businesss Intelligence/Configuration/Fact Databases/Columns
168
* Businesss Intelligence/Configuration/Known Application/Application
169
* Businesss Intelligence/Configuration/Known Application/Application Table
170
* Businesss Intelligence/Configuration/Known Application/Application Field
178
.. i18n: * bi.load.db.form (form)
179
.. i18n: * Parameters Configuration (form)
180
.. i18n: * bi.auto.configure.form (form)
181
.. i18n: * olap.schema.tree (tree)
182
.. i18n: * olap.schema.form (form)
183
.. i18n: * olap.cube.table.form (form)
184
.. i18n: * olap.cube.tree (tree)
185
.. i18n: * olap.cube.form (form)
186
.. i18n: * olap.dimension.tree (tree)
187
.. i18n: * olap.dimension.form (form)
188
.. i18n: * olap.hierarchy.tree (tree)
189
.. i18n: * olap.hierarchy.form (form)
190
.. i18n: * olap.level.tree (tree)
191
.. i18n: * olap.level.form (form)
192
.. i18n: * olap.measure.tree (tree)
193
.. i18n: * olap.measure.form (form)
194
.. i18n: * olap.saved.query.tree (tree)
195
.. i18n: * olap.saved.query.mdx (mdx)
196
.. i18n: * olap.saved.query.form (form)
197
.. i18n: * olap.query.logs (tree)
198
.. i18n: * olap.query.logs.form (form)
199
.. i18n: * olap.query.logs (mdx)
200
.. i18n: * olap.query.logs.form (form)
201
.. i18n: * olap.fact.database.tree (tree)
202
.. i18n: * olap.fact.database.form (form)
203
.. i18n: * olap.database.tables.tree (tree)
204
.. i18n: * olap.database.tables.form (form)
205
.. i18n: * olap.database.columns.tree (tree)
206
.. i18n: * olap.database.columns.tree.m20 (tree)
207
.. i18n: * olap.database.columns.form (form)
208
.. i18n: * olap.application.tree (tree)
209
.. i18n: * olap.application.form (form)
210
.. i18n: * olap.application.table.tree (tree)
211
.. i18n: * olap.application.table.form (form)
212
.. i18n: * olap.application.field.tree (tree)
213
.. i18n: * olap.application.field.form (form)
215
* bi.load.db.form (form)
216
* Parameters Configuration (form)
217
* bi.auto.configure.form (form)
218
* olap.schema.tree (tree)
219
* olap.schema.form (form)
220
* olap.cube.table.form (form)
221
* olap.cube.tree (tree)
222
* olap.cube.form (form)
223
* olap.dimension.tree (tree)
224
* olap.dimension.form (form)
225
* olap.hierarchy.tree (tree)
226
* olap.hierarchy.form (form)
227
* olap.level.tree (tree)
228
* olap.level.form (form)
229
* olap.measure.tree (tree)
230
* olap.measure.form (form)
231
* olap.saved.query.tree (tree)
232
* olap.saved.query.mdx (mdx)
233
* olap.saved.query.form (form)
234
* olap.query.logs (tree)
235
* olap.query.logs.form (form)
236
* olap.query.logs (mdx)
237
* olap.query.logs.form (form)
238
* olap.fact.database.tree (tree)
239
* olap.fact.database.form (form)
240
* olap.database.tables.tree (tree)
241
* olap.database.tables.form (form)
242
* olap.database.columns.tree (tree)
243
* olap.database.columns.tree.m20 (tree)
244
* olap.database.columns.form (form)
245
* olap.application.tree (tree)
246
* olap.application.form (form)
247
* olap.application.table.tree (tree)
248
* olap.application.table.form (form)
249
* olap.application.field.tree (tree)
250
* olap.application.field.form (form)
258
.. i18n: Object: Olap Fact Database (olap.fact.database)
259
.. i18n: ###############################################
261
Object: Olap Fact Database (olap.fact.database)
262
###############################################
264
.. i18n: :connection_type: Connection type, selection, required
266
:connection_type: Connection type, selection, required
268
.. i18n: :connection_url: Connection URL, char, readonly
270
:connection_url: Connection URL, char, readonly
272
.. i18n: :name: Fact name, char, required
274
:name: Fact name, char, required
276
.. i18n: :db_password: Database password, char, required
278
:db_password: Database password, char, required
280
.. i18n: :table_ids: Tables, one2many
282
:table_ids: Tables, one2many
284
.. i18n: :db_port: Database port, integer, required
286
:db_port: Database port, integer, required
288
.. i18n: :db_name: Database name, char, required
290
:db_name: Database name, char, required
292
.. i18n: :db_login: Database login, char, required
294
:db_login: Database login, char, required
296
.. i18n: :loaded: Loaded, boolean, readonly
298
:loaded: Loaded, boolean, readonly
300
.. i18n: :db_host: Database host, char, required
302
:db_host: Database host, char, required
304
.. i18n: :type: Database type, selection, required
306
:type: Database type, selection, required
308
.. i18n: Object: Olap Schema (olap.schema)
309
.. i18n: #################################
311
Object: Olap Schema (olap.schema)
312
#################################
314
.. i18n: :name: Schema name, char, required
316
:name: Schema name, char, required
318
.. i18n: :app_detect: Connection URL, char, readonly
320
:app_detect: Connection URL, char, readonly
322
.. i18n: :state: Schema State, selection, readonly
324
:state: Schema State, selection, readonly
326
.. i18n: :note: Schema description, text
328
:note: Schema description, text
330
.. i18n: :ready: Ready, boolean, readonly
332
:ready: Ready, boolean, readonly
334
.. i18n: :database_id: Database Connection, many2one, required
336
:database_id: Database Connection, many2one, required
338
.. i18n: :cube_ids: Cubes, one2many
340
:cube_ids: Cubes, one2many
342
.. i18n: :loaded: Loading Datastructure, boolean, readonly
344
:loaded: Loading Datastructure, boolean, readonly
346
.. i18n: :configure: Configuring Datastructure, boolean, readonly
348
:configure: Configuring Datastructure, boolean, readonly
350
.. i18n: Object: Olap Database Tables (olap.database.tables)
351
.. i18n: ###################################################
353
Object: Olap Database Tables (olap.database.tables)
354
###################################################
356
.. i18n: :hide: Hidden, boolean
358
:hide: Hidden, boolean
360
.. i18n: :name: End-User Name, char, required
362
:name: End-User Name, char, required
364
.. i18n: :fact_database_id: Database Id, many2one, required, readonly
366
:fact_database_id: Database Id, many2one, required, readonly
368
.. i18n: :table_db_name: Table Name, char, required, readonly
370
:table_db_name: Table Name, char, required, readonly
372
.. i18n: :active: Active, boolean
374
:active: Active, boolean
376
.. i18n: :columns: Columns, one2many
378
:columns: Columns, one2many
380
.. i18n: Object: Olap Database Columns (olap.database.columns)
381
.. i18n: #####################################################
383
Object: Olap Database Columns (olap.database.columns)
384
#####################################################
386
.. i18n: :hide: Hidden, boolean
388
:hide: Hidden, boolean
390
.. i18n: :primary_key: Primary Key, boolean
392
:primary_key: Primary Key, boolean
394
.. i18n: :related_to: Related To, many2one, readonly
396
:related_to: Related To, many2one, readonly
398
.. i18n: :table_id: Table Id, many2one, required, readonly
400
:table_id: Table Id, many2one, required, readonly
402
.. i18n: :active: Active, boolean
404
:active: Active, boolean
406
.. i18n: :type: Type, selection, required, readonly
408
:type: Type, selection, required, readonly
410
.. i18n: :column_db_name: Column DBName, char, required, readonly
412
:column_db_name: Column DBName, char, required, readonly
414
.. i18n: :name: Column Name, char, required
416
:name: Column Name, char, required
418
.. i18n: Object: Olap cube table (olap.cube.table)
419
.. i18n: #########################################
421
Object: Olap cube table (olap.cube.table)
422
#########################################
424
.. i18n: :available_table_ids: Available Tables, many2many, readonly
426
:available_table_ids: Available Tables, many2many, readonly
428
.. i18n: :line_ids: Database Tables, one2many, required
430
:line_ids: Database Tables, one2many, required
432
.. i18n: :schema_id: Schema id, many2one
434
:schema_id: Schema id, many2one
436
.. i18n: :name: Table name, char, required
438
:name: Table name, char, required
440
.. i18n: :column_link_id: Relational Column, many2one, required
442
:column_link_id: Relational Column, many2one, required
444
.. i18n: Object: Olap cube table (olap.cube.table.line)
445
.. i18n: ##############################################
447
Object: Olap cube table (olap.cube.table.line)
448
##############################################
450
.. i18n: :field_id: Link Field, many2one
452
:field_id: Link Field, many2one
454
.. i18n: :cube_table_id: Cube Table, many2one, required
456
:cube_table_id: Cube Table, many2one, required
458
.. i18n: :table_id: Database Table, many2one, required
460
:table_id: Database Table, many2one, required
462
.. i18n: Object: Olap cube (olap.cube)
463
.. i18n: #############################
465
Object: Olap cube (olap.cube)
466
#############################
468
.. i18n: :measure_ids: Measures, one2many
470
:measure_ids: Measures, one2many
472
.. i18n: :name: Cube name, char, required
474
:name: Cube name, char, required
476
.. i18n: :dimension_ids: Dimensions, one2many
478
:dimension_ids: Dimensions, one2many
480
.. i18n: :query_ids: Queries, one2many
482
:query_ids: Queries, one2many
484
.. i18n: :schema_id: Schema, many2one, readonly
486
:schema_id: Schema, many2one, readonly
488
.. i18n: :table_id: Fact table, many2one, required
490
:table_id: Fact table, many2one, required
492
.. i18n: :query_log: Query Logging, boolean
494
:query_log: Query Logging, boolean
496
.. i18n: Object: Olap query logs (olap.query.logs)
497
.. i18n: #########################################
499
Object: Olap query logs (olap.query.logs)
500
#########################################
502
.. i18n: :query: Query, text, required
504
:query: Query, text, required
506
.. i18n: :result_size: Result Size, integer, readonly
508
:result_size: Result Size, integer, readonly
510
.. i18n: :user_id: Tiny ERP User, many2one
512
:user_id: Tiny ERP User, many2one
514
.. i18n: :cube_id: Cube, many2one, required
516
:cube_id: Cube, many2one, required
518
.. i18n: :time: Time, datetime, required
520
:time: Time, datetime, required
522
.. i18n: Object: Olap dimension (olap.dimension)
523
.. i18n: #######################################
525
Object: Olap dimension (olap.dimension)
526
#######################################
528
.. i18n: :name: Dimension name, char, required
530
:name: Dimension name, char, required
532
.. i18n: :cube_id: Cube, many2one, required
534
:cube_id: Cube, many2one, required
536
.. i18n: :hierarchy_ids: Hierarchies, one2many
538
:hierarchy_ids: Hierarchies, one2many
540
.. i18n: Object: Olap hierarchy (olap.hierarchy)
541
.. i18n: #######################################
543
Object: Olap hierarchy (olap.hierarchy)
544
#######################################
546
.. i18n: :name: Hierarchy name, char, required
548
:name: Hierarchy name, char, required
550
.. i18n: :sequence: Sequence, integer, required
552
:sequence: Sequence, integer, required
554
.. i18n: :dimension_id: Dimension, many2one, required
556
:dimension_id: Dimension, many2one, required
558
.. i18n: :primary_key_table: Primary key table, char
560
:primary_key_table: Primary key table, char
562
.. i18n: :table_id: Fact table(s), many2one, required
564
:table_id: Fact table(s), many2one, required
566
.. i18n: :level_ids: Levels, one2many
568
:level_ids: Levels, one2many
570
.. i18n: :primary_key: Primary key, char
572
:primary_key: Primary key, char
574
.. i18n: Object: Olap level (olap.level)
575
.. i18n: ###############################
577
Object: Olap level (olap.level)
578
###############################
580
.. i18n: :column_id_name: Column ID, char, required
582
:column_id_name: Column ID, char, required
584
.. i18n: :name: Level name, char, required
586
:name: Level name, char, required
588
.. i18n: :sequence: Sequence, integer, required
590
:sequence: Sequence, integer, required
592
.. i18n: :table_name: Table name, char, required
594
:table_name: Table name, char, required
596
.. i18n: *The name of the table on which the column is defined. If False, take the table from the hierarchy.*
598
*The name of the table on which the column is defined. If False, take the table from the hierarchy.*
600
.. i18n: :hierarchy_id: Hierarchy, many2one, required
602
:hierarchy_id: Hierarchy, many2one, required
604
.. i18n: :type: Level class, selection, required
606
:type: Level class, selection, required
608
.. i18n: :column_name: Columns Name, many2one, required
610
:column_name: Columns Name, many2one, required
612
.. i18n: Object: Olap measure (olap.measure)
613
.. i18n: ###################################
615
Object: Olap measure (olap.measure)
616
###################################
618
.. i18n: :value_sql: SQL Expression, char
620
:value_sql: SQL Expression, char
622
.. i18n: *You can provide valid sql expression. Make sure it have function with fully qualified column name like (sum,avg ...)(tablename.columnname (+,- ...) tablename.columnname)*
624
*You can provide valid sql expression. Make sure it have function with fully qualified column name like (sum,avg ...)(tablename.columnname (+,- ...) tablename.columnname)*
626
.. i18n: :name: Measure name, char, required
628
:name: Measure name, char, required
630
.. i18n: :cube_id: Cube, many2one, required
632
:cube_id: Cube, many2one, required
634
.. i18n: :datatype: Datatype, selection, required
636
:datatype: Datatype, selection, required
638
.. i18n: :formatstring: Format string, selection, required
640
:formatstring: Format string, selection, required
642
.. i18n: :table_name: Table name, char
644
:table_name: Table name, char
646
.. i18n: *The name of the table on which the column is defined. If False, take the table from the cube.*
648
*The name of the table on which the column is defined. If False, take the table from the cube.*
650
.. i18n: :agregator: Agregator, selection, required
652
:agregator: Agregator, selection, required
654
.. i18n: :value_column: Fact Table Column, many2one
656
:value_column: Fact Table Column, many2one
658
.. i18n: :measure_type: Measure Type, selection, required
660
:measure_type: Measure Type, selection, required
662
.. i18n: *Select between auto column or sql expression for the measures*
664
*Select between auto column or sql expression for the measures*
666
.. i18n: :value_column_id_name: Column ID, char
668
:value_column_id_name: Column ID, char
670
.. i18n: Object: Olap application (olap.application)
671
.. i18n: ###########################################
673
Object: Olap application (olap.application)
674
###########################################
676
.. i18n: :query: Application Query, text
678
:query: Application Query, text
680
.. i18n: :field_ids: Fields, one2many
682
:field_ids: Fields, one2many
684
.. i18n: :name: Application name, char, required
686
:name: Application name, char, required
688
.. i18n: :table_ids: Tables, one2many
690
:table_ids: Tables, one2many
692
.. i18n: Object: Olap application table (olap.application.table)
693
.. i18n: #######################################################
695
Object: Olap application table (olap.application.table)
696
#######################################################
698
.. i18n: :application_id: Application Id, many2one, required
700
:application_id: Application Id, many2one, required
702
.. i18n: :is_hidden: Hidden, boolean
704
:is_hidden: Hidden, boolean
706
.. i18n: :table_name: Table name, char, required
708
:table_name: Table name, char, required
710
.. i18n: :name: Application table name, char, required
712
:name: Application table name, char, required
714
.. i18n: Object: Olap application field (olap.application.field)
715
.. i18n: #######################################################
717
Object: Olap application field (olap.application.field)
718
#######################################################
720
.. i18n: :field_name: Field name, char
722
:field_name: Field name, char
724
.. i18n: :table_name: Application table name, char
726
:table_name: Application table name, char
728
.. i18n: :is_hidden: Hidden, boolean
730
:is_hidden: Hidden, boolean
732
.. i18n: :application_id: Application Id, many2one, required
734
:application_id: Application Id, many2one, required
736
.. i18n: :name: Application field name, char, required
738
:name: Application field name, char, required
740
.. i18n: Object: olap.saved.query (olap.saved.query)
741
.. i18n: ###########################################
743
Object: olap.saved.query (olap.saved.query)
744
###########################################
746
.. i18n: :user_id: User, many2one
748
:user_id: User, many2one
750
.. i18n: :name: Query Name, text
752
:name: Query Name, text
754
.. i18n: :cube_id: Cube, many2one, required
756
:cube_id: Cube, many2one, required
758
.. i18n: :schema_id: Schema, many2one, required
760
:schema_id: Schema, many2one, required
762
.. i18n: :time: Time, datetime, required
764
:time: Time, datetime, required
766
.. i18n: :query: Query, text, required
768
:query: Query, text, required
770
.. i18n: Object: bi.load.db.wizard (bi.load.db.wizard)
771
.. i18n: #############################################
773
Object: bi.load.db.wizard (bi.load.db.wizard)
774
#############################################
776
.. i18n: :db_name: Database Name, char, readonly
778
:db_name: Database Name, char, readonly
780
.. i18n: :fact_table: Fact Name, char, readonly
782
:fact_table: Fact Name, char, readonly
784
.. i18n: Object: bi.auto.configure.wizard (bi.auto.configure.wizard)
785
.. i18n: ###########################################################
787
Object: bi.auto.configure.wizard (bi.auto.configure.wizard)
788
###########################################################
790
.. i18n: :name: Fact Name, char, readonly
792
:name: Fact Name, char, readonly
794
.. i18n: Object: Olap Server Parameters (olap.parameters.config.wizard)
795
.. i18n: ##############################################################
797
Object: Olap Server Parameters (olap.parameters.config.wizard)
798
##############################################################
800
.. i18n: :host_port: Port, char, required
802
:host_port: Port, char, required
804
.. i18n: *Put the port for the server. Put 8080 if its not clear.*
806
*Put the port for the server. Put 8080 if its not clear.*
808
.. i18n: :host_name: Server Name, char, required
810
:host_name: Server Name, char, required
812
.. i18n: *Put here the server address or IP Put localhost if its not clear.*
814
*Put here the server address or IP Put localhost if its not clear.*