cloning and synchronizing oracle bi requests and dashboards using content accelerator framework

8/8/2019 Cloning and Synchronizing Oracle BI Requests and Dashboards Using Content Accelerator Framework

1/91

Cloning and Synchronizing Oracle BI Requests and Dashboards Using Content Accelerator Framework (CAF)

Prerequisites

Before starting this tutorial, ensure that you have installed and configured:

Oracle Business Intelligence Suite Enterprise Edition, version 10.1.3.4 or later. Please note that CAF will not work with the future OBIEE 11gplatform.Java JDK version 1.6 or later

Windows XP. CAF has only been tested in a Windows XP environment. There is no guarantee it will support other OS environments. This tutorialassumes a Windows XP environment.

You can download Oracle Business Intelligence Suite Enterprise Edition from the Oracle E-Delivery Web site .

If you need assistance with OBIEE installation, system requirements, and so forth, you can access the most current documentation on the OracleDocumentation page.

You can download CAF documentation from Oracle Technical Network (OTN).

Note:

The servers for this OBE are hosted locally (localhost). If your server is not stored locally, the format is generally the IP address or the machine (server name). Confirm this information with your administrator before beginning this tutorial.

Reference Material

It is assumed in this OBE that you have a working knowledge of Oracle Business Intelligence products. If you need additional training and instruction,please refer to the following materials:

Oracle by Example (OBE) tutorials :

Oracle Business Intelligence Enterprise Edition (OBE Start Page)

Creating Interactive Dashboards and Using Oracle Business Intelligence Answers

Creating a Repository Using the Oracle Business Intelligence Administration Tool

Instructor-led training:

Oracle BI Suite EE 10 g R3: Build Repositories

Oracle BI Suite EE 10 g R3: Create Requests & Dashboards

Oracle University :

For additional courses and training, search Oracle University at this link.

Setting Up the OBE Training Environment

The goal of this topic is to set up your environment to enable you to complete the steps in this OBE. To set up the OBE training environment, perform thefollowing steps:

Installing Content Accelerator Framework

In this subtopic you learn how to download and install the Content Accelerator Framework utility.

1. Download the CAF utility ( CAF...Install.zip ) from the Oracle Business Intelligence Enterprise Edition Plus page on Oracle TechnicalNetwork (OTN). The Downloads section is located on the right side of the page.

2. Extract the CAF installation zip file into your OBIEE installation directory at the top level, for example, C:\OracleBI.


2/91


3/91

12. To verify installation is successful, select Start > All Programs > Oracle Business Intelligence > Catalog Manager and confirmthat Catalog Manager now opens.

13 . Select File > Open Catalog and open any available online or offline Presentation Catalog.

14. Expand the Presentation Catalog tree in the left pane until you are able to highlight an existing request in the right pane.


4/91

15. Right-click the highlighted request and verify that the contextual menu choices include both a Clone and a Synchronize option.This confirms your CAF installation is successful.

16. Close the catalog without selecting Clone or Synchronize .

17 . Close Catalog Manager .

Setting Up the OBE Training Folders

In this subtopic you learn how to set up the training folders you need to complete the steps in this OBE. Please note that the steps in this subtopic are for the purposes of this training only and are not required in your production environment.

In order to exactly match the examples provided in this OBE, you need to start with clean copies of the Sample Sales and Paint Presentation Catalogsand repositories that ship with the OBIEE product. By clean copies, we mean Presentation Catalogs and repositories that have not been modified after the initial installation of OBIEE. You can find clean versions of these Presentation Catalogs and repositories in \OracleBI\server\Sample . If you do nothave clean copies, you can download the Presentation Catalogs and repositories from here .

If you already have a more recent version of Sample Sales in your environment, you may notice slight differences in the structure of the PresentationCatalog, but the examples used in this OBE should still be available in the more recent versions of Sample Sales.

Throughout this OBE we refer to Sample Sales as the source and Paint as the target. The source Presentation Catalog and repository for cloning arefrom the Sample Sales sample application, and the target Presentation Catalog and repository are from the Paint sample application. During the cloningprocess in this OBE, the source Presentation Catalog is offline, the target Presentation Catalog is online, and both the source and target repositories areoffline. The source and target can be on separate machines or the same machine. For the purposes of this tutorial it is assumed that the source andtarget are on the same machine.

1. Create a new folder named CAF_Training on your local drive. For example, C:\CAF_Training .


5/91

2. Create two subfolders in C:\CAF_Training: Source and Target .

3 . Copy a clean version of the Sample Sales repository, samplesales.rpd , to the C:\CAF_Training\Source folder.

4. Copy a clean version of the Paint repository, paint.rpd , to the C:\CAF_Training\Target folder.

5. If necessary, copy clean versions of the samplesales and paint Presentation Catalogs to \OracleBIData\web\catalog .

Exploring Sample Sales Requests

In this subtopic you explore some of the requests you will clone from the source environment (Sample Sales) to the target environment (Paint).

1. Stop the Oracle BI Server and Oracle BI Presentation Server services.

2. Set samplesales.rpd as the default repository in the Repository section of \OracleBI\server\Config\NQSConfig.ini .

3 . Set samplesales as the catalog identified in the section of \OracleBIData\web\config\instanceconfig.xml .


6/91

4. Start Oracle BI Presentation Server and Oracle BI Server services.

5. Select Start > All Programs > Oracle Business Intelligence > Presentation Services to open Oracle BI Presentation Services .

6. Log in as Administrator with password Administrator .

7 . Click the Answers link.

8. Expand Shared Folders > Sample Sales > 0 3 Tiering and Distribution .

9. Click the 8020 request to explore its views and formatting.

10. Notice that the request includes a variety of Answers views, including charts, graphs, and tables. You will compare this layout to thelayout after you clone the request.


7/91

11. Notice the C1 Cust Name data. You will compare this to the data displayed after you clone the request.

12. Click the Modify button to view the criteria for the request. The screenshot shows only a partial view of the request criteria.

13 . Click the Edit Formula button for the Rank column to open the Edit Column Formula dialog box.

14. Notice that the rank formula uses a Sample Sales column: "F1 Revenue"."1-01 Revenue (Sum All)" . You will compare this to the

column displayed in the formula after you clone the requests.


8/91

15. Click Cancel to close the Edit Column Formula dialog box.

16 Click the Answers link.

17 . Expand Shared Folders > Sample Sales .

18. If desired, explore the following requests and their descriptions in the 03 Tiering and Distribution folder:

Comparative DistributionComparative Standard DeviationNtiling Comparative AnalysisStatistical DistributionValue Based Tiering

Do not modify the requests. These requests and the 8020 request are the requests you will clone from the Sample Sales sourcePresentation Catalog to the Paint target Presentation Catalog.

Back to Topic

Back to Topic List

Building a Sample Sales Request for Demonstration Purposes

In this subtopic you build a request using columns in Sample Sales. You use this request later in this OBE to demonstrate how to use CAF tosynchronize logical objects between source and target repositories.

1. Click the Answers link to return to the Answers start page .

2. Click the Sample Sales subject area.


9/91

3 . Use the following columns to create a new Answers request, which uses logical calculations in the repository:

"D0 Time"."T05 Per Name Year"

"D2 Market"."M04 Region""F 3 Bookings"."8-X1 Book to Bill Ratio""F1 Revenue"."1-01 Revenue (Sum All)"

4. CTRL + click the " D4 Product"."P02 Product Type" column to open Create/Edit Filter dialog box. Using CTRL + click allows youto build a filter for a column that is not included in the request.

5. In the Operator field select is prompted to create the following filter: P02 Product Type is prompted


10/91

6. Click OK .

7 . Use the Add Filter button for the T05 Per Name Year column to add the following filter: T05 Per Name Year is prompted

8. Notice that the request now has two filters and that P02 Product Type is prompted is a filter on a column that does not exist in therequest.


11/91

9. Save the request in Shared Folders > Sample Sales and name it CAF_EXP_1 .

10. Log out of OBI Presentation Services and close the browser.


12/91

Back to Topic

Back to Topic List

Setting Up Paint as the Target Presentation Catalog

In this subtopic you learn how to set up Paint as the target Presentation Catalog, which is where the generated code for cloned objects is saved. Whenyou clone objects with CAF, you provide details of the target Presentation Catalog instance in the format hostname:portnumber. CAF requires an onlinetarget Presentation Catalog in order to clone the objects. Note that this can be any online Presentation Catalog.

CAF uses the online Presentation Catalog to create folders, requests and dashboards with the correct cloned objects. Once the objects are created inthe Presentation Catalog, they can be copied or moved within the Presentation Catalog instance or to another Presentation Catalog instance.

Complete the following steps to identify Paint as the online Presentation Catalog in the catalog path in \OracleBIData\web\config\instanceconfig.xml.

1. Stop the Oracle BI Presentation Server and Oracle BI Server services.

2. Set paint.rpd as the default repository in the Repository section of \OracleBI\server\Config\NQSConfig.ini .

3 . Modify \OracleBIData\web\config\instanceconfig.xml so that paint is the catalog identified in the section.

4. Restart the Oracle BI Presentation Server and Oracle BI Server services.

Back to Topic

Back to Topic List

Cloning Answers Requests

The goal of this topic is to use CAF to clone a set of Answers requests from a source Presentation Catalog to a target Presentation Catalog.

To clone a set of Answers requests, perform the following steps:

Selecting the Source Requests for Cloning

Mapping the Required Columns

Identifying a Path for the Target Requests


13/91

Verify Cloning Results

Back to Topic List

Selecting the Source Requests for Cloning

In this subtopic you learn how to use Catalog Manager and the CAF Wizard to select the requests you want to clone in the source Presentation Catalog.

1. Select Start > All Programs > Oracle Business Intelligence > Catalog Manager to open Oracle BI Catalog Manager.

2. Select File > Open Catalog .


14/91

3 . In the Type drop down list, select Offline . Please note you are using offline mode in this example, however when using CAF to cloneobjects you could open the source Presentation Catalog in online mode.


15/91

4. In the Path field, browse to \OracleBIData\web\catalog\samplesales . This is the source Presentation Catalog for the cloningprocess. In this OBE the samplesales Presentation Catalog is located on the C:\ drive.


16/91

5. Click OK to open the samplesales Presentation Catalog in Catalog Manager.


17/91

6. Expand the tree to shared\Sample Sales\0 3 Tiering and Distribution . In the right pane you can see a list of the Sample Salesrequests you explored earlier in this tutorial.


18/91

7 . In the list, use Ctrl + click to select the following six requests:

8020Comparative DistributionComparative Standard DeviationNtiling Comparative AnalysisStatistical DistributionValue Based Tiering

Please note that you are not selecting the - Help requests or the Variability requests.

8. Right-click any one of the highlighted requests and select Clone to open the Content Accelerator Wizard dialog box.


19/91

9. In the Source Rpd field, browse to the location of the source repository. In this tutorial the location isC:\CAF_Training\Source\samplesales.rpd . This is the path to the repository that supports the source requests selected for cloning.CAF requires this information to list the objects used in the selected source requests, and to identify the minimum set of mappingsneeded for objects in the target environment. Some logical calculations in the source repository (used in requests) may also getcloned into the target repository. Only an offline version of a source repository is accepted by CAF. As in this example, you can use acopy of the repository originally used to support the source requests. The source repository is not modified during the cloning process.


20/91

10. Enter Administrator as the username and password for the Source Rpd.

11. In the Target Rpd field, browse to the location of the target repository. In this tutorial the location isC:\CAF_Training\Target\paint.rpd . This is the path to the repository that supports the target Presentation Catalog to which theselected requests will be cloned. CAF requires access to the target repository in order to provide the possible mappings from sourceobjects to target objects. An offline version of the target repository is required. In some situations, CAF may need to modify the targetrepository during the cloning process; for example, in a situation where logical calculations are included in the source requests. If it isnecessary to modify the target repository, a warning message is displayed before the target repository is updated and a backup of theoriginal target repository is saved in the same folder as the target repository with a _backup suffix added to its name.


21/91

12. Enter Administrator as the username and password for the Target Rpd.

13 . In the Target Webcat field, enter the location of the target online Presentation Catalog in the format hostname:port number . In thisexample the target Presentation Catalog is Paint on a local machine, so the hostname:port number is localhost:9 7 04 . This is whereCAF creates cloned copies of the requests you selected in the source Presentation Catalog (samplesales in this example). CAFrequires an online Presentation Catalog to clone the requests.


22/91

14. Enter Administrator as the username and password for the Target Webcat.

15. Click Next .

16. Select Paint as the target subject area.


23/91

17 . Click Next .

Back to Topic

Back to Topic List


In this subtopic you learn how to map columns in the source Presentation Catalog to columns in the target Presentation Catalog.

1. Notice in the required object mappings section that presentation columns are listed on the left. These are the minimum set of basecolumns needed to support the selected source requests. If some requests share the same columns in their design, those columnswill be listed here only once. If some requests use columns that are logical calculations in the repository, then only the basearguments needed to reproduce those logical formulas are listed here. Each object listed in this screen is used at least once in one of the requests you are cloning.


24/91

2. Expand Paint in the right pane to expose the folders and columns in the Paint Presentation Catalog.


25/91

3 . Select C1 Cust Name in the left pane.


26/91


27/91

5. Select the 4-01 Booked Qty (Sum All) column in the left pane.


28/91

6. Double-click Products > UPC in the right pane. A warning message is displayed. If the data types of the source and target columnsare not the same, CAF displays a warning message. You can still proceed with the mapping, but there is a risk that the cloned requestmay not work correctly. The impact of using different data type columns varies depending on the request itself or which data types arematched together. Generally it is advised to comply with the identical data type requirement, unless you are very familiar with thesource request design and understand the consequences of proceeding with mismatched data types.


29/91

7 . Click No to continue.

8. Correct the mapping:

4-01 Booked Qty (Sum All) = Sales Measures > Units


30/91

9. Repeat the steps to add the following mappings to the Mapped Values section. To proceed to next step, all columns in this screenmust be mapped to target columns:

P01 Product = Products > TypeP04 Brand = Products > BrandE01 Employee Name = Markets > Market1-01 Revenue (Sum All) = Sales Measures > Dollars2-01 Billed Qty (Sum All) = Sales Measures > Units3 -01 Booked Amt (Sum All) = Sales Measures > Dollars


31/91

10. Click Save Mapping and save the mapping as training_map in the C:\CAF_Training folder. The Save Mapping button allows detailinformation about mappings to be saved and reused for subsequent cloning processes. This feature is very helpful when multiplecloning processes are required between two environments.


32/91

11. Click OK to verify that the mapping was saved.

12. Click Next to open the Optional object mappings screen. The optional object mappings screen lists all the columns used only by filtersin the source requests. These columns are not mandatory for the cloned requests to function properly. You can choose to providemappings for all of the columns in this screen or for just a subset. Only those columns for which mappings are provided are carriedforward as filter definitions in the target. If a filter column is already listed on Required Object Mapping screen, then its substitutemapping is reused and the column is not listed here in this Optional Column Mapping screen. For the purposes of this exercise, leavethe optional columns unmapped and click Next to proceed.


33/91

Back to Topic

Back to Topic List

Identifying a Path for the Target Requests

In this subtopic you learn how to identify the location in the target Presentation Catalog where the cloned requests will be stored.

1. In the Path for the Target Request(s) field, enter /shared/CAF_Training . This will create a subfolder named CAF_Training in theshared folder of the target Presentation Catalog.


34/91

2. Leave the target request names as they are.

3 . Check the Add Prefix box and enter C1_ as a prefix for the target requests.


35/91

4. Leave Create Dashboard unchecked. In this example you do not want to create a new dashboard with cloned requests. If you did

want to create a new dashboard with each cloned request, then you would click on Create Dashboard and provide the dashboardname. This feature creates one page per cloned request within a single dashboard in the _portal folder of the specified path for thetarget requests. Please note that this process is different from the dashboard cloning process where existing dashboards are used as asource for cloning process. You use the dashboard cloning process later in this tutorial.

5. Notice the message: Cloning the selected objects has no impact on the Target RPD . This means that no logical calculations areused with the requests being cloned, so the target repository does not need to be modified. There may be Answers calculations in therequests, but those calculations are addressed in the Presentation Catalog, not the repository. CAF will recreate the exact same

Answers' calculations in the target requests. Therefore only substitutes for the objects in the Answers formulas are required in the CAFmappings.


36/91

6. Click Finish to open the Log Messages screen. In this screen, CAF displays the detailed log information of the cloning process, which

is also saved in the path indicated at top of the screen. Each cloning session generates a unique log file.

The log sequentially displays the following: column mapping information; changes in the repository per each cloned request; changesin the target Presentation Catalog; and results of the consistency check for the repository, if one was performed. In this example thereare no changes to the repository and no consistency check was performed. You see examples of these log entries later in this tutorial.


37/91

7 . Verify that you receive the message CLONING PROCESS COMPLETE and click OK to close the log file.

8. Leave Catalog Manager open.

Back to Topic

Back to Topic List

Verifying Cloning Results

In this subtopic you use OBI Presentation Services to verify the results of the cloning process.

1. Select Start > All Programs > Oracle Business Intelligence > Presentation Services .

2. Log in as Administrator with password Administrator .


38/91

3 . Verify that you are accessing the Paint application.

4. Click the Answers link.

5. If necessary, click the Catalog tab.

6. In the left pane, expand Shared Folders > CAF_Training . Notice that a new folder, CAF_Training , has been created in the targetPresentation Catalog, the six cloned requests are available in this folder, and each request has the C1_ prefix.

7 . In the right pane notice that the descriptions for the requests include the original description and also identify the cloning process timeand date. This provides the ability to look up the unique log file and identify the details of each cloning process, such as source-to-target column mappings.


39/91

8. Click the C1_8020 request to open it. Notice that the Paint request has the same views, layout, and formatting as the Sample Salesrequest, but now contains Paint data. For example, instead of C1 Cust Name data the request now has District data. This is becauseyou mapped Sample Sales.C1 Cust Name to Paint.Markets.District during the cloning process.

9. Click Modify to view the request criteria for C1_8020 .

10. Notice that the request now uses Paint columns.


40/91

11. Click the Edit Formula button to open the formula for the Rank calculation column.

12. Notice that the formula is now using a Paint column: Sales Measures.Dollars . Recall that in the Sample Sales version of the request,the rank formula used a Sample Sales column: F1 Revenue.1-01 Revenue (Sum All) .

13 . Click Cancel to close the Edit Column Formula dialog box.

14. Leave Answers open for the next topic.

Back to Topic

Back to Topic List

Cloning Dashboards


41/91

The goal of this topic is to use CAF to clone a dashboard from a source Presentation Catalog to a target Presentation Catalog.

Similar to cloning requests, you can clone dashboards by choosing either a single dashboard or multiple dashboards. When you clone a dashboard, thecomplete layout, including pages, sections, views, columns, and formatting, is copied to the target environment. Requests and prompts that areembedded within the dashboard are also cloned into the target environment according to the path provided by the user.

To clone dashboards, perform the following steps:

Selecting the Source Dashboard for Cloning


Identifying a Path for the Target DashboardVerify Cloning Results

Back to Topic List

Selecting the Source Dashboard for Cloning

In this subtopic you learn how to use Catalog Manager and the CAF Wizard to select the dashboard pages you want to clone in the source PresentationCatalog.

1. Return to Catalog Manager , which should still be open to the Sample Sales Presentation Catalog in offline mode.

2. Expand shared > Sample Sales > _portal > 0 3 Tiering and Distribution to view the dashboard pages.

3 . Select all of the dashboard pages in the right pane except for 3 6 Variability . Do not select dashboard layout . The dashboard layoutobject is present in every dashboard folder and should not be cloned. This object holds metadata information about the dashboardsand is not a dashboard page. It is automatically generated by the target OBIEE environment during cloning.


42/91

4. Right-click and select Clone to open the CAF wizard.


43/91

5. Verify that samplesales.rpd is still selected as the Source Rpd.


44/91

6. Enter Administrator as username and password for the Source Rpd.

7 . Verify that paint.rpd is still selected as the Target Rpd.


45/91

8. Enter Administrator as username and password for the Target Rpd.

9. Verify that the Target Webcat is the online Presentation Catalog (Paint). In this tutorial the address is localhost:9 7 04 .


46/91

10. Enter Administrator as username and password for the Target Webcat.


47/91

11. Click Next .

12. Select Paint as the target subject area.


48/91

13 . Click Next to open the Required object mappings screen.


49/91

Back to Topic

Back to Topic List


In this subtopic you learn how to map dashboard columns in the source Presentation Catalog to columns in the target Presentation Catalog.

1. Click Load Mapping and select the saved mapping training_map.txt .


50/91

2. Notice that most of the mapped values are automatically added to the Mapped Values pane. Because most of the required objectmappings are fundamentally the same in the requests and dashboards, you are able to load the mapping you saved earlier whencloning requests, rather than manually selecting each mapping.


51/91

3 . Map the remaining presentation columns:

T02 Per Name Month = Products > UPC T0 3 Per Name Qtr = Products > UPCT05 Per Name Year = Products > UPC

M04 Region = Markets > RegionE05 Manager Name = Markets > Market


52/91

4. Click Next to open the Optional object mappings screen.


53/91

5. Ignore the optional object mappings and click Next to open the Path for Target Request(s) screen.


54/91

Back to Topic

Back to Topic List

Identifying a Path for the Target Dashboard

In this subtopic you learn how to identify the location in the target Presentation Catalog where the cloned dashboard and associated requests will bestored.

1. Leave the Path for Target Request(s) set to /shared/Cloned .


55/91

2. Click Add Prefix and enter C2_ as the prefix for the target requests.

3 . In the Dashboard Name field enter new_dashboard . Notice the message that cloning the selected objects has no impact on the


56/91

Target RPD.

4. Click Finish to open the Log Messages screen. Review the log, which includes mapping information and the step-by-step sequence of tasks performed by CAF. The screenshot shows only a partial view of the Log Messages screen.


57/91

5. Verify that you see the message CLONING PROCESS COMPLETE at the bottom of the log and then click OK to close the LogMessages window.

Back to Topic

Back to Topic List


In this subtopic you use OBI Presentation Services to verify the results of the dashboard cloning process.

1. Return to Presentation Services , which should still be open to Paint.

2. Click Dashboards . Notice that there is now a new dashboard named new_dashboard .


58/91

3 . Click new_dashboard to open the dashboard.

4. Navigate through the dashboard pages and notice that the new dashboard contains all of the cloned pages, but now with Paint datainstead of Sample Sales data. When a dashboard is cloned, all of its content is replicated in the target environment. Dashboard pages,columns, sections, and all formatting are copied to the target Presentation Catalog.

5. Click the 37 Std Dev tab to open the dashboard page. Notice there is an Invalid Link Path . This is because cloning the dashboard didnot resolve the path of content that does not exist in Paint. Navigation and direct target paths are not handled by the cloning tool. CAFdoes not include a hierarchy of everything that this dashboard navigates to. It only clones objects that are directly contained in thecloned dashboard.


59/91

6. Click the Answers link, navigate to the Cloned folder, and observe that all of the cloned objects (requests and prompts) are now

visible in the Presentation Catalog folder. Requests and prompts that are included in the dashboard are also cloned automatically andsaved to the target environment.

Back to Topic

Back to Topic List

Cloning Repository Logical Objects

The goal of this topic is to use CAF to clone repository objects with logical calculations from a source repository to a target repository.

The CAF utility also handles duplication of logical calculations from one repository to another. In this topic you use the CAF_EXP_1 request you createdearlier in this tutorial to demonstrate how CAF exports and imports logical constructs from one OBIEE environment to another

To clone repository logical objects, perform the following steps:

Selecting the Source Request for Cloning

Mapping the Required ColumnsIdentifying a Path for the Target Request

Verify Cloning Results

Modifying the Target Repository

Back to Topic List

Selecting the Source Request for Cloning

1. Return to Catalog Manager , which should still be open to the Sample Sales Presentation Catalog in offline mode.


60/91

2. Expand shared > Sample Sales .

3 . In the right pane, right-click the CAF_EXP_1 request you created earlier and select Clone .


61/91

4. Accept the same details for the source and target repositories, and the target webcat, and enter Administrator as the usernames andpasswords.


62/91

5. Click Next .

6. Select Paint and click Next to navigate to the required object mappings screen.


63/91

Back to Topic

Back to Topic List


1. Create the following mappings:

"Sample Sales".."D0 Time"."T05 Per Name Year" = "Paint".."Periods"."Year""Sample Sales".."D2 Market"."M04 Region" = "Paint".."Markets"."Region""Sample Sales".."F1 Revenue"."1-01 Revenue (Sum All)" = "Paint".."Sales Measures"."Dollars"Sample Sales".."F 3 Bookings"." 3 -01 Booked Amt (Sum All)" = "Paint".."Forecast Measures"."Forecasted Dollars"


64/91

2. Click Next to open the Optional mappings screen. This screen shows the P02 Product Type column that is included in the filter, butnot in the request. In this example, do not map the filter column.


65/91

3 . Click Next to override the optional mappings and open the Path for Target Request(s) screen.


66/91

Back to Topic

Back to Topic List

Identifying a Path for the Target Request

1. Leave the Path for Target Requests set to /shared/Cloned .

2. Notice there is a message indicating that there will be an impact on the repository: Cloning the selected objects will result inchanges to the Target Rpd .


67/91


68/91

4. Click Finish .

5. Review the log, which includes mapping information and the step-by-step sequence of tasks performed by CAF. It indicates that CAFcreated the cloned request with the selected mappings, but it also created new logical objects in the target repository. It created alogical folder named Auto Gen Folder, and a logical column named Auto Gen 1 for the 8-X1 book to Bill Ratio column. It also created acorresponding presentation column. Because CAF modified the target repository it also created a backup of the target rpd. The log alsoindicates that a consistency check was run and that there are no errors.

6. Click OK to close the Log Messages window.

Back to Topic

Back to Topic List


1. Return to Presentation Services , which should still be open to Paint.

2. Click Answers to navigate to the Answers start page.

3 . Expand Shared Folders > Cloned and verify that the CAF_EXP_1 request now exists in the Cloned folder.


69/91

4. Click on CAF_EXP_1 to open the request. Notice that the request cannot be displayed. This is because the modified target Paintrepository is still located in C:\CAF_Training . In a subsequent step you copy the modified repository to the correct Oracle BI Server repository folder and verify results.

5. Click Modify to view the request criteria in Paint. Notice that the request is using the new logical column Auto Gen 1 that wasgenerated by CAF.

Back to Topic

Back to Topic List


70/91

Modifying the Target Repository

Because the cloning process impacted the target repository you must modify the target repository in preparation for the next step, which is synchronizingthe target Presentation Catalog with the target repository.

1. Navigate to C:\CAF_Training\Target . Notice there is a paint_backup.rpd that was created during the cloning process.

2. Double-click the paint.rpd repository file to open it in offline mode. Recall that this is the offline repository that was modified during thecloning process.

3 . Enter Administrator as the username and password.

4. Expand the Paint business model in the Business Model and Mapping layer.


71/91

5. Notice there is an Auto Gen Folder with an Auto Gen 1 column. Logical objects created by CAF are automatically grouped withsequential naming (Auto Gen 1, Auto Gen 2, etc) under a logical layer folder named Auto Gen Folder . Note that Auto Gen Folder hasno logical table source. This is because this folder only carries logical calculations, that is, objects sourced from other existing logicalobjects.


72/91

6. Double-click the Auto Gen 1 column to open its properties dialog box.

7 . Click the General tab.

8. Notice that the Auto Gen 1 column uses Paint objects in its logical calculation.


73/91

9. Notice also that the description contains information about the cloning process. For each created object, CAF replicates thedescription that is present in the source repository and adds a cloning message.


74/91

10. Click Cancel to close the Logical Column dialog box.

11. Expand Paint > Forecast Measures in the Presentation layer and notice that CAF created a corresponding Auto Gen 1 column inthe Presentation layer.

12. In the Business Model and Mapping layer, rename Auto Gen 1 to Forecast to Sales Ratio .

13 . Notice that the Presentation column is automatically updated in Paint > Forecast Measures.


75/91

14. In the Business Model and Mapping layer, drag Forecast to Sales Ratio from the Auto Gen Folder to the Sales Facts folder.

15. Delete Auto Gen Folder in the Business Model and Mapping layer.

16. Select File > Check Global Consistency to open the Consistency Check Manager.

17 . Verify that the repository is consistent before continuing. The repository is consistent if there are no errors or warnings displayed inthe Consistency Check Manager.

18. Close Consistency Check Manager .

19. Leave the repository open.

Back to Topic

Back to Topic List

Synchronizing Presentation Catalogs and Repositories

The goal of this topic is to use the CAF Synchronizer to synchronize the target Presentation Catalog with the target repository after the cloning processis complete.

After the cloning process, requests in the target Presentation Catalog use names of objects that exist in the target repository. However, as you saw inthe previous set of steps, the cloning process that creates new logical objects in target repositories may also result in poor functional naming of the newobjects. For example, after cloning, columns are named Auto Gen 1, Auto Gen 2, and so on. Therefore, you must rename these objects with goodfunctional names to complete the CAF process and to make the request columns intuitive to functional users.

Furthermore, any additional re-arranging or renaming of objects in the target repository impacts its Presentation layer and may therefore break Answers requests that use the renamed objects. This is where the CAF Synchronizer helps. It allows you to automatically fix Answers requests with any


76/91


77/91

4. Save the repository as paint2.rpd in C:\CAF_Training\Target . In order to run the CAF Synchronizer, you must keep a copy of theoriginal target repository. Synchronizer needs the original target repository as a starting point to be able to detect the changes thathappened between the original target repository (paint.rpd) and the modified target repository (paint2.rpd) that requiressynchronization.


78/91


79/91

4. In the URL field, enter the address of the online Presentation Catalog. In this tutorial the address ishttp://localhost:9 7 04/analytics/saw.dll .

5. Enter Administrator as the username and password.

6. Click OK . This opens the online localhost catalog where you have all of the cloned objects as a result of running CAF.


80/91

7 . Navigate to shared > Cloned .

8. Select all of the cloned requests including CAF_EXP_1 . Do not select the dashboard prompts.


81/91

9. Right-click and select Synchronize to open the Synchronize Wizard.


82/91

10. In the Original Rpd field, browse to C:\CAF_Training\Target\paint.rpd .


83/91

11. Enter Administrator as username and password.


84/91

12. In the Modified Rpd field, browse to C:\CAF_Training\Target\paint2.rpd .


85/91

13 . Enter Administrator as username and password. At his point you could select Backup Objects, but for the purposes of this training,leave this unchecked.


86/91

14. Click Finish .

15. Check the log. CAF parses both repositories and detects the modifications between the repositories. For example, Dollars has beenmodified to New Name for Dollars and Auto Gen 1 has been modified to Forecast to Sales Ratio . CAF then synchronizes any of

the requests that use the modified objects and provides the correct name.


87/91

16. Verify that you receive a SYNCHRONIZATION COMPLETE message and click OK to close the log.

17 . Select File > Close Catalog to close the online catalog.

18. Close Catalog Manager.

Back to Topic

Back to Topic List

Verifying Synchronization Results

1. Stop the Oracle BI Server service.

2. Copy paint2.rpd from C:\CAF_Training\Target to \OracleBI\server\Repository .


88/91

3 . Double-click \OracleBI\server\Repository \paint2.rpd to open in offline mode.

4. Enter Administrator as the username and password.

5. Select Manage > Variables to open Variable Manager.

6. Navigate to Repository > Variables and double-click the BI_EE_HOME variable to open the Static Repository Variable dialog box.


89/91

7 . If necessary, change the Default Initializer to the OBIEE home directory. The default is 'd:\OracleBI'. In this training it is changed to 'C:\OracleBI' . This ensures that the repository connection pool points to the correct location of the paint xml files.

8. Click OK to close the Static Repository Variable dialog box.

9. Close Variable Manager .

10. Save and close the paint2 repository. There is no need to check consistency.

11. Open \OracleBI\server\Config\NQSConfig.ini, modify the repository section to open the paint2 repository, and save and closeNQSConfig.ini .

13 . Start the Oracle BI Server service and restart the Oracle BI Presentation Server service.

14. Return to the Paint application which should still be open in Presentation Services.

15. If prompted, log in as Administrator and click Answers to return to the Answers Start Page.

16. Click Reload Server Metadata .


90/91


91/91

19. Click the C2_8020 request.

20. Click Modify and verify the request criteria appear as expected. Dollars has been renamed to New Name for Dollars .

cloning and synchronizing oracle bi requests and dashboards using content accelerator framework

Documents