Repository Variable Init (Initialization) Block page

Use the Repository Variable Init (Initialization) Block page, Repository Variable Init Block Data Source page, and Repository Variable Init Block Variable Target page to create initialization blocks and dynamic repository variables.

Navigation

select (Oracle BI Administration, then select Manage, then select Variables, then select Repository, then select Initialization Blocks)

These are examples of the Repository Variable Initialization Block pages for the Admission Application page that is referenced in the previous example:

Image: Repository Variable Init (Initialization) Block page

This example illustrates the fields and controls on the Repository Variable Init (Initialization) Block pageRepository Variable Init (Initialization) Block page. You can find definitions for the fields and controls later on this page.

Repository Variable Init (Initialization) Block pageRepository Variable Init (Initialization) Block page

Image: Repository Variable Init Block Data Source pageRepository Variable Init Block Data Source page

This example illustrates the fields and controls on the Repository Variable Init Block Data Source pageRepository Variable Init Block Data Source page. You can find definitions for the fields and controls later on this page.

Image: Repository Variable Init Block Variable Target pageRepository Variable Init Block Variable Target page

This example illustrates the fields and controls on the Repository Variable Init Block Variable Target pageRepository Variable Init Block Variable Target page. You can find definitions for the fields and controls later on this page.

In this example, you create an initialization block and dynamic repository variable to use to create the URL for the source system. You must create an initialization block for every online transaction system target page to which users will drill to from the Fusion Campus Solution Intelligence application.

This is an example of the data source default initialization string for one initialization block, which is defined with the component ID that was added to the PS_SRC_COMPONENT table in the previous step.

SELECT A.URI_TEXT_PSP
FROM PS_SRC_CONFIG A, PS_SRC_COMPONENT B
WHERE A.SRC_SYS_ID = B.SRC_SYS_ID
AND A.SRC_SYS_ID = 'HCM'
AND B.COMPONENT_ID='ADM_APPL_PROG_MNT'

This is an example of the variable target default initializer for the initialization block:

'http://adntas45.peoplesoft.com:
6300/psp/EM_HC890DV2_TS104539/EMPLOYEE/
HRMS/c/PROCESS_APPLICATIONS.ADM_APPL_
MAINTNCE.GBL?PAGE=ADM_APPL_PROG_MNT&
ADM_APPL_NBR=:1&INSTITUTION=:2&APPL_PROG_
NBR=:3&EMPLID=:4&ACAD_CAREER=:5'

Refer to the Oracle Business Intelligence Server Administration Guide for a discussion of initialization blocks and dynamic repository variables.

See Oracle Business Intelligence Server Administration Guide, "Using Variables in the OracleBI Repository," Process of Creating Initialization Blocks.