Publishing to Target IBM Cognos BI

The EC_<GROUPCODE> company is created to hold automatic journals for the following two situations when publishing to datamart for IBM Cognos BI.
  • The subgroup and subsidiary are cross-owned, as automatic journals for all parent perspectives are aggregated to each parent.
  • You are viewing a subsidiary or a subgroup as the top level for the parent perspective, as automatic journals for all parent perspectives are aggregated and included in the subgroup or subsidiary's total.
Note: Where cross-ownership exists, this solution is applied only when publishing the top group including subgroups.