Feature Release Note | Camms.Insights, August 2020

Camms is pleased to announce the August Feature Release for Camms.Insights.

This was released on 15th August 2020 and includes the following new features and enhancements to improve your user experience within the system. 

1. Introducing a new dataset to view KPIs by hierarchy node

The Planning_KPIsByHierarchyNode_STND dataset combines KPI data and hierarchy node data into one dataset for you to create reports using all KPIs associated with various hierarchy levels, including rollup KPIs. 

Following are the fields included in the dataset:

Field name 

Data Type

Notes 

Field name 

Data Type

Notes 

DATEFROM

Date Time

Date range selection for KPI data

DATETO

Date Time

 

KPIID 

Unique identifier 

Unique ID of the KPI

KPI Name 

Text

Name of the KPI

Single/Rollup 

Text

This field will retrieve whether the KPI is a single or rollup into your report

KPI Type 

Text

This field will retrieve KPI type into your report

Calculation method 

Text

This field will retrieve the Calculation Method into your report – Only applicable for calculated KPI’s

Reporting year 

Text

This field will retrieve the reporting year into your report. i.e. 19/20

Reporting year period 

Text

This field will retrieve the reporting year period into your report. e.g. Monthly: December 2017, quarterly: Jan-Mar 2017 

Benchmark 

Numeric

This field will retrieve the Benchmark into your report. 

Forecast 

Numeric

This field will retrieve the Forecast into your report

Sort date 

Date

This is a date field used to sort reporting year periods logically 

Period target 

Numeric

This field will retrieve the Period Target into your report

Period actual 

Numeric

This field will retrieve the Period Actual into your report

Period variance 

Numeric

This field will retrieve the Period Variance into your report

Period comments 

Text

This field will retrieve the Period Comments into your report

YTD target 

Numeric

This field will retrieve the YTD Target into your report

YTD actual 

Numeric

This field will retrieve the YTD Actual into your report

Hierarchy name 

Text

This field will retrieve the relevant hierarchy name into your report

Hierarchy level 

Text

This field will retrieve the relevant hierarchy Level into your report

e.g. Goal, Outcome 

HIERARCHYLEVELID 

Unique identifier 

Unique ID of the Hierarchy Level

HIERARCHYNODEID 

Unique identifier 

Unique ID of the Hierarchy Node

Node name 

Text

This field will retrieve the relevant hierarchy Node name into your report 

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

Administration: Configuring and enabling new datasets for use - Camms.Support Documentation - Confluence (atlassian.net)

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

Join Type

Data Object

Join Field

 

Foreign Data Object

Join Field

Join Type

Data Object

Join Field

 

Foreign Data Object

Join Field

INNER

Planning_KPIDetails_STND

KPIID 

=

Planning_KPIsByHierarchyNode_STND

KPIID 

For instructions on using the Relationships tab in your Insights Administration area, please refer:

Data Model/Relationships - Camms.Support Documentation - Confluence (atlassian.net)

2. Introducing a new dataset to view previous value and new value against each modified field name within an incident in Camms.Incident

The Incident_IncidentHistoryExtended_STND dataset will allow you to report previous value and new value against each modified field name within the respective incident.

Following are the fields included in the dataset:

Field name 

Data Type

Notes 

Field name 

Data Type

Notes 

Incident Title

Text

This field will retrieve the incident title of the respective field that linked to 

INCIDENTID