View source | Discuss this page | Page history | Printable version   

Modules:Analytics Create Cube

Contents

Define a Cube

An example of a Cube definition for analyzing Sales data by Regions.

AnalyticsCreateCube1.png

Define the Header

  1. As Client Administrator Create a new Record in the Cube Definition Window.
  2. The Module Field must be empty.
  3. Set a name, for example, Sales per Region.
  4. Select the Table from which the data is going to be retrieved, in this case, C_InvoiceLine.
  5. Set the Sql Filter. In this case, the Invoice Lines must be filtered to show only Sales records and to show only data from this Client.
1 = (SELECT 1 FROM c_invoice i WHERE i.issotrx='Y' AND [alias].c_invoice_id=i.c_invoice_id) AND ad_client_id = '23C59575B9CF467C9620760EB255B389'

AnalyticsCreateCube2.png

Define the Dimensions

  1. First, define a Dimension for the Product.
  2. Create a new record in the Cube Dimensions Tab with Module empty, the flag Measure not checked and Model Element: product.
  3. Then, define a Dimension for the Region.
  4. Create a new record in the Cube Dimensions Tab with Module empty, the flag Measure not checked and Model Element invoice.partnerAddress.locationAddress.region.country.
  5. For the second Dimension, the levels that need to be shown are only Region and Country.
  6. Create a new record in the Cube Level Tab, under the Dimension for the Regions with name: country.
  7. Create a new record in the Cube Level Tab, under the Dimension for the Regions with name: region.

AnalyticsCreateCube3.png

Define the Measures

The Measure for this Cube is going to be the invoiced quantity of a Product.

  1. Create a new record in the Cube Dimensions Tab with the module set as empty, the flag Measure checked and the Model Element: invoicedQuantity. The name of the Measure can be changed by setting a new name in the name field.

Retrieved from "http://wiki.openbravo.com/wiki/Modules:Analytics_Create_Cube"

This page has been accessed 3,758 times. This page was last modified on 23 April 2014, at 13:36. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.