Skip to Content

Issues of 'Entity Property Filter' in Elimination header

In this article,I would like to explain the behavior change introduced by note 1671219.

When customers configuring BPC consolidation business rule to do internal elimination, sometimes they want to configure a particular rule to be
applicable to only particular selected entities. In this scenario, they can utilize the ‘Entity Property Filter' field in Elimination header of the
‘Elimination and Adjustments’ rule.

In 10.0 SP07 (before note 1671219), system take the specified property from both E-type dimenion and I-type dimension. For example:


Entity


Property:EQUITY_SAP


Intercompany


Property:EQUITY_SAP

CO_01


Y


TP_01


Y

CO_02


Y


TP_02


Y

CO_13


Y


TP_13


Y

CO_93


Y


TP_93


Y

CO_B01


N


TP_B01

CO_B02


N


TP_B02

CO_B03


N


TP_B03

CO_B04


N


TP_B04

CO_B05


N


TP_B05

CO_B06


N


TP_B06

CO_B07


N


TP_B07

CO_B08


N


TP_B08

If the property ‘EQUITY_SAP’ is set to be filter, then data with entity on CO_01~CO_93 and intercompany on TP_01~TP_93 can be selected for the
rule because the property values are equal. But for CO_B01 to CO_B08 and TP_B01 to TP_B08, they are not because they are not equal (N not equal  empty).

Note 1671219 introduced a behavior change (enhancement).

Some customers think it is duplicate effort to maintain this in both Entity dimension and intercompany dimension. With this note, it is
sufficient to maintain the property in entity dimension only, like below:


Entity


Property:EQUITY_SAP


Intercompany


Property:EQUITY_SAP


CO_01


Y


TP_01


CO_02


Y


TP_02


CO_13


Y


TP_13


CO_93


Y


TP_93


CO_B01


N

       TP_B01


CO_B02


N

      TP_B02


CO_B03


N

       TP_B03


CO_B04


N

       TP_B04


CO_B05


N

        TP_B05


CO_B06


N

       TP_B06


CO_B07


N

      TP_B07


CO_B08


N

   TP_B08

However, with this enhancement some customers run into a problem.

In two different rules, they want to use two different properties to do the filtering, so they have configured two rules .Rule1 set Property’EQUITY_NON’
as the filter and rule2 set ’EQUITY_SAP’ as the filter.The dimension values are set like below:


Entity


Property1:EQUITY_NON


Propety2:EQUITY_SAP

CO_01

                  Y

CO_02

                  Y

CO_13

                  Y

CO_93

                   Y

CO_B01


Y

CO_B02


Y

CO_B03


Y

CO_B04


Y

CO_B05


Y

CO_B06


Y

CO_B07


Y

CO_B08


Y

What they expect is: the Entities whose value of Property ’EQUITY_NON’ is Y will be selected for rule1 and the Entities whose value of Property
’EQUITY_SAP’ is Y will be selected for rule2.

But when executing rule1, Entities from CO_01 to CO_ALL are considered and eliminated .The same issue occurs to rule2 too.

This is because Entities from CO_01 to CO_ALL has the same empty value.

To overcome the empty value problem, the suggested solution is:

Set dimension values like below:

       Entity


Property1:EQUITY_NON


Propety2:EQUITY_SAP

CO_01


A


Y

CO_02


B


Y


CO_13


C


Y


CO_93


D


Y


CO_ALL


E


Y


CO_B01


Y


A


CO_B02


Y


B


CO_B03


Y


C


CO_B04


Y


D


CO_B05


Y


E


CO_B06


Y


F


CO_B07


Y


G


CO_B08


Y


H

The idea is: Not to have blank(empty value) for the property.Use 'ABCD..' or '1234' to differentiate each entity.

In this way, when executing rule1, entities from CO_B01 to CO_B08 are considered and eliminated .

When executing rule2, entities from CO_01 to CO_ALL are considered and eliminated.

No comments