Jedox 3rd Party Access/MDX: Provided Functions

image_pdfimage_print

Jedox MDX Interpreter provides the following functions for use in multidimensional expressions. These functions can be used in any valid statement.

Functions applied on identifier

identifier.LEVELS(index)                              return: member

identifier.CURRENTMEMBER                     return: member

identifier.DEFAULTMEMBER                        return: member

identifier.MEMBERS                                     return: set

identifier.ALLMEMBERS                              return: set

Member functions

Returning a member:

member.LEVEL

member.PARENT

member.FIRSTCHILD

member.LASTCHILD

member.PREVMEMBER

member.NEXTMEMBER

member.LEAD( index )

member.LAG( index )

Ancestor ( member, level )

Ancestor ( member, numeric_value_expression )

Cousin ( member, member )

Parallelperiod ()

Parallelperiod ( level )

Parallelperiod ( level, index)

Parallelperiod ( level, index, member )

Strtomember( „member” )

Returning a set:

member.CHILDREN

Ascendants ( member )

Ascendants ( member, member ) //only grammer

Ascendants ( member, member, desc_flags ) //only grammer

Descendants ( member )

Descendants ( member, level )

Descendants ( member, level, desc_flags )

Descendants ( member, numeric_value_expression )

Descendants ( member, numeric_value_expression, desc_flags )

Returning a nr:

member.ORDINAL

 

Returning a string:

member.UNIQUENAME

level.UNIQUENAME

dim.UNIQUENAME

member.NAME(analog)

member.Properties ( quoted_string_literal )

Set & Member functions

Returning a set:

Ancestors ( member, level )

Ancestor ( member, numeric_value_expression )

Drilldownlevel ( set, member )

Drilldownlevelbottom ( set, index, level, numeric_value_expression )

Drilldownlevelbottom ( set, index, level )

Drilldownleveltop ( set, index, level, numeric_value_expression )

Drilldownleveltop ( set, index, level )

Drilluplevel ( set, level )

Intersect ( member, set )

Lastperiods ( index, member )         

Lastperiods ( index )

Periodstodate ( level )

Periodstodate ( level, member)

Set functions

Returning a set:

Addcalculatedmembers ( set )

Bottomcount ( set, index )

Bottomcount ( set, index, numeric_value_expression )

Bottompercent ( set, numeric_value_expression, numeric_value_expression )

BottomSum( set, numeric_value_expression, numeric_value_expression )

Crossjoin ( set, set )

Crossjoin ( set_tuple)

Distinct (set )

Drilldownlevel ( set )

Drilldownlevel ( set, , index )

Drilldownlevelbottom ( set, index )

Drilldownlevelbottom ( set, index, , numeric_value_expression )

Drilldownleveltop ( set, index )

Drilldownleveltop ( set, index, , numeric_value_expression )

Tuple ->Drilldownmember ( set, set )

Tuple ->Drilldownmember ( set, set, RECURSIVE )

Drilldownmemberbottom ( set, set, index, numeric_value_expression, recursive )

Drilldownmemberbottom ( set, set, index, numeric_value_expression )

Drilldownmembertop ( set, set, index, numeric_value_expression, recursive )

Drilldownmembertop ( set, set, index, numeric_value_expression )

Drilluplevel ( set )

Drillupmember ( set, set )

Except ( set1, set2 )

Except ( set1, set2, ALL )

Filter ( set, search_condition )

Generate ( set1, set2 )

Generate ( set1, set2, ALL )

Hierarchize ( set )

Hierarchize ( set, POST )

Intersect ( set, set, )

Intersect ( set, set, ALL )

Nonempty ( set )

Nonempty ( set, set )

Order ( set, value_expression )

Order ( set, value_expression, order_direction )

Topcount ( set, index )

Topcount ( set, index, numeric_value_expression )

TopPercent ( set, numeric_value_expression, numeric_value_expression )

TopSum ( set, numeric_value_expression, numeric_value_expression )

Union ( set, set )

Union ( set, set, ALL )

StripCalculatedmembers ( set )

Subset ( set, numeric_value_expression )

Subset ( set, numeric_value_expression, numeric_value_expression )

Tail ( set, numeric_value_expression )

Tail ( set )

Head ( set )

Head ( set, numeric_value_expression )

——–

Periodstodate ()

Returning numeric value:

Aggregate ( set )

Aggregate ( set, numeric_value_expression )

Avg ( set )

Avg ( set, value_expression )

Count ( set )

Count ( set, excludeempty )

Set.count

Max ( set )

Max ( set, value_expresion )

Min ( set )

Min ( set, value_expresion )

Sum ( set )

Sum ( set, numeric_value_expression )

 

Returning tuple:

set ( index )

set.Item ( index )

Numeric functions:

Abs ( numeric_value_expression )

Instr (numeric_value_expression, string_value_expression, string_value_expression, numeric_value_expression )

Instr (numeric_value_expression, string_value_expression, string_value_expression)

Instr ( string_value_expression, string_value_expression)

Val (string_value_expression ) (? Definition )

String functions:

Left ( string_value_expression, unsigned integer )

Right (string_value_expression, unsigned integer )

Tuple functions:

Returning a member:

tuple.ITEM ( index)    

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