To define data elements for data cubes
1 | In the Data Cube window, click the Data Elements tab. |
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. |
2 | Click Add Elements. |
3 | Select one data element or multiple data elements and click OK. |
4 | Click Add Functions and select a function type: |
• | Formula |
• | Date Difference |
• | Date Add |
• | Date Function |
a | For Formula: |
Click Create. 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.
b | For Date Difference: |
Enter a column heading name, specify the dates, and whether to show partial days. Click OK.
c | For Date Add: |
Enter a column heading name, specify the date and the add function. Click OK.
d | For Date Function: |
5 | Enter a column heading name and specify the date. Click OK. |
6 | To modify a data element, select a the data element and click the Modify button. |
7 | To remove a data element, select the data element and click the Remove button. |
8 | Use the Move Up or Move Down buttons to reorder the listed data elements. |
9 | Next, define queries in the Queries tab, as described in the following procedure. |
Oracle Corporation
Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.