Updating the extension script

After the raw source is configured, you must add the new extended attribute to the scripted source so that it is pushed to the Extension space hierarchy.

  1. In Birst, select the [Tenant]-ISM-Dimension-Extension space.
  2. Select Modeler > Prepare.
  3. Under Source list, select the scripted source to edit and hover over Edit Scripted source. For example, FS_CONTRACT_EXT.
  4. On the Script tab, complete these steps:
    1. In the Select Statement section, press Ctrl+A to select all text, then Ctrl+C to copy the original query.
    2. Open a text editing application, such as Notepad, and press Ctrl+P to paste the original query text.
    3. Specify this information to replace the corresponding Null field with the name of the field you are adding:
      Null
      Specify the source field name in the format [sourcename.newfieldname]. For example, ism_fs_contract_mst_extension.total_billed.
      CDF
      In the //CDF column, specify the field type. For example, //CDF Float 01.
      Note: Field types include CDF Float 01 to CDF Float 5 and CDF Integer 01 to CDF Integer 05. These fields work as attributes as well as measures.
  5. Copy the edited text from Notepad into the Data Sources pane from where it was copied.
  6. Click Validate.
    Note: Do not modify the text in the Script section except to add a custom calculation. For example, Column A * Column B.
  7. Click Save.
  8. Publish the respective processing group in the Extension space. For example, FS_CONTRACT.