KB484696: Requirements for the partition attribute on the Intelligent Cube in MicroStrategy 2020

Description 

Strategy 10 introduced a new option on the Intelligent Cube called Data Partition. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. 
 

To learn more about Intelligent Cube Data Partition, please refer to KB237803.
The partition attribute is the attribute that is used to divide your dataset. The partition attribute must meet the following requirements:

• The data type of the partition attribute must be one of the following:
  
• Integer
• BigDecimal
• Text
• Date
• The partition attribute should be present on as many fact tables as possible, especially your largest fact tables. This requirement ensures that the calculations that you need to perform take full advantage of Strategy's parallel processing capabilities. 
• The partition attribute is not used to filter your dataset. This ensures that when you analyze data in your application the maximum number of partitions are involved in the calculations, which leads to faster response times. 
• The partition attribute is on any tables that are larger than two billion rows. 

Refer to the Strategy In-Memory Analytics documentation for more details on requirements on the Intelligence Server machine and metrics.