Modeling

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…
8.5.3 Activity: Import Data into Volume Inputs Module
I am trying to upload Data into Volumes model . Please help me
Override and Edit
I want the Override Sales Target line item to be editable for input when Override boolean Line Item is checked (i.e. true) for the same row otherwise it should be all 0.
Show Precedent Line Items
Excel has a great feature that shows dependent and precedent cells for formulae. For those that do not know, here is a screenshot of trace precedents in action: The blue arrow is indicating that Profit is dependent on Costs and Revenue. This is a great visual way to show how cells affect one another. Whilst Anaplan…
How Define the current time period for system
Hi Guys, How to define the current time period for system with out using Current Period & Switch Over, isactualversion & Iscurrentversions. is there any possible way to get with formula. BY this formula, system should find the actual period and Forecast
CAN Property become list
can any let me know, can the property become subset of a list
Level 2 3.2.11.2 "Filter to show months only" - in a saved view
Hi all, I am working on Level 2 3.2.11.2 which is: And I am stuck on the last bullet point "Filter to show months only". My original SYS00 looks like this: And I made the saved view as per instruction like this: The final produce at stage 3.3.12 to look like this: Where the first grid to come from the saved view. I assumed…
Put total in a line item
Good afternoon, I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
ALM Version Structure Settings - Allow for CURRENTVERSION setting updates in PROD model
Other structural version settings are now unique to the production environment and the Current Version setting should be allowed to be changed directly in the PROD environment as well. Currently if you are using the native version formula settings in order to calculate for specific versions, there is no dynamic way to…
combine two line items
I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?
6.11.2
I am having a problem with inserting the formula. In level 1 lesson 6.11.2 You have to put formulas in for actual, budget, and forecast. the formula for actual and forecast worked fine. but when I put in the code for the budget it does not work. See photo
actual and forecast
Hi there, Anyone please help with the formula, Here i have actual value in one line item based on that the override line item should be editable. where jan22- apr-22 is actual values, show that override line item should be editable from may 22 Please suggest

Modeling

Discussion List