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
  3. Topics

KB5300: How MicroStrategy SQL Generation Engine calculates the Logical Table Size to choose the optimal fact tables for SQL queries

Community Admin

• Strategy

This article describes how MicroStrategy calculates the logical table size for tables.

The logical table size is an integer number that represents the granularity or level of aggregation of a particular table. It is called 'logical' because it is not related to the physical size of the tables (number of rows). It is calculated according to the attribute IDs that are present in the table and their level in the system hierarchy.
 
Even though, the number does not reveal the actual number of rows in the table, it is an accurate way of measuring a table size without having to access its contents.
 
IMPORTANT:
 
The system hierarchy is defined by the parent-child relationships between attributes of the same family (formerly known as a dimension), not by user-defined hierarchies (i.e., drilling hierarchies).
 
Strategy Engine utilizes an algorithm based on attribute keys to calculate the Logical Table Size (LTS):
 
Given the following tables:
 

ka04W000000OdfgQAC_0EM440000002GF6.gif

 
The algorithm that calculates the table sizes performs the following steps:

  1. Calculate the number of levels per hierarchy:
    Hierarchy 1: 3
    Hierarchy 2: 4
  2. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). The attribute level follows a consecutive order from the top to the bottom. For attributes with more than one parent, the next consecutive number of the highest weight parent is used (i.e., attribute D has a level of 3 (from attribute B) and not 2 (from attribute C).

 


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8

 

  1. Note that the lowest level attribute weight for every hierarchy is always 10.
     
  2. Calculate each table logical size: LTS = ROUND(sum(weights of attributes in the table))

 


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8


HierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8

 
In this way, every table in the project gets its own logical size depending on the attribute IDs that they contain and the level of the attributes.
The previous process is executed every time that the warehouse catalog is saved or the project's schema is updated with the following option checked:

ka04W000000OdfgQAC_0EM440000002GFA.gif

Whenever a report is executed and SQL is generated, the Strategy SQL Engine performs the following steps to determine what tables is to be used:

  1. Get the set of tables that can resolve the report, according to (mainly, but not exclusively) the attributes on the template, attributes on the filter and the metric dimensionality.
  2. From this set of tables, the engine chooses the table with the smallest LTS.
  3. If more than one table have the same LTS, the engine chooses the first table in memory. This scenario is possible when many aggregate tables exist in the project but should never affect the result set in a consistent warehouse. If certain table is preferable, then the LTS for that table may be modified to force the Engine to choose it.

 
NOTE:
 
If the schema is updated with the 'Recalculate table logical size' option, then the sizes are recalculated. If any change was made to the logical table size of a table, it is overwritten. Users may prevent a custom logical table size from being overwritten by checking the option to "Preserve this logical size when updating Schema information."
 

ka04W000000OdfgQAC_0EM440000002GF5.gif
Comment

0 comments

Details

Knowledge Article

Published:

April 6, 2017

Last Updated:

April 6, 2017