Skip to Content
0

Data Values for one specific Intercompany Elimination Rule are Tripling?

Oct 10, 2017 at 09:24 AM

73

avatar image

Hi,

We have a YTD Consolidation model in BPC on Microsoft DB. When executing the consolidation Data Manager Package, we run it for 1 month at a time sequentially for the particular quarter in question. For example in Q1, we execute the package for Jan, Feb, Mar separately but in order.

We are experiencing an error for only one specific Intercompany Elimination rule, of which I have highlighted the configuration in the image attached.

Config in Row 3 above, corresponds to the results highlighted in the top 2 rows below. All working as expected.

Config in Row 2 above, corresponds to the results in the bottom 2 lines below. Not working as expected. As you can see the amount posted to the ICELIM0037 (offset Account) increases in size, directly proportionally with the number of times that the consolidation package is executed. The value for March is $2.4M, three times the original amount in the Acc 30311of $800K.

Any help/ideas would be appreciated to try and eliminate this.

Regards,

-Billy Haworth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dorra KHEZAMI Oct 15, 2017 at 10:48 AM
0

Hello,

My first advice is to upgrade to the last SP available for the BPC MS version you are using to be sure that this is not a bug that has been identified and already addressed.

Regards,

Dorra.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Dorra,

Thanks for your response. I am certain we are on the latest SP so unfortunately that is not the cause of our problem.

Regards,

-Billy

0
avatar image
Former Member Nov 02, 2017 at 12:23 PM
0

Hi,

there used to be a problem when in your business rule you had a blank row as the last row. Maybe have a look if that is a possible cause.

Share
10 |10000 characters needed characters left characters exceeded