Create a TOTAL Level Performance Dictionary

The Performance Analysis report uses a dictionary to record the structure of the Performance data. For example, Fund/Country/Sector is a different structure than Fund/Sector/Country. If you use the Performance calculator, you do not need to set up these dictionaries. The Performance commit process creates them. If you are only going to be using the dynamic Mutual Fund returns fields, you need to set one up using these SQL statements:

1. Find the next instance for dictionary_id:

      ^{SELECT * FROM NEXT_INSTANCE WHERE TABLE_NAME LIKE 'RULESDBO.DICTIONARIES}

2. Insert into the dictionary_table using dictionary_id from the last query + 1:
   insert into rulesdbo.dictionaries ( Dictionary_ID, Dictionary_name, Dictionary_type, UPDATE_DATE )values ( 4, 'Mutual Fund Perf Model', 'P', SYSDATE)INSERT INTO RULESDBO.DICTIONARY_FORMAT
   ( Dictionary_ID, Dictionary_Level, Field_attribute_ID, Dictionary_Level_Desc)VALUES(4, 1, -1, 'TOTAL')

3. Find the next instance for dictionary_detail_id:
   ^{SELECT * FROM NEXT_INSTANCE WHERE TABLE_NAME = 'RULESDBO.DICTIONARY_DETAIL' ;}

4. Add 1 to the result and insert into dictionary_detail:INSERT INTO RULESDBO.DICTIONARY_DETAIL(Dictionary_ID, Dictionary_Detail_id, Dict_L1_Code_value, Dict_L2_Code_value, DictL3_Code_value, dictionary_item_id, SOURCE_CODE_ID) VALUES (4,2, TOTAL, NULL 1, 10)

5. Update the NEXT_INSTANCE table:

   ^{UPDATE NEXT_INSTANCE
   SET NEXT_INST = ( NEXT_INST + 1)WHERE TABLE_NAME IN( 'RULESDBO.DICTIONARIES', 'RULESDBO.DICTIONARY_DETAIL' ) ;}