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
-> 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.
Add a comment