EVLST with EVSET === result TRUE

[Former Member]

Hello,

We have BPC 7 SP5. I need to Know if with the new SP06-07-08 with the EVLST is possible to create a list of member IDs. Because I Write

=EVLST($S$50;"PGTO_Estructura";EVSET("Presupuestacion";"3421";"SELF";3;FALSO);R59:R60;"GROUP")

But the result is TRUE.

Thanks very much for some information about this.

Flavia - Buenos Aires

Argentina

[Former Member · Accepted solution]

Flavia,

Try changing "Self" to EVALS, which will include in your list the current member plus all children below it. You could also use EVMEMBERS instead which will include all members of the dimension in your list, or EVBAS for just the base members, etc.

examples:

EVLST($S$50;"PGTO_Estructura";EVSET("Presupuestacion";"3421";"EVALS";3;FALSO);R59:R60;"GROUP")

or

EVLST($S$50;"PGTO_Estructura";EVSET("Presupuestacion";"3421";"EVMEMBERS";3;FALSO);R59:R60;"GROUP")

Greg

Edited by: Greg Anderson on Jul 22, 2010 6:03 PM

Edited by: Greg Anderson on Jul 22, 2010 6:04 PM

[Former Member]

Thanks for your answer, but I change the formula and still TRUE appear.

Perhaps is something relation with the version. BUt I dont Kown how can I create a list of member's properties.

Flavia

[Former Member]

Flavia,

See this thread for some ideas:

You can also search this forum on EVSET, EVLST and EVPRP for some more examples. Some of the attributes the helpfile lists as optional may actually be required in reality.

This may be an overcomplicated example, but it works for me in 7.0M SP5. You could use the EVPRP() function to generate a list of properties for a given application and dimension, and then expand to the values of the properties using one EVEXP function to expand the list of property values for the members you want to generate. You'd need to have EVPRO statements in the data range of the EVEXP function (the cells that get expanded).

The example below shows how EVLST and EVSET work together to return a list of members of a dimension.

It will return TRUE in the cell where the formula is and that means it is working, and it puts the result in the target range (E34:E37 in my example)

In cell E22 put the following: (add an equal sign infront of this:)

EVLST($C$25,$C$26,EVSET($C$25,$C$27,$C$28,$C$29,TRUE,$E$20),E34:E37,"ID",TRUE,FALSE)

Definitions of cell contents of cells referred to. Enter the following in these cells.

C25: Application

C26: Dimension

C27: Member (of the dimension you want to expand on. This should be a parent member)

C28: This is the FLAG (enter EVALS for current member and all members below it, could also be EVDPS, EVDEP, EVBAS, EVBSS, EVMEMBERS etc)

C29: Levels: I just entered 99 in this cell

E20: Enter the following filter in this cell that would let you restrict your list based on a property. Don't forget to include an equal (=) sign in front:

IF(C31="N","",C26&".currentmember.properties("""&C32&""")"&C33&""""&C34&""""

C31: the cell that has a Y or an N in it. N if you do not want to filter, Y if you want to include a filter.

C32. The name of the property you want to filter on

C33: The operand. I just hav an = sign in this cell.

C34: This is the value you want to filter on.

E34:E37 this is the range where the result of the formula will appear.

ID: ID is the property you are displaying in the list.

True: ExpandDown

False: Do not repeat duplicates.

Please let me know if you can get this to work in 7.5M

Greg