Define data elements

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.

Copyright Information