Modeling

New to the Forum
Greetings everyone, I am new here. I am new to Anaplan as well. I completed Level 1 and Level 2 training in December and I am happy to report I am now working as an Anaplan Analyst. I do not have a data background I actually was an insurance adjuster for 15 years, so this is a different path for me. In all transparency ,…
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…
Child with multiple parents
Trying to make a heirarchy where a child is having multiple parents Trying to fix it out .How do we suppose to import without getting any error
How to get the total amount without using Select Function
Hi All, I have created a module with a list 'Fruit" and a list with 3 list item "A, B and C" Afterward i have created the second module only include a line item and without and two list mentioned above. How can i get the amount of Apple in A without using the function of select? Since i would like to reduce the size of…
Anaplan L1 MB part 4
Not sure if this asking dic'2020 or FY2020?
L1 Error MB test
Hi, I was about to complete the anaplan test. And was told that we have two trials, for some reason my account appears as If I have already used an attempt. Can someone help me pls? 🙂
3.3.5.1 Create Inventory Ordering Module
Hi, may i know how to i import TRA01 to DAT02? Anything part which i may have miss out? not sure why my data is 0
Undocking in New FX
It would be helpful if the new user experience allowed you to undock tab's like you where able to in the classic interface.
Import a time range
As a model builder, I would like to be able to Import settings into Time Ranges. This would enable me to make Time Ranges more sustainable by driving their settings from an Admin Screen with actions.
reset times for minor issues are becoming a major pain i Anaplan
13 minutes because i used number instead of text as a format !! Surely this can be prevented, it makes developing a very slow process and stops a very busy office from working. Are we supposed to develop out of hours????
Dependent Pick List for Line Item Subset
Hi, I'm trying to set up a dependent pick list for one of my line items. I have set up the combo list with properties. The pick list is a line item subset. I'm not getting the option to create a dependency for my pick list despite seemingly setting is up correctly. Are LIS pick lists not able to be dependent?
How Do I View if a Line Item Has Been Used as a Filter?
Hello, I am doing some model clean up from a previous development team, and am trying to remove extraneous line items from the Anaplan model. Is there a way to view if a line item is currently being used to filter a dashboard, or module somewhere in the model? If not, that might be a neat enhancement, similar to the…
Azure Cloudworks navigation
Hi, At the moment its quit difficult to navigate through Azure Cloudworks processes and imports/exports. We are planning of having around 70 - 80 different integrations. Only thing what we are doing is naming Process names by numbers, but even so, number order is not working in all cases. It would be great if there could…
Look Up Not Working
Hi Community, I have a source module with dimensions of P2 (P1 is the parent of P2), In the target I have a dimensions of D1. I have one to one mapping done from D1 to P1 in a separate line item with dimensions as D1 and formatting as P1. When I use lookup formulae the data is not coming to target module. Any reason why…
Depreciation Straight Line method
I am Trying to calculate Depreciation by straight line method. But I don't know which function to use. It would be very nice if you me best method for calculation of the same. Thank you in Advance
Cumulate Function in numbered list
I am facing cumulate function issue for numbered list. If unique index number of numbered list are #1 and #3 , without #2 (deleted for some reason), cumulate function fails to cumulate for list item with unique index number #3. Please suggest any fix for this. Regards, Omkar
Pick Item name against item code
How to pick List Item against the List Code? have a situation..... explained below 1. I have a list which looks like the below 2. Using this dimension, there is a mapping module also. 3. Now, there is a set of Transactional data which consists of codes e.g. - <another list> etc. as shown below 4. Now, I am looking a way…
2.3.9.1 Import data into DAT03 Historic Volumes module
hi i have seen a few solution, however, i am still not able to go get. May i know how do i reslove this error? thanks in advance
1.4.5.2 Import from Saved View
hi, may i know how to import save view to P3 SKU? thanks in advance.
circular reference issue
hi, I am facing the below circular reference issue. what can i do to calculate "carried interest"?
Anaplan Compare functionality Issue - Name of Compare to
Recently this changed so that when you use the native Compare functionality in Anaplan classic, it no longer shows the name of what you are comparing to, but shows as "undefined". Previously this would have shown the name - in the screen shot, instead of "undefined" it would have noted the name of the version I was…
Grid & Row Formatting
Hi, I'm trying to format a module to make it more user friendly and am running into a few issues (see below). 1) I'd like to have an alternating row background, but for some reason I can't update the module grid settings. In Anapedia, it says the following: Change an individual grid style The default style for a grid on a…
Include Categories as part of in model Pages Menu
Apologies if this has already been posted but I was wondering if it would be possible to include categories (and perhaps an option to filter by these) in the Pages tab of the model development environment. At present it is only possible to sort by name, this may be confusing if categories are used to identify stage of…
Location Planning (as a part of SWP)
Hello All, I was interested in learning about location and Strategic Workforce Planning in Anaplan. I am currently in the FP&A space. Wondering if there are any literature, videos, or even learning models within Anaplan that I can have a look at.
How to populate number series in every upcoming month in a line item
Hi, I have identified the starting month to start the series through boolean and time period function. However, starting from that month till end i want to populate numbers in a series on every upcoming month(eg. if starting month is march then for march i need to populate 1 in a separate line item. now for April the value…
How to calculate distinct values ?
Hi All, I have a list which has Product as parent and SKU as list. I am trying to calculate the number of SKUs with demand > 0 for all periods. Right now, using this formula - If demand > 1 then 1 else 0. The issue with this formula is that the summary adds individual SKUs with demand at yearly level. See below screenshot…
Duplicate entries - Module to module import
Hi, While carrying out a module to module import, if we do not import zeroes first in the target module, the values tend to sometimes double up if we execute the action twice (even after selecting the "Clear target prior to import" option while creating the action) but sometimes they reflect correctly even after executing…
what are the most common Challenges in anaplan & how can we deal with it
Hi guys, Anyone let me know, What are the most common challanges in anaplan while dealing with client & in support projects . How can we deal with it
NUX Board optimization : Copy Formatting
Hello everyone, I am a Solution Architect and building applications and pages. I am aware of the functionnality "Save card as template". Nevertheless, I think we miss a functionnality here. In fact, the functionnality "Save card as template" give us the possibility to copy & paste a same card to another page but the…
Total of specific nodes having selective access enabled
Hi Team, I needed help on how to get a total of selected cost centre from a List for which a user is having access to (only specific nodes) sub total is required to be viewed on a report. For example: In screenshot below: User wants to view a subtotal of specific cost centers(for which they have access) in Reporting…

Modeling

Discussion List