MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 25: MDX Grammar


 

Leveling Rules for MDX Elements

Several of the following leveling rules make it optional to qualify multidimensional schema object names. However, this does not imply that the ability to generate unique names for members, levels, dimensions, and hierarchies is optional. Providers are required to furnish unique names in the schema rowsets for these objects. If providers generate unique names by means other than qualification, the ability to qualify is optional. For more information, see "Provider Implementation Considerations for Unique Names" in Chapter 24, "Multidimensional Expressions."

  1. The ability to qualify a cube name by one or more of <data_source>, <catalog_name>, or <schema_name> is optional. Consumers can check the value of the property MDPROP_MDX_OBJQUALIFICATION to see whether a provider supports cube qualification.

  2. The ability to qualify a dimension name by a cube name is optional. Consumers can check the value of the property MDPROP_MDX_OBJQUALIFICATION to see whether a provider supports dimension qualification.

  3. The ability to qualify a hierarchy name by a dimension name or by cube name and dimension name is optional. Consumers can check the value of the property MDPROP_MDX_OBJQUALIFICATION to see whether a provider supports hierarchy qualification.

  4. The provider need only support one of the first two productions for <level>. (Support for the third production is mandatory.) Therefore, in the following case, the ability to qualify by <dim_hier> is optional:
       <level> ::= [<dim_hier>.] <identifier>

    Consumers can check the value of the property MDPROP_NAMED_LEVELS to see whether the provider supports named levels. If it does, the consumer can check MDPROP_MDX_OBJQUALIFICATION to see whether named levels can be qualified by <dim_hier>.

  5. The ability to qualify a member by a level, a member, or <dim_hier> is optional. Consumers can check the value of the property MDPROP_MDX_OBJQUALIFICATION to see whether a provider supports member qualification.