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

Issue with data retrieval

in Financial Consolidation and Close 1 comment

Summary:

I have a statistical hierarchy with the following structure:

The member formula for the dynamic calc accounts is composed of members from the Primary Balance Sheet hierarchy.
When I retrieve the following accounts—FCOSTotal, COSTotal, AdjEBIT, EngTotal, OPProfitwoRecharges, EBITwoRecharges with Periodic view in an ad hoc sheet, everything works fine.

The Periodic values retrieve correctly, but as soon as I add YTD to the same sheet, the results for all accounts are wrong. Even the Periodic numbers become incorrect. If I retrieve each account separately, it works perfectly.

As a workaround, I moved the dynamic calc accounts to insertion rules, which resolves the issue but negatively impacts consolidation performance. The customer is also reluctant to use on-demand rules for this.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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