Question Re: Elim&Adj Rules multiply data at each consolidation in Financial Management Q&A

Elim&Adj Rules multiply data at each consolidation

Former Member — Fri, 05 Feb 2016 17:48:11 GMT

Hi Experts,

I face issue using Elimination Rules in a Consolidation Model.

In some cases, (most of), datas are multiply at each consolidation ; it seems that the problem occurs when the account destination of the rule is different than the source account.

Détails below :

Before Conso :

After 1st Conso : Résults are correct. :

After 2nd Conso : Data on elimination audittrail are multiply, and so on at each consolidation :

Anybody has met that kind of issue ?

Tks for your help.

Best regards,

Olivia.

Re: Elim&Adj Rules multiply data at each consolidation

former_member225135 — Tue, 09 Feb 2016 08:42:37 GMT

Hi Olivia,

It might be due to some parameters are missing in your dimension.Please check the below note:

1941497 - Check points for consolidation issue

Regards,

Rahul

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 09:41:54 GMT

Hi Olivia,

have you tried to define the destination accounts by ID in the rule and if so, does that make any difference?

also, what does your multiplier M_IC look like?

BR,

Arnold

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 09:56:11 GMT

Hi Arnold,


 have you tried to define the destination accounts by ID in the rule and if so, does that make any difference?

Yes. No difference. Data are also doubled at each run of Consolidation.

Also note, that Amount are not doubled when destination account remains the same as source account.


 also, what does your multiplier M_IC look like?

Note that i've tried with MINORITY Formula filled as "1" ou without anything.

Results are the same.

Tks a lot,

Olivia.

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 10:31:19 GMT

Hi Olivia,

have a look at SAP NOTE 1514944 - it is about the IS_CONSOL property in the AUDIT dimension. Alternatively, SAP NOTE 1682227 might help, it is about the STORE_GROUP_CURR property in your GROUP dimension.

BR,
Arnold

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 10:48:03 GMT


Arnold Warhonowicz wrote:

Hi Olivia,

have a look at SAP NOTE 1514944 - it is about the IS_CONSOL property in the AUDIT dimension.

Regarding that, my destination datasource used in business are already flagged as :

IS_CONSOL = Y

IS_CONVERT=Y


Alternatively, SAP NOTE 1682227 might help, it is about the STORE_GROUP_CURR property in your GROUP dimension.

BR,
Arnold

My consolidated scope is flagged as STORE_GROUP_CURRENCY=Y

I've got a conversion rule using AS_IS formula.

I do not use the integration mode in my BR formula.

So not sure i'm concerned with that note

But thanks for your help,

Olivia.

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 11:01:01 GMT

The destination datasources should be of DATARSC_TYP A and I never flag them as IS_CONVERTED = Y, instead I leave the IS_CONVERTED blank.

BR,

Arnold

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 11:09:19 GMT

That's true.

I made a mistake in my last answer.

My destination datasource are all, flagged as 'A', IS_CONSOL=Y and IS_CONVERTED=N (i can try by leaving them blank.... not sure it changes something.... as it should be the same )

Olivia.

Re: Elim&Adj Rules multiply data at each consolidation

former_member225135 — Tue, 09 Feb 2016 14:54:01 GMT

Hi,

Can you check what ratetype you have maintained for GLs which are there in Destination GL account.

If it is blank, try to fill it with CLOSING rate type.

Regards,

Rahul

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 15:23:02 GMT

Hi Rahul,

I've Ratetype = CLO.

BR,

Olivia

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Tue, 09 Feb 2016 18:16:44 GMT

Hi,

It seems that amount that are doubled at each consolidation , come from account with ratetype = clo.

account with rate type = avg seems ok...

Re: Elim&Adj Rules multiply data at each consolidation

former_member225135 — Wed, 10 Feb 2016 08:15:54 GMT

So, the issue is now closed?

Regards,

Rahul

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 08:32:57 GMT

Hi,

what does the rule for CLO look like?

BR,

Arnold

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 09:35:05 GMT

No 😞 It occurs for BS accounts....

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 09:36:48 GMT

Hi Arnold,

Please see the conversion rule for CLO :

My Flow Dimension :

Tks for your help,

Regards

Olivia

Re: Elim&Adj Rules multiply data at each consolidation

former_member225135 — Wed, 10 Feb 2016 09:51:01 GMT

Hi Olivia,

You should also have a flow member with "OPENING" flow type.

Can you create the same and run the consol again.

Regards,

Rahul

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 09:53:15 GMT

Hi Olivia,

I would also try to leave the destination flow blank. Rahul is correct, you should also have an OPENING flow or leave the flow_type blank for F99.

BR,

Arnold

Re: Elim&Adj Rules multiply data at each consolidation

former_member225135 — Wed, 10 Feb 2016 10:05:16 GMT

Hi Arnold,

SAP has said in note:1941497

" Check Flow dimension.
- Flow_Type: Must have OPENING and CLOSING and VARSCP:the generic flow for change in scope"

So flow dimension should have opening and closing flow type.

I keep the delivered the flow member as it is and use to create a new flow member based on requirement

Regards,

Rahul

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 10:10:17 GMT

Hi Rahul,

I know, but in my experience having only OPENING or CLOSING is more of a problem then having neither.

BR,

Arnold

Re: Elim&Adj Rules multiply data at each consolidation

Former Member — Wed, 10 Feb 2016 11:22:34 GMT

I totally agree with that, but unfornately, that fails (I need to put some securities in my flow dimension, to make unavailable the flow opening, which is unused in my case)

Anyway, thanks for your valuable help guys.

Regards

Olivia