Query-based data elements give you the ability to query data from business processes and manager sheets, and display the results on a business process. In effect, for example, you can create a small cost report on a business process. This reduces referring back to the cost sheet while a user is working in the business process.
During configuration, for each query-based data element (up to five per business process), you can define a query formula and any conditions that will filter query results. For example, if you want to see the total project commitment, which includes the original commitment amount plus any changes to the original commitment, you can build a query formula to show that value from the cost sheet. You may limit, or filter, the query results by adding a condition. You also define the refresh condition that will prompt a data update for these query-based data elements. When a user opens the business process, Primavera Unifier looks at the refresh condition to determine if it can display the last calculated value or values in the business process.
Note: This feature is not available for company-level, single-record business processes.
The difference between a refresh condition and a trigger. A refresh occurs when a user opens a business process. A trigger works when the business process is already open and a user changes a value in a “trigger element” on that form. The trigger element prompts Primavera Unifier to run the query again and dynamically update the value in the query-based field.
To configure the query
| 1 | Go to the Company Workspace tab and switch to Admin mode. |
| 2 | Click Business Process Setup in the left Navigator. |
| 3 | On the right pane, double-click the business process to open it. |
| 1 | to Configuration > Business Process. The Configuration-Business Processes log opens, displaying the BPs that have been imported into your company. |
| 2 | Select the business process that contains the query-based data element and click Open > Data Elements. The Data Elements Configuration window opens. |
| 3 | Click the Query tab. |
| 4 | Under Query Conditions, click the Add button. The Define Query window opens. |
The Define Query window shows two sections, a Definition section and a Condition section.
| 5 | Use the instructions in the following table to complete the Definition section. |
|
In this field: |
Do this: |
|
Data Element |
Select the data element you want to configure. The list shows only the query-based data elements on the form. |
|
Data Type |
Select the source from which Primavera Unifier will extract the values (e.g., a column in the WBS Cost Sheet or a business process). |
|
Datasource |
Click the Select button and on the Formula Creation window that appears, build a formula to calculate the value you want to see in the field on the BP form. For information on creating a formula for a query, see "About Queries". |
| 6 | (Optional) specify a condition to filter the data that is extracted by the definition. |
A condition is not mandatory for a query definition, but your results will be more refined if you build a condition.
| a | Click the Add button. The Add Query Condition window opens. |
| b | Use the instructions under "About Queries" to complete the query condition. |
| c | Click OK. |
| 7 | On the Define Query window, click OK. |
| 8 | On the Data Elements Configuration window, under Refresh Conditions, click the Add button. The Refresh Condition window opens. |
| 9 | Use the instructions in the following table to complete the refresh condition. |
|
In this field: |
Do this: |
|
Data Element |
Select the data element you want to prompt the field refresh. |
|
Condition |
Select the condition this data element must meet to prompt the refresh. |
|
Values |
Enter or select the value this data element must contain to prompt the refresh. |
| 10 | Click OK, then click Close on the Data Elements Configuration window. |
Oracle Corporation
Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.