Show TOC

Syntax documentationEvEXP Locate this document in the navigation structure

The Expand function performs row or column expansions.

Syntax Syntax

  1. EvEXP(AppName,Member,KeyRange,DataRange,ExpandDown,IncludeFlag,LevelDown,ParentBefore,Filter,RepeatBlock)
End of the code.

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 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.

End of the note.

RepeatBlock — (Optional) Repeats a block of cells for each member. Works similar to DataRange, except that blocks of cells are copied.

Example 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.

End of the example.