Ignore Timescale as a dimension if Time formatted mapping line item is used for aggregation

Options
Eugeny.Seledkov
Eugeny.Seledkov Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
in Planning & Modeling

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.

Tagged:

Categories