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 |
---|---|---|
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:
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 |
---|---|---|---|---|---|
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 |
---|---|---|
Incident Title | Text | This field will retrieve the incident title of the respective field that linked to |
INCIDENTID |