Modules:Analytics Create Cube
Languages: |
English | Français | Translate this article... |
Contents |
Define a Cube
An example of a Cube definition for analyzing Sales data by Regions.
Define the Header
- As Client Administrator Create a new Record in the Cube Definition Window.
- The Module Field must be empty.
- Set a name, for example, Sales per Region.
- Select the Table from which the data is going to be retrieved, in this case, C_InvoiceLine.
- 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'
Define the Dimensions
- First, define a Dimension for the Product.
- Create a new record in the Cube Dimensions Tab with Module empty, the flag Measure not checked and Model Element: product.
- Then, define a Dimension for the Region.
- 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.
- For the second Dimension, the levels that need to be shown are only Region and Country.
- Create a new record in the Cube Level Tab, under the Dimension for the Regions with name: country.
- Create a new record in the Cube Level Tab, under the Dimension for the Regions with name: region.
Define the Measures
The Measure for this Cube is going to be the invoiced quantity of a Product.
- 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.