Input Schedule Question

[Former Member]

Hi Gurus,

I have two questions about input schedules.

1 . I want to calculate have users enter data in two columns, and then calculate a third and post all three back to the cube. Is there a way to have a formula in the input area and to have that formula remain active when I exopand all or insert members?

2. I have two dimensions where one is able to be derived from the other. (I know this is bad design as one dimension is superflous but I am inheriting someone elses work). I can derive the second by using an Excel formula. (Both Vlookup and EVPro can be used to derive the second.) is there a way to put my formula in the column representing the second dimension so that when a user enters a value for the first (e.g. with insert member), the second is automatically populated?

Thanks

Cliff

[krishna_priya1 · Accepted solution]

-> If input scedule is static, both of the mentioned tasks works .

-> To make it work in dynamic report , VBA can be used . In BEFORE_EXPAND , you can derive keys of other dimension .In AFTER_EXPAND , formula can be copied to the third column for the calculation. But using too much of VB code effects EVDRE performance .

Hope this helps.

[Former Member · Accepted solution]

Thanks P Krishnas. As you may have noticed from my other post I had started to explore this but I was not sure whether I needed to use VBA or whther there were coding techniques that would work with Evdre. I think the older EvGts and EvSnd allow these tricks.