Behind the Blackboard! Hotfix 155 for Analytics for Learn – DimCourse and DimStudent processing performance issue - Behind the Blackboard Skip Navigation
Download PDF  Icon Download PDF    Print article

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

Date Published: Feb 05,2019

CategoryProduct:Installs & Configurations,Implementation Process; Version:Learn 9.1 Q2 2017 (3200.0.0),4.3.2,4.3.3,Learn 9.1 Q4 2017 (3300.0.0),Learn 9.1 Q2 2018 (3400.0.0),Learn 9.1 Q4 2018 (3500.0.0),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


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.

The information contained in the Knowledge Base was written and/or verified by Blackboard Support. It is approved for client use. Nothing in the Knowledge Base shall be deemed to modify your license in any way to any Blackboard product. If you have comments, questions, or concerns, please send an email to © 2019 Blackboard Inc. All rights reserved