Jedox 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:

1. Catalog – Catalogname – Description 2. Cube – Catalogname – Cubename – Cube type 3. Dimension – Catalogname – Cubename – Dimensionname – Dimensionuniquename – Dimensioncaption – Dimensionordinal – Dimensiontype – Dimensioncardinality – Defaulthierarchy – Description 4. Hierarchy – Catalogname – Cubename – Dimensionuniquename – Hierarchyname – Hierarchyuniquename – Hierarchycaption – Dimensiontype – Hierarchycardinality – Defaultmember – Allmember – Description – Hierarchystructure 5. Level – Catalogname – Cubename – Dimensionuniquename – Hierarchyuniquename – Levelname – Leveluniquename – Levelcaption – Levelnumber – Levelcardinality – Leveltype – Description 6. Measures – Catalogname – Cubename – Measurename – Measureuniquename – Measurecaption – Measureaggregator – Datatype – Numericprecision – Numericscale – Description 7. Properties – Propertytype – Catalogname – Cubename – Dimensionuniquename – Hierarchyuniquename – Leveluniquename – Propertyname – Propertycaption – Datatype – Description 8. Members – Levelnumber – Memberordinal – Membername – Memberuniquename – Membertype – Membercaption – Childrencardinality – Parentlevel – Parentuniquename – Parentcount – Depth – Description 9. Sets – only schema data 10 . Functions – Function name – Description – Parameterlist – Returntype – Origin – Interfacename – Object – Caption 11. 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
Was this post helpful?
NoYes (No Ratings Yet)
Loading...