EvEXP 
The Expand function performs row or column expansions.
Syntax
EvEXP(AppName,Member,KeyRange,DataRange,ExpandDown,IncludeFlag,LevelDown,ParentBefore,Filter,RepeatBlock)
AppName — The current application name.
Member — The dimension member on which you would like to base your expansion.
KeyRange — The beginning point and ending point for the expansion. Must be a minimum of two rows (if ExpandDown is True) or two columns (if ExpandDown is False).
DataRange — Specifies which area of the report to copy when you expand the report. This property maintains the report structure by copying the formulas and formatting of the first row of the range, and copying it to all the new rows upon expansion. Must
be a minimum of two rows (if ExpandDown is True) or two columns (if Expand down is False).
ExpandDown — (Optional) TRUE = expand members by row (default). FALSE = expand members by column.
IncludeFlag — (Optional) The members to include in the expansion. You can use the following options:
SELF — (Default) Returns the current member
EVDPS — Returns the current member and its dependents
EVDEP — Returns the current member's dependents
EVBSS — Returns the current member and its base level members
EVBAS — Returns the current member's base level members
EVALS — Returns the current member and all members below it
EVALL — Returns all members below the current member
EVMembers
— Returns all members, above and below the current member
You can also use any of the following MDX functions:
BEFORE — (Default) Returns descendant members from LevelDown value only. Includes Member only if the LevelDown value specified is the level of Member.
AFTER — Returns descendant members from all levels subordinate to the LevelDown value.
LEAVES — Returns leaf descendant members regardless of the level.
SELF_AND_AFTER — Returns descendant members from the LevelDown value and all levels subordinate to LevelDown value.
SELF_AND_BEFORE — Returns descendant members from the LevelDown value and all levels between Member and the LevelDown value.
SELF_BEFORE_AFTER — Returns descendant members from all levels subordinate to the level of Member
BEFORE_AND_AFTER — Returns descendant members from all levels subordinate to the level of Member except members from LevelDown value.
LevelDown — (Optional) Used with MDX flags to specify how many levels to display within a hierarchy.
ParentBefore — (Optional) TRUE puts parents before children. FALSE puts parent after children.
Filter — (Optional) Uses conditional MDX statements to base expansion on member properties, and to specify fixed dimension members. The Filter property is used with the IncludeFlag property. The value in the IncludeFlag is filtered based on the value, or condition, of the Filter property.
Note
For the NetWeaver version only, Filter is not supported. That is, if you specify a Filter, EvEXP does not work. See SAP Note: 1328981.
RepeatBlock — (Optional) Repeats a block of cells for each member. Works similar to DataRange, except that blocks of cells are copied.
Example
For the Row Expansion formula =EvEXP($B$1,$B$3,A17:A20,B17:H20,,Evdep,,FALSE, the breakdown of the formula, which displays the dependents of the current entity member, is:
$B$1 = Budgeting (the current application)
$B$3 = Sales (the current member)
A17:A20 = the KeyRange
B17:H20 = the DataRange
,, = ExpandDown. The default for ExpandDown is True, or blank
EVDEP = IncludeFlag. EvDEP returns all dependents of the current member
,, = LevelDown. The default value for level down is one (1), or blank
FALSE = ParentBefore. FALSE puts the parent after the children.