Issue with Consolidation of New Members in the Movement Dimension

Summary

Issue with Consolidation of New Members in the Movement Dimension

Content

We are exploring ways to capture additional information required for Country by Country or Related Party dealings and have uncovered a potential issue with the consolidation of new members in the Movement dimension.

The starting premise is that much of the related party information will be available in the source finance or consolidation systems ie. trial balance data, and that this will be loaded to TRCS in the Consol cube. Ideally the solution will be automated so that data could be mapped to both the TRCS_TBClosing Movement member, plus elsewhere as required. We are considering another movement member to capture the additional reporting information.