Environment:

• Oracle Analytics Cloud (OAC) Data Visualization
• Source System: Essbase EPM
• Issue: Dynamic hierarchy column selection in calculated columns

I am trying to create a calculated column that dynamically selects different hierarchy columns based on a parameter value using a CASE statement. While the hierarchy members exist and work perfectly as canvas filters, I cannot reference them in calculated column expressions.

Questions:

1. Is there a specific syntax for referencing Essbase hierarchy members in OAC calculated columns?
2. Are there limitations on using hierarchy dimensions in calculated column expressions vs. filters?
3. What's the correct way to dynamically select between different hierarchy levels using parameters?
4. Are there alternative approaches to achieve dynamic hierarchy column selection in OAC DV?

Additional Context:

• The same hierarchy members work perfectly when used directly in visualizations or as filters
• This suggests the issue is specifically with how calculated columns handle hierarchy member references
• I need this functionality to create dynamic reports where users can switch between different organizational hierarchy levels

Any guidance on proper syntax or alternative approaches would be greatly appreciated!