With this VLDB property enabled, Strategy uses the generation number property of every hierarchy member to place the member in the appropriate level attribute's column. In a balanced hierarchy, every member of a given level will have the same generation number. In ragged or unbalanced hierarchies, generation numbers and level numbers do not have a one-to-one correspondence.
In this report, Essbase returns three members (attribute elements) for level 2.
- Personal Electronics
- Home Entertainment
- Computers and Peripherals
'Personal Electronics' and 'Home Entertainment' have generation number 2 in the raw XML results from Essbase, but 'Computers and Peripherals' has generation number 3. The generation numbers are mapped onto attributes as follows. The hierarchy has five levels, with level 4 and generation number 1 at the top, and level 0 and generation number 5 at the bottom.
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a b a b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab abGenerationLevel1423324150 |
Generation number 3 maps onto the template attribute (level 2) neatly, but generation 2 (which is also found in the result set) should be displayed as part of level 3. The level 3 attribute is not on the template, so the Strategy Query Engine has nowhere to put this attribute element. Hence, the level as specified by the generation number is unexpected.
In a ragged or unbalanced hierarchy, there is a mismatch between the level numbers and generation numbers as Essbase calculates them. Strategy expects specific generation numbers for the template level attributes, but the result set includes additional, unexpected generation numbers.
For more information on level numbers and generation numbers in ragged and unbalanced hierarchies, consult the following Strategy Knowledge Base technical note.
KB16411: The MicroStrategy display of ragged and unbalanced hierarchies in Hyperion Essbase cubes does not match the cube definition
ACTION
In most cases, the error may be avoided by including all levels of the hierarchy above the desired level on the template. Because generation 2 should be displayed in level 3, the level 3 attribute should also be on the template, as shown below:
