Additional Blogs by SAP
cancel
Showing results for 
Search instead for 
Did you mean: 
SEdelstein
Product and Topic Expert
Product and Topic Expert
0 Kudos

Relevant versions: BPC5.x+

EVLST and EVSET are two powerful BPC functions that can work together to present filtered member data selections for use in BPC Planning applications.   EVLST accesses the member data file and EVSET filters the returned list according to MDX filtering specifications.

A practical example in using these functions is as follows:

Return a list of dimension members, but only those members with a specific property (i.e. attribute).

In the example provided below, the scenario is to return a list of dimension member IDs that only contain the property "Group" set to "Group A".

The EVLST function requires the following configuration:

EvLST Parameters:

AppName = the name of the BPC Application

DimensionName = the name of the dimension from which you are requesting the list of members.

SetExpression = the cell location of the EVSET function.  EVSET will be applied as a filter against the entire member list associated with "DimensionName".

Target = specify the cell locations you want the filtered list to appear

PropertyName = EVLST can return any property within the specified dimension, in this example the member's ID is being requested.

ExpandDown = enter TRUE to expand members by row, FALSE to expand members by column.  Value if omitted is TRUE.

RepeatDuplicates = TRUE displays duplicate properties, FALSE suppresses multiple copies of the same property.  Value if omitted is TRUE.

 

The EvSET function is referenced by the EvLST function in order to filter the listing to specific parameters.  In this example, the EvSET function is limiting the selection to a MDX filter specified in the Filter parameter:

 

 

EvSET parameters:

AppName = the name of the BPC Application

Member = enter one valid member of the dimension; this is required for the MDX statement to execute properly.  The selection of which member to enter is irrelevant, since the returned list will be consist of all members matching the "Filter" criteria

Include Flag = enter "EVMEMEBRS" to specify base members

LevelDown = specific number of hierarchy levels down the filter needs to expand to

ParentBefore = if returning a hierarchy, enter TRUE for the placement of the parrnt before the child, FLASE to place parent after children.

Filter = is aan optional parameter, but is required in this example to filter on member properties.  Complete example expression:

"ACCOUNT.CurrentMember.PROPERTIES('GROUP')='GROUP_A' "

This expression will select only those members in the dimension "ACCOUNT" that have the property "GROUP" set equal to "GROUP_A".

8 Comments