Modeling

Determining A Line Item By Reference to Other Line Items
Hi all, I'm trying to do something that I think SHOULD work but I can't get it quite straight in my head so I'd appreciate some support. I've got a module that's holding employee data, dimensioned by Employee ID and by month. I need to be able to identify people managers, but the data extract doesn't have a flag for that.…
New Modelling Experience
There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS),…
Restrict access for import
Hi, I'm trying to amend the UX page for my organization. in the UX page, each user can import data into 'General expense' line item. After they import, they are able to check and view what they have imported. How can I set the access such that each person is only able to view and check the numbers they have uploaded…
how to add module
Hi All, I got access to the anaplan but my home page doesnt show anything even i am unable to add a new module as there is no option showing. Pl help. Regds, Chetan
Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
Hello Community! Is there a way to calculate the number of complete months between two dates in Anaplan? E.g. Start Date (MM/DD/YYYY)End Date (MM/DD/YYYY)Number of Complete Months07/17/202007/16/20211212/03/202103/31/2022310/1/202112/31/20213 In the second row, even though the duration between 12/03/2021 & 03/31/2022 is 3…
How to find monthly average of Daily Totals?
I want to create the average of every month of a LI that displays Daily totals. One of the LI's will be my total account balances on a daily bases, and then I would want to create another LI that would show me the average of those daily total for each month. How would I go about this? Thank you
Module Selection for Line Item Subset With >1000 Modules
We have encountered a bug where if there are more than 1000 modules in a model, the panel where you select a module(s) to assign to a line item subset does not work. There is a workaround available (provided by Anaplan support to us about a year ago) where we can look at the web-page elements and find the code for the…
LOOKUP function with a version module
Hello all, I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function : previous Fcst = Fcst Qty[LOOKUP: Param Version.Previous Version], Param Version is a system module that manages versions. It seems to…
Dynamic ranking not working
Hi Community, I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working. However, when I remove "group by" condition from rank formula, it ranks. Why is it so? Can somebody explain please? Thanks Alka
Understanding data referencing in Anaplan
Hello All, I am unable to understand how Anaplan is using data referencing. Please see the below scenario. I have to create a system module with product SKU details. I am using SKU Flat list as dimension and Code,Products and Distribution Center as Line item. I have imported the data from a CSV file and it looks like this.…
2.3.10 Activity: Create Demand Forecast
Plz can someone let me know are these formulas correct to go further in the assignment
Start function returning start of the week when I pass a Month period as a parameter
When I apply the Start function below against a Month period it returns the week period start instead of the start of the month for the month period. The calendar setting has calendar type set as week which I guess is the reason it's returning the start of the week. Is there an easy way or another function to that will…
A Good Plan: Spend Time on User Stories
In this guest blog series, Anaplan partner Spaulding Ridge examines what they have found to be integral parts of a good plan: the level of detail, the process, the people involved, the timing, and pitfalls to avoid. Writing user stories is one of the most impactful and exciting phases of the early Anaplan implementation…
Import Shipping Expenses into OTH01 Module
Hi, I am getting the below error. Here is my mapping What am I missing? Appreciate the guidance here.
Ability to generate a simplified scheme presenting all the direct interdependencies of a module
As a model builder, I need to be able to see quickly, for one given module, all the interdependencies with other modules of the model, both upstream and downstream. I need to be able to add or remove elements from the generated scheme if needed. I also need to publish it in a dashboard. The scheme elements will be linked…
Mapping Data from one module to another
Hi Everyone, Please consider following example, NameTypeAZPBRBZRBRCZRCLDZWIR I have a module A with 'Name" as list and a line item named type as shown above, now below I have a second module B with a List "Class" and the list "Name" in module A is a line item here. ClassName TypeABDA SHGB AJSC How can I bring the values in…
why DCA for formula based line item?
Hi All, Downloaded the DCA App from App Hub and looking through the examples. Have a question in regard to below screenshot, 2 lines in module, both have formula which means no user input and in effect read only, and yet DCA read write has been set up, what is the purpose? not clear. Anyway user can't input since populated…
Level 1 Model Building Exam Activtiy 5 -- unable to calculate right formulas
Hi, Can anyone please suggest to me what is the mistake I'm making here? Q:
2.3.9.1 Import data into DAT03 Historic Volumes module
hi in this run process in getting as below picture. Can u help in this
General Questions
Hello, I currently try to take a Anaplan lvl 1 Model building class and I don't have any accessibility to Anaplan system(Current company doesn't use). I applied for 90 days trials(I read that I need this) and Anaplan activated my account for access. From this point, I don't know how to start my course, can I start my…
Level 1 Exam Activity 5 - import txt data error
Hi All, I'm stuck and getting multiple errors when trying to upload the SYS08 txt file for activity 5. I saw another forum to not change the txt file to csv and to map e2 to code, but I'm still receiving errors. Do you know of any reasons why this error is persisting? I've provided screenshots attached. Also, anaplan did…
Abnormal behaviour of Actions
Hi Anaplanners ! Is Anaplan facing issues in the Action Mappings? I had renamed few line items(eg: Line Item A renamed to Line Item B) in the model, and tried to test the actions, but none of them worked. When i checked the mapping of the actions, what i saw is really strange. I saw two line items (Line Item A and Line…
New Modeling Experience Quick Edit in Formula Editor
To all the Model Builders and SAs using the New Modeling Experience - we have a new feature that just dropped today. We have just switched on a new formula editor feature to help you quickly enter edit mode if you have edit permissions. How it works You can kick off edit mode by: * Double click (left mouse button) in the…
Summary of Visible Items Only
Note: please send Kudos to this post to get it on the roadmap. Please can either model builders or end users have the option to toggle the summary method used on lists where it is possible to view the total of visible items only. For example, consider a list Countries in a module with one line item, Revenue. Countries…
not recognised as a hierarchy
Hi getting below message when I try to add formula to code as per 6.8.2 Activity .
Add Syntax Highlighting
As a Model Builder, I would like to have "syntax highlighting" when I create my formulas in order to improve readability.
Missing data when importing flat file
Hey! I am facing an issue when it comes to a data import. I want to build lists based on a flat file, and I get the file from another system, so I do not have option to modify the source file. The file structure is like the one below: Product CategoryProductCatregory AProduct A Product B Product CCategory BProduct…
Spare Anaplan Talent Builder Account
Hi all - I am trying to learn Anaplan and am currently on L1 model building training. It says to "Click to download a copy of the Level 1 Model Building 2.0 (New UX) model" but I am unable to do so because Anaplan requires a separate account from Anaplan Community. Since I am not currently with a company, I have to use an…
Values not being displayed in the TAR01 Detailed Sales Target module.
Hi, I am unable to view the values even after entering the formulas in the TAR01 module. The dimensions are quarterly but no value is being displayed in any format. Please refer the screenshots attached below. Please help in this anyone. Regards,
SYS05 Region not populating with Region List
Hi, The 'Region list' is populated but still the 'SYS05' code line item is not populating with the region code. What can be the issue. I have not made any changes to the 'SYS05' module. Screenshots attached. Pls guide.

Modeling

Discussion List