Modify listing of Grouping Attributes in Cost Plan
search cancel

Modify listing of Grouping Attributes in Cost Plan

book

Article ID: 115360

calendar_today

Updated On:

Products

Clarity PPM On Premise

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?

Environment

Clarity PPM 15.x

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@

 

The lookup LOOKUP_FIN_GROUPING_ATTRIBUTES_CAPTIONS is a Static List, also System-restricted.