Previous Topic: New FeaturesNext Topic: Microsoft Project Field Mapping Administration

CA Clarity PPM 14.2 Release Notes › New Features › Advanced Reporting and Data Warehouse

Advanced Reporting and Data Warehouse

Advanced Reporting allows you to create an ad hoc view of CA Clarity PPM data that you can save as a report and share using different formats. You configure each ad hoc view and its corresponding report by selecting the data that you want to include. You can run a report immediately or you can set up a schedule. In either case, you control the output method and format.

The CA Clarity PPM Data Warehouse is the main data source for Advanced Reporting. The Data Warehouse schema is optimized specifically for reporting. The schema includes the Investment, Resource, Portfolio, Timesheet, and Project data. The Data Warehouse is populated at scheduled intervals by jobs that load the relevant data from the CA Clarity PPM database to the Data Warehouse. The Data Warehouse can be extended to include custom objects and attributes.

Note: If you have your own preferred reporting tools, you can use them with the Data Warehouse.

CA Clarity PPM provides a set of domains that contain the most frequently used data. When you create an ad hoc view, you select from a list of the available domains. A domain provides a business view of the CA Clarity PPM Data Warehouse. A domain limits your access to data based on your security permissions. For example, if a user is permitted to access specific projects and resources in CA Clarity PPM, that user can access the same projects and resources in the Advanced Reporting domains. If you add custom objects or attributes to the product, these custom objects and attributes can also be included in the domains.

Note: To view the data that is included in the domains, you must have the PMO Accelerator add-in with Jaspersoft Content installed. For more information, see the PMO Accelerator Product Guide.

You create ad hoc views in the form of charts, tables, and cross tabs that let you analyze data from the domains. You can also use the ad hoc views to generate reports, which you can share, store, or display in the following ways:

Note: Advanced Reporting uses the Jasper Reports Server (which is integrated with CA Clarity PPM) to manage ad hoc views and reports. For information about the Jasper Reports Server, see the Jaspersoft Community web site.

For information about installing, configuring, and using Advanced Reporting and the Data Warehouse, see the Installation Guide, Administration Guide, and Basics User Guide.