Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Data Management extract members as iDescendants

edited Jan 21, 2020 2:01PM in Financial Consolidation and Close 15 comments

Summary

Extracting an entire hierarchy

Content

Hi,

In HFM, when extracting data we could specify Hierarchy for dimension members.  This gave us the values of the parents, the children, and the base levels. In FCC, Hierarchy is not available to select but I believe that it is now called iDescendants (screenshot below) in the data load rule.  I have tested this and it works the same as Hierarchy did in HFM, so far so good. However, the values of the base members are formatted in a way that does not work well for us.

For example, we have base entities X and Y which both belong to parent A.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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