Mapping account dim to parent member (HFM to Essbase) — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Mapping account dim to parent member (HFM to Essbase)

edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

Mapping account dim to parent member (HFM to Essbase)

Content

Hi everyone

I have a pretty straight-forward question: Can I declare a member of a dimension (Accounts) as a LEV0 member conditional on another (Value) dimension? We have an Essbase ASO cube sending data for translation and aggregation to HFM. Consolidated data returning from HFM cannot be mapped to G/L accounts (LEV0) since the data is only available at a higher node from HFM. We need a way to map the data coming in from HFM to a parent member in the account dimension, ideally without needing an alternate roll-up. Is there a way to do this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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