Friday, December 28, 2012

Replacing Data Models in Impacted Documents


Overview


This tutorial covers how to use Impact Manager in Workspace to update Interactive Reporting data models. In OBEs 1 through 5 in this series, you learned to create data models in Interactive Reporting Studio to accommodate various database changes. Now you are ready to import the final updated data model into Workspace and replace old data models with this new version.

Scenario


You created an Interactive Reporting document named BMV Datamodel.bqy, which you plan to use to update data models in Workspace. You first need to import the document into Workspace. Next, you need to synchronize metadata to ensure that all Workspace content is harvested. Lastly, you need to configure Impact Manager to replace the data models in Sales1.bqy, Sales2.bqy, and Sales3.bqy with the updated data model in BMV Datamodel.bqy.

Prerequisites


Before starting this tutorial, you should:
1.Complete the first four OBEs in this series.
2.
Import Bookmart Sample Database.oce into Workspace. In Configuration and Management Console (CMC), configure Interactive Reporting Data Access Service to connect to the Bookmart data in Oracle. You created the OCE in OBE 2: Accommodating Database Table and Column Name Changes.
3.
Import Interactive Reporting documents ( Sales1.bqy, Sales2.bqy, and Sales3.bqy) that contain old data models into Workspace at the root directory level. Associate all Query sections with Bookmart Sample Database.oce.
4.Have available BMV Datamodel.bqy, which you last updated in OBE 4: Accommodating Deleted Columns in Databases.

Importing Replacement Data Models


BMV Datamodel.bqy accommodates all database changes. In order for Impact Manager to use this data model, you must import the document into Workspace.
To import BMV Datamodel.bqy into Workspace, perform the following steps:
1.
Log on to Workspace:
a) In a browser window, enter the URL for Workspace, which is http://localhost:19000/workspace.
b) In the User Name and Password boxes, enter the user name and password, and click Log On.
Screenshot for Step
c) Access the Explore module.

2.
In the View pane, right-click the Root directory, and select Import > File.
Screenshot for Step
The General properties page is displayed.

3.
Browse to and select BMV Datamodel.bqy, and click Next.
Screenshot for Step
The Interactive Reporting Properties page is displayed.

4.
For the Query section, select Bookmart Sample Database.oce and Defaults, and click Finish.
Screenshot for Step
BMV Datamodels.bqy is imported into Workspace.

Synchronizing Metadata


In this topic, you synchronize metadata in Workspace. This operation enables you to harvest new documents that have not yet been harvested or that have changed since the documents were last harvested. Documents in Workspace that were opened, modified, and resaved are also harvested. You can harvest immediately or by schedule (date and time).
To synchronize metadata:
1.
In Workspace, select Navigate > Impact Manager > Synchronize Metadata.
Screenshot for Step

2.
Under Synchronize Options, select a scheduling option, and click Submit.
In this example, "Run now" is selected so that the synchronization runs immediately. If you select Schedule, you also need to select a date and time.
Screenshot for Step

3.
Click OK.
Screenshot for Step


Updating Data Models with Impact Manager


You update harvested data models in Workspace to reflect changes in underlying databases. When you update, you complete the following tasks:
1. Decide whether to provide update parameters interactively or through a task definition file. Task definition files are text files that you import into Workspace. They contain one line for each document to be transformed.
2. Optional: Select an original data model to be updated. Do this only if you want the system to find the set of update candidate documents that contain an instance of the selected data model. That is, you want all documents that contain the same topics as the selected replacement data model.
3. Select a replacement data model to replace the appropriate data models found in the update candidate documents.
4. Select update candidates. The system searches for data models that match the required criteria. You then select one or more of the documents that you want to update.
5. Schedule the update request. Transformation requests can run in the background or during off-peak hours.
To update data models in Sales1.bqy, Sales2.bqy, and Sales3.bqy, perform the following steps:
1.
In Workspace, select Navigate > Impact Manager> Update Data Models.
The Specify Data Models page is displayed.
Screenshot for Step

2.
Under Task Description, enter a name for the task; for example, Update Sales Documents.
Screenshot for Step

3.
Select Specify documents and data models interactively.
Screenshot for Step

4.
Select Match the full data model.
Screenshot for Step

5.
Click Browse, and select a file that contains the original data model; for example, Sales1.bqy.
Screenshot for Step

6.
Select the original data model; for example, DataModel (Query).
Screenshot for Step

7.
Click Browse, and select the replacement data model file; for example, BMV Datamodel.bqy.
Screenshot for Step

8.
From the list, select the replacement data model; for example, DataModel (Query).
Screenshot for Step

9.
Click Next.
The Candidates page is displayed, and the sales documents are listed.
Screenshot for Step

10.
Select Sales1.bqySales2.bqy, and Sales3.bqy, and click Next.
Screenshot for Step
The Scheduling page is displayed.

11.
Select a scheduling option, and click Finish.
In this example, the Run now option is selected.
Screenshot for Step
A message is displayed that the update task is submitted.

12.
Click OK.
Screenshot for Step

13.In the Explore module, right-click Sales1.bqy, and select Open As > Interactive Reporting Web Client.
Screenshot for Step

14.
View the data model.
The updated data model is displayed in the Query section.
Screenshot for Step
You successfully configured Impact Manager to replace the data models in Sales1.bqy, Sales2.bqy, and Sales3.bqy.


Summary


In this lesson, you learned how to perform these tasks:
Import replacement data models into Workspace
Synchronize metadata in Workspace
Update data models with Impact Manager