Release notes
Filter and view release notes relevant to you. Visit our ideas portal for feature requests, a private forum designed as an interactive space where our clients can post ideas, vote on other ideas and receive feedback from the INX Software product team.
Email updates
SubscribeFully populated Event Equipment tables and exposure hours and their statistics are now visible in Power BI starter models
Available 11 August 2024
New features
Fully populated Event Equipment tables
We have now made your Event Equipment information available through the tables dim_Equipment and dim_EquipmentClass, allowing you to aggregate the associated costs.
Exposure hours and exposure hour statistics are now visible in Power BI starter models
In a previous release, we introduced the dbo.fact_ExposureHours and dbo.fact_ExposureHourStatistic tables. These tables have now been incorporated into the Power BI InControl starter model to further enhance your reporting capabilities.
To save you the need to complete the standard joins yourself, we have also created two new views within the Analytical Layer titled vw_BI_ExposureHours and vw_BI_ExposureHourStatistics.
Improvements
Role added to ‘CCP Status by Person & Role’ table
To enhance data accessibility and analysis, we have made the role from the underlying table Fact_PersonRoleCCPStatus available in both the vw_BI_InTuitionCCPStatusByPersonAndRole analytics view and the ‘InTuition CCP Status By Person And Role’ table in the InTuition Power BI starter model.
Power BI models now use source table metadata
The Power BI sample models previously used a query to retrieve data that would display an error when refreshing if an INX+BI table changed.
All models have been updated to use the Navigate feature that queries the table metadata and adapts the Power BI tables to handle new and deprecated columns.
New INX+BI versioning
To support multiple versions of INX Core with a single release, INX+BI has been decoupled from the INX Core products and will use a Year.ReleaseNumber format.
Exposure Hour fields now support decimal values
We have changed the Exposure Hour Statistics data types to decimal for the monthly, rolling 3-month and rolling 12-month fields so UI fraction values will display correctly.
Mandatory Site ID to enhance system reliability
The Site ID in the INX Core global configuration has been made a required field. This improvement ensures that INX+BI runs will alert users to set a value if it’s missing, preventing run failures and optimising the data warehouse size.
INX InViron Power BI starter model no longer distributed
As INX InViron is no longer supported, we have streamlined our offerings and removed the ‘INX InViron starter model and dashboards.pbix’ Power BI model from distribution.
Email notification on completion of INX+BI runs
You can now receive email notifications upon the completion of an INX+BI run, detailing any data processing errors encountered. This will also allow you to determine if your INX+BI data is up to date.
The email subject follows a standard format that includes a site identifier, making it easy for your users to set up mailbox rules for organising or forwarding notifications.
Additionally, data processing errors are now accessible through a new Analytical Layer view, vw_BI_MetaDataErrors, which displays the error details, destination table and column, and the key value for the source record.
Fixes
Exposure Hours Organisation now populates
The ‘Organisation ID’ field in the table fact_ExposureHours is now populated, enabling enhanced filtering and display by organisation or employer.
Power BI starter model nullable table columns match the Analytical Layer
The nullable flags on Power BI models table columns, which indicate if a field can be blank, have now been updated to accurately reflect the underlying analytical views.
Duplicated compliances removed
To optimise the vw_BI_InTuitionCCPStatusByPersonAndRole analytical view and the ‘InTuition CCP Status by Person and Role’ Power BI table, they no longer contain duplicate compliances.
Unassigned workgroup and organisation individuals are now displayed in ‘CCP Status by Person & Role’
For a more comprehensive display of all relevant individuals, the analytical view vw_BI_InTuitionCCPStatusByPersonAndRole and the InTuition CCP Status by Person and Role Power BI table now include individuals who are not currently assigned to a workgroup or organisation (or “employer”).
00:00:00 time record no longer duplicated
The dim_Time table, vw_BI_Time analytical view, and the Power BI Time table now feature a single record for 00:00:00, streamlining the time data by removing the duplicate entry.
