-
Simplifying a formula with multiple checks for User Input
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) .…
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
Identifying list members with booleans
Hi, I need to identify list members using a boolean. (What I tried is at the bottom) In a system module SYS06, I have a line item "P2 Product Brand" that is populated using a list (shown in photo 1), it is list formatted. Photo 1 then, I created a boolean line item that is intended to check in another module SYS03 (Photo…
-
Looking for text in modules
Hi, I need some orientation on this: I need to look for a text in the column "P2 product Brand" (first photo) in another module (second photo) and if it is there, I need to return TRUE otherwise False this formula should populate the last column of the first photo. Both columns are formatted as lis, and they are populated…
-
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.
-
Modeling advice: How to build item level discounts for set time periods
Looking for help and advice on how to build out a discount function in our model. My company manufactures products and sells them to stores, for this example let's say our customers are Target and Walmart. Our business will give special discounts on specific items (~10 items) for specific time periods, like May 2nd through…
-
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…
-
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…
-
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…
-
Add a dependent to the listings with Top Level.
hi! I want to add a dependent to the listings with Top Level. I would like to prevent TopLevel from being selected in the pull-down. How to do it？ Please help me.
-
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
-
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…
-
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…
-
calculation
Hi experts I have use a list for time dim. and i considered four week in every month . i just want that in first 3 week there is the 7 days in the week and in 4th week there should be rest of day in that particular month . i cant get how we can do this when we used time dim. as a list . suggest me that process I have also…
-
Best way to have a daily model in Anaplan
Hi, I'm creating a Daily model in Anaplan that needs to skip over weekends and Holidays. Instead of putting a formula in every LI. What would the best way to approach this? Should I be by creating a LI in the SYS's module that has this formula that will skip over weekends and Holidays and then call upon that formula? Or is…
-
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…
-
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…
-
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…
-
Model Optimization
Blueprint Analysis Model Analysis techniques using Excel What? A model analysis technique using metadata from your Anaplan model imported in to Excel; utilizing purpose built formulas to identify line items of interest. Why? We do this so that we have some extra information to arm ourselves when trying to optimize a model.…
-
Text Functions
There should be a function to convert Date to Text -- call it TEXTDATE(x)