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.