Skip to Content
0

consolidation package not taking records

Sep 13, 2017 at 06:30 AM

140

avatar image
Former Member

Hi,

when i run consolidation package (logic script has both FX_TRANS and CONSOLIDATION programs in it), i'm getting 0 records submitted for CONSOLIDATION where as currency translation is translating 10 CG_NONE records and generating 10 "CG_B and CG_WORLD" records. What could be the issue for CONSOLIDATION not to pick those group records? (I'm Selecting scope CG_WORLD while running consolidations)

below screenshot has entity, scope and ownership structures.Any help is greatly appreciated

temp.png (148.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Sep 14, 2017 at 02:32 AM
0

Vadim,

I updated the name. Any feedback you can provide?

Share
10 |10000 characters needed characters left characters exceeded
Lucas Costa Sep 14, 2017 at 02:59 AM
0

Not sure if I got your issue, but have you tried running consolidation in a separate package? If yes, did generate records?

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your reply.

I created a new package for consolidation and it resulted in same result.

Here is more on the issue and hope it is clear. I'm running LEGAL CONSOLIDATION package with scope selected CG_WORLD.

in the logic script, i'm calling both CURRENCY translation and CONSOLIDATION programs.

for same selections, currency translation is generating records where as CONSOLIDATION program is not taking those same records.

0

Ok, so you have created two packages one for CT and another for Consolidation. CT works and Consol don't.

Can you share:

  1. The consol script logic
  2. The consol business rules/methods
  3. Audit trail, currency and group dimension members

Cheers,

Lucas

0
Former Member

Lucas,

attaching a screenshot that has all needed info. GROUP dim is listed in my original post screenshot. Appreciate your help

more-info.png (135.7 kB)
0

Ok, is the CT result being saved against TOTALADJUSTMENTS audit trail?

0
Vadim Kalinin Sep 13, 2017 at 09:54 PM
0

Using name BPC tech you are violating the forum rules! Use your real name instead!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 18, 2017 at 12:29 AM
0

Yes, CT result being saved against TOTALADJUSTMENTS audit trail.

Consolidation rules along with data for the relevant rules are shown in this screenshot. Any suggestions?


report.png (51.4 kB)
report.png (51.4 kB)
Show 14 Share
10 |10000 characters needed characters left characters exceeded

CG_B currency is CAD (From your first post) but you have no CAD as a result from the CT. Try changing GC_B group currency to USD and running the consolidation package as test.

0
Former Member

Thanks Lucas for your prompt reply. Since my 1st post, i've been trying many things and changing lot of things and in the process, i have currency also changed. Yes, CG_B already changed to USD for the reason report has USD. For your reference, i'm including screenshots of ENTITY and SCOPE again here.

temp.png (148.8 kB)
0

Can you share your Audit and Group dim members? From Dimension maintenance, would like to see other properties.

0
Former Member

Sure Lucas. Here it is, screenshot of group & Audit dim.

0
Former Member

I forgot to add Audit dim earlier so modified the previous post to include both Audit and Group.

0

Can you try adding Y to the IS Consol? property to the parent nodes as well?

1
Former Member

I added Y to parent nodes but still same result. Screenshot updated.

0

Well, this is really odd..

Since everything you shared so far looks ok to me I'd try:

  • Remove the Source Audit from the business rule
  • Include INCREMENTAL_MODE= in your SL

I'd also take a look at the Entity and Flow dimensions.

1

Not sure if went through this document yet:

https://archive.sap.com/documents/docs/DOC-56719

It can give you some insgihts.
0
Former Member

i tried below things but still same result.

  • Remove the Source Audit from the business rule
  • Include INCREMENTAL_MODE= in SL (this is already included)
  • completed relevant checklist as per document https://archive.sap.com/documents/docs/DOC-56719 except "Run Ownership calculation package for current TIME/CATEGORY/GROUP". Can you provide some info on this?

i'm attaching entity and flow dim maintenance here.

0
Former Member

Do we need to run ownership calculation package? i'm unable to successfully complete it for whatever options I select. I've ownership data entered manually so Not sure if this is really needed. anything wrong with the ownership data that i entered? any ideas?

0

No.. I have never used it. From my perspective it more useful when you have complex structures.

Sorry man, this is really odd. Your whole setup is quite basic and I can't see anything wrong with it.

But another thing you could try - other than Arnold's suggestions - it's to remove the Entity from the Group dim for test.

0
Former Member

Hi,

could you change your ELIM_OWNERSHIP audit member from IS_TRANSLATED Y to either no value for this property or an N. Also, having the same account as the destination_all and destination_group account seems strange. Could you change the destination_group account to a different account.

I never run the ownership calculation and my cons works, so it is not mandatory.

1
Former Member

Thanks Arnold. these settings resolved the issue.

0
avatar image
Former Member Sep 14, 2017 at 01:41 PM
0

Hi,

which consolidation rules have you got? And do you have data that is relevant to those rules?

Regards,
Arnold

Share
10 |10000 characters needed characters left characters exceeded