Skip to Content
avatar image
Former Member

Multiple expansion execution order

Hi,

I have an EVDRE report which column memberset is defined by the result of an EVENE function.

Say that the user sets a year in a cell. I would then use an EVENE to retrieve the list of all subsequent years and concatenate the result to use it in the EVDRE memberset.

How can I ensure that the EVENE will be executed before the EVDRE in the expansions sequence?

Basically, when one has more than one expansion functions in a worksheet and they are interdependent, how do we control the execution sequence?

Thanks

Regis

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 13, 2010 at 10:00 AM

    I will reply to my own question for the benefit of others.

    What I found out is that BPC scans the worksheet left to right and top to bottom and execute expansion functions as it finds them. So one just need to order them in the worksheet accordingly..

    Regis

    Add comment
    10|10000 characters needed characters exceeded