-
Level 1 Model Building
Is this all correct?
-
Anaplan front-end language
Hi, I read that Anaplan language is browser-based but I changed my browser language to Spanish and I still see it in English... is there any additional step I missed? Thanks!
-
Dynamic Day Calculation
Hi, We're struggling with a conceptually easy topic which is surprisingly difficult to model build in Anaplan. For a dynamic ordering calendar, so the days when you can order can be adjusted and are not fixed, we're looking to define the amount of days in between two ordering days. Technically I'm stuck at the point where…
-
Information for Line Item Referenced By Actions
It will be helpful to have information for any line items that are used or mapped in actions either in list or line items mapping tabs. This will prevent deleting them accidentally when performing a model cleanup
-
Level 1 Model Building
I'm not quite sure how to get rid of the column heading that aren't necessary.
-
Module Pivoting
The Module currently does not have Version in it's Pages, Column or Row and Version is now required in Pages. Been trying various options.....still can't find it. Where else have I been missing?
-
line item with no time dimension
Hi, I have a module with no time dimension.In this module I have a line item "Contract Amount". In another module that has time dimension, I also have a line item "Contract Amount". In Jan 2020, value of the contract amount is 100,000. In Feb 2020, value is 120,000.In Mar 2020, value is 130,000. It is now June 2020. The…
-
Show Multiple Spaces in Module Names (Bug?)
Not sure if this is a bug, or just a weird feature. If you enter multiple spaces in a module name, Anaplan will trim to a single space when displaying the module in the modules panel. For instance 'Country P&L' becomes 'Country P&L'. This becomes an issue when using the search function to try and locate a module. The…
-
How to set default value for list item
Hi,everyone. Can I set a default value for a list? I have a list of calendars. For example, if the current date is February 1, 2020, I would like to display February 2020 in advance. Best regards. Taku.
-
Level 1 Model Building
I completed the last two steps but the first two I just can't seem to get right.
-
where can I find export defination after exporting?
since "When you save the export definition, the sort criteria, filter, and rows/columns that have been shown or hidden are saved with the export." If saved the export definition, where can I find these filter, row/columns, shown/hidden information later? (I have several saved exports and some of them are not from saved…
-
Selective access based on property
Hi all, I have a list of customers belonging to a region . Every customer is linked to a unique account manager. I have a SYS- Customers module, with the customer list as a dimension and the account manager as a list-formatted line item and the region as a list-formatted line item. The lists of account managers and regions…
-
Character limit of 60 on Anaplan code - Possible solution to address the issue required
Hi, My Anaplan model contains an SKU hierarchy roles up to the top with 9 different levels... The codes for each of these levels are concatinated from the top level LevelsLevel CodesLevel 1 - Organisation Concatination of first and last 3 digits of Level 1 nameLevel 2Level 1 + Concatination of first and last 3 digits of…
-
Totals remove.
Hi Friends, Is it possible to remove the totals. I didn't select any top-level. I want to look it as below.
-
Picklists and Selective Access: Using a List Formatted Line Item
Are there limitations when applying selective access to a picklist with "double" selective access enabled per the link below? https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/Picklists_and_Selective_Access.htm In List: Employees I added a Property named "Filter User Access" to filter access to…
-
Review Import
Referring to someone else model on how the import was done to confirm the mapping - is it possible when you pick up a random model to review how the import was done?
-
Level 1 Model Building - Design
Hi In the Level 1 Model for Unicorn, Size was defined as a List and the Products file imported shows a 1-to-1 relationship for Product -> Size. Product CodeProduct NameFamily CodeSizeP001Nutzo BarCH100gP002Raising the BarCH200gP015AnapoppersSO500gP016Juicy Lucy gummiesSO100g Assuming, the Product -> Size is a 1-to-many…
-
Hide model map button
Hi all, I've just noticed a new idea posted here asking for the model map button to be hidden/moved. Hopefully creating this forum post allow increased visibility for a workaround that works very well (while a long term solution might be delivered in the future). There is a nice browser add-in called A+ for Anaplan…
-
{Trick] Previous on regular list / sequential calcs using time as days
Hi everyone, I've been talking about this in the forums a few times and recently @gaurav_sharma-bng told me he couldn't get it to work so here's a quick topic on how to do this. Used for: Doing sequential calculations in Anaplan or doing previous on a regular list Disclaimer: as we're using time as days, it's quite a heavy…
-
SUM in conjunction with boolean filter
I have 2 modules: Data Module and Dashboard module. 1. Data Module has: Region (List Item) Product (Line Item with List Items called PRODS) Value (Line Item) Export? (Line Item - Boolean) e.g North America PRODS=Mountain Bike 100 True Europe PRODS=Mountain Bike 50 False I would like the Dashboard module to have:- Region…
-
Lead formula not allowed for formula summary
Hi, I have a line item in percentage (POC). I already created the formula and set the summary totals to formula to get the correct %. But I need the value of the percentage for the following year. for example my period is Jan 2020, I need to reflect the value of the percentage in Jan 2021 in my Jan 2020 period. I tried…
-
Near-instant page/dashboard display
It might be possible to skip the initial loading wait, when switching to a new page (model) in the platform. We know that models are aggregated as the contributing data is changed, and we can also know what needs to be displayed when a page is first requested. To load a page near-instantly, I propose that we don't load the…
-
Calculate Week and Days in a Week: Not a straight forward logic
Hi All, Hope you are doing great! I have to create a peculiar way to calculate weeks and then calculate the days in each of these weeks. Please find below the rules to create a week- * Weeks will be defined from Sunday to Saturday. The only exception to this rule is stated in rule(4) * The usual number of days in a week…
-
Anaplan : Send Email with link directing to specific dashboard
Team, I am currently using MAILTO function and would like to insert a link in the body of email the specific dashboard in Anaplan. Please help. Thanks in advance for any help. Tom
-
Data granularity
We can get the data from lower level to higher level by applying SUM or LOOKUP. But if we already have data at higher level and want to get at the lower hierarchical level, how should we do it?
-
Enter Formula
Hi, Curious to know if I enter the formula at the line item directly, would it work (screenshot)? Im doing LM1, reccommneded method is to double click and write on top or expand the formula bar. But looks like it is editable at the line item directly as well, but I am not sure if it will work..
-
Unable to map module /csv
Hello Everyone, I am trying to import a csv file in my module but having troubles with the mapping for one of the columns when I tried to do "Match on names or codes" all the items are ignored and when I tried to map manually it doesnt allows to pick any value from the target items. Please see below screenshots for…
-
Circular Reference - Supply Planning
Hi, For a customer of ours we're building a Supply Planning model on daily basis. When trying to build the core module I'm running into a circular reference which I can not seem to solve. Any help would be greatly appreciated. Relevant line items are shown in the screenshot below. For the Suggested Reorder Quantity the…
-
dropdown view in Anaplan
if the SKU count is >10000 it is understood that Anaplan dropdown does not show all items because of the restriction. Is there any other possibility through which we can see all the SKUs when the overall SKU count> 10000 in anaplan dropdown
-
Can't find Week 53 FY20 in Time Settings.
Hello All, When Setting Calendar type as Weeks: 4-4-5 and setting for Current Period FY 2020( viz. a leap year). There is no option available for week 53 FY20. Whereas the same is available for FY16 and FY22(which is not a leap year). Week 53 missing in FY20 Week 53 in FY16 Week 53 in FY22 Am I missing something in the…