Populating a Datamart
A datamart will be useless unless it contains actual data. In this section we will look at how to populate a datamart. Upon completing the previous steps (see How to Create a Datamart), the system displays a confirmation message indicating the next steps and the fields for customer and product details are shown.
...
Populating a Datamart
Select customer fields. Choose the following fields from the Customer source: Customer Name, Country, Industry, Region, Customer Group
Select product fields. Choose the Product Group field from the Product source.
| Expand | ||
|---|---|---|
| ||
  |
Select
...
pricing and
...
financial fields. Select the following fields from the Data source: Global List Price, Gross Margin, Cost, Promotion Discount, Invoice Price, Local List Price, Net Price, Quantity
...
Click on the
...
Add to Fields
...
button at the bottom (on the black ribbon) to include the selected fields.
...
| Expand | ||
|---|---|---|
| ||
 |
The system displays a confirmation message at the top of the window. All selected fields from the existing data sources appear on the right side.
Create Additional Field for Margin Result:
...
You can also create additional field for margin result. To store a margin result, an additional field must be created in the datamart.
Click on the
...
Add Field
...
icon at the top-right of the window to create an additional field.
Enter the required fields marked with red asterisks (Data Type, Label, Name, Expression or formula).
Click on the
...
Add Field
...
button in blue, at the bottom.
...
| Expand | ||
|---|---|---|
| ||
 |
The system displays the new additional field with the calculated formula to store the margin result.Deploy Fields:
| Expand | ||
|---|---|---|
| ||
 |
Deploying Fields
Click on the
...
Deploy
...
button in the top-right corner.
The system shows will show all fields in green color (if no warnings are displayed).
Click again on the
...
Deploy
...
button in blue at the bottom of the window.
...
| Expand | ||
|---|---|---|
| ||
 |
The system displays a confirmation message.
Click
...
OK
...
.
A confirmation message also appears after deployment completion. Notice You will se the different data sources under the Owner column.Complete Datamart Field Structure:
| Expand | ||
|---|---|---|
| ||
 |
The datamart field structure is now completed.
| Tip |
|---|
To ensure that the datamart gets populated you must execute a Data Load process. |
...
Executing Data Load Process
...
Go to the main menu and navigate to Analytics > Data Manager > Data Loads.
The system displays a list of all data load executions.
Click on your datamart with
...
Refresh-Draft
...
status.
| Expand | ||
|---|---|---|
| ||
 |
| Tip |
|---|
On the left-side section, unselect the Incremental checkbox to ensure complete calculation. |
Click on the
...
Run Data Load
...
icon in the top-right corner.
| Expand | ||
|---|---|---|
| ||
 |
Click on the
...
OK
...
in the confirmation message.
The system performs the data load processing with "Pending" status.
| Note |
|---|
Wait until the status changes to |
...
Ready |
...
. |
| Expand | ||
|---|---|---|
| ||
 |
Reviewing Data Load
...
Click
...
the
...
Refresh
...
button at the top-corner of the window.
Review You can now review the data load of your datamart with "Ready " status.
Review Datamart Information:
Go
| Expand | ||
|---|---|---|
| ||
 |
To review Datamart information go to the main menu and navigate to Analytics > Data Manager > Datamarts. Notice Note the number of rows populated for your datamart.
Click on the
...
Data
...
tab at the top-left corner
...
to review the data loaded into your datamart.
...
| Expand | ||
|---|---|---|
| ||
  |