1. Managing Metadata Repositories for Oracle Analytics Server
  2. Build Your Metadata Repository
  3. Work with ADF Data Sources
  4. About Importing ADF Business Components

About Importing ADF Business Components

During import, the required physical tables and complex joins are automatically created.

The ViewObject and ViewLink instances are imported into Oracle Analytics Server. During query processing, the definitions retrieved from these instances are used to create the CompositeVO (view objects) in Oracle Application Development Framework (ADF).

These complex joins are dummy joins and aren't run in Oracle Analytics Server. Instead, the dummy joins denote ViewLink instances that connect pairs of View Objects in the ADF model. The physical table and complex join names correspond to the fully qualified ViewObject and ViewLink instance names. This convention allows arbitrary nesting of ApplicationModules in the ADF model.

The name of the automatically generated joins uses a naming convention similar to ViewObjectName1_ViewObjectName2, for example, AppModuleAM.AP_VO1_AppModuleAM_BU_VO1. The ViewLink instance name appears in the ViewLink Name field of the Complex Join dialog.

The complex joins are created automatically if a ViewLink instance is available. Complex joins aren't created for ViewLink definitions. You must create joins using ViewLink definitions manually. To manually create a join using ViewLink definitions, specify the ViewLink definition name in the ViewLink Name field of the Complex Join dialog.

The External Expression field in the Complex Join dialog for ADF data sources is populated with the join condition defined in the view link.

If custom properties are defined on the ApplicationModule, joins between view objects in different ApplicationModules are created on import from ADF. The format for the property name and value are as follow:

  • The property name format is BI_VIEW_LINK_property_name

  • The property value format is source_view_object_instance_name, ViewLink_definition_name, destination_view_object_instance_name

Be sure to use the fully qualified view object instance names for the source and destination view objects, as well as the fully qualified package name for the ViewLink definition.