Custom EV function

[Former Member]

Hi every one ,

Is it posible to create custom EVfunction , text function ?

I need to get a comma separated values of the member list which satisfies certain criteria.

EVlst doest work in BPC7 .

Is it possible to create one ..

Please let me know .

Thanks

Madhu

[Former Member · Accepted solution]

Hi Madhu,

There are a couple of ways to do this. You could create an EVDRE and set your Options to "ExpandOnly" to return lists of values and no data, and some EVPRO statements to return some properties in the expansion. Also, you can get creative with the functions EVPRP(AppName,Dimension,DestinationRange)- returns properties, EVLST and EVSET. You might want to look up these three functions and the examples shown in the online help. EVLST does work together with EVSET in BPC 7M. I have used it in BPC 7M SP5 to return a list of members that meet certain criteria (properties for example calc = y).

Greg

[Former Member · Accepted solution]

If i use EVLST & EVSET together i am getting value TRUE in the cell which i have formula for EVLST instead of list ofmembers in the specified range.

Might be that i am using SP less than 5.

[Former Member · Accepted solution]

That is correct. It will return TRUE in the cell where the formula is and that means it is working.

Consider this example that should work for you: In cell E22 put the following:

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: This is the Filter if you want to restrict your list based on a property. 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 what you are displaying in the list.

True: ExpandDown

False: Do not repeat duplicates.

Edited by: Greg Anderson on Apr 27, 2010 5:56 PM

[Former Member]

Hi Madhu,

I dont think that will be feasible. These come as inbuilt components.

Hope this helps.

[Former Member]

Apart form creating a custom EV function is there any way to get comma separated list of members that satifies certain criteia (ex: calc=y) .. I want to use this comma seperated list in pagekeyrange of EVDRE to get totals in data range.

ans the same senario i have to use it several times.

Dimension member propery values change dynamically . and member list which satisfies this criteria changes dynamically.

And i am not intersted in specifiying that criteria in expansion range because my requirement is for total not for the detail .

I will have to get a lot of totals(may be hundreds) that way and get a grand total at the end

Please let me know if there is any way to accomplish this

[Former Member]

or is it possible to cretae a macro for creating comma separaed list

[Former Member]

Is it possible to create a macro which serves my purpose?

[Former Member]

Hi Madhu,

You can definitely create a macro to do that. However, I wont be able to guide you with that; since I dont have much knowledge on the macro coding.