Adding and mapping the column in the scripted source

  1. Select Modeler > Prepare.
  2. Select a source, for example FSM_AccountingEntity_Ext. In Column Properties, add the columns to the respective hierarchy and specify the datatype and length as needed.
  3. Select a script, for example GL Accounting Entity. Click Edit Scripted Source.
  4. Map the column to any of the user fields in the Script section.
    The column is now added and mapped into the model. This is attached to the Accounting Entity in the conforming dimension and the value is displayed in string user field 01. Ensure that the entire Level script is added.