Jedox 3rd Party Access/MDX: Supported Statements

image_pdfimage_print

SELECT statement

The SELECT statement is the most important statement used by the MDXInterpreter.

The parts of the SELECT statement are defined as follows:

a) “formula_specification” expression

Set functions can be used in member specifications, and member functions can be used in set specification if the function call is between brackets.

b) “axis_specifications” expression

The SELECT statement supports only set functions that return a set, or set and member functions that return a set on axis specifications.

Example:

UPDATE statement

Example:

 

ALTER DIMENSION statement

 

Example:

To see how these statements work we will do the following operations:

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...