Mapping account dim to parent member (HFM to Essbase)
SummaryMapping account dim to parent member (HFM to Essbase)
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?