HOW TO UPLOAD A RPD

To upload the RPD follow these steps.

Step :-1

Open a browser and enter the following URL to navigate Fusion Middleware Control Enterprise Manager.

http://<machine name>:7001/em

Step :-2

Log in as an administrative user. Typically you see the administrative user name and password provided during the Oracle BI installation. (For this project it is “weblogic“)

Step:-3

In the navigation pane, expand Business Intelligence and click coreapplication. After that click on Deployment tab, then the Repository subtab. Then click Lock and Edit Configuration.

Step :-4

Click Close when you receive the confirmation message “Lock and Edit Configuration-Completed Successfully.”

Step :-5

In the “Upload BI Server Repository” section, click Browse to open the choose file dialog box.

Navigate to the repository directory where you previously saved your repository and select your RPD file and click Open.

Step :-6

Enter the password and confirm the password.

Step :-7

Click Apply

Step :-8

In the BI Server Repository section, confirm that the Default RPD is now that you have uploaded (here TennisTournament.rpd).

Click Activate Changes.

Click Close when you receive the confirmation message Activate Changes – Completed Successfully.

Step :- 9

Click Restart to apply recent changes to navigate to the Overview page.

Step :- 10

On the overview page, click Restart.

Click Yes when you receive the message Are you sure want to restart all BI components?

Allow the Restart all processing to complete. This may take few moments.

Click Close when you receive the confirmation message Restart All – Completed Successfully.

Confirm that System Components are 100% and that five components are up. Leave Enterprise manger open.

BISAMPLE : Using Aggregates

STEP : 1

Connection Pool > Import Metadata.

STEP 2 :

Select Tables,Keys,Foreign Keys & Views.

STEP 3 :

Import the highlighted tables.

STEP 3 :

Right Click on

> SAMP_REVENUE_FA2 > New Object > Alias… F2 Revenue Aggregate 

> SAMP_TIME_QTR_D > New Object > Alias… D1 Time Quarter Grain

Below Screen shot should appear.

STEP 4 :

Select D1 Time Quarter Grain,D2 Product & F2 Revenue Aggregate > Right Click > Physical Diagram > Selected Object(s) only.

STEP 5 :

Join D2 Product with F2 Revenue Aggregate as per the below screen shot.

STEP 6 :

Join F2 Revenue Aggregate with D1 Time Quarter Grain.

STEP 7 :

Drag the following columns from D1 Time Quarter Grain to their corresponding columns in D1 Time.

Note: Make sure to drag them to their corresponding columns & Rename the D1 Time Quarter Grain to LTS2 Time Quarter Grain.

STEP 8 :

Drag Units & Revenue from F2 Revenue Aggregate(Physical Layer) to F1 Revenue(BMM Layer).

STEP 9 :

Rename the F2 Revenue Aggregate logical table source to LTS2 Revenue Aggregate in BMM Layer.

STEP 10 :

File > Check Global Consistency > Yes.

STEP 11 :

Select Manage > Variables…

STEP 12 :

Action > New > Repository > Initialization Block.

STEP 13 :

Select on Edit Data Source…

STEP 14 :

Select Browse… in Connection Pool.

STEP 15 :

Select Connection Pool.

STEP 16 :

Below scree shot will appear.

STEP 17 :

Enter the SQL Query as per the below screen shot in the empty box and click Test…

STEP 18:

The below screen shot should appear after the Test.

STEP 19:

Click on Edit Data Target…

STEP 20 :

Click on New…

STEP 21 :

Enter Name as CurrentDay & click on OK.

Blow screen shot will appear :

STEP 22:

Create 2 more variable by repeating step 21 for CurrentMonth & CurrentYear.

STEP 23 :

Click Test…

Below screen should appear:

STEP 24:

Close the Variable Manager Window.

STEP 25 :

File > Check Global Consistency > Yes.

Congratulation!!!! You have successfully completed all the steps in development of repository.