Modeling

Importing into a list based on a specific value of the parent
Hi, I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list. The model has the following Hierarchy: In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property: On a…
Regarding Successful and Unsuccessful login
If we have a SSO model . We want to gather the details of Successful and Unsuccessful login for last 6 months. Is there a
Level 1 SYSO8 Errors ( but not for date, salary, or commission)
Hi, I receive an error message after I import Employee details into SYSO8. I got the dates, salary, and commission to work. However, it says other fields have errors. I want to ensure that I have done things right before proceeding. It did not give me an option to match dep code, country code, and Active?. Am I missing…
Linking formula
Hi, Please see details on the attachment. Regards,
Level 1 model building #E2 List Upload
Hi, I cannot seem to fix my employee list import. I keep getting the same error. If I select code, it will not let me import and if I select #name it will fail. The steps in a previously answered question were not clear. I also notice in my import source that display name property is missing even though I have it in my…
Certification Level 01 / Level 02
Hi everyone, I've recently passed both Level 01 and Level 02 trainings (Previously, I had 101 and 201). I did it online, is it enough to justify the official Model Builder certification? I received the 2 diplomas. Also, I plan to get the official Solution Architect but I have no clue on how to obtain it. I've been told…
Dynamic Cell Access (DCA) with subset
Hi Guys, I am trying to create a DCA access control module and noticed something . Wondering if someone can shed some light on this So i have a list and the list has a subset eg below I have 3 modules -First one "lets call it module" has above list as "Applies to" with 1 line item "Read" as Boolean and Formula as "True" .…
Day Count Convention (YEARFRAC)
Hi, has anyone found an alternative to Excel's YEARFRAC-Formula? The formula has various day count conventions such as Actual/Actual, US 30/360, Actual/360, etc. I am trying to get the year fraction for different time periods but it's quite complicated in Anaplan. Best, Evgenij
Re-ordering list item subsets in the list setting section
Hi Anaplan community, I believe I have just encountered an Anaplan bug but wanted to share if anyone has experience the same issue and whether it is a known bug. When creating a list item subset I have attempted to change the order of the list item subsets but even after changing the order and returning apply the list item…
Mapping Data Based on Combination of Codes/Number
Hi All, I would like to hear your idea or case regarding the topic. What needs to be build is to map the code based on combination of codes/number (please refer to the attached image that describe mapping logic table). I can create such logic but too much complicated to maintain(Use tons of IF, LEFT, and such). The table…
Difference between Top Level Item, Parent Hierarchy
Hi, I would like to know the difference between top level item and parent hierarchy. Is the top level item necessary when there is parent hierarchy?. Also, when would one use Parent in the list without having Parent Hierarchy and/or top level item? Would appreciate some clear egs. Thank you, Cheng Hong
Count with time dimension
Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details. Regards,
App analysis
Hello Team, Recently I started analyzing on Sales forecasting app from app hub. I didn't understood the concept of vice president, Area Manager and District Manager. And also their target value is same in Quarterly Rep target module. Thanks & Regards Keerthi
Multiselect booleans - how the Hyperblock behaves?
Dear Community, I'm seeking for your assistance with the following topic. In the model I'm contributing to we do have a possiblity that allows turning off/on some features. It's done using simple boolean line item dimensioned by list of features (to keep it simple). Let's say it looks like that: FeatureBoolean…
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
Day time period format
We currently cannot have Daily as a Time Period format for a line item Use Case: Mapping from a fake daily timescale to Real time. Issue: Currently we have to use a date formatted line item and to map from a Fake Daily timescale in the format 1 Jan 2019 to a date requires a lot of text and string manipulation
Swtichover set to False driving Formula error
Hi team, I have a Line Item where the Formula Scope = All Versions & Use Switchover = True. When I turn the Switchover off I receive a 'Formula is invalid' error I have tried removing the formula, setting Switchover to False & return the formula by the same error ocurrs I cannot see why this error would be happening. My…
Territory Allocation Urgent
Certified Model Builder
Hello, I completed Anaplan Way Training and also both Level 1 and Level 2 Model Builder trainings. As Certified Model Builder is a step in Anaplan Training Path for Partners is there an additional certificate or badge for it? Regards, Jarek
Rounding function giving different result for similar numbers
I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers. Original NumberRound to 3Round to 2 P131.49496$31.495$31.50 P235.49528$35.495$35.49 This should be 35.50 Formula used for rounding to 3 - Round(n,3) Formula used for rounding to 2 -…
Limit on Importing using "Combination of Property"
#Gurus, I am aware that we should minimize the use of "Combination of property" and get a unique ID from the source itself. This case is an exception, where the client IT team has turned it off. Is there any limit on number of records that can be processed when we are importing using "Combination of property". Thanks Arun
New UI
Hi team, I cannot able to see Action Features in my NUX. but my colleagues have this feature. Could anyone please telll me whats the issue. Action Feature is not visible
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
Transfer Employees
Hi, I was wondering how people handle transfers in their model. I saw a previous post that referred to a doc but I can't seem to find the doc. Any advice? Here is the previous post: https://community.anaplan.com/t5/Locked-Product-Requests-for/Transfer-Employee-Button/td-p/2821
Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
modelling
Hello, I have one scenario where i have to select start date and date. my requirement is end date should not be selected before start date and end date should always greater than start date. Thanks,
What Anaplan Does Distinctively?
Many many things, though few to spotlight as thoughts of the moment: * Delivering an enterprise-level planning analytics applications without any dev-ops process. Unbelievable! * One-stop solution to hosting data, making transformations, managing hierarchies, and providing real-time reporting. Completeness! * Data View/…
Anaplan Lookup Question
What could be the underlying reason behind allowing lookup only through list formatted line items, not through a normal text formatted line item?
Production Optimization
hi I am working on production optimization.I am getting error regarding C3 constraints. I have attached screenshot of formulas. Please guide me.

Modeling

Discussion List