Skip to content
CA PPM - 15.2
Documentation powered by DocOps

Advanced Reporting with Jaspersoft

Last update March 8, 2019

Learn about CA PPM Advanced Reporting with Jaspersoft, reporting best practices, and the Jaspersoft Community. Advanced Reporting with Jaspersoft allows you to create ad hoc views of CA PPM data. You can save the information as a report, display a dashboard, or share it 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 recurring schedule. In either case, you control the output method and delivery format.



Tip: Restricted documentation pages are hidden until you log in. To view more information, click Sign In. At minimum, a Basic Access account is required. Registration takes only a few seconds and provides you with access to the CA PPM online community. More topics about reporting are available in the English edition of the documentation.


In this new release, Jaspersoft provides embeddable software improvements to provide developers with the building blocks to create their own advanced reporting solution with CA PPM.

Additional Resources

What's New in Jaspersoft Version 7.1 for CA PPM?

  • New Visualize.js: All new support for embedding ad hoc views with hyperlink support and CSS inheritance. The visualize.js improvements are designed to deliver a more immersive embedded reporting experience. No or low-code components such as the interactive report viewer, dashboards, and input controls reduce reliance on Jaspersoft Studio for report design.
  • New Ad Hoc Views: This release delivers improvements to configurable ad hoc components. Allowing infinite data scrolling on dom elements has greatly improved performance and reduced memory signatures. This release also provides new ways to view aggregate time series data. Ad hoc views can now include calculations on time series components and inherit CSS styling. Improved domain support now permits field sorting, group listing, and filters with AND/OR conditions. Ad hoc view enhancements also include an option to remove missing items from ad hoc views when they are removed from a domain. You can also define basic time balance properties on measures and group by the day of the week.
  • New Jaspersoft Studio: New and improved data source support for domains and TIBCO Spotfire® information links. Jaspersoft Studio now provides an evaluation time feature for parameters, has a new UI to discover element properties, and uses spreadsheet layouts as an option for a better user experience. Users can now use Raster (PNG) rendering of custom visualization components to avoid having to convert them into SVG images.
  • Improved JasperMobile App Experience: Improved native app support for hyperlinked reports.
  • Enhancements: For JasperReports engine, users now can use simple text in field property expressions. Create a regular expression that validates the queries defined for the domain-derived tables. TIBCO discontinued JExcelAPI support and also removed the HTML and XHTML exporter. Users now can use TIBCO Datasource Visualization JDBC driver to provide data to Jaspersoft Studio and TIBCO JasperReports Server domains. 

  • Compatibility: In this release, TIBCO provides native Java 8 support and drops support for Java 7, SOAP APIs, and REST API v1.0. CA introduces support for Microsoft SQL Server 2016 for reporting.

  • Security Fixes: A number of fixes are provided including a mechanism to protect against clickjacking attacks. See Known Issues Addressed in this Release in the Jaspersoft Release Notes from TIBCO.

Tip: If you built a custom integration using SOAP APIs or the REST API v1.0, TIBCO requires that you retrofit and convert your code for those components to use REST V2 in order to upgrade to Jaspersoft 7.1.0.

Tip: If you are implementing a custom REST API integration with Jaspersoft, and you encounter an issue, remove the | character and use %7c instead. Jaspersoft JRS-11883 notes that some application servers, such as Tomcat, are ending their support of the pipe character (|), which delimits a username and organization when they are passed as a URL to the server. The application server returns an illegal character error for pipe characters. TIBCO examples and documentation now use %7c instead of pipe.

For example, instead of:

  homeFlow&j_username=jasperadmin|organization_1

we now use:

  homeFlow&j_username=jasperadmin%7Corganization_1

Video: Jaspersoft 7.1 Overview Tutorial

Tip: To play videos in full-screen mode, click the YouTube logo. 

Video: Jaspersoft 7.1 Ad Hoc View Tutorial

Video: Jaspersoft 7.1 Domains Tutorial

The following video is provided by CA Technologies.

Join Alyce Reopelle, Global EMP Governance Manager, Brinks and Kevin Hill, Manager, Software Engineering, Xerox for this panel discussion on Migrating to CA PPM and Advanced Reporting. (Note: CA PPM 14.2 introduced Jaspersoft Advanced Reporting. Today, supported releases include CA PPM 15.1 or higher with Jaspersoft 6.4.2 or 7.1.)

This video provides an opportunity to hear directly from customers who have successfully migrated to CA Project & Portfolio Management (CA PPM) on a global scale and are taking advantage of the new advanced reporting features. In this panel discussion you'll hear from leadership at Xerox and Brinks as they discuss their upgrade to CA PPM for their global operations including their use of multi-currency and multi-language as well as advanced use of the new reporting functionality.

Getting Started with Advanced Reporting

Prerequisites: To manage ad hoc views, reports, and dashboards, your administrator sets up Advanced Reporting for you and grants you access rights.

  • If you do not see the Advanced Reporting menu link in CA PPM when you click Home, Personal, contact your administrator.
  • To work with the Advanced Reporting content, install it in your target environment.
  • Verify that your administrator has installed the PMO Accelerator.  

Training: The following training is recommended for all users, designers, and administrators:

  • CA Education Courses and Learning Content

  • TIBCO Jaspersoft Online Learning Portal: With free access to the TIBCO Jaspersoft Online Learning Portal (JS OLP), you can empower yourself to improve your Jaspersoft skills anywhere, anytime. To register for Jaspersoft Online Learning Portal Access, visit the CA Marketplace. TIBCO sends you an email message with your login credentials and a recommended list of courses by job role.

Resources: As a report designer or administrator, review the following resources:

  • Advanced Reporting Support Index: Visit this page to learn about popular issues, resolutions, and workarounds.

  • Jaspersoft Community: Tutorials and tips.

  • Oracle and SQL Database Performance Whitepapers: To establish performance benchmarks and validate system stability, CA Technologies conducted a series of tests for CA PPM. The data warehouse is optimized for reporting and analytics, and is on a separate schema from the CA PPM database. The data warehouse is populated at scheduled intervals by an ETL job. To help you plan for an upgrade, you can view examples of expected growth rates and loading times which is based on existing database sizes. See the Reference section of the English edition of the documentation.

  • To help you plan for a new installation or upgrade with Advanced Reporting, refer to the deployment architecture examples in the sizing guide for CA PPM 15.x. See Installing and Upgrading in the English edition of the documentation.

Important! The Load Data Warehouse job determines the freshness of the data in the data warehouse. Running this job with great frequency impacts performance; not running it often enough yields stale data. We recommend that you run this job only once every day during non-peak hours. For more information, see Jobs Reference in the English edition of the documentation.

Advanced Reporting Components

The following image shows the Advanced Reporting components:

Image showing the Advanced Reporting components

CA PPM Data Warehouse

The CA PPM data warehouse is the main data source for the advanced reporting features. The data warehouse schema is optimized 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 application database. The data warehouse can be extended to include custom objects and attributes.

The application provides a set of domains that contains the most common 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 data warehouse. A domain limits your access to data based on your security permissions. A user who can access specific projects and resources in CA PPM 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.

To view the domains and reports, you must have the PMO Accelerator add-in installed with the required Jaspersoft Advanced Reporting content.

You create ad hoc views in the form of charts, tables, and crosstabs that let you analyze data from the domains. You can also use the ad hoc views to generate and share reports.

Ad Hoc Views and Reports

Advanced Reporting lets you create ad hoc views of your project and portfolio data. You can use the ad hoc views in the following ways:

  • Create a dashboard of multiple related views.
  • Save the views as reports.
  • Export or email the reports as PDF, Word, Excel, PowerPoint, and other file formats
  • Display multiple related reports on a dashboard.

You customize each ad hoc view and report by selecting the domains and fields that you want to include.

The integrated JasperReports Server manages ad hoc views, reports, and dashboards. When you select the Advanced Reporting option from the Home menu, the Advanced Reporting page appears. This page, and all pages that are opened from this page, are based on the Jaspersoft application.

Note: For information about using Jaspersoft, access the Jaspersoft Community website and click the Documentation link. On the Documentation page, select the version of Jaspersoft that corresponds to your CA PPM release. Then click the link for the JasperReports Server User Guide. Refer to the CA PPM Release Notes for the Jaspersoft version that corresponds to your release.

Video: Ad-Hoc Reporting with Jaspersoft

The following third-party video is provided by WinMill Software. This video is provided by CA Technologies “AS IS” and without warranty.

Tip! To play this video in full screen, click the YouTube logo at the bottom of the video. 

Create an Ad Hoc View and Report

Use Advanced Reporting to create ad hoc views and reports by selecting fields from the domains. You can then run the reports or you can place the reports on a dashboard to monitor status and progress.

Follow these steps:

  1. Open Home, and from Personal, click Advanced Reporting.
    The Advanced Reporting page opens. You see links to the different Advanced Reporting functions (in blocks). The functions that you can see and access depend on your user role. The following blocks require explanation:
    • Ad Hoc Views
      Create a limited view of your data that you can use to prepare reports or access a list of existing ad hoc views.
    • Reports
      Create and format reports from existing ad hoc views or access a list of existing reports.
  2. Click the Ad Hoc Views, Create link, select a domain, and click Choose Data.

    Note: Click the Ad Hoc Views, View List link to see the existing ad hoc views that you can access.
  3. Select the domain fields that you want to have available for your ad hoc view. Click Table, Chart, or Crosstab (depending on the format that you want).

    Important! We do not recommend that you select all fields in the domain. For best performance, use the following guidelines to create smaller views:

    For the Investment Management, Project Management, Application Management, Idea Management, and Resource Management domains, select one metric set for each view. The metric sets are Summary, Weekly, Calendar, and Fiscal.

    For the Financial Management domain, select one set for each view. The sets are Financial Transaction and Plan Data.

    For the Time Management domain, select one set for each view. The sets are Missing Time and Timesheets.

  4. Create an ad hoc view by selecting fields and measures and adding (dragging) them to the new ad hoc view.
  5. Save the ad hoc view.
    You can save the ad hoc view to the Shared folder. If you save to the Shared folder, other users can access your ad hoc view.

  6. (Optional) Create a report when you save the ad hoc view. Reports allow you to use scheduling and more formatting options.

    Note: The Advanced Reporting features use the JasperReports Server. For information about using Jaspersoft with views, reports, and dashboards, access the Jaspersoft Community website and click the Documentation link. On the Documentation page, select the version of Jaspersoft that corresponds to your CA PPM release. Then click the link for the JasperReports Server User Guide. See the CA PPM Release Notes for the Jaspersoft version that corresponds to your CA PPM release.

Run or Schedule an Advanced Report

Advanced Reporting lets you run, schedule, and manage scheduled reports that are based on CA PPM data. You can schedule reports with different output options (for example, PDF or Excel) and email reports to people that you want to notify.

To run and schedule advanced reports, verify that you meet the following prerequisites. If you do not, contact your administrator.

  • You can see the Advanced Reporting link in the Personal menu under Home.
  • A list of reports exists.

You can run a report immediately or you can schedule it to run at a specific interval and frequency. You can also manage your scheduled reports by monitoring the list of scheduled reports, changing schedules, or deleting schedules.

Important! Your report output cannot exceed 500 pages. This limit applies to each output format that you select. As a best practice, we recommend that you filter the report to limit the output data. Do not use reports to extract large volumes of data.

Follow these steps:

  1. Open Home, and from Personal, click Advanced Reporting.
    The Advanced Reporting page opens. You see links to the different Advanced Reporting functions (in blocks). The functions that you can see and access depend on your user role. The following block requires explanation:
    • Reports
      Create and format reports from existing ad hoc views or access a list of existing reports.
  2. On the Reports block, click View List.
    A list of reports to which you have permissions appears.
  3. Run a report immediately by selecting and opening a report and entering values for the Options on the left. Click Apply.

    Note: The Options act as filters to focus the report on only the data that you want to see.
  4. To schedule a report to run as a job, right-click the report name and select Schedule. Click Create Schedule.
    The New Schedule page opens with the Schedule tab selected. The following image shows an example of this page.
    This image illustrates the Advanced Reporting report scheduling page.

    1. Select a schedule definition using a Simple or Calendar recurrence schedule.
    2. Select parameters, which are similar to the report filter options.
    3. Select output options (for example, PDF, Excel, and PowerPoint) and distribution methods. You can also specify a locale. When the scheduled report runs, the report is presented in the specified language.

      Formats

      Select a maximum of two options (for example, Power point and Word, or PDF and Excel).

      Output to Repository

      Browse to select the Shared folder (or a subfolder) or your own user folder (under Users). If you save to the Shared folder, other users can access your report. Only you can access the report if you save to your own user folder.

       
      Output to Repository Examples:
      • /shared/reports
      • /users/username
      We do not recommend that you save your report to the CA PPM folder or any of its subfolders. These folders are overwritten during a system upgrade, and your reports are then lost.
    4. Select the notifications that you want to send when the scheduler runs. The notifications can include the report as an email attachment.

      Email Notification To, CC, or BCC

      Enter email addresses, up to a maximum of 100 characters.  If you are sending the report to a large number of users, separate email addresses with commas. You can also enter email aliases, which we recommend.

  5. Click Save.

  6. Manage your scheduled reports by changing or deleting the scheduled jobs.

Video: Add Custom Attributes to Reports with Jaspersoft

The following third-party video is provided by WinMill Software. This video is provided by CA Technologies “AS IS” and without warranty.

Tip! To play this video in full screen, click the YouTube logo to the right of Settings at the bottom of the video. 

Recently Viewed Items and Modified Items

Access events are enabled for a maximum of seven days. As an Advanced Reporting user, you can see the recently viewed items and the modified items from the following locations:

  • Recently Viewed Items section on the Advanced Reporting Home page
  • Modified by me section under Advanced Reporting Home, View, Search Results

The items appear for up to seven days from the date you accessed or modified the reporting item. Say you modify the Application Assessment Analysis report today, then the report appears under the Modified by me items for the next seven days starting today. On the eighth day, the report no longer appears under Recently Viewed Items.

Task Data in the Data Warehouse

Beginning with Release 15.4, the data warehouse began including fields for tasks, phases, and milestones as seen on the new project task board. The stored data includes field names, task board values, columns, colors, task card position and color, and to-do items. You can develop reports on the following new data warehouse task board tables:

  • DWH_INV_BOARD: This table stores each task board as a row. The table includes a relationship back to the linked parent object.
  • DWH_INV_BOARD_LANE: This table stores every lane (column) on the board. Attributes include the lane level, position (sequence), and orientation.
  • DWH_INV_BOARD_CARD: This table stores basic data about every task card on the board. Attributes include the card color and position (sequence).

The Task Owner field also appears in its own column in the dwh_inv_task table.

Roadmap Data in the Data Warehouse

Release 15.4 also added thirteen (13) new tables in the data warehouse to support the new Roadmapping features:

DWH_CMN_SCENARIO DWH_LKP_ROADMAP_STATUS
DWH_CMN_SCENARIO_FACTS DWH_LKP_ROADMAP_TYPE
DWH_RDM_ROADMAP DWH_LKP_RDM_MUST_HAVE
DWH_RDM_ROADMAP_LN
DWH_RDM_PICKLIST
DWH_RDM_PICKLIST_LN
DWH_RDM_ROADMAP_ITEM
DWH_RDM_ROADMAP_ITEM_LN
DWH_RDM_ITEM_POSITION
DWH_RDM_ITEM_SUMMARY_FACTS

The following calculated attributes for the Roadmap Item object are also included:

  • Remaining Capacity = Capacity − Actual Capacity
  • Remaining Capital Cost = Capital Cost − Actual Capital Cost
  • Remaining Operating Cost = Operating Cost − Actual Operating Cost
  • Total Actual Cost = Actual Capital Cost + Actual Operating Cost
  • Total Cost = Capital Cost + Operating Cost
  • Total Remaining Cost = Total Cost − Total Actual Cost

Resource Team Data in the Data Warehouse

Release 15.5.1 added two (2) more tables in the data warehouse for the Team object:

   DWH_INV_TEAM_DEF
   DWH_INV_TEAM_MEMBER

The following section summarizes these changes:

DWH_CMN_SCENARIO:

  • One row for every scenario

DWH_CMN_SCENARIO_FACTS:

  • Contains summary level facts
  • One row for every fact type for a scenario target or goal

DWH_RDM_ROADMAP:

  • One row for every roadmap

DWH_RDM_ROADMAP_LN

  • One row for each roadmap and language

DWH_RDM_PICKLIST

  • One row for each value in a roadmap picklist

DWH_RDM_PICKLIST_LN

  • One row for each roadmap picklist value and language

DWH_RDM_ROADMAP_ITEM

  • One row for each roadmap item

DWH_RDM_ROADMAP_ITEM_LN

  • One row for each roadmap item and language

DWH_RDM_ITEM_SUMMARY_FACTS

  • Contains summary level facts
  • One row for each roadmap item

DWH_RDM_ITEM_POSITION

  • For roadmap items, stores each picklist, the selected picklist value, and position

DWH_LKP_ROADMAP_STATUS

  • Lookup table for roadmap status
  • One row for each roadmap status and language

DWH_LKP_ROADMAP_TYPE

  • Lookup table for roadmap types
  • One row for each roadmap type and language

DWH_LKP_RDM_MUST_HAVE:

  • Lookup table for roadmap must haves
  • One row for each roadmap must-have and language

Two (2) New Tables in the Data Warehouse for the Team object in 15.5.1:

In 15.5.1, we added 2 new columns to the DWH_RES_RESOURCE dimension table :

  • TEAM_DEF_KEY
  • IS_TEAM

This table contains one row for each resource, including a team resource.

  


Advanced Reporting Domains

CA PPM provides a set of domains that contains the most frequently used product data. A domain provides a business view of the CA PPM data warehouse. You select a domain from the ad hoc viewer when you build your ad hoc views. A domain limits your access to data based on your security permissions.

The domain fields are organized into sets and items. The sets act like folders that you can expand to view the items. Some examples of domain sets include the General and the OBS sets. For descriptions of the domain fields, see the Advanced Reporting and Database Schema Index page on CA Support Online.

Custom attributes are listed and are viewable if they are enabled for the data warehouse. Each domain has its own custom attributes.

Important! We do not recommend that you change the domains that are provided with the product. To modify a product-provided domain, copy the domain, place it in another location in the repository, and make your changes in the copied version. However, the dynamic domain updates that CA PPM performs are not reflected in your copied versions. We recommend that you request enhancements to the product domains, instead of making these changes yourself.




Domain Terminology

The following terms are commonly used with the domain descriptions:

Sets and Items. The domains are organized into sets and items. The sets act like folders that you can expand and view the items. Some examples of domain sets include the General and the OBS sets. Items include fields and measures.

Fields. Items that display qualitative information, such as name or location, are fields.

Measures. Items that display numeric values or aggregate values are measures. Measures are the quantitative values of a record, such as an amount. In domains, all items that are based on numeric fields are designated as measures. The items in Measures are numeric fields or items for which you can do mathematical calculations.

Ad Hoc Viewer and Editor. The Ad Hoc viewer and editor is the interactive designer for viewing, creating and editing an ad hoc view. With an ad hoc view, you can explore and analyze data. Ad hoc views can also be used to create content for reports.

Common Characteristics of Advanced Reporting Domains

The following major characteristics apply to all Advanced Reporting domains. See the descriptions of the individual domains for information that is domain-specific.

  • Object Domains. Domains are provided for the most frequently used objects, including the new product investment objects (NPIOs), such as Ideas and Applications. In each domain, you can see only the product data that you have permission to view.
    When viewing a domain in the ad hoc editor, the Fields section of the left panel lists all field properties (such as Investment names, OBS, text fields, and dates). The Measures section of the left panel lists all numeric amounts that are related to the fields (such as hours and costs). The items in Measures are fields for which you can do mathematical calculations.
  • Internal IDs. Each domain contains an Internal ID set. You use internal IDs for building dashboards. Internal IDs are primarily used as filters by report developers and dashboard developers. These IDs, which are not used in ad hoc views, are the same across all domains. You can map these IDs to input controls and you can use them for filtering on dashboards. 
    Internal IDs are related to objects, not domains. If Investment data exists in multiple domains, the same Investment key is available in each domain.

    Note: Dashboards are not provided with CA PPM. See the Jaspersoft documentation for information about how to build dashboards.
  • Custom Folder. The Custom folder appears in a domain if you have custom fields or objects (related to the domain objects) that are data warehouse enabled. To verify that your custom fields and objects are data warehouse enabled, see your administrator. The Custom folders also include add-in fields. The Custom folder always appears as the first set under each object (after the list of object fields). If you have multiple objects in a domain, the Custom folder appears under each object folder. For example, the Team object includes its own custom team fields in a Custom folder under the Team folder.
    If you add custom fields to an object (or if you install an add-in with custom fields) and the fields are data warehouse enabled, custom sets are created in the corresponding domains. The custom fields are included in the Custom sets under the related object.

    Note: If a custom object or subobject has a lookup attribute, the key for it is included in the Internal IDs folder under the Custom folder.
  • Period Type. When you select period types, select the same period type for both Fields (top of left panel on Advanced Reporting page) and Measures (bottom of left panel). Selecting different period types for Fields and Measures can produce unexpected results.
  • Domain Sets. Domains are organized into sets and field items. The sets act like folders that you can expand to view the field items. Some examples of sets are the General and the OBS sets.
  • Domain Security. You have access to specific domains based on your role. When you open Advanced Reporting, you see only the domains that you can access. However, you may not have access to all data in the domains that you can access. When you view a domain that you can access, you see all object sets and fields in that domain. However, the data that appears for the objects and fields depends on your access rights.
  • Date Fields. Most of the dates in the domains are business dates that are displayed without timestamps and time zone conversions. The exceptions are the system dates, which display date and time and have time zone conversions applied to them. The system dates include Created Date, Last Updated Date, and Warehouse Updated Date.
  • PMO Accelerator Fields. The PMO Accelerator fields are dynamically included in the domains (similar to custom attributes). However, the internal IDs of the PMO Accelerator fields are renamed when they are included in the data warehouse and the domains. The renaming of the internal IDs occurs only for PMO Accelerator fields. All other add-in fields have the same behavior as the custom attributes.

Investment Management Domain

The Investment Management domain includes information about investments (for all investment types) and their corresponding teams. This domain only includes information that is common to all investment types. For example, no information about assignments is included.

The Investment Management domain includes financial summary data for Investments, but not detailed financial planning or actual transaction data. The detailed financial planning and actual transaction data is included in the Financial Management domain.

Custom fields that you add to the Investment object in CA PPM appear in the Investment Management domain (in the Custom set under the Investment set). If you add custom fields to the Team object in CA PPM, those fields appear in the Investment Management domain, Custom set under the Team set.

Custom subobjects that you add to the Investment object appear under the Custom set in their own subobject folder (set), for example, “Country”. The name of the subobject set is the same as the subobject name.

The Investment Management domain contains two main types of data: investment-level financial data (summarized for the total Investment and divided into periods) and team data (at the team level and by calendar periods). The domain has general information, financial information, OBS information, and team information for all team members in an investment.

The Investment Management domain does not have detailed Cost Plan or actual transaction detail data. See the Financial Management domain for that information.

Data security. Data security is determined by investment-level access rights. If you have rights to view an investment in CA PPM, then you see all data that is related to that investment in this domain. You can also view all subobject data that is enabled for the data warehouse.

Do not mix object types when selecting from Fields and Measures. If you select Investment Name in the Fields area, select a total under the Investment Totals in the Measures area. Selecting a total from a different Measures object category (for example, Team Totals) could produce unexpected results. For Investment data, use investment fields and investment measures. To use Team data when creating an ad hoc view, select a team member field from the Team folder under Fields. Use a team amount from the Team folder under Measures. In general, use Investment data (Fields) with Investment metrics (Measures) and use Team data (Fields) with Team metrics (Measures).

Use Team data when you want specific data about a team and its members (for example, resources or allocation start dates).

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making ad hoc view selections. For example, use calendar period measures (Measures section, left panel) for calendar period fields (Fields section, left panel). Use fiscal period measures (Measures section) for fiscal period fields (Fields section). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Portfolios. The Investment Management domain includes portfolios (contents and properties). You can use the portfolios to filter and group the investment data by portfolio when building ad hoc views.

For example, you created a portfolio in CA PPM with 100 investments. In the Investment Management domain, you add Investment Name to the ad-hoc view (drag Investment Name from Fields to Columns in the New Ad Hoc View). Then drag Portfolio Name (from Fields) to the Filters, select the portfolio (that you created with 100 investments) from the drop-down, and click Apply. The ad hoc view now only shows the 100 investments in that selected portfolio. In this way, you are using Portfolios as a filtering method of reporting on your investment data.

You can also group your data by portfolio in the Investment Management domain. For example, you want to see the Total EAC Hours for the investments in each portfolio. You add (drag) Investment Name from the Fields area to Columns in the New Ad Hoc View. Then you drag Total EAC Hours from the Investment Totals in the Measures area to Columns in the New Ad Hoc View. Then you add Portfolio Name (from Fields) to Groups in the New Ad Hoc View. Your data is shown organized by portfolio in the format you selected (table, chart, pie diagram).

In the Investment Management domain, you are working with actual up-to-date investment data. You are not using the portfolio investment snapshot of the data that you use during portfolio planning in CA PPM. Portfolio planning uses a copy of the actual investment data. Therefore, the Investment Management domain data does not match the data in the CA PPM portfolios that you use for portfolio planning. For more information about portfolio planning, see Portfolio Management.

Custom Fields. If you have custom fields that are related to investments, these fields appear in a Custom folder in the Investment Management domain. This domain can have multiple Custom folders. For example, Team custom fields appear in the Team Custom folder.

Application Management Domain

The Application Management domain contains information about the investments, teams, and financials that are related to applications. Items that apply only to applications are included in this domain.

The Application Management domain contains two main types of data: investment-level financial data (summarized for the total Investment and divided into periods) and team data (at the team level and by calendar periods). The domain has general information, financial information, OBS information, and team information for all team members in an investment.

The Application Management domain does not have detailed Cost Plan or actual transaction detail data. See the Financial Management domain for that information.

Data security. Data security is determined by application-level access rights. If you have rights to view an application in CA PPM, then you see all data that is related to that application in this domain, including all subobject data that is enabled for the data warehouse.

Do not mix object types when selecting from Fields and Measures. If you select Investment Name in the Fields area, select a total under the Investment Totals in the Measures area. Selecting a total from a different Measures object category (for example, Team Totals) could produce unexpected results. For Investment data, use investment fields and investment measures. To use Team data when creating an ad hoc view, select a team member field from the Team folder under Fields. Use a team amount from the Team folder under Measures. In general, use Investment data (Fields) with Investment metrics (Measures) and use Team data (Fields) with Team metrics (Measures).

Use Team data when you want specific data about a team and its members (for example, resources or allocation start dates). However, for Baseline hours, do not use Team data. You can find total Baseline hours summed under Investment data.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making ad hoc view selections. For example, use calendar period measures (Measures section) for calendar period fields (Fields area) and use fiscal period measures (Measures area) for fiscal period fields (Fields section). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Portfolios. The Application Management domain includes portfolios (contents and properties). You can use the portfolios to filter and group the investment data by portfolio when building ad hoc views.

In the Application Management domain, you are working with your actual up-to-date investment data (not a copy of the data as you use when doing portfolio planning in CA PPM).

For example, you created a portfolio in CA PPM with 100 investments. In the Application Management domain, you add Investment Name to the ad-hoc view (drag Investment Name from Fields to Columns in the New Ad Hoc View). Then drag Portfolio Name (from Fields) to the Filters, select the portfolio (that you created with 100 investments) from the drop-down, and click Apply. The ad hoc view now only shows the 100 investments in that selected portfolio. In this way, you are using Portfolios as a filtering method of reporting on your investment data.

You can also group your data by portfolio in the Application Management domain. For example, you want to see the Total EAC Hours for the investments in each portfolio. You add (drag) Investment Name from the Fields area to Columns in the New Ad Hoc View. Then you drag Total EAC Hours from the Investment Totals in the Measures area to Columns in the New Ad Hoc View. Then you add Portfolio Name (from Fields) to Groups in the New Ad Hoc View. Your data is shown organized by portfolio in the format you selected (table, chart, pie diagram).

In the Application Management domain, you are working with actual up-to-date investment data. You are not using a copy of the data as you use during portfolio planning in CA PPM. Therefore, the Application Management domain data does not match the data in the CA PPM portfolios that you use for portfolio planning. Portfolio planning uses a copy of the actual investment data.

Custom Fields. If you have custom fields that are related to applications, these fields appear in a Custom folder in the Application Management domain. This domain can have multiple Custom folders. For example, Team custom fields appear in the Team Custom folder.

Idea Management Domain

The Idea Management domain contains information about the investments, teams, and financials that are related to Ideas. Fields that apply only to ideas are included in this domain.

The Idea Management domain contains two main types of data: investment-level financial data (summarized for the total Investment and divided into periods) and team data (at the team level and by calendar periods). The domain has general information, financial information, OBS information, and team information for all team members in an investment.

The Idea Management domain does not have detailed Cost Plan or actual transaction detail data. See the Financial Management domain for that information.

Data security. Data security is determined by idea-level access rights. If you have rights to view an idea in CA PPM, then you see all data that is related to that idea in this domain, including all subobject data that is enabled for the data warehouse.

Do not mix object types when selecting from Fields and Measures. If you select Investment Name in the Fields area, select a total under the Investment Totals in the Measures area. Selecting a total from a different Measures object category (for example, Team Totals) could produce unexpected results. For Investment data, use investment fields and investment measures. To use Team data when creating an ad hoc view, select a team member field from the Team folder under Fields. Use a team amount from the Team folder under Measures. In general, use Investment data (Fields) with Investment metrics (Measures) and use Team data (Fields) with Team metrics (Measures).

Use Team data when you want specific data about a team and its members (for example, resources or allocation start dates). However, for Baseline hours, do not use Team data. You can find total Baseline hours summed under Investment data.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making ad hoc view selections. For example, use calendar period measures (Measures area) for calendar period fields (Fields area) and use fiscal period measures (Measures section) for fiscal period fields (Fields section). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Portfolios. The Idea Management domain includes portfolios (contents and properties). You can use the portfolios to filter and group the investment data by portfolio when building ad hoc views.

For example, you created a portfolio in CA PPM with 100 investments. In the Idea Management domain, you add Investment Name to the ad-hoc view (drag Investment Name from Fields to Columns in the New Ad Hoc View). Then drag Portfolio Name (from Fields) to the Filters, select the portfolio (that you created with 100 investments) from the drop-down, and click Apply. The ad hoc view now only shows the 100 investments in that selected portfolio. In this way, you are using Portfolios as a filtering method of reporting on your investment data.

You can also group your data by portfolio in the Idea Management domain. For example, you want to see the Total EAC Hours for the investments in each portfolio. You add (drag) Investment Name from the Fields area to Columns in the New Ad Hoc View. Then you drag Total EAC Hours from the Investment Totals in the Measures area to Columns in the New Ad Hoc View. Then you add Portfolio Name (from Fields) to Groups in the New Ad Hoc View. Your data is shown organized by portfolio in the format you selected (table, chart, pie diagram).

In the Idea Management domain, you are working with actual up-to-date investment data. You are not using a copy of the data as you use during portfolio planning in CA PPM. Therefore, the Idea Management domain data does not match the data in the CA PPM portfolios that you use for portfolio planning. Portfolio planning uses a copy of the actual investment data.

Custom Fields. If you have custom fields that are related to ideas, these fields appear in a Custom folder in the Idea Management domain. This domain can have multiple Custom folders. For example, Team custom fields appear in the Team Custom folder.

Project Management Domain

The Project Management domain contains information about projects and programs that are related to the Project object. This information includes investments, teams, financials, issues, risks, and change requests. Change requests include metrics (under Measures), but issues and risks do not include metrics. This domain also contains tasks and assignments, with summary-level data (totals) for both objects. The financial attributes in this domain are project summary level and not cost plan level. You can find the detailed financial information at the cost plan level in the Financial Management domain.

Custom attributes and subobjects for the investment and project objects are included in this domain. They appear combined in a Custom set. No distinction exists between the attributes and subobjects that belong to the investment and those that belong to the project.

This domain includes properties that apply specifically to the Project object. These properties appear in the General set.

The Portfolio properties are used for filtering projects by portfolios. You can see the projects that are associated with each portfolio. This domain does not contain aggregated data.

The Project Management domain contains two main types of data: investment-level financial data (summarized for the total Investment and divided into periods) and team data (at the team level and by calendar periods). The domain has general information, financial information, OBS information, and team information for all team members in an investment.

The Project Management domain does not have detailed Cost Plan or actual transaction detail data. See the Financial Management domain for that information.

Data security. Data security is determined by project-level access rights. If you have rights to view a project in CA PPM, then you see all data that is related to that project in this domain, including all subobject data that is enabled for the data warehouse.

Do not mix object types when selecting from Fields and Measures. If you select Investment Name in the Fields area, select a total under the Investment Totals in the Measures area. Selecting a total from a different Measures object category (for example, Team Totals) could produce unexpected results. For Investment data, use investment fields and investment measures. To use Team data when creating an ad hoc view, select a team member field from the Team folder under Fields and use a team amount from the Team folder under Measures. In general, use Investment data (Fields) with Investment metrics (Measures) and use Team data (Fields) with Team metrics (Measures).

Use Team data when you want specific data about a team and its members (for example, resources or allocation start dates). However, for Baseline hours, do not use Team data. You can find total Baseline hours summed under Investment data.

Note: If you want to add a task to an ad hoc view and you want to view the data by resource and task, add the Assignment Resource to the view. If you add the Team Resource (instead of the Assignment Resource), the resulting data is inaccurate. If you want to view team data (without task data) by resource, add the Team Resource to the view.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making ad hoc view selections. For example, use calendar period measures (Measures area) for calendar period fields (Fields area) and use fiscal period measures (Measures area) for fiscal period fields (Fields area). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Portfolios. The Project Management domain includes portfolios (contents and properties). You can use the portfolios to filter and group the investment data by portfolio when building ad hoc views.

In the Project Management domain, you are working with your actual up-to-date investment data (not a copy of the data as you use when doing portfolio planning in CA PPM).

For example, you created a portfolio in CA PPM with 100 investments. In the Project Management domain, you add Investment Name to the ad-hoc view (drag Investment Name from Fields to Columns in the New Ad Hoc View). Then drag Portfolio Name (from Fields) to the Filters, select the portfolio (that you created with 100 investments) from the drop-down, and click Apply. The ad hoc view now only shows the 100 investments in that selected portfolio. In this way, you are using Portfolios as a filtering method of reporting on your investment data.

You can also group your data by portfolio in the Project Management domain. For example, you want to see the Total EAC Hours for the investments in each portfolio. You add (drag) Investment Name from the Fields area to Columns in the New Ad Hoc View. Then you drag Total EAC Hours from the Investment Totals in the Measures area to Columns in the New Ad Hoc View. Then you add Portfolio Name (from Fields) to Groups in the New Ad Hoc View. Your data is shown organized by portfolio in the format you selected (table, chart, pie diagram).

In the Project Management domain, you are working with actual up-to-date investment data. You are not using a copy of the data as you use during portfolio planning in CA PPM. Therefore, the Project Management domain data does not match the data in the CA PPM portfolios that you use for portfolio planning. Portfolio planning uses a copy of the actual investment data.

Custom Fields. If you have custom fields that are related to projects, these fields appear in a Custom folder in the Project Management domain. This domain can have multiple Custom folders. For example, Team custom fields appear in the Team Custom folder.

Resource Management Domain

The Resource Management domain includes information about investments, resources, teams and assignments, and task fields from the resource perspective.

Data security. Data security is determined by resource-level access rights. If you have rights to view a resource in CA PPM, then you see all data that is related to that resource in this domain. You can also see all subobject data that is enabled for the data warehouse.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making ad hoc view selections. For example, use calendar period measures (Measures area) for calendar period fields (Fields area) and use fiscal period measures (Measures area) for fiscal period fields (Fields area). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Time Management Domain

The Time Management domain contains information about created timesheets and missing timesheets. Use this domain if you are managing timesheets. This domain provides timesheet details at the date worked level. All created timesheets for all statuses are included in this domain. Incidents are also included in this domain.

Note: This domain does not contain aggregated hours for a project or investment. For aggregated data, use the Investment Management domain.

If you do not use the integrated application timesheets for timekeeping, you can see the fields in this domain, but the fields have no data.

Data security. Data security is determined by timesheet-level access rights. If you have rights to view a timesheet in CA PPM, then you see all data that are related to that timesheet in this domain, including all subobject data that is enabled for the data warehouse.

Missing Timesheets. This domain includes missing timesheets. You can view a specific resource by period and you can see the timesheets that were not created for that resource. The domain does not include missing time entries on a created timesheet.

If you forgot to create an entire timesheet for a given time period, that missing timesheet appears under Missing Time (in the Fields area). However, if you forgot to complete some of the time entries on an existing timesheet, those time entries do not appear under Missing Time. To see all time entries (entered hours and missing entries) in existing timesheets, look under the Timesheets set. Any missing time entry from an existing timesheet appears there.

Financial Management Domain

The Financial Management domain lets financial managers view financial data. This domain includes OBS and Investment data. The domain includes only fiscal time periods (not calendar or weekly time periods). All metrics (under the Measures area of the Ad Hoc Viewer/Editor) are fiscal.

This domain contains detailed financial planning data, including cost plans, cost plan details, benefit plans, benefit plan details, and WIP transaction details. The domain includes the data at a plan level (in the Financial Plans set under Investments in the Fields area of the Ad Hoc View/Editor). You can view the data for an actual plan of record or an actual Benefits plan.

This domain does not include invoicing or chargeback data.

Note: Some of this financial planning data is also available in the Investment Management domain as a subset of the investment data.

If you do not use Financial Management, you can see the fields in this domain, but the fields have no data.

The Financial Management domain includes detailed financial planning data under Financial Plans. The domain also includes break-ups, such as charge codes. WIP transaction data is included at the transaction level. A row is included for every transaction (at the detail level not at the summary level).

Data security. Data security is determined by financial plan-level access rights. If you have rights to view a financial plan in CA PPM, then you see all data that are related to that financial plan in this domain. You can also see all subobject data that is enabled for the data warehouse.

Do not mix metric types when selecting from Fields and Measures. If you select a total under the Investment Totals in the Measures area, do not also select a Transaction Measure under the WIP Transactions in the Measures area. This combination could produce unexpected results. When selecting a Measure in the Financial Management domain, select either Investment Totals or WIP Transactions, but not both simultaneously.

You cannot look at the investment-level summary financial data using the detailed financial planning metrics. In the detail level, you have a row of data for each financial plan. All the financial plans for a project are available. To view only the POR plan data, for example, use the filter. Otherwise, you get duplicated or triplicated numbers.

Data that is shown under Investment Totals (Measures area) is investment-level data. Data that is shown under Financial Plans or Fiscal Periods (Fields area) is detail-level data. Data that is shown under WIP Transactions (Fields and Measures areas) is transaction-level data. Data that is not shown under Fiscal periods is total (summary/investment level) data.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making selections. For example, use calendar period measures (Measures area) for calendar period fields (Fields area) and use fiscal period measures (Measures area) for fiscal period fields (Fields area). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results, because the data is repeated for each period type.

Project Plans. As you include financial plans in your Ad Hoc View, you notice that there are multiple plans for each investment project. You do not only see the plan of record. You see all plans for the investment. To view only the plan of record, use a filter.

Custom Fields. If you have custom fields that are related to financial planning, these fields appear in a Custom folder in the Financial Management domain. This domain can have multiple Custom folders. For example, Team custom fields appear in the Team Custom folder.

Custom Master Objects Domain

The Custom Master Objects domain contains information about custom master objects and their child objects. This domain also includes the Language subobject and fields. Your administrator makes these objects data warehouse-enabled, and they are then included in the Custom Master Objects domain.

Note: Custom Master Objects do not have parent objects and so are not related to any other objects in CA PPM.

This domain contains custom master objects and their children. These objects are not related to any other object in CA PPM. Each custom object has a corresponding set in this domain. The custom object name is also the set name. The objects in this domain are not related to each other.

View one custom master object at a time. When you select the Custom Master Object domain for viewing in the Ad Hoc Viewer/Editor, select one of the custom master objects to view. You cannot view data for multiple custom master objects simultaneously, because the custom master objects do not have relationships with each other.

Data security. Data security is determined by custom master object-level access rights. If you have rights to view a custom master object in CA PPM, then you see all data that is related to that custom master object in this domain. You can also see all subobject data that is enabled for the data warehouse.

Do not mix calendar types. When you look at periodic data (for example, monthly data), do not mix calendar types when making selections. For example, use calendar period measures (Measures area) for calendar period fields (Fields area) and use fiscal period measures (Measures area) for fiscal period fields (Fields area). Also, do not mix the period types (week, calendar, fiscal). Otherwise, you get unexpected results because the data is repeated for each period type.

Data Warehouse Database Schema

Schema information for CA PPM and the data warehouse is available on the CA PPM Advanced Reporting and Database Schema Index page. You can download and view the following information:

  • Database schema information for the application and data warehouse
  • An ERD diagram for the data warehouse
  • Advanced Reporting domain field descriptions
  • PMO Accelerator add-in information
  • Jaspersoft Studio Professional Client and Report Development Guide

Advanced Reporting FAQs

This FAQ provides important information about Advanced Reporting with Jaspersoft.



Can you tell us more about this new reporting solution?

CA PPM delivers a reporting platform that provides our customers with a powerful yet simple reporting experience. Customers benefit from this solution in a number of ways:

  • A truly integrated self-service reporting experience:  Users can access ad-hoc reporting from inside CA PPM. The experience is simple and powerful. No separate logins, no steep learning curves. Users get the information that they need, export it, email it, and consume it as they want.
  • Easy access to CA PPM data:  The data warehouse simplifies the data model and makes end user ad hoc reporting simple and powerful. This reduces the demand for custom report development and delivers powerful information to your users – when they need it.
  • Access from any reporting solution:  You can access the information in the data warehouse from any reporting solution. We deliver it – you consume it as you see fit.
Why is CA PPM moving to a new solution based on Jaspersoft reporting technology?
  • Our customers have been asking for a lightweight, easy-to-use, drag-and-drop, self-service ad hoc reporting capability.
  • SAP has declared the end of support for the Business Objects (BOBJ) version that is included with CA PPM (v3.1) in favor of a newer version (v4.0). The amount of refactoring necessary to continue with the new BOBJ version (universe changes, reporting changes, and so on.) was expected to be significant for our customers, so this was an appropriate time to research more modern and lighter weight solutions.
How do Jaspersoft ad-hoc reports compare to Business Objects WEBI?

Although Business Objects WEBI is comparatively feature rich, Jaspersoft ad-hoc reporting provides similar capabilities in a more intuitive manner. We feel Jaspersoft ad-hoc reporting provides business users an easier-to-use and easier to understand user interface so they can serve themselves. Jaspersoft plans to continue investing significantly in their Dashboard and Ad-hoc reporting capabilities, including mobile capabilities.

Does Jaspersoft have an equivalent feature to replace Xcelsius?

One of the main benefits of Jaspersoft is that it is one integrated solution. Jaspersoft Studio, as shown in the following image, has dashboarding capabilities, interactive dials, and gauges to provide compelling executive reporting. We are also investigating their OLAP capabilities for a future release.

This image illustrates Jaspersoft Studio.

For more information, see the Jaspersoft Community.

Can we use both Business Objects and Jaspersoft on the same CA PPM instance during this transition?

Existing 14.2 and 14.3 customers are able to run both BO and Jaspersoft reports simultaneously on the same CA PPM instance. This supported scenario allows customers to migrate their content to Jaspersoft in an incremental fashion.

Customers on 14.4 or newer releases only receive Jaspersoft packaged with CA PPM once released. With Release 14.4, the ability to configure CA Business Intelligence with Business Objects to work with CA PPM is no longer available.

I have an enterprise license for Business Objects. Can we still use it with CA PPM?

Customers on 14.2 or 14.3 can use Business Objects or any other reporting solution against CA PPM and the data warehouse. The new data warehouse feature makes it easy to use any reporting solution. However, the integrated and supported reporting solution is Jaspersoft.

With Release 14.4, the ability to configure CA Business Intelligence with Business Objects to work with CA PPM is no longer available.

When will CA PPM officially drop support for Business Objects?

Refer to this announcement (CA Business Intelligence for CA PPM End of Life Follow Up Announcement). We discontinued product updates for all releases of CA Business Intelligence 3.x on December 31, 2015.

Will there be a utility to migrate a Crystal Report to a Jaspersoft report?

There will be no utility to migrate the reports from Crystal Reports to Jaspersoft. A few things to consider:

  1. Our experience has shown that investing time and effort in empowering your information consumers to use the new ad hoc reporting and data warehouse pays greater dividends than funding a huge effort to convert old reports.
  2. For reports that do require conversion, there are two simple steps: the query and the rendering. Most queries can be reused and the rendering is much easier in the new reporting tool.
  3. We are working with CA Services and Education to ensure that there are offerings in place to familiarize customers and assist in any conversion work necessary.
Can you share some experiences on converting reports from Business Objects?

We asked this question of our developers and thought it would be helpful to have their insight. They found:

  • Jaspersoft Studio is easy to learn and intuitive to use.
  • Jaspersoft is simpler than Business Objects in several ways but that does not mean it is less comprehensive. For example, moving a report from development to production is much simpler. Simply export from one environment and import to the other.

Jaspersoft Studio is the report designer tool for JasperReports and JasperReports Server. Report developers can use Jaspersoft Studio to create sophisticated report layouts containing charts, subreports, images, crosstabs, and more. Advanced and first-time report developers can easily adapt to the powerful and intuitive report design environment. Jaspersoft Studio is also available as an Eclipse plug-in. Developers who use Eclipse as their primary development tool can develop reports inside Eclipse.

Jaspersoft Studio offers useful capabilities for efficient report creation and maintenance. Improved pixel precision, inheritance, and other features help developers in designing high-quality reports faster while conforming to corporate standards. Jaspersoft Studio offers drag-and-drop tools for easy and intuitive report customization. Jaspersoft Domains (like Universes) can be accessed and modified in a browser. The report design tool also offers a powerful expression editor incorporating several built-in functions and the ability to create ones. Report queries can use standard SQL and basic expressions to simplify the use of parameters in reports. Developers can access data from Jaspersoft Studio through JDBC, JavaBeans, XML, Hibernate, CSV, and custom sources. End users can schedule a report and can email it to their stakeholders.

Converting Business Objects reports is fairly straightforward. The parameter syntax is slightly different (for example, {?param_language} changes to $P{param_language}). There are 3 or 4 constructs that are provided by Jaspersoft that can be used as parameters that take only a few minutes to learn, particularly for someone with experience in Business Objects.

If you use a report template and a report style template, you can quickly format a new report. The template can have predefined header and footer and other sections that are defaulted for all reports. The style template can have all fonts, colors, and alignments that you want to use as defaults for each report section. The developer creates the report using a template, copies the query, modifies the parameters, and formats the layout. The developer does not need to worry whether he should use Arial 10 or 12, blue or gray background, or other details. Developers can use a style like Column Header to take care of these style details. All reports have a consistent look-and-feel and are easy to produce.

Custom field integration is also a key feature of the new reporting solution. When you add a custom field to CA PPM, the data warehouse can incorporate it automatically provided you check the appropriate flag. Your administrators will not need to add it to a reporting universe or other data views before you can report on it. This accelerates information delivery and reduces your administration overhead. Reports with multiple layout options, graphs, and storyboards with several frames or subreports may take more time.

Was this helpful?

Please log in to post comments.