How should Dynamic Time Series (DTS) members behave in a ratio member formula?
Summary:
Hi all,
I'm looking for guidance on how Dynamic Time Series (DTS) members interact with member formulas for ratio/KPI accounts in EPBCS.
Setup
- Period dimension: Jan–Dec rolling up to Q1–Q4 and YearTotal.
- DTS enabled on the Period dimension (Y-T-D, Q-T-D).
ProfitandCostare level-0 stored accounts loaded monthly.Profit_%is an Account member with Data Storage = Dynamic Calc, Account Type = Saved Assumption / Data Type = Percentage, and member formula:
"Profit" / "Cost";
Content (please ensure you mask any confidential information):
Expected vs. actual
Account | Jan | Feb | Mar | Y-T-D(Mar) |
|---|---|---|---|---|
Profit | 100 | 200 | 300 | 600 |
Cost | 500 | 800 | 1,200 | 2,500 |
Profit_% (expected) | 20% | 25% | 25% | 24% (600 / 2,500) |
Profit_% (actual) | 20% | 25% | 25% | 0 |
So the monthly values calculate correctly, but as soon as I select the
Tagged:
0