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

KB46313: In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligent Cube monitor. Additionally, if the "Hit Count" is 0, indexes are not being created on the fly


Community Admin

• Strategy


In a clustered environment, Intelligent Cube sizes are varied on different nodes of the cluster in the Intelligent Cube monitor. Additionally, if the "Hit Count" is 0, indexes are not being created on the fly.

Users of the OLAP Services Intelligent Cubes feature in a Strategy 9.x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). An example of this behavior for a relatively small cube is shown below.
 

ka04W00000148TlQAI_0EM440000002CQo.png

 
 
This is working as expected. The difference in Intelligent Cube sizes is due to the fact that the size seen in the Intelligent Cube Monitor is the Intelligent Cube size + Indexes. For example, in a 2 node cluster, when a cube report is created and executed on one node, the number of indexes on that node increase and the size of Intelligent Cube in the Intelligent Cube Monitor will increase as well. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller.
 
 
For more information on Intelligent Cube sizes, refer to the following Strategy Knowledge Base technical note:
KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9.4.x - 10.x
 


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

August 16, 2017