Oracle by Example brandingCreating Business Views in Web Object Management Workbench

section 0Before You Begin

This 40-minute OBE (Oracle by Example) shows you how to create Business Views in the Web Object Management Workbench (Web OMW).

In this OBE, you will:

  1. Create a project.
  2. Add a Business View Object to the project.
  3. Create a Table Join.
  4. Create a Table Union.

Background

A business view is a selection of data items from one or more tables. JD Edwards EnterpriseOne uses the business view that you create to generate the appropriate SQL statements that are necessary to retrieve data from the database. Business analysts use Business Views to define custom data sets that represent the operations of their business.

Starting with Tools Release 9.2.8, you can create Business Views in the Web Object Management Workbench by using the Business View Design Aid.

Scenario

In this OBE, let us consider a scenario in which you are a Business analyst who needs to create two Business Views, with one containing a Table Join and the other containing a Table Union.

Prerequisites

To perform the steps in this OBE, you must have:

  • Installed JD Edwards EnterpriseOne Applications Release 9.2 with Tools Release 9.2.8 or later.

section 1Create a Project

In this section, you will create a project in the Web Object Management Workbech.

  1. Open a web browser and sign in to EnterpriseOne.
  2. Navigate to Object Management Workbench – Web (P98220W) from the Fast Path.
  3. In the Object Management Workbench – Web form, click Add to add the OMW project.
  4. In the Create EnterpriseOne Object form, from the General Object drop-down list, select OMW Project. Click OK.
    5. Description of create_enterpriseone_object.png follows
    Create EnterpriseOne Object
  5. In the Project Revisions form, complete the following fields:
    • Project ID = Enter the project name, for example, PBVPROJECT.
    • Description = Enter a description for the project, for example, Demo BV Project 1.
    • Type = 01
    • Severity = 04
    • Product System Code = 55
    • Release = E920
    Description of project_revisions.png follows
    Project Revisions
  6. In the Object Management Workbench – Web form, select the project you created. From the Row menu, select Advance Project.
  7. Enter 21 in the Status field of the Confirm Project Status Change window. Click OK.
    8. Description of advance_project.png follows
    Advance Project
  8. Click OK.

section 2Add a Business View Object

In this section, you will add Business View object to the project you created.

  1. In the Object Management Workbench – Web form, select the project you created in the previous task and then click Add.
  2. In the Create EnterpriseOne Object form, from the General Object drop-down list, select Business View. Click OK.
    3. Description of create_business_view_object.png follows
    Create Business View Object
  3. In the Add Object form, complete the following fields:
    • Object Name = Enter the object name, for example, PBVDEMO1
    • Description = Enter a description for the object, for example, Demo BV Object 1
    • Product Code = 55
    • Product System Code = 55
    Description of add_object.png follows
    Add Object
  4. Click OK. The newly created Business View object is displayed in the Project Objects tab.
    5. Description of project_objects.png follows
    Project Objects

section 3Create a Table Join

In this section, you will understand how to create a Business View with a Table Join.

  1. In the the Object Management Workbench – Web form, select the project you created, and from the Project Objects tab select the Business View object you created in the previous task and then select Design from the More Row Actions drop-down menu. Alternatively, click the Object Name link. The Business View Design form is in the Join Mode by default, but you can change to Union Mode or Union All Mode by selecting them from the Table/Column Selection.
    2. To create a distinct Business View, select Distinct from the Table/Column Selection.
    Description of business_view_design_aid.png follows
    Business View Design Aid
  2. In the Available Tables pane, use the query by example (QBE) line to search for an appropriate table. For this OBE, search for tables starting with the Table Name: F2*.
    3. Description of search_for_table.png follows
    Search for Table
  3. Click the arrow located in the Select Table field of the table row to select a Table. You can select one or more tables, the table you select will appear in the Selected Table pane.
    4. If more than one table is selected in Join Mode, you cannot change to Union Mode or Union All Mode. However if you select more than one table in Union Mode or Union All Mode, you can change between them, but you cannot select the Join Mode.
    Description of select_table.png follows
    Select Table
  4. If more than one table is selected, click the primary option for the appropriate table to designate it as the primary table. If the business view contains multiple tables, the system automatically designates the first table that is added to the Selected Table pane as the primary table. A green dot appears in the Primary field of the table row. If a business view contains only one table, that table is the primary table by default.
    5. If you are in Join Mode and select more than one table, the Table Joins pane and Column Joins pane appear. You can add up to 15 tables for a table join.
    Description of primary_table.png follows
    Primary Table
  5. To delete a table from a business view, select the table and click Delete in the Selected Table pane.
  6. In the Selected Columns pane, select the data items to include in the business view. You can click Select All to select all the data items in the pane.
    7. Primary keys for the table are always selected by default for Join Business View, you can’t remove them.
    Description of selected_columns.png follows
    Selected Columns
  7. Click the Add row button in the Table Joins pane, a table join is added.
  8. Select a table from the Left Table drop-down list and select a table from the Right Table drop-down list. The Left Table drop-down and Right Table drop-down list contains the list of tables selected from Selected Tables pane.
    9. Description of add_row.png follows
    Add Row
    The selected data items for both the tables appear on the Left Table and Right Table tabs of the Column Joins pane respectively.
    Description of left_table_and_right_table.png follows
    Left Table and Right Table
  9. Select an appropriate join type from the Join Type drop-down menu. Simple is the default join type.
    10. Description of join_type.png follows
    Join Type
  10. To delete a table join, click Delete in the Table Joins pane.
  11. Click Add in the Column Join form, a column join is added.
    12. Description of column_joins.png follows
    Column Joins
  12. Select a column from the Left Table tab, the column is added in the Left Column field of the join.
    13. Although the column names do not have to be the same, the attributes for Data Type and Decimals must be identical before you can create a column join between two columns.
    Description of left_column.png follows
    Left Column
  13. Select a column from the Right Table tab, the column is added in the Right Column field of the join.
    14. Description of right_column.png follows
    Right Column
  14. Select an appropriate operator from the Join Operator drop-down menu. Equal is the default join operator.
    15. Description of join_operator.png follows
    Join Operator
  15. To delete a column join, click Delete in the Column Joins pane. If you add more data items from the Selected Columns pane to the Left Table and Right Table tab, click Refresh to save the changes.
    16. Refresh will remove unsaved column join.
  16. Click OK to save your changes.

section 4Create a Table Union

Before you follow the steps in this section, create a second Business View object by following the steps in section 2 of this OBE.

  1. From the Table/Column Selection, select either Union Mode or Union All Mode. In this OBE, Union Mode is selected.
    2. The Union and Union All features are available only if all columns in one table also reside in the other table.
    Description of union_mode.png follows
    Union Mode
  2. Click Yes in the Business View Design Aid: Union/Union All Mode window.
    3. Description of union_mode_window.png follows
    Union Mode Window
  3. In the Available Tables pane, use the query by example (QBE) line to search for an appropriate table. For this OBE, search for tables starting with the Table Name: F2*.
  4. Select the tables for which you want to create a table union. You can add up to 3 tables for a table union.
    5. If the business view contains multiple tables, the system automatically designates the first table that is added to the Selected Table pane as the primary table.
  5. Select the data items you want from the primary table. You can’t choose data items from the other tables. If you select Only Selected Columns, only the selected data items are displayed. You can use the Select All to select all the data items from the primary table.
    6. Description of select_data_items_2.png follows
    Select Data Items for Union
  6. Click OK to save your changes.

more informationWant to Learn More?