Adding Columns to Live Access Sources

You can add custom columns to your Live Access sources using Modeler Relate.

Note: To create a new column with uploaded data for your Professional space, use Modeler Prepare.

For example, if a measure for Revenue does not exist directly in a Live Access table, you can add a new column to the table and enter a formula: Quantity*UnitPrice.

To add a new column to your Live Access source:

  1. From Modeler Relate, select the source you want to add the new column to.
  2. Click Model Col..
  3. Click the +Add Column icon.
  4. Specify the Name of the new column, and the click Confirm to save.
  5. Complete the fields by selecting these column properties:
    Column Type
    select how your column is interpreted in subject areas; Attribute, Measure, or both. Setting the column to None with hide it from the subject area.
    Data type
    The data type of the column. Birst attempts to automatically detect the column's datatype but users can overwrite the default if needed.
    Formula
    Using your existing column names from the data base, create a custom formula for the column selected. Users can create a new column to customize formulas if need be.
  6. Click Save.
Related topics