3rd Party Access/MDX: Supported Schemas and Defined Syntax Elements

image_pdfimage_print

Supported Schemas

Below are all the supported schemas with all elements that are implemented:

Schema Elements
Catalog
  • Catalogname
  • Description
Cube
  • Catalogname
  • Cubename
  • Cubetype
Dimension
  • Catalogname
  • Cubename
  • Dimensionname
  • Dimensionuniqueename
  • Dimensioncaption
  • Dimensionordinal
  • Dimensiontype
  • Dimensioncardinality
  • Defaulthierarchy
  • Description
Hierarchy
  • Catalogname
  • Cubename
  • Dimensionuniquename
  • Hierarchyname
  • Hierarchyuniquename
  • Hierarchycaption
  • Dimensiontype
  • Hierarchycardinality
  • Defaultmember
  • Allmember
  • Description
  • Hierarchystructure
Level
  • Catalogname
  • Cubename
  • Dimensionuniquename
  • Hierarchyuniquename
  • Levelname
  • Leveluniquename
  • Levelcaption
  • Levelnumber
  • Levelcardinality
  • Leveltype
  • Description
Measures
  • Catalogname
  • Cubename
  • Measurename
  • Measureuniquename
  • Measurecaption
  • Measureaggregator
  • Datatype
  • Numericprecision
  • Numericscale
  • Description
Properties
  • Propertytype
  • Catalogname
  • Cubename
  • Dimensionuniquename
  • Hierarchyuniquename
  • Leveluniquename
  • Propertyname
  • Propertycaption
  • Datatype
  • Description
Members
  • Levelnumber
  • Memberordinal
  • Membername
  • Memberuniquename
  • Membertype
  • Membercaption
  • Childrencardinality
  • Parentlevel
  • Parentuniquename
  • Parentcount
  • Depth
  • Description
Sets
  • only schema data
Functions
  • Function name
  • Description
  • Parameterlist
  • Returntype
  • Origin
  • Interfacename
  • Object
  • Caption
Property
  • Propertyname
  • Propertydescription
  • Propertytype
  • Propertyaccesstype
  • Isrequired
  • Value

Defined Syntax Elements

Identifiers

Identifiers are the names used for cubes, dimension, members, levels, or measures. There are two types of identifiers: regular and delimited.

Regular Identifiers

A regular identifier can be used with or without delimiters. It can not contain embedded spaces or special characters (such as ex: &,….) .

Delimited Identifiers

These are regular identifiers that must always be delimited by using brackets ([]). they can contain embedded spaces. Way of definition:

Member

A member is a representation of one or more occurrences of data. It represents an item from a dimension. Way of definition:

Tuple

A tuple defines a slice of data from a cube. It can contain one or more members. Way of definition:

Set

A set is a collection of zero or more tuples + identifier. Way of definition:

Level

Each dimension is broken down into different levels.

image_pdfimage_print