BPC Logic Script - Run program consolidation issue

[former_member645232]

Hi all,

I have to fix a legacy logic script and I'm struggling with it. Unfortunately I'm not familiar with this logic script, and I'm hoping someone can give me some hint to something I might be overlooking. I have to run the script that makes adjustments to the balance sheet and P&L accounts in the consolidation cube as a previous step to perform consolidation. There are several steps and after running them all I'm facing that for some data lines (what lines seem kind of random to me) are being set to 0. I've been running these steps individually and I came up to the conclusion that I'm having this issue within the RUN PROGRAM CONSOLIDATION function. I've found very little documentation about this fuction and I'm completely lost about why it is behaving as it is. Find attached the same script having run the CONSOLIDATION function and without it. The step 6 is the chunk of script that is transforming the lines being set to 0.

Thanks in advance!

Regards,

Cristina.

budget-consolidation-logic-script.txt

[former_member186338]

Sorry, but do you really think that somebody will do your job instead of you for free?

In general *RUN_PROGRAM CONSOLIDATION will run all defined consolidation rules. It's the same as if you run consolidation in consolidation monitor.

[former_member645232]

Hi Vadim,

Thanks for your help. I didn't mean that, I just needed more information on how that program works because I haven't found much documentation on this subject and I am new on this.

[former_member186338]

The troubleshooting has to be:

1. Run each when/endwhen in the script one after another and check results after each step. Very strange script with when/endwhen calculations of consolidation results. No idea why it was done this way.

2. Check all consolidation rules and mulipliers settings. Understand the logic.

3. *RUN_PROGRAM CONSOLIDATION and check results.