You are here: Primavera Unifier Administration Mode > Company Administration > Data Views > Create and Publish Data Views and Metadata

Create and Publish Data Views and Metadata

After you create a data view, you must publish it to be able to use it in user-defined reports, data cubes, or custom reports. There are two things to know about using data views in user-defined reports:

• Data views must contain project_id in the SQL query for the data view to show up in a project or shell-level UDR data type list
• Data views published prior to the Primavera Unifier 9.5 release, must be republished (i.e., set to draft status and then reset to published status) before they show up in the UDR data type list

Depending on the data elements you choose, you might need to publish the metadata associated with the data view. For example, if the selected data element has a data definition type of pull-down Menu, you will have to publish the metadata to see the actual label of the pull-down rather than the value. In the case where a data element is defined as Actual Value? based on a Yes/No data element, with 0= No and 1=Yes, if Actual Value? is used in the data view, then you need to publish the metadata of Actual Value? to get the Yes or No value rather than 0 or 1.

To create Data Views

1 Go to the Company Workspace tab and switch to Admin mode.
2 Click Data Structure Setup > Data Views in the left Navigator. The User-Defined Data Views log opens.
3 Click New. The User-defined View window opens.
4 The Prefix is auto-populated with the company short name. Enter the name of the Data View, the label, an optional description, and the SQL query for the Data View. For further details on how to create SQL queries used in the creation and management of Data Views, please consult the Oracle Consulting Services team.
5 Click OK.

To publish Data Views

1 Go to Company Workspace tab and switch to Admin mode.
2 In the left Navigator, click Data Structure Setup > Data Views. The User-Defined Data Views log opens.
3 Select an unpublished Data View.
4 Click the Status button.
5 Select Published.
6 Click OK.

To publish metadata

You can associate metadata with its Primavera Unifier data set for both labels and values. Data views tend to contain technical shorthand from system and SQL abbreviations. While clear to the technical person who wrote the data view, report consumers will appreciate seeing the same field labels and field value selections they see in their business processes and managers.

For example, in your data view you might include the data element “year_pd,” which represents a pull down menu with selections for different years assigned to its data set. In your user-defined report, you might want to see the label “Year” instead of “year_pd;” and you might want to query on meaningful values, such as 1999, 2001, 2002, etc., instead of the numeric values of the data definition, 1,2,3, etc.

1 In the User-Defined Data Views log, select a published Data View.
2 Click the Metadata button.
3 Double-click in the Definition field for each data element and select the data definition for the selected element. The data definitions available for selection are filtered by the data elements used.

 

 

4 Double-click the Label field for each element you want to use in the UDR. Rename it to whatever you want to see in the report.
5 Click Publish Metadata.

 

 

 

 

Oracle Corporation

Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.

Copyright Information