Adding a data field to a Birst Query Object

These instructions describe how to add a new field to a Birst Query Object using the sales order line (oeel_extension) query object as an example.

  1. In Birst, select the [Tenant]-SX-Dimension-Extension space.
  2. Select Modeler > Connect > CSD Infor Data Lake.
  3. Hover your mouse over the oeel_extension object, click on the down arrow and select Edit.
  4. In the Query text box, add a comma after the last field in the query's SELECT statement.
    Each new field must be added as the last field in the SELECT statement.
  5. Press Enter.
  6. Specify the new field name on the blank line.
    Field names are case sensitive.
    Example:
    SELECT
/* Required Attributes */
"oeel"."DCTransDate",
"oeel"."Deleted",
"oeel"."VariationId",
"oeel"."cono",
"oeel"."orderno",
"oeel"."ordersuf",
"oeel"."lineno",
"oeel"."rowpointer",
"oeel"."lastModified",
/* User Attributes Below (Don't forget comma after
  last attribute above) */

add_new_column_name

FROM "oeel"
WHERE "oeel"."lastModified" >= 
'V{InforCSD_oeel_ExtractStartDate}'
  7. Click Save.
  8. A preview of the newly modified query is displayed. If the preview does not display, or the newly-added fields are not included, check your edits and save again.