Version 13.0 Updates › What's New for the Report Server and Reports

What's New for the Report Server and Reports

This release of CA Clarity PPM supports CABI 3.2 and BusinessObjects Reporting Server. See the Compatibilities appendix in the Release Notes for a complete list of supported CABI 3.2 configurations.

The following changes were made to reports:

• The following stock reports were removed due to functionality that is no longer offered in CA Clarity PPM:
  • Pre-Billing Report
  • Invoice Register Report
  • Customer Invoice Report
• CA Clarity PPM v13 does not support Actuate. Any stock CA Clarity PPM report definitions for Actuate under Reports and Jobs will be deleted during the upgrade.
• A new Investments Financial universe has been added to this release: CA PPM Investment Financials v13.
• The existing CA PPM Investments Financial universe was modified to provide backward compatibility with custom reports written for previous versions.
• The following change was made to shared reports starting with CA Clarity PPM v12.1:
  • The report can be viewed in PDF format only. A shared report does not use the BusinessObjects report viewer.

Changes to Existing CA PPM Universes

The following changes were made to the existing CA PPM Investment Financials universe to support the v13.0 database schema:

• Added derived tables to the universe to mirror the Group By and Sub-Group By in the Financial Plans for Cost and Budget.

  SELECT l.pk_id cost_plan_id,
         MAX(CASE WHEN l.seq = 0 THEN
                  CASE WHEN value = 'charge_code_id' THEN 'LOOKUP_CHARGE_CODES'
                       WHEN value = 'role_id' THEN 'SCH_BROWSE_ROLE'
                       WHEN value = 'transaction_class_id' THEN 'FIN_TRANSCLASSES'
                       WHEN value = 'lov1_id' THEN 'FIN_BROWSE_USER_LOV1'
                       WHEN value = 'lov2_id' THEN 'FIN_BROWSE_USER_LOV2'
                       ELSE NULL END
                  ELSE NULL END) AS plan_by_1_code,
         MAX(CASE WHEN l.seq = 0 THEN ln.name ELSE NULL END) AS plan_by_1_name,
         MAX(CASE WHEN l.seq = 1 THEN
                  CASE WHEN value = 'charge_code_id' THEN 'LOOKUP_CHARGE_CODES'
                       WHEN value = 'role_id' THEN 'SCH_BROWSE_ROLE'
                       WHEN value = 'transaction_class_id' THEN 'FIN_TRANSCLASSES'
                       WHEN value = 'lov1_id' THEN 'FIN_BROWSE_USER_LOV1'
                       WHEN value = 'lov2_id' THEN 'FIN_BROWSE_USER_LOV2'
                       ELSE NULL END
                  ELSE NULL END) AS plan_by_2_code,
         MAX(CASE WHEN l.seq = 1 THEN ln.name ELSE NULL END) AS plan_by_2_name
  FROM   odf_multi_valued_lookups l
         LEFT OUTER JOIN cmn_lookups_v ln ON l.value = ln.lookup_code
                                         AND ln.lookup_type = 'LOOKUP_FIN_GROUPING_ATTRIBUTES_CAPTIONS'
                                         AND ln.language_code = @Prompt('param_language','A',,mono,free,,{'en'}
  WHERE  l.attribute = 'grouping_attributes'
  AND    l.seq IN (0,1)
  GROUP BY l.pk_id
  

• Changed the links in the Investment Financials Universe for budget plan details and cost plan details. The previous fields were different from the new v13 fields:

The Legacy Universe has been updated to remove references to fields that have been changed or are no longer in the Clarity data schema. See the section named "Data Model Changes" for a list of changed and deprecated fields.