You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to run ODR ruleson all stored Consolidation dimension members and Entity & Parent Currency

in Financial Consolidation and Close 4 comments

Summary:

How to get Cash Flow calculated on all stored Consolidation dimension members and Entity & Parent Currency using ODR rules?

Content (required):

We need to run Cash Flow (part of the Account dimension) calculation in different consolidation steps (local currency/ translation / consolidation – both Entity and Parent Currency, and all consolidation dimension base level members) to get the same outcome as HFM.

Unfortunately, this is leading to a huge increase of consolidation time as we went with Calc Script rules for Cash Flow calculation to embed them in insertion point rule (btw, we had to build multiple rules as we can’t write on seeded Data Source dimension members).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!