BI Release 4.47.3 - 18th January

Employer Reports

New Functional Skills Report

We have also added a new Functional Skills report to the Employer Report which will highlight where learners have functional skills outstanding and the percentage complete.

We have added traffic lights at the top to indicate where learners are coming towards the end of their apprenticeship and still have functional skills outstanding.

 

mceclip0.png


Standard Reports Enhancements

  • Overdue Payments and Scheduled Payments reports - If a learner withdraws, no payments will be included in the report past the learners Withdrawal date.

  • On Programme - We have added the new measures for tracking Required Off The Job Hours, in addition to the Planned and Completed Off The Job Hours measures.

  • Break Details and Withdrawal Reports – We have added a Last Submission Date column, this is the last submission by the Trainer or the Learner.

New Data Warehouse Fields

The following new fields are being added in this release:

Table Name

Column Name

Description

Data Type

Column is Nullable

Change Type

Learning Plan Links

Planned Off The Job Hours Completion Progress

Percentage of Off The Job Hours completed of those planned (excluding exempt activities)

decimal

Yes

New

Learning Plan Links

Planned Off The Job Hours Submission Progress

Percentage of Off The Job Hours submitted of those planned (excluding exempt activities)

decimal

Yes

New

Learning Plan Links

Required Off The Job Hours Completion Progress

Percentage of Off The Job Hours completed of those required for the learning plan

decimal

Yes

New

 

IMPORTANT: Faster Data Warehouse Access

To improve the service Bud offers to our reporting users, we have now implemented a scale-out solution for the Bud Data Warehouse.

This means that behind the scenes, there are now two, fully synchronised servers available and a load-balancer will automatically pick the best one to fulfil your request.  

If you haven’t already done so, please amend your Data Warehouse connection strings as follows:

In PowerBI Desktop: 

  • Select the ‘Enable SQL Server Failover support’ under Transform data > Data source settings. 

Data_source_settings.png

When reports are published to the PowerBI service, this will reduce the refresh times of your report in PowerBI.com too. 

Connecting from a client other than PowerBI:

We can tell the load balancer that we’re only reading data by adding the following to the connection string:  ApplicationIntent=ReadOnly

  • In SSMS this can be added under Additional Connection Properties:

SQL_server.png

  • Please note you must also specify the database name as well:

SQL_server_2.png

  • Azure Data Factory (ADF):Edit the relevant linked service, and add a new additional connection property:

edint_linked_service.png



Was this article helpful?

1 out of 2 found this helpful

Have more questions? Submit a request