Modify listing of Grouping Attributes in Cost Plan

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When creating a Cost Plan, a listing of data is presented for the “Grouping Attributes” which a user can select to be used in the Cost Plan creation.
Can we modify the list of Grouping attributes displayed?

Resolution

The Grouping Attribute data in Cost plan is populated from Lookup id: 'LOOKUP_FIN_GROUPING_ATTRIBUTES'.

This is a System restricted dynamic lookup and so cannot be modified.

The data is stored in the table 'FIN_ATTRIBUTES'.

SELECT DISTINCT @SELECT:FA.CODE:CODE@,
                          @SELECT:NLS.NAME:NAME@,
                          @SELECT:LANG.ID:LANGUAGE_ID@,
                          @SELECT:LANG.LANGUAGE_CODE:LANGUAGE_CODE@,
                          @SELECT:FA.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
                  FROM    FIN_ATTRIBUTES FA, CMN_LOOKUPS_V NLS, CMN_LANGUAGES LANG
                  WHERE   @FILTER@
                  AND FA.PLANNING = 1                  
                  AND NLS.LOOKUP_TYPE = 'LOOKUP_FIN_GROUPING_ATTRIBUTES_CAPTIONS'
                  AND NLS.LOOKUP_CODE = FA.CODE
                  AND NLS.LANGUAGE_CODE = LANG.LANGUAGE_CODE
                  AND NLS.LANGUAGE_CODE = @WHERE:PARAM:LANGUAGE@