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

End Routine Results are coming in New table but Not in Active Table

Hi Guru !!

I am facing an issue and need you help.

I am using the End-Routine to fill up the 3 fields (All are Key figure type Number) in Detail DSO with lookup from Header DSO. In my case along with all other fields these key figures are also populating the Activation of the Detail DSO. i.e. the fields are populating correctly in the /BIC/A****40) table. However, after activating the DSO, key figures are getting Values 0.The Active table does not contain the actual values of these key figures. Rest all fields are fine.

I have maintained Constant with initial with Overwrite as aggregation as rule for all these three key figures in my transformation.

Any idea why this is happening…

Thanks...

Shambhu

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2008 at 09:34 AM

    Hi,

    Change the rule type as "Routine" instead of Constant in the transformation rule.

    Regards,

    Dinesh D

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 08, 2008 at 06:31 AM

    Hi,

    Dont used the initial in the transformation, in place of used the constant "0". It helps. I am having the same problem when I have intial, and When I activate the data, it become 0.

    This will help.

    regards

    Gopal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2008 at 07:06 AM

    Hi,

    Thanks for your input. I checked all the option, but it didn't worked.

    Finally, I have created a fresh DSO and put the same code there. Now, its working absolutely fine.

    I have maintained Constant with initial with Overwrite as aggregation as rule for all these three key figures in my transformation. This is also working for Constant with Value "0" in the rule for these key figures.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      We need to set the following option correctly to populate the end rotine calcualtions correctly into active table.

      Update the following target fields from end routine:

      Only target fields with active rule

      or

      All targets fields (independen of active rule).

      We encountered the same issue and selected the second options and worked as expected.

      You can fidn this option near end rouitne push button (after end routine deletion symbol)

      Hope it help

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.