Hotfix 155 for Analytics for Learn – DimCourse and DimStudent processing performance issue

Hotfix 155 for Analytics for Learn – DimCourse and DimStudent processing performance issue

Date Published: Feb 05,2019 Category: Product:Installs_and_Configurations_Learn,Implementation_Process; Version:Learn_9_1_Q2_2017_3200_0_0,X4_3_2,X4_3_3,Learn_9_1_Q4_2017,Learn_9_1_Q2_2018,Learn_9_1_Q4_2018,Learn_9_1_Q4_2016_3100_0_0_rel_107_401e,SaaS,Learn_9_1_Q4_2015_9_1_201510_1171621,Learn_9_1_Q2_2016_3000_1_0_rel_52_991d   Article No.: 000050084

Product:  Analytics

Announcement Details:

Blackboard is pleased to announce the availability of Hotfix 155 for Analytics for Learn that addresses performance issue in processing of Course and Student dimension.  This hotfix applies to Analytics for Learn versions 4.3.2 through 4.3.3.


This hotfix moves the translation logic from transform view of Course and Student dimension to source helper which loads the new prestage table with all translations used in affected dimensions to appropriate language set up in HEA.GLOBAL. Transform views then only use these translations instead of calling translation function repetitively and therefore severely affecting performance by breaking the execution plan.


  1. Execute the script in the SQL hotfix file corresponding to your product version in SQL Server Management Studio on the Analytics for Learn database (iBBLA).


After application of this hotfix processing time of affected dimensions should be significantly lower.


  • Appropriate knowledge of SQL Server to apply the hotfix script


The hotfix was made available on April 11, 2017.

Please reach out to Blackboard Support with any questions or issues regarding this hotfix or any prerequisites.