-
INV01 Module - Some observations in Override Switches
Hi Anaplan team In both 'Óverride Suggested Order Amount' and 'Override Shipping Method' toggle switch scenarios, when ''checked'' the user entered values at lineitems Override Amount and Override Method correspondingly reflect in Final Shipment Amount and Final Shipping Method as per formula.Here are the steps : Initial…
-
ARIMA forecasting method
Hii all, Does anaplan has ARIMA method of forecasting inbuilt in any app?
-
Subgroup within Parent structure
Hi Please refer the screenshot, we would like to further subgroup the records under each parent based on the job name. ex. for example, for the parent 'C-4K/768/960, there are 6 records, with two records for a job name. We would like to further subgroup the 6 records within a parent, based on Job name. Please see the…
-
not recognised as a hierarchy
Hi getting below message when I try to add formula to code as per 6.8.2 Activity .
-
How can I map these two dimension ?
I am writing formula for growth percentage where time dimension in weeks, and having product family as a list i.e. Product SKU's. In source module I have product family AS a dimension, where product SKU is third level of product family hierarchy. How can I map these two dimension ?
-
Ranking across a dimension consisting of multiple list items
Hello, I'm trying to create a sort of 'heat map' based on percentages within columns in a table. Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting. For example, 'training period' would have 'problems with…
-
Formatting Views in Dashboard
Hi, I am trying to format a view for a dashboard based on the business requirements and to make it more presentable in Anaplan. Following are my doubts, * How can we change the row height in Anaplan? * How can we color row to differentiate values belonging to a single row from other rows while scrolling horizontally? * How…
-
Mapping issue
HI, I have one Account flat list which has code for every accounts. there is one more flat list account items which is related to items within the accounts. So one account can be related to many account items list. there is one list which consist of items levels (1-5 numbers). so now i want to have values of account based…
-
Level 3; Sprint 1, Section 6.3
Hello, I am trying to verify the model as part of 6.3. But the numbers are mismatching a little. Initial Account Sales Target from my build: Screenshot from the training material section 6.3 File received from the training material and used for calculating the Initial Account Sales Target by Country and by Product Family.…
-
Multiple SUM&LOOKUP splitting workaround
Hi, I am trying to split multiple SUM&LOOKUP's used in a lineitem in a module in order to optimize the model performance. But while splitting the SUM & LOOKUP into different line items in separate modules (dimensioned by lists used in SUM&LOOKUP) , the result is not coming as expected. Since the size of lists is quite…
-
Difference between Calendar Type options - "Weeks"
Hi Context : In Model Calender, Calender Types reflects 3 different options like a) Weeks: 4-4-5, 4-5-4 or 5-4-4 b) Weeks: General c) Weeks: 13 4-week periods In exl there is "weeknum" to interpret the week number in a given date. Appreciate a clarification on different week formats provided by default. Cheers.
-
I am currently working on The essentials of Model Building for customers
I have not started my Lessons training. However, I am nearing completion of the essentials of model building in the customer module. I am in course 7.6 Drill to Transaction functionality. I have tried to drill down on Pet and Food supplies expenses but get an error message. I have posted a screen shot. I am not quite sure…
-
Locked Saved Module View
Hi all, I am working on L2 Sprint 3 training and I ran into a saved view issue. Currently, there's a lock on the Default view and I'm not able to view my SYS00 Planning Period Filter for UX. Any ideas about what I may have done to lock this option and how to resolve the issue? Thanks!
-
lines disapear from a dashboard
Sometimes published grids on a dashboard do not show the entire grid. As you can see in the screenshot below, the third line "Personeelskosten" at the last item of the grid is not shown. In the dashboard settings the percentage of Height are set at 499 and a minimum of -1 px. When the percentage of Height is set at 50 the…
-
Formula to choose Dec value
Hi All I have one unit in my module that is missing a monthly phasing for 2 years (2022 & 2023). I have value only for December, so I want to say that if there is no input in a month, it should pick up Dec value and apply it to all months from January to November. I'd prefer to avoid saying that if it's 2022 then take Dec…
-
Bill of Material Explosion - Best Practice
Hi, Pondering my head around a Supply Chain use case where a bill of material explosion is required with an undefined amount of steps to get to the lowest level. This should be an iteration where an SKU can have a one level explosion or up until 6 levels of bill of material. What is the best practice of Anaplan to set this…
-
FORMULA RELATED ISSUE
hello community, i have a lineitem Has Data? which is a boolean format and in the same module i have product and store dimensions i want to write a formula in such a way that if a store has a particular product then the corresponding boolean box has to be checked please help me with a resolution sai.
-
Prior year value for selected period
Hi All, I needed a logic to pick the values as below: If my current month selected is Jan, Feb or March FY20 then populate the value from Oct , Nov and Dec FY19 respectively. Thanks & Regards Madhu
-
Level 2 Sprint 3 INV03 Distribution center Summary
Line item 'stock exception' formula - I have summed safety stock exception line item of a major module based on 'supplied by' line item of a system module (I have used only one sum parameter. As per the training program, we are instructed not to use any summary method. However, I am getting the results only when i use…
-
Forecast an amount every 'x' periods
Hi, I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need…