Support Central
Get a clearer picture of how your project is tracking.
Custom reports
Step 1: Define your data
Step 2: Design a layout
Step 3: View, export and share
Printable reports for Cost
Step 1: Define your data
Step 2: Design a layout
Step 3: View, export and share
Processes configured in Dashboards only apply to the Dashboards. They do not affect other areas of Aconex such as Mail or Documents.
As an example, this scenario may occur if your process is configured to ‘auto close in X days’. This means you'll see the status of Responded when viewing the mail itself. However, in Dashboards the process is 'Closed Out' due to the configuration of that process in Dashboards.
Dashboard configuration does not Close Out the mail itself.
Yes. In the data model editor, after adding the subject areas and required attributes/columns you will see the option Custom Heading which can be used to rename a data field or attribute label. The custom label will apply in the layout only.
We don't recommend this. While the offline editor allows you to drag and drop attributes from different subject areas (that are not linked) in the same chart, doing so will give you incorrect output.
Yes, using BI Publisher (Plugin) Template Builder in offline RTF layouts. Learn more
Yes. If you are creator of the report that is shared across projects, you can edit it only from the project where you created it.
If you have minimum access permission Create Project Org. Reports, you can also edit (except Share) the report that is shared with all users from your organization across projects, but only from the project the report was created.
Yes. In the online layout editor you can select the date field or column in the table, then select properties in left pane. Under data formatting, enter the date format you want in the formatting mask option. We also recommend you select the formatting style as ‘Oracle’.
Yes, in the data model editor choose Document as the main subject area. Select the ‘Include historical data’ checkbox. If Document is a supporting subject area it will return the historical data by default.
For Mail you can use the ‘sent month’ attribute. For other subject areas you will need to code your own logic for this. (e.g. 1/1/2001 = Jan, 1/2/2021 = Feb etc.. ). Use the Case-Switch statement to create a chart with an axis showing monthly data.
Yes. Download the template as an XPT file and then upload it as a layout for other reports. This works on different projects too. See Reuse a report template (layout)
It's a good idea to save frequently used template files on your computer, so you can quickly add them to your next report.
Yes. If you have the required access permission, open the report from the project you created it in, and select to share it across all projects you have access to.
A report you created can only be shared across all projects that you have access to.
No. A user from an organization can view a process in dashboard only if the organization is involved in that specific process. This helps everyone see just what's needed. If an organization on your project can't see a process on their dashboard, it's because they aren't part of that process.
Make sure pop-ups are allowed for the Aconex instance URL (for example us1.aconex.com). Also see Configuring your web browser
Select the table. Expand the Properties panel on the left then go to Appearance. Use the Margin option.
Expand the Properties pane on the left and locate Chart Title. Set Visible as True.
Copy and paste or use the Insert function in MS Word to add an image/logo into the RTF layout. We suggest you use .PNG or .JPEG image types. Make sure you right click on the image(s) and select Wrap Text > In Line with Text.
Switch to web view so you can scroll across the page. This web view is available on the status bar at the bottom of the Word file – it’s called Web Layout.
In the layout editor, expand the Properties pane on the left and scroll to Chart Plot Area. Set Data Visible as True to view data labels in the chart. Use the Data Font Bold/Colour/Italics/Size & Data position options to format the data labels.
Use the Image component from the Insert panel at the top and select an image from your computer. We suggest dropping the image into a layout grid for best alignment.
Expand the Properties pane on the left and locate the Total Row or Total Column section. Set the Display option to None which removes totals display for the pivot table.
In the data model editor, click Add Columns to view the list of available attributes (data fields) for the selected subject area. From this list, select or deselect the options as required, click OK and then Save the data model.
In the data model editor, click on the Filter icon to view and configure filters. Complete the Field, Operator, and Value options to set the filter. To remove a filter, click on the gear icon and click Delete. Click Apply and then Save the data model. To add more filter rows, click the gear icon and select the add below/above option.
In the data model editor, select ‘Main subject area’ or ‘Supporting subject area’ to get a pop-up window where you can select or deselect the subject areas.
From the Insert panel at the top, locate Page Elements to add a page number.
Expand the Properties pane on the left and locate the Chart Values section with options for formatting the axis.
Expand the Properties pane on the left. For each section adjust the formatting options for font size, type, and colour. For example, in the Chart Legend section, there are options to adjust the font size, type, and colour of the legend text.
In the layout editor, expand the Properties pane on the left and scroll to Charts. Set the Background Color option as required.
You can also scroll to the Chart Plot Area section in the Properties pane and use the Series Color option to change the graph series color.
From the Page Layout panel at the top, select the orientation and size (for example, predefined A4, A3, B5) from the Paper section.
To change the margin size, select the page by clicking on the margin then go to Properties on the left panel. Click the Margin option under Appearance. From here you can also adjust the Page Height and Page Width under the Misc section.
From the custom report list, hover over the report name until you see the ellipsis menu (three dots). Click this to get a dropdown list and click Edit Data Model.
The child or supporting subject area has secondary attributes linked with the selected main subject area. For example, Documents can be attached to mails, therefore the attributes of the documents such as document type, document created by, document discipline, are secondary attributes for mails as the main subject area.
Click Export to download the Process Details table into excel or PDF.
From the table select the column you want to sort. Select the table and click the Column tab at the top. Adjust the Sort option as required.
Use a Layout Grid to drop all your components. Select the grid and from the Layout Grid Cell tab at the top, click the Background Colour icon to open the Colour Picker. Choose the required color for the background of the grid.
After you have installed the plugin, open Microsoft Word and click File from the menu bar at the top.
Click on Options from the left panel. From the dialog box select Add-ins on the left and select BI Publisher Template Builder for Word from the Add-ins list.
Click OK.
The Dashboard data refresh is different for each instance. Note these are approximate values.
| Instance | Dashboard data refresh approx. |
| AU1 | 6 hours |
| AU2 | 30 minutes |
| CA1 | 15 minutes |
| ASIA1 | 30 minutes |
| EU1 | 15 minutes |
| ASIA2 | 2 hours |
| KSA1 | 1 hour |
| MEA | 3 hours |
| UK1 | 3 hours |
| US1 | 1 hour |
Note: Your time-zone preference is used to display the refresh time.
If you have not set your timezone, then the organization-level setting is used.
If your organization has not set a timezone, then the default timezone for the Aconex instance will be used.
For the report to be available in the new project, you will have to once again share the report across projects after accessing the new project.
If you add a new mail based process or edit an existing one, it appears in the Dashboard only after the next data refresh. See How often is Dashboards data refreshed
Yes, if you edit a report then those changes will apply to that report on all other projects it was shared across.
Office 365 is now certified with the BI Publisher Desktop Template Builder.
See the certification
To install the add-in, download Oracle Business Intelligence 12.2.1.4.0 (the recommended version). Choose the BI Publisher Desktop based on your version of Microsoft Office 32 bit or 64 bit.
Yes. There is a limit on the number of records that can be requested from each subject area while running a report.
These limits ensure high performance while processing the real time data required for your report.
If the limit is reached, only the records within that limit will be available in your report. You may need to filter your report to get most relevant data within the limit.
The below table shows the limits for each subject area.
|
Subject Area |
Maximum number of records in your report |
|
|
10,000 |
|
Workflow steps, Workflow |
10,000 |
|
Field issues, Field inspections |
10,000 |
|
Documents |
50,000 |
There is no limit on the number of columns you can add in a table. To add more columns, you can either:
If you are directed to this page from an error message in Aconex, you can find the error below and find out what to do next.
This error is caused by a temporary issue in Aconex, or a special character in your chosen data.
Confirm if there's a temporary issue in Aconex
Find and remove unsupported special characters
This error is caused by:
Confirm if there's a temporary issue in Aconex
Check the layout matches the data model (using the online editor)
any attribute incorrectly used as a series, label, or value.
the filters applied.
any grouping used on table or pivot charts.
Check the layout matches the data model (using the offline template builder)
Generate a preview when using the MS Word template.
Find and remove invalid characters
Reduce the volume of data requested in the report
If there are no invalid characters, then the report may fail due to the amount of data being requested. Use filters to reduce the amount of data in the report and try again.
If you are still unable to run your report, please raise a request with Oracle Support. Include a HAR file, along with screenshots of your data models, layouts, and filters used in the report.
The report may have exceeded its data limit. Use the prefilter & view report option from the three dots menu to refine the data in the report.
Some special characters are not supported as filter input values. Please check and remove special characters from your filters.
It may be the document version isn’t yet available in your document register. Some organizations are configured to require a manual update of the Document Register using the ‘Update Register’ button. Once your register is updated try the report again. If the issue persists contact Oracle Support.
Tables, Pivot Tables, Conditional formatting, Charts and more are available. View Layout Components in the Offline Template Builder
Available charts include Area, Bar, Bubble, Line, Pie, Funnel, and more.
Change the chart type by clicking on it then clicking the Chart tab at the top. Select a Chart Type as required.
This allows filters to be adjusted when running the report. This option must be enabled on the main subject area before it can be used in a supporting subject area.
If you remove data fields or attributes that are being used in a report layout, the report will load but will display empty cells or charts where the removed attribute was used.
The parent or main subject area contains all directly linked attributes to a given field. For example, Mail as the main subject area contains attributes such as sent date, recipient list, mail type, etc. that are directly linked with mails.
This occurs if the width of the content, chart, or table you added in the layout extends outside the page width. As an example the table may have too many columns.
To resolve this you must increase the page width by following these steps:
TIP: To check the alignment, you can open the Aconex report view page in another tab of your web browser and refresh it. Continue adjusting the page width until you see the alignment is correct.
For the contract number filter in the data model editor to list values in the dropdown:
These are the attributes that are available in the project the report was created, but are missing from this project. See Considerations when sharing reports across projects
If it’s not a shared report then check if there are values created and assigned for the given attribute. If yes, and still you are unable to select or view values in those filters then please contact us for troubleshooting.
This could occur for several reasons:
Optionally you can open the report and click Save As to save a copy of the report. You can then edit and share the copy with others (based on your access permissions).
This issue can occur when reports have filters applied in the layout with English values.
As a workaround, try:
1. Run the report.
2. Click Save as to save a copy of the report.
3. Find the saved report in the listing page (custom tab)
4. From the more options (three dots) menu click Add/Edit Layout to open the online layout editor.
5. Click on the chart that isn’t displaying data in the report view page.
6. From the Chart tab click Manage Filters.
7. Click on each filter and enter the appropriate translation for each English value. For example, 'Request for Information' will need to be changed to 'Solicitud de información (RFI)' if your language is Spanish.
8. Save and then run the report again.
If a project is not displayed on your portfolio page:
The Cost reports are only available if you, your project, and your organization have access to Cost. Insights don't support shared workspaces, so if you access your clients' data via a shared workspace, you won't see Cost reports, even if your client has them.
If you should have access, are logged in, and can't see the Cost reports, we recommend:
This error happens when you login, load the XML file, pull in a field or two and then run the preview feature. It’s related to the JRE version installed. To fix the issue:
