Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Content Management Service
  4. Data Integration Service
  5. Data Integration Service Architecture
  6. Data Integration Service Management
  7. Data Integration Service Grid
  8. Data Integration Service Applications
  9. Metadata Manager Service
  10. Model Repository Service
  11. PowerCenter Integration Service
  12. PowerCenter Integration Service Architecture
  13. High Availability for the PowerCenter Integration Service
  14. PowerCenter Repository Service
  15. PowerCenter Repository Management
  16. PowerExchange Listener Service
  17. PowerExchange Logger Service
  18. Reporting Service
  19. Reporting and Dashboards Service
  20. SAP BW Service
  21. Search Service
  22. System Services
  23. Test Data Manager Service
  24. Web Services Hub
  25. Application Service Upgrade
  26. Application Service Databases
  27. Connecting to Databases from Windows
  28. Connecting to Databases from UNIX
  29. Updating the DynamicSections Parameter of a DB2 Database

Reporting Service Overview

Reporting Service Overview

The Reporting Service is an application service that runs the Data Analyzer application in an Informatica domain. Create and enable a Reporting Service on the
Manage
tab of the Administrator tool.
When you create a Reporting Service, choose the data source to report against:
  • PowerCenter repository. Choose the associated PowerCenter Repository Service and specify the PowerCenter repository details to run PowerCenter Repository Reports.
  • Metadata Manager warehouse. Choose the associated Metadata Manager Service and specify the Metadata Manager warehouse details to run Metadata Manager Reports.
  • Data Profiling warehouse. Choose the Data Profiling option and specify the data profiling warehouse details to run Data Profiling Reports.
  • Other reporting sources. Choose the Other Reporting Sources option and specify the data warehouse details to run custom reports.
Data Analyzer stores metadata for schemas, metrics and attributes, queries, reports, user profiles, and other objects in the Data Analyzer repository. When you create a Reporting Service, specify the Data Analyzer repository details. The Reporting Service configures the Data Analyzer repository with the metadata corresponding to the selected data source.
You can create multiple Reporting Services on the same node. Specify a data source for each Reporting Service. To use multiple data sources with a single Reporting Service, create additional data sources in Data Analyzer. After you create the data sources, follow the instructions in the
Data Analyzer
Schema Designer Guide
to import table definitions and create metrics and attributes for the reports.
When you enable the Reporting Service, the Administrator tool starts Data Analyzer. Click the URL in the Properties view to access Data Analyzer.
The name of the Reporting Service is the name of the Data Analyzer instance and the context path for the Data Analyzer URL. The Data Analyzer context path can include only alphanumeric characters, hyphens (-), and underscores (_). If the name of the Reporting Service includes any other character, PowerCenter replaces the invalid characters with an underscore and the Unicode value of the character. For example, if the name of the Reporting Service is ReportingService#3, the context path of the Data Analyzer URL is the Reporting Service name with the # character replaced with _35. For example:
http://<HostName>:<PortNumber>/ReportingService_353