MEMBER-EXPRESSION
The MEMBER-EXPRESSION terminal in the MaxL language represents a specification of members from one or more dimensions in an Essbase database outline.
The member expression can be one member, a list of members, member combinations separated by commas, or member sets defined with functions. The string be enclosed in single or double quotation marks.
Type
string (see MaxL Syntax Notes)
Example
'@ANCESTORS(Qtr2)'If MEMBER-EXPRESSION contains MEMBER-NAMES that begin with numbers or contain special characters, enclose those member names in double quotation marks, and the entire MEMBER EXPRESSION in single quotation marks. For example:
-
create or replace filter demo.basic.numfilt no_access on '"2"'; -
'@DESCENDANTS("Eastern Region"), @CHILDREN(Qtr1)'
The following example shows how create drillthrough uses a member expression to define the list of drillable regions.
create drillthrough sample.basic.myURL from xml_file "temp.xml" on {'@Ichildren("Qtr1")', '@Ichildren("Qtr2")'} level0 only;