To add data elements for data cubes
- Click the Data Elements tab where you will see the fields listed in the table below these directions.
- Click Add Elements.
- Select one data element or multiple data elements and click OK.
- Click Add Functions. Select a function type:
- Formula: Click Create a formula and click OK. The data source available for the formula are based on the data sources you selected in the Data Sources tab Date Difference: Enter a column heading name, specify the dates, and whether to show partial days. Click OK.
- Date Add: Enter a column heading name, specify the date and the add function. Click OK.
- Date Function: Enter a column heading name and specify the date. Click OK.
Field | Description |
|---|---|
Data Source | The data element data source. |
Label | The data element label. You can modify this label. |
Name | The data element name. |
Type | The data element type. |
Group | Click to define whether the data element can be used as a Grouping element when the data cube is used. |
Summary | Click to define whether the data element can be used as a Summary type. |
Additional actions you can take
- Modify a data element by selecting the data element and clicking the Modify button.
- Remove a data element by selecting the data element and clicking the Remove button.
- Reorder the listed data element by using the Move Up or Move Down buttons.