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

[Former Member]

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

[Former Member]

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.

[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

[former_member434828]

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

[Former Member]

Hi,

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

Regards,

Dinesh D