addons/olap_sale/olap_sale.xml

   1 <?xml version="1.0"?>
   2 <openerp>
   3 <data noupdate="True">
   4
   5 <!--
   6 CUSTOM CUBE FOR SALES
   7 -->
   8
   9     <record model="olap.fact.database" id="fact_databases_BI">
  10         <field name="name">OpenERP Sales Databases</field>
  11         <field name="db_name">sales</field>
  12         <field name="db_login">postgres</field>
  13         <field name="db_password">postgres</field>
  14     </record>
  15 <!--
  16 Schema
  17 -->
  18     <record model="olap.schema" id="schema_main_sales">
  19         <field name="name">OpenERPSales</field>
  20         <field name="state">none</field>
  21         <field name="database_id" ref="fact_databases_BI"/>
  22     </record>
  23
  24 <!--
  25 Adding the database tables and database columns to be used and making up the of the
  26 cube table and cube table line
  27 -->
  28
  29     <record model="olap.database.tables" id="table_sale_order_line">
  30         <field name="name">sale_order_line</field>
  31         <field name="table_db_name">sale_order_line</field>
  32         <field name="fact_database_id" ref="fact_databases_BI"/>
  33         <field name="active">True</field>
  34     </record>
  35
  36     <record model="olap.database.tables" id="table_sale_order">
  37         <field name="name">sale_order</field>
  38         <field name="table_db_name">sale_order</field>
  39         <field name="fact_database_id" ref="fact_databases_BI"/>
  40         <field name="active">True</field>
  41     </record>
  42
  43     <record model="olap.database.tables" id="table_product_product">
  44         <field name="name">product_product</field>
  45         <field name="table_db_name">product_product</field>
  46         <field name="fact_database_id" ref="fact_databases_BI"/>
  47         <field name="active">True</field>
  48     </record>
  49
  50     <record model="olap.database.tables" id="table_product_template">
  51         <field name="name">product_template</field>
  52         <field name="table_db_name">product_template</field>
  53         <field name="fact_database_id" ref="fact_databases_BI"/>
  54         <field name="active">True</field>
  55     </record>
  56
  57     <record model="olap.database.tables" id="table_product_category">
  58         <field name="name">product_category</field>
  59         <field name="table_db_name">product_category</field>
  60         <field name="fact_database_id" ref="fact_databases_BI"/>
  61         <field name="active">True</field>
  62     </record>
  63     <record model="olap.database.tables" id="table_res_partner_address">
  64         <field name="name">res_partner_address</field>
  65         <field name="table_db_name">res_partner_address</field>
  66         <field name="fact_database_id" ref="fact_databases_BI"/>
  67         <field name="active">True</field>
  68     </record>
  69
  70     <record model="olap.database.tables" id="table_res_country">
  71         <field name="name">res_country</field>
  72         <field name="table_db_name">res_country</field>
  73         <field name="fact_database_id" ref="fact_databases_BI"/>
  74         <field name="active">True</field>
  75     </record>
  76
  77     <record model="olap.database.tables" id="table_res_user">
  78         <field name="name">res_users</field>
  79         <field name="table_db_name">res_users</field>
  80         <field name="fact_database_id" ref="fact_databases_BI"/>
  81         <field name="active">True</field>
  82     </record>
  83
  84     <record model="olap.database.tables" id="table_res_partner">
  85         <field name="name">res_partner</field>
  86         <field name="table_db_name">res_partner</field>
  87         <field name="fact_database_id" ref="fact_databases_BI"/>
  88         <field name="active">True</field>
  89
  90     </record>
  91     <record model="olap.database.columns" id="columns_product_id_sale_order_line">
  92         <field name="name">product_id</field>
  93         <field name="column_db_name">product_id</field>
  94         <field name="type">int4</field>
  95         <field name="table_id" ref="table_sale_order_line"/>
  96         <field name="related_to" ref="table_product_product"/>
  97         <field name="active">True</field>
  98     </record>
  99
 100     <record model="olap.database.columns" id="columns_product_product_id">
 101         <field name="name">id</field>
 102         <field name="column_db_name">id</field>
 103         <field name="type">int4</field>
 104         <field name="table_id" ref="table_product_product"/>
 105         <field name="primary_key">True</field>
 106         <field name="active">True</field>
 107 </record>
 108 <!--    <record model="olap.database.columns" id="columns_sale_order_line_product_id">
 109                 <field name="name">product_id</field>
 110                 <field name="column_db_name">id</field>
 111                 <field name="type">int4</field>
 112                 <field name="table_id" ref="table_sale_order_line"/>
 113                 <field name="active">True</field>
 114                 <field name="related_to" ref="table_product_product"/>
 115         </record>
 116 -->
 117     <record model="olap.database.columns" id="columns_product_template_id">
 118         <field name="name">id</field>
 119         <field name="column_db_name">id</field>
 120         <field name="type">varchar</field>
 121         <field name="table_id" ref="table_product_template"/>
 122         <field name="active">True</field>
 123         <field name="primary_key">True</field>
 124     </record>
 125
 126     <record model="olap.database.columns" id="columns_sale_order_line_id">
 127         <field name="name">id</field>
 128         <field name="column_db_name">id</field>
 129         <field name="type">int4</field>
 130         <field name="table_id" ref="table_sale_order_line"/>
 131         <field name="active">True</field>
 132         <field name="primary_key">True</field>
 133     </record>
 134
 135     <record model="olap.database.columns" id="columns_sale_order_id">
 136         <field name="name">id</field>
 137         <field name="column_db_name">id</field>
 138         <field name="type">int4</field>
 139         <field name="table_id" ref="table_sale_order"/>
 140         <field name="active">True</field>
 141         <field name="primary_key">True</field>
 142     </record>
 143
 144     <record model="olap.database.columns" id="columns_sale_order_amount_total">
 145         <field name="name">amount_total</field>
 146         <field name="column_db_name">amount_total</field>
 147         <field name="type">float8</field>
 148         <field name="table_id" ref="table_sale_order"/>
 149         <field name="active">True</field>
 150     </record>
 151
 152     <record model="olap.database.columns" id="columns_res_user_name">
 153         <field name="name">name</field>
 154         <field name="column_db_name">name</field>
 155         <field name="type">varchar</field>
 156         <field name="table_id" ref="table_res_user"/>
 157         <field name="active">True</field>
 158     </record>
 159
 160     <record model="olap.database.columns" id="columns_product_category_name">
 161         <field name="name">name</field>
 162         <field name="column_db_name">name</field>
 163         <field name="type">varchar</field>
 164         <field name="table_id" ref="table_product_category"/>
 165         <field name="active">True</field>
 166     </record>
 167
 168     <record model="olap.database.columns" id="columns_product_template_category_id">
 169         <field name="name">categ_id</field>
 170         <field name="column_db_name">categ_id</field>
 171         <field name="type">int4</field>
 172         <field name="table_id" ref="table_product_template"/>
 173         <field name="related_to" ref="table_product_category"/>
 174         <field name="active">True</field>
 175     </record>
 176
 177     <record model="olap.database.columns" id="columns_product_template_name">
 178         <field name="name">name</field>
 179         <field name="column_db_name">name</field>
 180         <field name="type">varchar</field>
 181         <field name="table_id" ref="table_product_template"/>
 182         <field name="active">True</field>
 183     </record>
 184
 185     <record model="olap.database.columns" id="columns_res_partner_address_city">
 186         <field name="name">city</field>
 187         <field name="column_db_name">city</field>
 188         <field name="type">varchar</field>
 189         <field name="table_id" ref="table_res_partner_address"/>
 190         <field name="active">True</field>
 191     </record>
 192     <record model="olap.database.columns" id="columns_res_country_name">
 193         <field name="name">name</field>
 194         <field name="column_db_name">name</field>
 195         <field name="type">varchar</field>
 196         <field name="table_id" ref="table_res_country"/>
 197         <field name="active">True</field>
 198     </record>
 199
 200     <record model="olap.database.columns" id="columns_product_product_product_tmpl_id">
 201         <field name="name">product_tmpl_id</field>
 202         <field name="column_db_name">product_tmpl_id</field>
 203         <field name="type">varchar</field>
 204         <field name="table_id" ref="table_product_product"/>
 205         <field name="related_to" ref="table_product_template"/>
 206         <field name="active">True</field>
 207     </record>
 208
 209     <record model="olap.database.columns" id="columns_product_category_id">
 210         <field name="name">id</field>
 211         <field name="column_db_name">id</field>
 212         <field name="type">int4</field>
 213         <field name="table_id" ref="table_product_category"/>
 214         <field name="primary_key">True</field>
 215         <field name="active">True</field>
 216     </record>
 217
 218     <record model="olap.database.columns" id="columns_product_template_id">
 219         <field name="name">id</field>
 220         <field name="column_db_name">id</field>
 221         <field name="type">int4</field>
 222         <field name="table_id" ref="table_product_template"/>
 223         <field name="primary_key">True</field>
 224         <field name="active">True</field>
 225     </record>
 226
 227     <record model="olap.database.columns" id="columns_product_product_default_code">
 228         <field name="name">default_code</field>
 229         <field name="column_db_name">default_code</field>
 230         <field name="type">varchar</field>
 231         <field name="table_id" ref="table_product_product"/>
 232         <field name="active">True</field>
 233     </record>
 234
 235     <record model="olap.database.columns" id="columns_sale_order_date_order">
 236         <field name="name">date_order</field>
 237         <field name="column_db_name">date_order</field>
 238         <field name="type">date</field>
 239         <field name="table_id" ref="table_sale_order"/>
 240         <field name="active">True</field>
 241     </record>
 242
 243     <record model="olap.database.columns" id="columns_sale_order_line_product_uom_qty">
 244         <field name="name">product_uom_qty</field>
 245         <field name="column_db_name">product_uom_qty</field>
 246         <field name="type">int4</field>
 247         <field name="table_id" ref="table_sale_order_line"/>
 248         <field name="active">True</field>
 249     </record>
 250
 251     <record model="olap.database.columns" id="columns_sale_order_line_price_unit">
 252         <field name="name">price_unit</field>
 253         <field name="column_db_name">price_unit</field>
 254         <field name="type">int4</field>
 255         <field name="table_id" ref="table_sale_order_line"/>
 256         <field name="active">True</field>
 257     </record>
 258
 259     <record model="olap.database.columns" id="columns_sale_order_line_id">
 260         <field name="name">id</field>
 261         <field name="column_db_name">id</field>
 262         <field name="type">int4</field>
 263         <field name="table_id" ref="table_sale_order_line"/>
 264         <field name="primary_key">True</field>
 265         <field name="active">True</field>
 266     </record>
 267
 268 <!--    <record model="olap.database.columns" id="columns_sale_order_line_product_id">
 269 <field name="name">product_id</field>
 270 <field name="column_db_name">product_id</field>
 271 <field name="type">int4</field>
 272 <field name="table_id" ref="table_sale_order_line"/>
 273 <field name="related_to" ref="table_product_product"/>
 274 <field name="active">True</field>
 275
 276 </record>
 277 -->
 278     <record model="olap.database.columns" id="columns_sale_order_line_order_id">
 279         <field name="name">order_id</field>
 280         <field name="column_db_name">order_id</field>
 281         <field name="type">int4</field>
 282         <field name="table_id" ref="table_sale_order_line"/>
 283         <field name="related_to" ref="table_sale_order"/>
 284         <field name="active">True</field>
 285     </record>
 286
 287     <record model="olap.database.columns" id="columns_sale_order_partner_id">
 288         <field name="name">partner_id</field>
 289         <field name="column_db_name">partner_id</field>
 290         <field name="type">int4</field>
 291         <field name="table_id" ref="table_sale_order"/>
 292         <field name="related_to" ref="table_res_partner"/>
 293         <field name="active">True</field>
 294     </record>
 295
 296     <record model="olap.database.columns" id="columns_res_partner_address_id">
 297         <field name="name">id</field>
 298         <field name="column_db_name">id</field>
 299         <field name="type">int4</field>
 300         <field name="table_id" ref="table_res_partner_address"/>
 301         <field name="primary_key">True</field>
 302         <field name="active">True</field>
 303     </record>
 304
 305     <record model="olap.database.columns" id="columns_res_partner_id">
 306         <field name="name">id</field>
 307         <field name="column_db_name">id</field>
 308         <field name="type">int4</field>
 309         <field name="table_id" ref="table_res_partner"/>
 310         <field name="primary_key">True</field>
 311         <field name="active">True</field>
 312     </record>
 313
 314     <record model="olap.database.columns" id="columns_res_partner_name">
 315         <field name="name">name</field>
 316         <field name="column_db_name">name</field>
 317         <field name="type">varchar</field>
 318         <field name="table_id" ref="table_res_partner"/>
 319         <field name="active">True</field>
 320     </record>
 321
 322     <record model="olap.database.columns" id="columns_res_user_id">
 323         <field name="name">id</field>
 324         <field name="column_db_name">id</field>
 325         <field name="type">int4</field>
 326         <field name="table_id" ref="table_res_user"/>
 327         <field name="primary_key">True</field>
 328         <field name="active">True</field>
 329     </record>
 330
 331     <record model="olap.database.columns" id="columns_res_country_id">
 332         <field name="name">id</field>
 333         <field name="column_db_name">id</field>
 334         <field name="type">int4</field>
 335         <field name="table_id" ref="table_res_country"/>
 336         <field name="primary_key">True</field>
 337         <field name="active">True</field>
 338     </record>
 339
 340     <record model="olap.database.columns" id="columns_sale_order_partner_order_id">
 341         <field name="name">partner_order_id</field>
 342         <field name="column_db_name">partner_order_id</field>
 343         <field name="type">int4</field>
 344         <field name="table_id" ref="table_sale_order"/>
 345         <field name="related_to" ref="table_res_partner_address"/>
 346         <field name="active">True</field>
 347     </record>
 348
 349     <record model="olap.database.columns" id="columns_res_user_name">
 350         <field name="name">name</field>
 351         <field name="column_db_name">name</field>
 352         <field name="type">varchar</field>
 353         <field name="table_id" ref="table_res_user"/>
 354         <field name="active">True</field>
 355     </record>
 356
 357     <record model="olap.database.columns" id="columns_res_country_name">
 358         <field name="name">name</field>
 359         <field name="column_db_name">name</field>
 360         <field name="type">varchar</field>
 361         <field name="table_id" ref="table_res_country"/>
 362         <field name="active">True</field>
 363     </record>
 364
 365     <record model="olap.database.columns" id="columns_res_partner_address_country_id">
 366         <field name="name">country_id</field>
 367         <field name="column_db_name">country_id</field>
 368         <field name="type">int4</field>
 369         <field name="table_id" ref="table_res_partner_address"/>
 370         <field name="related_to" ref="table_res_country"/>
 371         <field name="active">True</field>
 372     </record>
 373
 374     <record model="olap.database.columns" id="columns_res_partner_address_city">
 375         <field name="name">city</field>
 376         <field name="column_db_name">city</field>
 377         <field name="type">varchar</field>
 378         <field name="table_id" ref="table_res_partner_address"/>
 379         <field name="active">True</field>
 380     </record>
 381
 382     <record model="olap.database.columns" id="columns_sale_order_line_order_id">
 383         <field name="name">order_id</field>
 384         <field name="column_db_name">order_id</field>
 385         <field name="type">int4</field>
 386         <field name="table_id" ref="table_sale_order_line"/>
 387         <field name="related_to" ref="table_sale_order"/>
 388         <field name="active">True</field>
 389     </record>
 390
 391 <!--    <record model="olap.database.columns" id="columns_sale_order_line_product_id">
 392 <field name="name">product_id</field>
 393 <field name="column_db_name">product_id</field>
 394 <field name="type">int4</field>
 395 <field name="table_id" ref="table_sale_order_line"/>
 396 <field name="related_to" ref="table_product_product"/>
 397 <field name="active">True</field>
 398
 399 </record>
 400 -->
 401     <record model="olap.database.columns" id="columns_sale_order_line_product_uom_qty">
 402         <field name="name">product_uom_qty</field>
 403         <field name="column_db_name">product_uom_qty</field>
 404         <field name="type">numeric</field>
 405         <field name="table_id" ref="table_sale_order_line"/>
 406         <field name="active">True</field>
 407     </record>
 408
 409     <record model="olap.database.columns" id="columns_sale_order_line_price_unit">
 410         <field name="name">price_unit</field>
 411         <field name="column_db_name">price_unit</field>
 412         <field name="type">numeric</field>
 413         <field name="table_id" ref="table_sale_order_line"/>
 414         <field name="active">True</field>
 415     </record>
 416
 417     <record model="olap.database.columns" id="columns_sale_order_line_create_uid">
 418         <field name="name">create_uid</field>
 419         <field name="column_db_name">create_uid</field>
 420         <field name="type">int4</field>
 421         <field name="table_id" ref="table_sale_order_line"/>
 422         <field name="related_to" ref="table_res_user"/>
 423         <field name="active">True</field>
 424     </record>
 425
 426
 427 <!--
 428 Making of the olap.cube.table and olap.cube.table.lines
 429
 430 -->
 431     <record model="olap.cube.table" id="cube_table_sale_order_line">
 432         <field name="name">Sales</field>
 433         <field name='schema_id' ref='schema_main_sales'/>
 434         <field name='column_link_id' ref='columns_sale_order_line_id'/>
 435     </record>
 436
 437     <record model="olap.cube.table" id="cube_table_product_category">
 438         <field name="name">Product Category</field>
 439         <field name='schema_id' ref='schema_main_sales'/>
 440         <field name='column_link_id' ref="columns_product_id_sale_order_line"/>
 441     </record>
 442
 443     <record model="olap.cube.table.line" id="line_prodcut_category_line_21">
 444         <field name="field_id" ref="columns_product_product_product_tmpl_id"/>
 445         <field name="table_id" ref="table_product_product"/>
 446         <field name="cube_table_id" ref="cube_table_product_category"/>
 447     </record>
 448
 449     <record model="olap.cube.table.line" id="line_prodcut_category_line_31">
 450         <field name="field_id" ref="columns_product_template_category_id"/>
 451         <field name="table_id" ref="table_product_template"/>
 452         <field name="cube_table_id" ref="cube_table_product_category"/>
 453     </record>
 454
 455     <record model="olap.cube.table.line" id="line_sale_order_line">
 456         <field name="field_id" ref="columns_sale_order_line_order_id"/>
 457         <field name="table_id" ref="table_sale_order_line"/>
 458         <field name="cube_table_id" ref="cube_table_sale_order_line"/>
 459     </record>
 460
 461     <record model="olap.cube.table" id="product_table">
 462         <field name="name">Sale Product</field>
 463         <field name='schema_id' ref='schema_main_sales'/>
 464         <field name='column_link_id' ref='columns_product_id_sale_order_line'/>
 465     </record>
 466
 467     <record model="olap.cube.table" id="country_table">
 468         <field name="name">Sale Country</field>
 469         <field name='schema_id' ref='schema_main_sales'/>
 470         <field name='column_link_id' ref='columns_sale_order_line_order_id'/>
 471     </record>
 472
 473     <record model="olap.cube.table" id="address_table">
 474         <field name='schema_id' ref='schema_main_sales'/>
 475         <field name="name">sale_order_line</field>
 476         <field name='column_link_id' ref='columns_sale_order_line_order_id'/>
 477     </record>
 478
 479     <record model="olap.cube.table" id="date_table">
 480         <field name="name">sale_order_line</field>
 481         <field name='schema_id' ref='schema_main_sales'/>
 482         <field name='column_link_id' ref='columns_sale_order_line_order_id'/>
 483     </record>
 484
 485     <record model="olap.cube.table" id="user_table">
 486         <field name="name">sale_order_line</field>
 487         <field name='schema_id' ref='schema_main_sales'/>
 488         <field name='column_link_id' ref='columns_sale_order_line_create_uid'/>
 489     </record>
 490
 491     <record model="olap.cube.table.line" id="country_table_line_id_2">
 492         <field name="field_id" ref="columns_sale_order_partner_order_id"/>
 493         <field name="table_id" ref="table_sale_order"/>
 494         <field name="cube_table_id" ref="country_table"/>
 495     </record>
 496
 497     <record model="olap.cube.table.line" id="country_table_line_id_3">
 498         <field name="field_id" ref="columns_res_partner_address_country_id"/>
 499         <field name="table_id" ref="table_res_partner_address"/>
 500         <field name="cube_table_id" ref="country_table"/>
 501     </record>
 502
 503     <record model="olap.cube.table.line" id="country_table_line_id_31">
 504         <field name="field_id" ref="columns_sale_order_partner_order_id"/>
 505         <field name="table_id" ref="table_sale_order"/>
 506         <field name="cube_table_id" ref="address_table"/>
 507     </record>
 508
 509     <record model="olap.cube.table.line" id="country_table_line_id_41">
 510         <field name="field_id" ref="columns_sale_order_partner_id"/>
 511         <field name="table_id" ref="table_res_partner_address"/>
 512         <field name="cube_table_id" ref="address_table"/>
 513     </record>
 514
 515 <!--
 516 Fact Table
 517 sale_order_line
 518 -->
 519
 520     <record model="olap.cube" id="cube_sales_order_line">
 521         <field name="name">Sales</field>
 522         <field name="table_id" ref="cube_table_sale_order_line"/>
 523         <field name="schema_id" ref="schema_main_sales"/>
 524     </record>
 525
 526 <!--
 527 DIMENSION PRODUCT CATEGORY
 528
 529 product_template (product_id)
 530 -->
 531
 532     <record model="olap.dimension" id="dimension_product_template">
 533         <field name="name"> All Products</field>
 534         <field name="cube_id" ref="cube_sales_order_line"/>
 535     </record>
 536
 537     <record model="olap.hierarchy" id="hierarchy_product_template">
 538         <field name="name">All Products</field>
 539         <field name="dimension_id" ref="dimension_product_template"/>
 540         <field name="primary_key_table">product_product</field>
 541         <field name="table_id" ref="product_table"/>
 542     </record>
 543
 544     <record model="olap.level" id="level_product_template">
 545         <field name="name">Product Code</field>
 546         <field name="column_name" ref="columns_product_product_default_code"></field>
 547         <field name="column_id_name">default_code</field>
 548         <field name="table_name">product_product</field>
 549         <field name="hierarchy_id" ref="hierarchy_product_template"/>
 550     </record>
 551 <!--
 552 Adding of the product by the category
 553 -->
 554     <record model="olap.dimension" id="dimension_product_category">
 555         <field name="name">Products by Category</field>
 556         <field name="cube_id" ref="cube_sales_order_line"/>
 557     </record>
 558
 559     <record model="olap.hierarchy" id="hierarchy_product_category">
 560         <field name="name">Products Category</field>
 561         <field name="dimension_id" ref="dimension_product_category"/>
 562         <field name="primary_key_table">product_product</field>
 563         <field name="table_id" ref="cube_table_product_category"/>
 564     </record>
 565
 566     <record model="olap.level" id="level_product_category_1">
 567         <field name="name">Product Category</field>
 568         <field name="column_name" ref="columns_product_category_name"></field>
 569         <field name="column_id_name">name</field>
 570         <field name="table_name">product_category</field>
 571         <field name="hierarchy_id" ref="hierarchy_product_category"/>
 572     </record>
 573
 574     <record model="olap.level" id="level_product_category_2">
 575         <field name="name">Product</field>
 576         <field name="column_name" ref="columns_product_template_name"></field>
 577         <field name="column_id_name">name</field>
 578         <field name="table_name">product_template</field>
 579         <field name="hierarchy_id" ref="hierarchy_product_category"/>
 580     </record>
 581 <!--
 582 DIMENSION ORDER DATE
 583 sale_order (order_id)
 584 -->
 585     <record model="olap.dimension" id="dimension_sales_order">
 586         <field name="name">Order Date</field>
 587         <field name="cube_id" ref="cube_sales_order_line"/>
 588     </record>
 589
 590     <record model="olap.hierarchy" id="hierarchy_sales_order">
 591         <field name="name">Order Date</field>
 592         <field name="dimension_id" ref="dimension_sales_order"/>
 593         <field name="primary_key_table">sale_order</field>
 594         <field name="table_id" ref="date_table"/>
 595     </record>
 596
 597     <record model="olap.level" id="level_sales_order">
 598         <field name="name">date_order</field>
 599         <field name="column_name" ref="columns_sale_order_date_order"></field>
 600         <field name="column_id_name">date_order</field>
 601         <field name="type">date_year</field>
 602         <field name="sequence">1</field>
 603         <field name="table_name">sale_order</field>
 604         <field name="hierarchy_id" ref="hierarchy_sales_order"/>
 605     </record>
 606
 607     <record model="olap.level" id="level_sales_order_q">
 608         <field name="name">date_order</field>
 609         <field name="column_name" ref="columns_sale_order_date_order"></field>
 610         <field name="column_id_name">date_order</field>
 611         <field name="type">date_quarter</field>
 612         <field name="sequence">2</field>
 613         <field name="table_name">sale_order</field>
 614         <field name="hierarchy_id" ref="hierarchy_sales_order"/>
 615     </record>
 616
 617     <record model="olap.level" id="level_sales_order_m">
 618         <field name="name">date_order</field>
 619         <field name="column_name" ref="columns_sale_order_date_order"></field>
 620         <field name="column_id_name">date_order</field>
 621         <field name="type">date_month</field>
 622         <field name="sequence">3</field>
 623         <field name="table_name">sale_order</field>
 624         <field name="hierarchy_id" ref="hierarchy_sales_order"/>
 625     </record>
 626 <!--
 627 DIMENSION ORDER DATE
 628
 629 partner_country (order_id)
 630 -->
 631 <!--
 632 DIMENSION PARTNER TO COUNTRY
 633 res_users (user_id)
 634 -->
 635
 636     <record model="olap.dimension" id="dimension_partner_country">
 637         <field name="name">Country</field>
 638         <field name="cube_id" ref="cube_sales_order_line"/>
 639     </record>
 640
 641     <record model="olap.hierarchy" id="hierarchy_partner_country">
 642         <field name="name">Partner Country</field>
 643         <field name="dimension_id" ref="dimension_partner_country"/>
 644         <field name="primary_key_table">sale_order</field>
 645         <field name="table_id" ref="country_table"/>
 646     </record>
 647
 648     <record model="olap.level" id="level_partner_country">
 649         <field name="name">country_id</field>
 650         <field name="column_name" ref="columns_res_country_name"></field>
 651         <field name="column_id_name">name</field>
 652         <field name="table_name">res_country</field>
 653         <field name="hierarchy_id" ref="hierarchy_partner_country"/>
 654     </record>
 655
 656 <!--
 657 DIMENSION PARTNER_ADDRESS TO COUNTRY
 658 -->
 659
 660     <record model="olap.dimension" id="dimension_partner_address_country">
 661         <field name="name">Sales by Partner City</field>
 662         <field name="cube_id" ref="cube_sales_order_line"/>
 663     </record>
 664
 665     <record model="olap.hierarchy" id="hierarchy_partner_address_country">
 666         <field name="name">City</field>
 667         <field name="dimension_id" ref="dimension_partner_address_country"/>
 668         <field name="primary_key_table">sale_order</field>
 669         <field name="table_id" ref="address_table"/>
 670     </record>
 671
 672     <record model="olap.level" id="level_address_country">
 673         <field name="name">city</field>
 674         <field name="sequence">1</field>
 675         <field name="column_name" ref="columns_res_partner_address_city"></field>
 676         <field name="column_id_name">city</field>
 677         <field name="table_name">res_partner_address</field>
 678         <field name="hierarchy_id" ref="hierarchy_partner_address_country"/>
 679     </record>
 680
 681     <record model="olap.level" id="level_address_country_1">
 682         <field name="name">name</field>
 683         <field name="sequence">2</field>
 684         <field name="column_name" ref="columns_res_partner_name"></field>
 685         <field name="column_id_name">name</field>
 686         <field name="table_name">res_partner</field>
 687         <field name="hierarchy_id" ref="hierarchy_partner_address_country"/>
 688     </record>
 689
 690
 691
 692 <!--
 693 DIMENSION SALEMAN
 694
 695 res_users (user_id)
 696 -->
 697
 698     <record model="olap.dimension" id="dimension_sales_user">
 699         <field name="name">Users</field>
 700         <field name="cube_id" ref="cube_sales_order_line"/>
 701     </record>
 702
 703     <record model="olap.hierarchy" id="hierarchy_sales_user">
 704         <field name="name">Users</field>
 705         <field name="dimension_id" ref="dimension_sales_user"/>
 706         <field name="primary_key_table">res_users</field>
 707         <field name="table_id" ref="user_table"/>
 708     </record>
 709
 710     <record model="olap.level" id="hierarchy_sales_user_level">
 711         <field name="name">name</field>
 712         <field name="column_name" ref="columns_res_user_name"></field>
 713         <field name="hierarchy_id" ref="hierarchy_sales_user"/>
 714         <field name="table_name">res_users</field>
 715         <field name="column_id_name">name</field>
 716     </record>
 717
 718
 719
 720
 721 <!--
 722 Measures
 723 -->
 724
 725     <record model="olap.measure" id="measure_item_sold">
 726         <field name="name">Average Sales</field>
 727         <field name="cube_id" ref="cube_sales_order_line"/>
 728         <field name="value_column" ref="columns_sale_order_amount_total"></field>
 729         <field name="value_column_id_name">amount_total</field>
 730         <field name="table_name">sale_order</field>
 731         <field name="agregator">avg</field>
 732         <field name="formatstring">cr_postfix</field>
 733     </record>
 734     <record model="olap.measure" id="measure_total_sales">
 735         <field name="name">Total Sales</field>
 736         <field name="cube_id" ref="cube_sales_order_line"/>
 737         <field name="value_column" ref="columns_sale_order_amount_total"></field>
 738         <field name="value_column_id_name">amount_total</field>
 739         <field name="table_name">sale_order</field>
 740         <field name="agregator">sum</field>
 741         <field name="formatstring">cr_postfix_comma</field>
 742     </record>
 743
 744     <record model="olap.measure" id="measure_sql_expression">
 745         <field name="name">Units Sold</field>
 746         <field name="cube_id" ref="cube_sales_order_line"/>
 747         <field name="measure_type">sql_expr</field>
 748         <field name="value_sql">count(sale_order.id)</field>
 749     </record>
 750
 751
 752 </data>
 753 </openerp>