ASO Aggregation Issues with FX Conversion Member Formulas
Summary
ASO Aggregation Issues with FX Conversion Member FormulasContent
Dear Essbase community,
We are having issues with a currency conversion member formula where USD values are not aggregating to the parent members for the other dimension. Here are the dimensions in our PBCS ASO cube:
- Account (dynamic)
- Period (stored)
- Currency = Local (stored) and USD (dynamic)
- Scenario (stored)
- Entity (stored)
- Product (stored)
- Cost Center (stored)
- Project (stored)
We tried to add a new parent "USD Consolidated" member that is set to store and put the "USD" member with the member formula as a child. We know that we can setup an ASO procedural to calculate level 0 and have the data aggregate for the parent members, but we were able to get this to work in our on-prem ASO cube. Any insights would be highly appreciated?
0