With this release, we are delighted to announce the latest major update to the Nimbus Power BI template which enables users to set up and take advantage of the powerful functionality in Power BI known as Incremental Refresh.

We have updated the queries in the template so that this functionality can be exploited if required. 

Note that the template parameters no longer offer the option to select “x number of days”: if you need to refresh the template regularly for x number of days, please set up the Incremental Refresh functionality as explained under in PBI Incremental Refresh.

Features: 

• Nimbus template enabled for Incremental Refresh. Users are now able to take advantage of this Power BI in-built functionality if they wish to regularly refresh the report for a given period of time (replaces the old parameter “x number of days”).
• Transfers page updates:
  • Destination column updated to show Destination name if available, or Destination UPN if name not available, if neither available, a null value is shown.
  • New column called "Destination UPN or USPN" showing transfer destination PSTN number or UPN as applicable.
• Various query optimizations to improve performance.

Fixes: 

• TotalTime measure calculation updated in the template to exclude HoldTime since this is already included in TotalConnectedTime which is used in the underlying logic of TotalTime.
• Unified Sessions page: the date slicer is now filtering dates as expected.
   

Temporary limitation:

• In this version of the template we have temporarily removed the caller column from the Unified Sessions details of the report. This will be brought back into the template in a more performant way as soon as possible in an upcoming release.
  It is still possible to filter unified sessions by caller, using the slicer on the top of the page.

Fixes: 

• Fixed a filter problem in Unified Sessions page. When selecting a new date range or dragging the slider in the date slicer, the page is now updated to select the relevant date range.

Features: 

• Code optimizations for the template's fact tables to improve performance. 

Fixes: 

• Fixed sorting issue with DayOfMonth date dimension which is used in the Sessions Overview tile “Session Volume by date and Hour, % Handled Rate”. When drilling down to the day of month, the data is now sorted in chronological order.

Features: 

• Time Zones: updated logic to take into consideration different switching for Day Time Savings in the US. 
• 8x new measures for After Call Work Extended (AWC Extended) available for creating your own visuals: 
  • ServiceSessions: ØAverageAcwExtendedTimeS, ΣTotalAcwExtendedTime, ΣTotalAcwExtendedTime_HHMMSS, ØAverageAcwExtendedTime_HHMMSS
  • UserSessions: ØAcwExtendedTimeS, ΣAcwExtendedTime, ØAcwExtendedTime_HHMMSS, ΣAcwExtendedTime_HHMMSS

Description of the new measures available in the Nimbus Reporting Model page and in the template (hovering with the mouse on the measure).

Fixes:

• Fixed an issue where not all Organization Units a User Supervisor has access to were provided via OData and visible in PowerBI so that they can be used as filters. 
• Removed obsolete Service filter from the Unified Sessions page.

Features: 

• Caller Overview page: added column with Opening Hours
• Modality filter added to the following template pages: Service Overview, User Overview, Session Details, Tags-Codes.
• Caller Overview: the page is by default filtered for modality = Voice.

Fixes: 

• Resolved issue with ServiceSessionTags table which prevented new tags to be shown in the template following subsequent data loads.

Alignment of the Nimbus Power BI Template with the Historic Reporting features made available with 1.89 Latest Release Notes

Features:

• New Opening Hours filter and Opening Hours Types dimension table available for selection in Power BI template. (Ref. NIMB-I-116).
• IsShortConversation flag available in the Service Sessions fact table. Description available in KB Nimbus Reporting Model and in the template metadata. This object can be added to the visuals or filters as needed.

Fixes: 

• "Or From date/To Date" parameter now correctly selecting the expected date ranges.
• Re-introduced missing date hierarchies.

Fixes:

• Optimized TransferSessions query
• Resolved intermittent error on TransferSessions table when retrieving large datasets: “ServiceSessionIdFrom in Table ‘ServiceSessions’ contains duplicate value xxxxxxxx-xxxx-xxxx-xxxx and this is not allowed for columns on the one side of many-to-one-relationship or for columns that are used as primary key of a table."

Features: 

• Added transfers report page
• Expanded time zones selection in parameters (Ref. NIMB-I-238). The list is taken from the Windows database. Please note that the current solution switches the daylight savings on/off based on European daylight savings timelines.