Define a report data model
Create a Data Model
- From Insights > Reports, click on the Add button at the top of the report listing page.
- The Data Model Editor window will open.
- Give your report a name and description using the pencil icons on the left panel.
You will see each subject area has been added to the main editor window.
To the right of each subject area, there is a Filter icon and Add Columns button.
For each subject area, complete the following steps to add columns/attributes and customize filters
a. Click Add Columns.
The Add Columns dialog box has two groups that categorize the attributes as
- Dates (attributes pertaining to dates such as Sent Date for Mails or Due Date for Workflows)
- General (all other attributes such as status for Workflows or Discipline for Documents)
- Click to expand the column groups, and select one or more columns/attributes to add. Click OK when you are done. Each subject area must have at least one column/attribute added.
The model editor lists all available attributes in Aconex, even if they are not being used on your project. Please ensure you only select data that is available on your project, otherwise, your report may show empty cells or charts.
- If required, you can click into the Custom Heading column to create a custom title.
Note: Any custom headings you set here will not carry through to filtering. This means when you set your filters in the next step, the attributes will be listed by their original heading.
- Click the Filters icon.
Configure your filters as required using the dropdowns.
Select a Field to be used as a filter attribute.
Choose an Operator for the filter.
Select a Value for the filter.
You can select multiple values using Shift button + <up/down arrow key>
Select Prompt at run to allow filter values to be changed when running the report. This option must be enabled on the main subject area before it can be enabled on a supporting subject area.
When you have added all required filters, click Apply
- After adding columns for all subject areas, editing column headings and setting your filters click Save to save your Data Model.
- Click the X button to close the Data model editor window.
- Your new report will be available in the Custom tab, but you still need to add a Layout in order to view it.