Account with two pass and stored formula is not pulling data at the Year Total level
Summary:
We have many % accounts that have stored formula with two pass.
a. When we pull these accounts vs year total at top level of other stored dimensions, they populate the correct % values in the ON-PREM Essbase app.
b. Then we run a calc to call these stored % accounts so that the formula gets calculated for all descendants of the stored dimensions.
We are migrating this essbase app to cloud as a planning application. In cloud we lost the above functionality where these % accounts will populate the correct values at Yeartotal at the top level.
Moreover, when we run the calc to call these % stored accounts, it shows aggregated % at year total, therefore ignoring the two pass functionality.