EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB484898: Cube publishing requires additional disk space for improvements in cube loading times in MicroStrategy 2021 Update 1


Cheng Guo

Product Owner, Principal • Strategy


This article explains why MicroStrategy 2021 Update 1 requires additional disk space when publishing a cube to improve cube loading times.

When publishing an Intelligence cube, Strategy saves a cube cache file to disk. In Strategy versions prior to Strategy 2021 Update 1, the cube cache file that is saved to disk does not include an Attribute Element Index, which is generated during cube publishing to improve cube querying performance. Instead, in prior versions, the Attribute Element Index is only kept in memory. This causes the cube cache file size in memory to be larger than the cube cache file size on disk in prior versions. 
Under the prior design, each time a cube is loaded into memory from the cube cache, the Analytical Engine regenerates the Attribute Element Index, which is a time-consuming operation. Starting in Strategy 2021 Update 1 under Data Engine Version 10, 11 and 12, the Attribute Element Index is serializes to disk during cube publishing to improve performance for cube loading. Cubes load faster with this optimization but will consume additional disk space to host the cube cache files. The cube cache file sizes on disk and in memory are similar.


Comment

0 comments

Details

Knowledge Article

Published:

March 2, 2021

Last Updated:

March 29, 2021