I ran into the issue when I needed to pull the data from the module with a timescale as a one of dimensions to another module that also contains timescale as dimension. I used time formatted line item in the source module for aggregation but it's been ignored in the Result module and error message box has been appeared.
Example:
Source Module | |||||||||
Timescale / Line Items | FY10 | FY11 | FY12 | FY13 | FY14 | FY15 | FY16 | FY17 | FY18 |
Value | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Mapping Item | FY20 | FY23 | FY19 | ||||||
Result Module | |||||||||
Timescale / Line Items | FY19 | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | FY27 |
Expected Value | 7 | 1 | 4 |
When I set a formula for Expected Value = Source Module.Value[sum:Mapping Item] Anaplan shows "An error has occurred on the server. The model has been restored to its state prior to the last submission."
In order to avoid that I need to create intermediate line items with excessive dimensions. It consumes space and isn't efficient.
It would be very helpful to add ability to aggregate the data using Time Formatted Line item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.