-
Level 2 Model Building Sprint 3 INV04
Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a…
-
Error in Importing
Hi, guys! I always have this problem when I am importing my data in Anaplan. I tried all the methods I know but I can't solve this problem. I am trying to upload this data to my budget version but to no avail. Hope you can give some assistance! Thank you for the help!
-
Import Fail - Invalid date or Timescale error
Hi Team, I have a line item where the data is Imported from another module in the model I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action. I have these 2 Actions in a process (1st…
-
How to implement "hardcoded" logic with best practice in following example
Hi, I have the following challenge in modeling the target module. I need to aggregate data before calculation to account level 1, but there is an exception for certain accounts where I need to aggregate those for level 2. I have tried to create system account details where I flag those accounts which are exceptional…
-
How to rename the Time from Week 1 FY 20 1-Jan-2020 to 7-jan-2020
Hi Guys, Is there a possibility to rename the TimeScale from Week1 Fy20 to 1-Jan-2020 to 7-Jan-2020 Thanks and regards PJ
-
Transformation Data
What is "Transformation Data" in Anaplan ? What is its significance and in what scenarios, it can be applicable ?
-
Planual Explained - Day 14
"Rule 2.01-15": Article 2, Chapter 1, and Rule 15 – “Filters in separate modules”. ” Try and keep filters in separate System modules. They can then be reused for different modules. In the notes section list where this filter is used to prevent accidental deletion”. It goes against Auditable & Necessary elements of PLANS if…
-
improving filters and tags in manage model page and Anaplan UI
I am posting this on behalf of Jason First, design a way for our model builders to tag their models with attributes like Model Owner, Model Purpose Category, or other built in attributes like Environment (as in Picture 2 below). Second, design a way to filter or sort models based on these tags in the Model Management pane…
-
NUX or Old - Add Jump to Section (Text Object) Functionality
As a user, it would be nice to add a jump to section functionality on either the pages in the NUX or the dashboards of the old UX. Some dashboards can be quite lengthy and scrolling becomes difficult when you have to navigate your mouse into the white space (as you scroll down) to avoid any published module views that…
-
Query on Parent function
Hi Guys, Curious - Why wont we use Parent(Item('G2 Country')) for line item 3 (Region)? Thanks
-
Move "Refresh" button from Edit Menu, onto Main Blueprint Toolbar
This is a quick one, but I was wondering if we could move the Refresh button out of the Edit Menu and into the main module blueprint toolbar? When I explain it to new folks, they always find it un-intuitive to have to open the Edit Menu, before they can Refresh.
-
Planual Explained - Day 12
"Rule 2.01-14": Article 2, Chapter 1, and Rule 14 – “Avoid using Select Levels and Filters together”. Don't use Select levels combined with filters on the same hierarchy. It is a double filter and inefficient. Use one or the other. Setting a Boolean line item in a System module with 'none' as the summary option will often…
-
Anaplan Foundation Model
As the Anaplan App Hub is currently undergoing a redesign and upgrade, this post will serve as the formal documentation source for the Anaplan Foundation Model. Anaplan Foundation Model Download Process: 1. Click on the link below to begin the download * (Old Link)…
-
How to cross-join 2 lists
Hi Anaplanners, I am Simon from DXC. I am working for a requirement which needs to generate a cross-join list based on 2 lists. But I doubt if Anaplan can do this like SQL queries. I would like to take any workaround as well. We have 2 lists: one is for Managment Nodes and another for Industry. In Management Nodes there…
-
Variance Calculations and QTD Formula
Hello, I’m working on developing a Variance Analysis Module. I have reviewed the posts on Community and found this training that has been helpful. I used the below link to develop the Comparison and Variance Modules:…
-
Allow Format & Style Selection While Adding Line Items
As a user, it would be nice to have the ability to choose the format, style and add notes while adding a line item. I imagine format and style are the most adjusted settings for a line item and notes are at the very far right of the blueprint screen which adds time and decreases likelihood of builder adding them. I will…
-
Rollback caused by "Is Summary"
Description of the enhancement: When a user incorrectly selects "is summary" for any line item with non simple formulas they hit a rollback. A rollback consists of a model closing, opening, reapplying a changelog, and saving. Can we look into a solution to capture that the formula isn't a summary line item before it causes…
-
Copy Existing List Button
As an author of a new idea, I want to have the ability to copy an existing list to save a new version of the list. Lists can often be similar in structure and/or list members and it would helpful to have a copy list button. I'll know this is successful when I'm able to go to the general lists page, select a list and hit a…
-
Select / Unselect All Levels Option
As a user, it would be nice to have a select / unselect all levels option when reselecting levels on a dimensionn. Some hierarchies have many levels and with reporting that requires various levels displayed, creating the necessary views can become cumbersome. Giving a button to select all / unselect all levels would be a…
-
Planual Explained - Day 13
"Rule 2.01-16": Article 2, Chapter 1, and Rule 16 – “Use Data Tags”. ”If not using for any other reasons, use Data Tags to signify the DISCO category”. It doesn’t go against any element of PLANS but why not use it when we have the functionality available. Use Case: As a workspace admin I need to check if ALL Countries are…
-
Unable to paste values in text property of a list
Hi, Scenario - I have a numbered list which has some items already in it. I have to add some new items to this list. When I add, the items are getting created but when I try to paste the display name in a property (Text Formatted), it throws the below error - This error is coming only for the new items added and not for…
-
Calendar Conversion: How to Map 445 to Gregorian in Anaplan
Navigation: Retail UAG Home | Forum | Get Started - Content Directory Convert 445 Calendar to Gregorian Calendar Hi Anaplanners! Today I was really fortunate to have an article posted in the best practices forum. For the retail industry, this is the first step to connected planning between merchants and finance…
-
150 Line items
Hello everyone, I have a module without Time Range(I can't have it). I need to calculate a quarterly item in 30 years. Actually, the module is in 7 years old and we have one line item per quarter, but if I want to continue this method, I must have 150 line items. Any suggestion? Thanks in advanced, Roba
-
Level 2 Model Building Sprint 3 INV01 Module
Hi! I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get: IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0 I've found similar questions in the…
-
Filter Crash in Production
Hi, I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong. Attaching the screenshot from Dev…
-
how to restrict List
im I have this Lists. Region : Asia,Europe Country: Japan, France when i make a table has List(Region, Coutry), i can get table1. Table 1 RegionCountry AsiaJapan France EuropeJapan France Off course i know when I make a table has List (Country), Iget table2 table2 Country + Asia Japan + Europe France But I want this type…
-
How to match value in List with code
Hi, All Referring to the photo below Suppose that there is a line item call YMD (value is 202006) How to use this YMD to get the 'Test2' in List with matching the code (value is 20200620-2)
-
Need to lookup Employee name basis the Employee order
Hi, Source module has All Employee list and basis their "Joining Date" (Line Item 1) "Rank" (Line Item 2) has been determined, in Target Module I have "Employee Order" (Line item) formatted as number. Is their any way, basis the "Employee Order" in Target Module I can get the respective employee’s name from the source…
-
New UX: Let me save unfinished boards without requiring completion of all cards
When starting to build in New UX, I did what I normally do when designing anything...software designs, drawings or even musical ideas...rough out where I'm going in a sketch using basic placeholders then start filling in the pieces. In New UX I knew I wanted a handful of graphs here and there, text headlines etc. only to…
-
DCA - Time Dimension
Hi Team, I have a: * Time Filter Boolean/DCA Boolean for Annual Time Periods in a Time Filter module * Target module with Time Period set to months and the DCA for line item set to the Boolean above My understanding was that there would be no input fields available as the DCA is being set at the Parent level (the Year) but…