Modeling

1.4.4.1 Create Build SKU Saved View (Product column)
Hi, for the following activity, I should have product names shown in the "Product" column. However, my result doesn't have product names showing, but it has product names showing when clicking the arrow. Could anyone help me figure out what am I missing here?
How to prevent misentry by end-users when importing.
Hi Anaplanners, On my current model, there is an export module providing a CSV template for end-users. When end-users get this CSV, I’d like them to be submitting the date format correctly (ie Q1F Y23 rather than Q1FY23). Does anyone know if there is a way to put a drop-down list on the date column of a CSV file to prevent…
Level 1 MB Time Settings Month name display
Hi, After configuring the time setting I got the result below. Fiscal Year Start Month is displayed as "M01" while Current Period - as "Jan 20". What causes the discrepancy in view/format? Do I need to correct it, and if so, how to fix it?
Level 1 MB, Lesson 7, Number formatting while import data
Hi, While importing data to the Module SYS08 Employee Details I ended up with Commission % 15 instead of 0.15 as in the source file The format of this Line Item below How can I fix this?
Auto Code Generation
Hi all- I'm trying to automatically create budget codes after a new expense has been entered via input grid on a UX page. Overall, I'm having trouble generating a numerical sequence after the other parts of my concatenated code. I've so far been using RANK(1, DESCENDING, SEQUENTIAL) but having it skip by 15 every line.…
Data type mismatch: format other than LIST or DATE being referenced as a relation
this is the formula IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0
Difference between custom view and saved view
Hi, Could anyone please tell me Difference between custom view and saved view. While designing UX which should we have to prefer. Thank you.
12.4.4 Activity: Create Saved View for Profit & Loss Report
this is actual which should have 0 as given
How to lookup a value from a source with no time
Context * My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time * My Source module has the following dimensions: (1) Movement Code (2) Line Items* Employee ID is a line item (List) * Effective Date is a line item (Date) Goal * In the destination module, populate an employee's job level…
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
my resultthe lesson result
Look up for future periods
Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future periods. We then have a module that groups various job codes called Professional Services Profitability. This already splits…
Stacked charts with several dimensions UX App
I published a post on the Anaplan Community concerning the problem I'm facing on an App Anaplan, and I've been told to post an idea regarding my problem, so here's the problem I would like to solve: I want to create a chart from a module that has several line items and dimensions: -Dimensions are: Time, and a List composed…
12.4.4 Activity: Create Saved View for Profit & Loss Report
the result displays the actual version whereas it should show only the budget and forecast version the lesson reslutmy result
Data from Line Item Subset back to original line item
Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my main module. Thanks, Tom
Regarding 80000 Character Limit in Mailto function.
Hi, Can anyone please clarify whether spaces and newlines are counted as a character in the 80000 character limit in browser? Thanks and regards, Aakash Sachdeva
Filter References
Hello all! In the modules screen within settings, you can view whether a given module is shown on a dashboard AND which other modules reference that module. This gives a great indication whether or not that module is active OR whether it is a candidate for getting deleted. What is NOT shown, however, is if a given module…
Referencing List Items in Formula
I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that 1. references data from another module, and 2. does some calculations for all the data in each item for PR2 Product…
Can module 'Applies To' have multiple lists from the same hierarchy?
I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have P1 Product Lines, P2 Product Families, and P3 Product Names. I have module D07 which shows how many slots each of P2 Family…
Model Architecture and reporting stages in anapalan
i am learner i want to know that the Architecture and reporting stages in anaplan, i was totally balnked seen this questions. help me out on this.
Looking up Day of the Week list for a LI in a different module
Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I have weekdays as a list but I'm getting a error message when I try to use LOOKUP, SELECT, or SUM. Please advise. Blue Print…
Architecture of the model stand alone model using ALM?
Hi I am learner till i have faced issue questions in panel Architecture of ur model and what is the meaning of stand alone model. based on that stand alone how can u use ALM by steps. Another one query about reporting(stages) and permission staging. it will be helpful further to improve my skills.
haschildren(List)
There should be a haschildren() function that takes in a list that a module is dimensioned by and returns a boolean, indicating whether or not the list member has a child. This would be especially useful in conditional formatting with multiple dimensions, where for one of the dimensions, you do not want the conditional…
10.2.6 Activity: Add Formulas to Employee Expenses Module
Hello, Anyone Can help me to figure out the error in Bonus, not sure where I am mistaking it. I tried both way Copy and Paste the formula also written it. However, still have having same issue. Please find the attached screenshots. Thanks.
Have a line item that does not apply to a dimension, not repeat itself
Hi guys, I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details about the list and then another module which has the time dimension look at revenue for specific accounts. I have pulled through…
The values doesn't appear in Gridview
I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different subsets from the same list for each module. Blueprint of Module 'Sales Qty - Motor' Gridview of 'Sales Qty - Motor' I use a…
DAT01 Level 3
Hello, Can someone explain me in which step I need to create the DAT01 module, I started few weeks ago level 3 and now I'm stuck at 4.6.5 Level 3- User story 3 where I need to create DAT02 module, but the first one is missing from my model. Thank you!
Convert Months to Quarter
Hi, How can I sum my months to get the quarter value in another module? My source module is using month, i turned off of the summary SUM for Time. (to save space) My target module, i want to get the quarter value of my source. Thanks, Tom
Model Building Level 1 Model Building Activity 6 8 1
I thought I followed the steps properly, but my finished product looks like this but, according to the solution, it's supposed to list the regions in columns to the right of code. Can someone please help me understand what's missing?
how to import model to model without ALM
i am new learner of anaplan please explain how import model to model without alm
10.2.2 Import Data into Non Employee Expenses Module
hey guys what date format do you do I am at my wits end lol HELPPP

Modeling

Discussion List