SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 11958: Drilldown performance in SAS ABM 6.1 OLAP may be poor with cubes created from some large models

DetailsHotfixAboutRate It
Due to an undocumented problem with parent-child dimension schemas in
Microsoft Analysis Services, pre-aggregations in SAS Activity-Based
Management 6.1 OLAP cubes are not being calculated during cube
processing.

Consequently, all aggregations have to be calculated during
interactive drilldown. In cubes containing more than a few dimensions,
each with many levels and members, this could result in delays of up to
several minutes each time a user drills down into an item within an OLAP
view.

A Technical Support hot fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/abm61.html#011958


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Activity-Based ManagementMicrosoft Windows 2000 Server6.1
Microsoft Windows 2000 Datacenter Server6.1
Microsoft Windows 2000 Advanced Server6.1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.