![\"EvLST\"](\"https:\/\/weblogs.sdn.sap.com\/weblogs\/images\/251702118\/EvLST.JPG\")
<\/p>\nRelevant versions: BPC5.x+ <\/p>\n
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. <\/p>\n
A practical example in using these functions is as follows: <\/p>\n
Return a list of dimension members, but only those members with a specific property (i.e. attribute). <\/p>\n
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”. <\/p>\n
The EVLST function requires the following configuration: <\/p>\n
<\/p>\n
EvLST Parameters: <\/p>\n
AppName = the name of the BPC Application <\/p>\n
DimensionName = the name of the dimension from which you are requesting the list of members. <\/p>\n
SetExpression = the cell location of the EVSET function. EVSET will be applied as a filter against the entire member list associated with “DimensionName”. <\/p>\n
Target = specify the cell locations you want the filtered list to appear <\/p>\n
PropertyName = EVLST can return any property within the specified dimension, in this example the member’s ID is being requested. <\/p>\n
ExpandDown = enter TRUE to expand members by row, FALSE to expand members by column. Value if omitted is TRUE. <\/p>\n
RepeatDuplicates = TRUE displays duplicate properties, FALSE suppresses multiple copies of the same property. Value if omitted is TRUE. <\/p>\n
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: <\/p>\n
![\"EvSET\"](\"https:\/\/weblogs.sdn.sap.com\/weblogs\/images\/251702118\/EvSET.JPG\")
<\/p>\n
EvSET parameters: <\/p>\n
AppName = the name of the BPC Application <\/p>\n
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 <\/p>\n
Include Flag = enter “EVMEMEBRS” to specify base members <\/p>\n
LevelDown = specific number of hierarchy levels down the filter needs to expand to <\/p>\n
ParentBefore = if returning a hierarchy, enter TRUE for the placement of the parrnt before the child, FLASE to place parent after children. <\/p>\n
Filter = is aan optional parameter, but is required in this example to filter on member properties. Complete example expression: <\/p>\n
“ACCOUNT.CurrentMember.PROPERTIES(‘GROUP’)=’GROUP_A’ “<\/strong> <\/p>\n This expression will select only those members in the dimension “ACCOUNT” that have the property “GROUP” set equal to “GROUP_A”. <\/p>\n http:\/\/sapbpctutorials.blogspot.com\/2010\/07\/business-planning-and-consolidations.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" Relevant versions: BPC5.x+ Business Planning and Consolidations (BPC) 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 … Continue reading