Skip to Content
author's profile photo Former Member
Former Member

Input Schedule Question

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2011 at 03:45 AM

    -> 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
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.