Modules:Analytics Create Cube

Define a Cube

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

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'

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.

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.