Modeling

Distribution Capacity Module -3.5.4.2
I am going around in circles with this task. I finally got to a place where I know where the numbers are pulling from into Inv04 module. I need to calculate the beginning inventory by month and distribution center. The data source time dimensions (Inv01) is in weeks and the target in Months (Inv04). Initially, I was under…
How many dimensions can we use in Anaplan
I am the beginner so i would to know about the how many dimensions can be used in anaplan and please let me know in details or other market committers have using not more than 30 dimension.
Time Filter - Current Period
Hello, I have a module which is NOT Time dimensioned. I have a line item named as "Year Filter" with Time scale as years and Boolean formatted, formulae with different conditions in the same module. When I apply the "Year Filter" in the saved view in the same module, I DONT see "Time: Current Period". It shows specific…
Creating code for numbered list
Hello all if I need to create and add code to already existing numbered list. What are actions to be taken. I understand list should be exported to excel and then create code and reimport to model but how to create code? What’s the best practice to ensure uniqueness. Thank you
Model builder roles and responsibilities and he can participate in testing or testing team is differ
I am the beginner so confusing the roles of Model builder and responsibilities and he can participate in testing or testing team is different, i am not able to find those answers and i want to know the project team members available. there roles and responsibilities
Best practice for supply chain route planning?
Dear, I am building a supply chain planning system, which has different order types. Depending on the specific order type it has to hit only specific workcenters in a specific sequence with specific lead times. I have created a list with the different order combinations, e.g. "ProductA_Wood_Black" And also a list with the…
Convert Numbered list into text
Hi, I am having a hard time trying to convert a numbered list into a text value. I have used the NAME() Function, but as a result I get the Number assigned to the list member. Instead I would like to get the text value of the Display name. The reason why I am trying to do it this way is because I need to Concatenate the…
Provide the ability to filter+sort modules in the Modules in particular in the "Applies too" column
In short the title explains the proposed improvement. When you have larger models or multiple MB working on a model, giving the ability to quickly find and sort makes finding other places that someone is using the module to complete significantly easier and quicker so you don't duplicate work, can reference other modules…
Long Term Planning with 2 Models
Hi everyone, We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028. Ideally the LTM…
User stories
I am the beginner i want to know the information about user stories who will write user stories who will do testing on it and in the project how they implement the user stories
Data type mismatch: format other than LIST or DATE being referenced as a relation
any suggestion on how to resole above error
List parent in module along with time columns
Hi there, I would like to add a parent column for the list in my module. I want to create the following module which shows the list parent in the second column: At the moment I have the left and right side of the image as that part is a straightforward pivot: Page = volumes line item. Rows = Customer-SKU list, where…
Level 3 sprint 2 - How to populate G4T Territory>Account# list
I am stuck in G4T Territory>Account# list in Level 3 sprint 2. A2 Account>Product# list was similar to this one and we imported from data hub. It was clear for me. We assigned combined codes for the intersection cells in account-product matrix then imported it. In G4T Territory>Account# list is confusing. I couldn't figure…
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
Manual Filter for a Hierarchy
Anaplanners, Had a table that displayed different layers of the hierarchy. Layer 4 rolling up to layer 3, layer 3 rolling up to layer 2 and so on. If i as a user select layer 4 then only layer 4 needs to be displayed in the table. I know there is a native anaplan functionality where we can select the hierarchy but we…
Optmizer issue - "Could not parse Optimizer configuration"
Dear experts, I'm trying to create an Optimizer, where I'm defining the Objective, Inputs and Variable. However, I get an error "Could not parse Optimizer configuration". Is it compulsory to define the constrain in it? Can you plz suggest what could have possibly gone wrong based on the error message. I tried to search any…
Level 3 Sprint 1 Story 7.3 unable to match the data
Hi I am trying to match With But no success. I mapped Segments directly from SYS02 any suggestions?
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All followed by IF VersionsControl.Budget THEN .... ELSE...
How to insert member in a list in between an order using actions?
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so…
13.3.4 Activity (Add formula to Profit and Loss Module) - understanding what these formulae mean
Hi I am working on the above activity, but struggles to understand what these formulae mean in the following format (If, then, else) with the sum function in the formulae: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and…
level2 :Create DEM03 Demand Forecast Module
Hi I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup the SY08 product family as an intermediary module since dimensions are not same but still the message is showing invalid.…
Employee Expenses
Hi, I want to be sure in the Level 1 exam, the question is asked for FY even though the Employee Expenses are not based on time. So, since all Employee Expenses are given as currently values, the values for all FY are the same, is this normal? Thanks, Mark
Anaplan Live! Model Contributor Meet Up
Attending Anaplan Live next week, in San Jose? Make sure to swing by our Customer Connect meet up, specifically geared towards Model Contributors of all levels! Our own @rob_marshall will be leading a relaxed conversation and connecting attendees with similar backgrounds. Sign up today. Unable to join in-person? Make sure…
Ability to Add Multiple List Items on a Grid Card in Worksheets Additional Insights
Currently, there is ability to add multiple items in a worksheet main view: When there are grid cards in Additional Insights, the insert multiple items option is not available: The option to be able to add multiple list items without additional actions/processes is really helpful in addition to making the experience for…
Count in numbered list
Hello everyone, I am facing a problem in counting the same names in numbered list. Let me explain with pictures, I have a numbered list :- Style. In this list, every member has different code but multiple members has the same Display name property as shown in the picture below. I have a module "Module M1", where this list…
New Model Experience - Formula Editor Function Tool-Tip
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after typing the start of any function, a hovering display lists the required/optional parameters needed. As an example, typing…
2.4.7 Activity: Create Saved Views for UX
I have created a saved view as required for this activity but my work is markedly different from the example provided and i have not been able to figure out why. Here is my saved view as opposed to the example Example : My View: Here is how i set up the Pivot for the Saved view I want to view the Initial Demand Forecast…
Offset Formula Help
Hello, I am unsure what went wrong, but my Offset formula for FY20 is no longer populating. I had it working previously, but I don't know where I went wrong. I've been using the appropriate formula for calculating it and triple-checked the SYS01 it was pulling from. I was confused when my FY21 values weren't showing up in…
Finding blank cells in a number line item
I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to find blanks in a number formatted line item similar to the ISBLANK function?
Alternative for SUMPRODUCT
Hello Community, Is there any Alternative function as SUMPRODUCT()... If there any method please Suggest.... Thankyou In Advance. Regards, JeevaK

Modeling

Discussion List