This TN has been archived because its content is outdated. For the latest information, see KB43268: Metric dimensionality notation.
In a Strategy Desktop 9.x metric definition, the dimensionality information always appears within braces ( { } ), and uses a distinct syntax. To show the full syntax, in the metric editor, go to View > Show Level (Dimensionality) Properties.
The dimensionality consists of a list of expressions, separated by commas. Each expression represents one entry in the dimensionality.
Each entry consists of three parts:
- The level part is the name of an attribute or hierarchy to which the metric should be aggregated. If the name of the attribute or hierarchy contains more than one word, it will appear within brackets ( ). Also, the level can be 'report level', represented by the tilde (~) symbol.
- The grouping part comes before the level part and uses the following symbols:
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
- The filtering part comes after the level part and uses the following symbols:
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
PostgreSQL 9.332-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified PostgreSQL 9.364-Bit Strategy ODBC Driver for PostgreSQL Wire Protocol 7.10.00.13 Certified noname1a2b3cnopercentage120%210%Standard+Absolute*Ignore%UndefinednoneStandardNoneBeginning>Beginning Lookup>Ending Fact<Ending Lookup<None!
|
For example, the following dimensionality grids would be represented as shown in the Metric Editor:
Example 1:
