|
Return to Newsletter Contents
Data Integrator Metadata Reports
by: Tom Hinkle, Consultant, CRCP, Data Integrator
Instructor
The Web-based Metadata Reports application provides several convenient
graphical options for analyzing dependencies, managing job execution
performance, assessing source data quality, and producing documentation for
your Data Integrator projects.
Metadata Reports provide four modules for exploring your metadata:
-
Impact and Lineage Analysis Reports—Allows
you to easily browse,
analyze, and produce reports on the metadata for your Data Integrator
jobs as well as for other Business Objects applications associated with
Data Integrator
-
Operational Dashboard Reports—Provides
several standard graphical
dashboards that allow you to evaluate your job execution performance at
a glance
-
Data Quality Dashboard Reports—Provide
feedback that allows business
users to quickly review, assess, and identify potential inconsistencies or
errors in source data.
-
Auto Documentation Reports—Offers
a convenient way to create printed
documentation for the objects you create in Data Integrator by capturing
critical information so you can see an overview of the entire ETL process.
In addition, the Metadata Integrator collects metadata for Crystal Reports,
Business
Views, Universes, Desktop Intelligence document, and Web Intelligence
documents from the Central Management Server (CMS) and stores the
metadata in the Data Integrator reporting tables.
Impact and Lineage Analysis
The Impact and Lineage Analysis module of Metadata Reports provides a
simple, graphical, and intuitive way to view and navigate through various
dependencies between objects.
Impact and lineage analysis allows you to identify which objects will be
affected if you change or remove other connected objects.
For example for impact analysis, a typical question might be, “If I drop the
source column Region from this table, which targets will be affected?”
For
lineage analysis, the question might be, “Where does the data come from
that populates the Customer_ID column in this target?”
In addition to the objects in your Data Integrator datastores, Metadata Reports
impact and lineage analysis allows you to view the connections to other
objects including Universes, classes and objects, Business Views, Business
Elements and Fields, and reports (Crystal Reports, Desktop Intelligence
documents, and Web Intelligence documents).
Operational dashboard
Operational dashboard reports provide graphical depictions of Data Integrator
job execution statistics. This feedback allows you to view at a glance the
status and performance of your job executions for one or more repositories
over a given time period. You can then use this information to streamline and
monitor your job scheduling and management for maximizing overall
efficiency and performance.
Data Quality dashboard
Data Quality dashboard reports provide graphical depictions that let you
evaluate the reliability of your target data based on the validation rules you
created in your Data Integrator batch jobs. This feedback allows business
users to quickly review, assess, and identify potential inconsistencies or
errors in source data.
Auto Documentation reports provide a convenient and comprehensive way to
create printed documentation for all of the objects you create in Data
Integrator. Auto Documentation reports capture critical information for
understanding your Data Integrator jobs so you can see at a glance the entire
ETL process.
After creating a Data Integrator project, you can use Auto Documentation
reports to quickly create a PDF or Microsoft Word file that captures a
selection of job, work flow, and/or data flow information including graphical
representations and key mapping details.
The types of information provided by Auto Documentation reports include:
-
Object properties—Apply to work flows, data flows, and R/3 data flows
-
Variables and parameters—Apply to jobs, work flows, data flows, and R/3
data flows
-
Table usage—Shows all tables used in this object and its child objects.
For example for a the data flow, table usage information includes
datastores and the source and target tables for each.
-
Thumbnails—An image that reflects the selected object with respect to all
other objects in the parent container. Applies to all objects except jobs.
-
Mapping tree—Applies to data flows
Auto Documentation reports provide a convenient and comprehensive way to
create printed documentation for all of the objects you create in Data
Integrator. Auto Documentation reports capture critical information for
understanding your Data Integrator jobs so you can see at a glance the entire
ETL process.
After creating a Data Integrator project, you can use Auto Documentation
reports to quickly create a PDF or Microsoft Word file that captures a
selection of job, work flow, and/or data flow information including graphical
representations and key mapping details.
The types of information provide by Auto Documentation reports include:
-
Object properties—Apply to work flows, data flows, and R/3 data flows
-
Variables and parameters—Apply to jobs, work flows, data flows, and R/3
data flows
-
Table usage—Shows all tables used in this object and its child objects.
For example for a the data flow, table usage information includes
datastores and the source and target tables for each.
-
Thumbnails—An image that reflects the selected object with respect to all
other objects in the parent container. Applies to all objects except jobs.
-
Mapping tree—Applies to data flows
You can open the Metadata Reports application in several ways:
Data Integrator launches the login page. Enter the same information you
use to log in to the Web Administrator (the default user name is admin
and the default password is admin). Only users with valid
Administrator
login privileges can log in to the Metadata Reports application.
http://computer_name:port/reports
The default port is the same as the Web server (28080).
Data Integrator launches the login page. Enter the same information you
use to log in to the Web Administrator (the default user name is admin
and the default password is admin). Only users with valid
Administrator
login privileges can log in to the Metadata Reports application.
Data Integrator opens the Metadata Reports home page which contains a link
for each module:
-
Impact and Lineage Analysis Reports
-
Operational Dashboard Reports
-
Data Quality Dashboard Reports
-
Auto Documentation Reports
Go to Top |
Return to Newsletter Contents
|
