To access cubes, browse to Administration > Configuration > Cubes from Campaign explorer.
With cubes you can:
Export data directly in a report, designed in the Reports tab of the Adobe Campaign platform.
To do this, create a new report and select the cube you want to use.
Cubes appear like templates based on which reports are created. Once you have chosen a template, click Create to configure and view the new report.
You can adapt measures, change the display mode or configure the table, then display the report using the main button.
Reference a cube in the Query box of a report to use its indicators, as shown below:
Insert a pivot table based on a cube into any page of a report. To do this, reference the cube to be used in the Data tab of the pivot table on the concerned page.
For more on this, refer to Explore the data in a report.
Admin permissions are required to create cubes.
Before starting building a cube report, identify the relevant dimensions and measures, and create them in the cube.
To create a cube, apply the following steps:
In the example below, learn how to quickly create a simple cube in a report to export its measures.
To create a cube, follow the steps below:
Click the New button above the list of cubes.
Select the schema which contains the elements you want to explore (also known as the ‘fact schema’). In this example, select the default Recipient table.
Click Save to create the cube: it is added to the list of cubes. You can now use the tabs to configure it.
Click the Filter the source data… link to apply the calculations of this cube to data in the database.
Once the cube is created, define its dimensions. Dimensions are the analysis axes defined for each cube based on their related fact schema. These are the dimensions explored in the analysis, such as time (year, month, date), a classification of products or contracts (family, reference, etc.), a population segment (by city, age group, status, etc.).
To create dimensions, follow the steps below:
Browse to the Dimension tab of the cube and click the Add button to create a new dimension.
In the Expression field, click the Edit expression icon to select the field that contains the concerned data.
In this example, we are selecting the recipient Age. For this field, you can define binning to group ages and make information reading easier. We recommend using binning when there is a likelihood of several separate values.
To do this, check the Enable binning option. Learn more.
In our example, we only want to display years, months and days. Note that you cannot work with weeks and semesters/months at the same time: these levels aren’t compatible.
You can enable binning to make information reading easier and link the values to an enumeration.
Select the enumeration from the drop-down list. Note that this enumeration must be defined as Reserved for binning.
Only the values in the enumeration will be displayed. The others will be grouped under the label defined in the Label of the other values field.
For more on this, refer to this section.
Once the dimensions are defined, specify a calculation mode for the values to be displayed in the cells.
To do this, create the indicators in the Measures tab. Create as many measures as there are columns to display in the reports based on this cube.
To build indicators, follow the steps below:
Browse to the Measures tab and click the Add button.
Select the type of measure and the formula to apply. In this example, we are counting the number of women among the recipients. Our measure is based on the fact schema and uses the Count operator.
Use the Filter the measure data… link to select women only. Learn more.
Enter the label of the measure and save it.
Save the cube.
You can now create a report based on this cube. Learn more.