You can set up Dashboards and Analyses, for Unifier Shells, in Oracle Business Intelligence Enterprise (OBIE) analyses and select the Shell data that you want to use for analyses.
When you open a Shell in the Analytics node, you will see the Analytics - Shells Setup window with one tab:
Data Mapping.
The Data Mapping tab is divided in two sections:
- System defined and User defined attributes
- User Defined Columns
The system defined columns of the Data Mapping tab allows you to map the Shells (called "Projects" in Analytics) Analytic fields to a corresponding Shell attribute Data Element (DE) defined in Unifier.
The top section of the Data Mapping tab displays all the system defined fields in the following columns:
- Name
- Data Source
Name
Lists a series of predefined, read-only fields, which represent the fields used in OBI.
Note: When the user adds a new user-defined field on a Shell mapping page, the "Name" field displays fields up to 100 (minus the ones used already).
- Shell Phase
- Anticipated Start
- Anticipated Finish
- Start
- Finish
- Forecast Start Date
- Forecast Finish Date
- Planned Start
- Planned Finish
- Scheduled Finish
- Current Budget
- Original Budget
- Proposed Budget
- Address 1
- Address 2
- City
- State
- State Code
- Country
- Country Code
- Postal code
Data Source
- Lists all of the Data Elements (DEs), in the Shell attributes, with matching Data Definitions (DDs).
- The DEs are listed in alphabetical order.
- The values listed in the drop-down list have a matching DD as in the Name field and includes a consolidated list of all the DEs across all Shell attribute forms. For example, when you select the "Project Start Date," the drop-down list will include all the date fields in all of the Shell attribute forms.
The bottom section of the Analytics - Shells Setup window includes the User Defined attributes/fields presented in the following columns:
- Name
- Data Type
- Data Source
- Label
Use the Add, Modify, and Remove to add, modify, or remove user defined attributes.
To modify a user-defined attribute, click to select the attribute, click Modify, and modify the fields.
To remove a user-defined attribute, click to select the attribute, click Remove, and modify the fields.
Note: If you remove a user-defined attribute, the DE name will remain in the list for future use.
To add a user-defined attribute, read the following information:
When you click Add, the Add User Defined Attribute window opens. This window allows you to select the following mandatory fields:
- Data Type
- Name
- Data Source
- Label
Notes:
- The Label field is populated based on the Data Element that you have selected from the Data Source drop-down list.
- The Label field is editable and required. You will receive an error message if you leave the Label field blank.
- If you notice that the value in the Label field has changed, it means that other fields have been updated at one point.
The Data Type that you select impacts the Name and the Data Source of the user-defined attribute. The Data Type field allows you to select the following attributes, only:
- String (default)
- Date
- Numeric
For example, if you select String as your Data Type, you can:
- Add up to 20 names (User Defined String Fields 1 - 20) as the Name.
- Select from a predefined set of data sources from Data Source drop-down list.
- The content of the Label filed will be selected by the system and according to your other selections.
Dimension and Fact
The Data Type that you select corresponds to the Analytics fields as follows:
- If the Data Type that you select is String/Date, then your selection corresponds to a Dimension object in Analytics.
- If the Data Type that you select is Numeric, then your selection corresponds to a Fact object in Analytics.
Additional Information
Pickers are available for String field mappings for both canned and user defined attributes are as follows:
- BP Data Picker
- User Data Picker
- Planning Data Picker
- User Picker
- Location Picker
- P6 Activity Picker
- Auto-update Status Setup Picker