Modeling

Level 1 Activity 6
How close am i here??? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0
New Level within Hierachy
I have an established hierarchy and need to add a new level within the middle of it. Currently, the hierarchy looks like M1>M2>M3. I will be adding a new level between M1 and M2. The current M2 and M3 will be children of the new M2. My concern is around the formulas already associated with the levels in their current…
Error when Exporting Text formatted Number: Missing Leading zero
I have a text formatted line item called Company Code = "0505" When I export the module, I noticed that the Company Code becomes 505 instead of 0505. Why was the leading zero removed when I exported it? To solve it I created another line item thats number formatted and called it New Company code = VALUE(Company Code) The…
breakback when using average
consider adding ability to use breakback when the summary method is set to average (number entered into the summary period is entered into each of the lower time members). seems like a no brainer. would be used a lot for many % line items that are used in modules. thanks.
Level 3 Import to A2 Account>Product# list
Hi, In Level 3 Activity 4.6.4 Import data from the Data Hub model to populate the A2 Account>Product# list Here I have created a Saved view in Data But for Module SYS14 Create Account>Product to import this data to A2 Account>Product# list. But could not import successfully. I have seen both Product List and Account List…
Certified Model Builder - Certificate
Hi, I completed Level 1, Level 2, and The Anaplan Way. How can I get the certificate "Certified Model Builder"? I found this article, but the link in the article does not seem to work - Certified Model Builder Certificate Thanks!
Level 2 Sprint 1, Create a filter to show only half-years. (Hint: Use a system module)
Can anyone offer guidance as to how to create the filter to show only the half year view? (for 1.6.3.3 Create Saved View for Export.) I have this now: So in order to hide the FY20 and FY21 columns to meet the requirement, the hint is to filter using a system module. So i tried this: But this resulted in hiding all the…
Time Range Start Period That is relative to current time period
Current: Time ranges require a fixed start period Request: Enable time range start to be setup relative to a specific period such the current time period. Also would be good if you can set up the start period with an offset. E.g. start period is current period minus 3 years. What occurs in several of our models as that…
Scenario planning across multiple models
We have 3 to 4 different models that feed from/to each other where we need to perform connected scenario planning across all models. For those who have had to develop this functionality. I wanted to check how you've implemented it, pros and cons of what you did and if you could do it again if there was anything you would…
User wants to change the employee's department.
Hi, There are lists (Department and Employee where the Department is the parent of Employee). I want to make a UX page where the user can select the employee and change his department, therefore details of the employee such as salary will reflect in the new department. Please let me know how I can achieve this. Thanks in…
Incremental Load
How to do incremental load when there is change in any one of the list properties?
Create a "Date Last Modified" column in Modules to let Admins see when line items were last changed
I would like the ability to interrogate when a Module has received changes to specific line items to help in troubleshooting bugs. For example, when someone changes a line item's summary type, or formular, or data type, or name etc. this should ideally change the "Date Last Modified" for that line item. I could see this…
Avoiding Circular Reference
I have a list of Manufacturing Plants. The output material of one plant becomes the input for the next plant. The cost at which a material is transferred from one plant to the other is the weighted average of opening stock cost, production cost and cost of materials transferred from other plants. Since the cost of one…
True Connected planning : Formulas between models
As an anaplan coe and model builder, i d like to increase models interoperability and achieve the true connected planning ambition. To achieve that i need the ability to call into formulas line items from other models. This cannot be achieved currently and every model builder who practise import actions (who doesnt ?) To…
Item count in subset tab
As a model builder I'd like to be able to see number of items in a subset. The same is applicable for Line item subset.
SYS02 Region Details
I am stuck in 6.8.1 I can not see region details, my model is not same the screenshot, please guide. Thanks,
Bulk Copy for Production Lists
Need ability to be able to create a bulk copy action for the production lists.
Need help connecting text values between two modules
I have two modules with a common text formatted line item Employee ID. The modules are DATA03 and ADM07. In ADM07 there is a corresponding text line item called C4 Code. I want to bring the C4 Code value into DATA03 into the C4 Connect line item based on where the Employee ID line item matches between the two modules. What…
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
UX Page ability question
Hello, I am trying to figure out below two things for UX pages Is it possible to add status of a running import job on the page. I have user action button that starts a cloudworks integration job. Anyway to show status of the job like its running or is complete? Also I notice that once the import is finished, the data on…
NUX - Text Card - Use Hyperlink Line Items as Dynamic Text Values
We are trying to put together a landing page where the user can see basic information about the purpose of the tool + and can have supporting links. With the new edits to the text cards, it is really nice to put together such page. I was trying to use dynamic text value functionality to use the text-hyperlink formatted…
FINDITEM(Manipulation)
Hello All, I have a situation where I need to do a FINDITEM on a bit different situation. I have one list called Org with codes such as 1001_AX_501, 1002_BX_503, etc. Other list called CC with the same set of members, however, the codes are 1001, 1002. In order to map them, I need to do a FINDITEM with some twist so that…
How to Make a Line Item Manual and Highlighted Yellow
Hello Anaplan Community! I have a question about adding new line items. When I add a new line item to a module in the backend of Anaplan, how do I know for sure the line item will be manual entry and shown highlighted yellow in the app page? For example, in the screenshot below I inserted the highlighted line item and as…
Add 'Does Not Contain' as condition when performing a filter on a text formatted line item
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, however a 'Does Not Contain' would also provide a lot of value.
Five tips for a (mostly) painless model rollover
Author: Clarissa Hassfurder is a Certified Master Anaplanner and CEO at Double10 Consulting. As Anaplanners, we all hope that when a model is being build the Solution Architect and model builders think about and document all maintenance requirements for the admins. But this isn’t always the case, especially when many hands…
Retail: Markdown Planning
Summary As a buyer, you are responsible for managing your price reductions to a monthly markdown budget. But markdown management at your company is not that straightforward. You must also adhere to the company’s pricing policies when considering a new price for your items, including having to use price tiers, percentage…
New UX Idea - Dafault source model listed in more than one model used as a source for a page
This will be helpful to choose a default out of two or more sources used in a created page. Currently users see the first listed source when they open a page for the first time. And can be confused of the wrong data they see on the screen. The order in the settings of a page below does not affect on how the models will be…
RE Create Inventory Ordering Saved View and Export
Hi , Please guide me how to filter out parent in rows to make exactly same as export view. Thanks Abhishek
How to delete Anaplan Community Account
How can i delete my Anaplan Community account which i deleted by mistake.
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…

Modeling

Discussion List