I have seasonality input per month (January, February, etc.), summing up to 100% in a full year. How can this be uploaded to the timeline?
Hi,
In case you'd like to import a source (1 for Jan in your case) to multiple targets (Jan 16, Jan 17, etc.), this is not possible. But, in case your assumption is that distributions are defined by month and equal over years, why don't you:
1. create a list (Jan-Dec with code 1-12)
2. build a module with this dimensionality to load the distributions once for all periods
3. link it to the module with time dimensionality with a look up for further calculations in your model?
If your load is purely a prepopulation of data which can be manually adjusted by the end-user, you can consider to:
1. make two line items called Seasonality input and Seasonality final
2. make a formula which says: if year total of Seasonality input = 0 then Seasonality input else 1/12
3. enable the user to change the input and use the final values for calculations. In case the user doesn't input, the value is defaulted by 8.33%
4. optionally for the final value: divide the input value of the user by the year total value to make sure the value always adds up to exactly 100%
Build a module which only has dimensionality Time:
1. add a line item called Year and format Time -> Year
2. give the formula: PARENT(ITEM(TIME)) to the line item
2. LOOKUP this field to take the year value for each month
Time is not a list indeed. It's a "Time Period". Take Format Type: Time Period. The printscreen might help you as well.
In the settings of the mapping it's possible to define how to map the source data into timescale. Select Periods in specific year and define the year you'd like to have the monthly percentages imported in. In the printscreen you can see the settings to select.
Hi Jethro,
Thank you for your response! Only I need some more guidance to resolve my question:
The data I want to import has the months in the rows, which have to be imported on the time dimension for all the years that are in the model (see attachment). Meaning that for all January columns the Seasonality should be equal to 8.33%, etc.
The way I import it now, that is shown on the picture in the attachement, Anaplan is importing the rows as rows and therefore, no data is imported.
Thanks a lot, how can the year total value be applied in the formula?
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
