Skip to Content
avatar image
Former Member

Consolidation using store entity

Dear Experts,

I'm bringing up a question from 2016 which I found in the archive:

Basically I want to know if it's possible to setup BPC (without custom logic) to run consolidation with store_entity approach. Consider the following scenario:

Holding company C1000 owns 2 subsidiaries: C1100 and C1200 (both fully owned). Subsidiary company C1200 owns 1 subsidiary: C1210. For this requirement, 2 SCOPE (G dimension) members are created : G1000, G1200

The Ownership hierarchy should look like this:


I set up SCOPE.STORE_ENTITY = 'Y', SCOPE.ENTITY = 'SE_1200'. Therefore when consolidating G1200, data will be generated into SE_1200 as the store entity.

The expected function is that SE_1200 will be included in the consolidation of G1000 as a single entity, product of consolidation SCOPE G1200.

There are 4 issues in this setup:

1. CURRENCY generated in group currency, not local currency as required by Consolidation Engine
2. SCOPE generated in SCOPE=G1200, not G_NONE (non group)
3. AUDIT_TRAIL includes the elimination audit, while it should just be 'INPUT'
4. INTERCO from C1000/C1100 will be pointing to I_C1200/I_C1210. But during consolidation, it would require the INTERCO to points at I_SE_1200

All the issues above can be resolved using custom logic, but is it the only way? Is this kind consolidation approach supported in BPC or am I missing the purpose of store_entity?

Thank you in advance,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers