Modeling your data
1. First select Edit queries in the main ribbon and select a table.
2. Scroll to the right of the table and notice all the yellow columns.
These are all the references of your order, for example the order property, requestor etc. You can include fields from these references in your order table. E.g. property code and name, or cost group name.
3. Click on the Expand button (
) and select the fields you want to include and click OK
) and select the fields you want to include and click OK
If you made a mistake or want to change the prefix of your expanded columns, you can change these/redo it by clicking the Settings icon in Applied steps.
When you are done, click Close and apply.
The data will be loaded shortly.