Installation and Upgrade › What's New for the Report Server and Reports › Changes to Existing CA PPM Universes

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 Data Model Changes for a list of changed and deprecated fields.