-
New solution architect Exam
I have completed my L1 and L2 certifcation exams and would like to know what are the next steps for getting certified as a solution architect. Thanks in Advance
-
Level 2 Sprint 3 Stock Exception REview Dashboard
hi when I click to select FY21 the table data still included months in FY20 see attached
-
Series of Action (Process)
Hi Friends, I want to know, I have 6 Modules. Mod1 data flows to Mod2----> Finally Mod6. Now can I create any Action to automate the full process?
-
Filter formular Monthvalue
hi, how do I construct a formula using monthvalue to be used as a filter ? thanks Donna
-
Cannot enter decimals starting with a dot via new UX forms
It seems that we cannot enter decimals without leading zeros (i.e .068) via forms. The field on the form is from a module with the same list and has the number format. When I open the module, I can enter the number as .068 in to the cell but cannot do it via the form because it is giving me an error saying "Not a valid…
-
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
-
mapping of property
Hi, I have created a list with members : A,B,C. This has a property with values 1,2,3 respectively which is also a list. Now in my list with 1,2,3 members, I need to map the values A,B,C (list) so that 1=A, 2=B, 3=C as shown in screenshot below : Is there a formula to automatically link the Property in List 123, to List…
-
The ability to see entire Note, Applies to, Referenced By fields inside blueprint view
It would be great ot see the entire Note section in the blueprint view without having to copy and paste it into another tool, double click into the note section, etc. Double clicking into the note section isn't ideal in Standard (Non-Deployed) models, as it can lead to the accidental editing/deletion of the note field. One…
-
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
-
MBL2: Conclusion INV05 Shipping Export
Hello! I would appreciate some help with the 'calculate shipping costs by location' formula in the INV05 Shipping Export -module. It seems like basic LOOKUP-function, but I can't get it right. The problem seems to be here the different time scales when I use values of DAT02 Shipping Metrics -module (month vs year) and time…
-
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
-
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.
-
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
-
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?
-
New UX ability to extend the show/hide functionality to all selectors when creating a card
Hi Anaplan, I've been using the new UX and theres some functionality which would really improve the experience. Currently there is functionality to 'show and hide' items when creating a card but it only applies to the dimensions on the view and not all selectors. For example time and line items but not a geography…
-
Big News! Anaplan Micro-lessons are available.
Big news Anaplanners! The Anaplan Academy has just published all their best practice micro-lessons from the level 1 to level 3 certifications. For me personally, the DISCO micro-lesson is one of the best. Congratulations @L.A.Foster and @ChrisMullen https://community.anaplan.com/t5/On-Demand-Courses/tkb-p/TrainingClasses
-
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
-
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
-
Normalization and De-normalization under the same hood
Anaplan is not just a one-stop solution to many essentials like user interface, data storage, data transformations, reporting, and most importantly the magic of modeling. "It is an elegant exhibition of synergizing totally different concepts into one common, consistent, and complete solution." Database management systems…
-
Enthralling thoughts about the trade of technology
* In how many businesses does making one copy or one million copies of your product cost about the same? * How many businesses have up to 99 percent gross profit margins for their product sales? * In how many businesses do many products companies eventually become services or hybrid companies (that is, providing some…
-
Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system. This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs. How can I bring this efficiently to…
-
Referencing the Last Month of the Model Time Period For Comparison
In my model, I have the Current Fiscal Year set as "FY20: 1 Jan 2020 - 31 Dec 2020." As we move into future years this will be updated. I need to write a formula that pulls the last date of the current fiscal year; for this year it would be 12/31/2020 and when we update the Current Fiscal Year in 2021 it will be…
-
Invalid Selection, please select items from the '#Cost Center > General Sub Cat' list
I keep getting this error "Invalid Selection, please select items from the '#Cost Center > General Sub Cat' list" when trying to add a budget line under a COGS cost center.
-
Need help with NPV formula
Hi Everyone, I was applying discount percentage of 4% to a cash value of -193 , I feel that my value is incorrect please see attached screenshot. My formula is NPV(Cash flow input %, PCON). Could you please help me what I am doing wrong here. Regards, Manisha
-
Best practice - Accounts
1) Has anyone seen Accounts (e.g. P&L accounts) being defined as List instead of Line Items? 2) When these accounts are defined as List, how do you define the formula for accounts that require calculation, e.g. Profit? 3) Is a Dummy Line Item required? Can we do without Line Item?
-
Data Hub Download for Level 2 Model Building Sprint 1
Hi Anaplan Gurus, I working on Level 2 Model building Sprint 1 training. There is process step where Solution Architect asks for downloading Data Hub Model in your anaplan workspace. There is link provided in the activity to download the data hub for sprint 1. On clicking the link, System lands me on the Anaplan Frontdoor…
-
Numbered List - View
Hi Below are two numbered list screens. For Column 1, how does one toggle the view between system generated codes and Display Names?
-
IF function without ELSE condition
I am looking at a calculation where I want to have C = IF A > 0 THEN B ELSE DO NOTHING... DO NOTHING needs to retain previous value on C.
-
Dynamic module for list in a hierarchy
I need help creating a list for the market. I was able to do this at the retailer level, but how do you do the same thing for the market. I need to be able to do this so that I have the code for the market.
-
Resources every Anaplanner should be familiar with
Hi All, I recently thought about gathering the most important articles & resources that every Anaplanner should be familiar with. I was actually preparing it for myself, but decided to give it a go and share with everyone since it could be useful! Of course, all these materials are available at Anaplan Resources, but I…