Skip to content

Reporting Enhancements

The archive reporting data in the fact and dimension tables is now accessible by OData APIs in the RESTful Gateway. Open Data Protocol (OData) is a standard that allows accessing data via REST APIs. These APIs can be called directly or linked up with external tools (e.g. Power BI Desktop) to generate reports.

See the Interface Guide Reporting OData Endpoints section for further details.

The Schedule Archiving Service will now continuously update the reporting dimension and fact data as the scheduling datasets are updated allowing the use of the OData reporting APIs to access up-to-date data. In addition ARC_Plan_Fact, ARC_Resource_Fact and ARC_Allocation_Fact tables have been added. These tables contain the latest state of a schedule and are used to populate the related Snapshot_Fact tables when a snapshot happens.

Continuous reporting can be disable if required. See the Schedule Archive Guide for further details.

Note

When generating reporting analysis data from the workbench, the data produced will now contain records in the new ARC_Plan_Fact, ARC_Resource_Fact and ARC_Allocation_Fact tables, rather than the existing Snapshot_Fact tables.

Minor Enhancements

  • Basic HTTP authentication can be enabled in the RESTful gateway to simplify Power BI Desktop access.
  • A GatewayOpenIdAllowStandardAuthentication permission has been added to replace the OpenIdAllowLegacyAuthentication parameter allowing per user configuration
  • References to the previous and next activity have been added to ARC_Travel_Fact.
  • Snapshots are no longer taken if the data has not changed since the previous snapshot. Instead the previous snapshot's timestamp is updated.