Overview 

 
CAMMS is pleased to announce the January Feature Release for cammsinsights. 

This includes a number of new features and enhancements to improve your user experience within the system. The release is set for the 24th of January 2020, and will include the following features.

1. Introducing a new dataset for Risk Secondary Owners in cammsrisk

The new Risk_RiskOwnerLink_STND dataset will enable users to generate reports based on cammsrisk Secondary Owners data.

Fields included in the dataset:

To ensure this new dataset is enabled for use within your cammsinsights application, please follow the steps in the link below: 

https://cammsgroup.freshdesk.com/support/solutions/articles/43000509883-administration-configuring-and-enabling-new-datasets-for-use

Below are the default relationships for this new dataset - you can set these up as an Insights Administrator.

For instructions on using the Relationships tab in your Insights Administration area, please refer: https://cammsgroup.freshdesk.com/support/solutions/articles/43000545174-data-model-relationships

2. Introducing a new dataset for Secondary Service Profiles in cammsproject

The new Project_ProjectServiceLink_STND dataset will include both the project's primary and secondary service profiles with corresponding ID fields enabling Insights report writers to join these with other datasets and display these Service Profiles in reports.

Fields included in the dataset:

To ensure this new dataset is enabled for use within your cammsinsights application, please follow the steps in the link below: 

https://cammsgroup.freshdesk.com/support/solutions/articles/43000509883-administration-configuring-and-enabling-new-datasets-for-use

Below are the default relationships for these new datasets which you can set up as an Insights Administrator.

For instructions on using the Relationships tab in your Insights Administration area, please refer: https://cammsgroup.freshdesk.com/support/solutions/articles/43000545174-data-model-relationships

3. Ability to fetch data from the current/latest phase of Project Custom Tables

The current facility which allows you to create your own dataset for custom tables will be further extended by allowing you to create two possible datasets for each custom table. As such you can have;

1. A dataset which produces data from all phases of the project which includes a custom table of the same name (which is currently available).

2. A dataset which will always retrieves data from the current or latest phase where the particular custom table sits in (this will be a new option from this release).

In order for you to generate the Insights datasets, a drop down called ‘Create Insights Dataset’ is now available in the custom table configuration pop-up in cammsproject as shown below;

Figure 1: Dropdown to create Insights Dataset in cammsproject

There are two options provided for you in the drop down as below;

1) Create for all phases

Selecting this option will provide the current functionality of the “Create Insights Dataset” button which produces a dataset which draws data from all workflows and phases where a custom table of the same name exists.

E.g. If the custom table name is “MyTable”, then the dataset will be “Project_MyTable_TBL”

1) Create for Current phases

Selecting this option will create a dynamic dataset which always pulls data for the custom table from the current phase of the project. Therefore, when this option is selected, a new dataset will be created for the custom table and the dataset name will be taken from the custom table name appended with ‘CurrentPhase’.

E.g. If the custom table name is “MyTable”, then the dataset will be “Project_MyTableCurrentPhase_TBL”

NOTE

- If the same custom table is used multiple times in the same phase, then the first custom table is considered to create the dataset. And if the current phase does not contain the custom table, then the latest custom table from the previous phase will be considered.

- This modification requires that the custom tables should be configured with the same columns and rows across multiple workflows and phases to avoid report crashes upon moving a project from one phase to another.

Apart from the column names you configure in cammsproject for the relevant custom table, the following standard fields will also be available in the custom dataset;

4. Introducing new datasets to retrieve links from the Compliance module

With this release, several new datasets are made available for you to retrieve the links between different areas of the Compliance module as below.

1. Compliance_PolicyAuthorityDocumentLink_STND

Fields included in the dataset:

2. Compliance_CompliancePolicyLink_STND

Fields included in the dataset:

3. Compliance_AuthorityDocumentLink_STND

Fields included in the dataset:

4. Compliance_PolicyLink_STND

Fields included in the dataset:

5. Compliance_ComplianceRiskLink_STND

Fields included in the dataset:

6. Compliance_ComplianceIncidentLink_STND

Fields included in the dataset:

To ensure these new datasets are enabled for use within your cammsinsights application, please follow the steps in the link below: 

https://cammsgroup.freshdesk.com/support/solutions/articles/43000509883-administration-configuring-and-enabling-new-datasets-for-use

4. Modifications to the Action Details dataset to extract the image and the confidential fields

Two new fields namely ‘Image’ and ‘Confidential’ have been added to the Planning_ActionDetails_STND dataset. Using these fields now you can get the Image and the data from the confidential tick box of the Action to your Insights reports.

IMPORTANT: Any reports you have created using this dataset may display configuration errors after this release due to these new fields. Please update the dataset as soon as possible to ensure smooth functioning of your reports.

To update and apply the modifications to the above-mentioned dataset, please follow the steps in the link below:

https://cammsgroup.freshdesk.com/a/solutions/articles/43000506771