-
Extracting text field from transactional data load module
I have a question regarding pulling a text-formatted field (e.g., a status entry that could be but currently is not list-formatted) from a large transactional data load module that consists of CSV-imported line items and then various data mappings to lists, numbers, etc. and some RANK and MAX cleverness to focus in on the…
-
Sort function missing "OK" button
Hello, I am trying to complete Activity 12.4.6 in Module 12 of Level 1 Model Building, but my sort function is missing the OK button to implement by sort. I've tried restarting my browser and computer, but no luck. Has anyone else run into this issue?
-
LEVEL 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas - Order Receipt
Hello I have been stuck on this for a little while now, would appreciate some guidance. I am trying to get confirmed purchase receipt to show 2 weeks ahead like the learning portal answer but mine keeps only shows two weeks before. Been reading other posts about this and they all eventually switch to post and add a new…
-
how to capture last updated date of a record in anaplan as a value in a field
I have a module and it has three fields called A, B,C.. how to capture last updated date for those fields in anaplan. i know by clicking the history at the field level. but i want to capture via fields for those three fields. please suggest.
-
Anaplan and Google
Hi Anaplan community, Last month, Anaplan published an interesting video about Google Cloud. I wanted to learn the study case or training materials that explain Anaplan functions in Google Cloud, AI & ML. I need advice for the Anaplan community, please. Thanks,
-
substitute function
i have list with codes in a test module I am trying to replace last digits of code by +1 using substitute function but i am getting result- A1B1_1 ->A2B2_2 ----incorrect A1B1_2 ->A1B1_3 ------correct A1B1_3 ->A1B1_4------correct A1B2_1 ->A2B2_2 -----incorrect A1B2_2 ->A1B3_3 -----incorrect A1B2_3 ->A1B2_4------correct…
-
Level 2 Sprint 1 SYS07 mapping
I am importing the Locations flat list into SYS07. Everything is mapping correctly except for Region. I deleted and then re-imported the Locations flat file, but I still can't figure out why I am getting this error.
-
Line Item:Confirmed PO Delivery Sprint 3
Hi, Would like to know if this is the correct formula for the Line Item:Confirmed PO Delivery in Module INV01. If not please give me some guidance. OFFSET('PO(Purchase Order) Submitted', Shipping Time Weeks, 0) or should I use POST(PO Submitted, Shipping Time Weeks) Thank you
-
Q4 Cert question.
Got Struck at Q4 in Cert exam. This is my selection in SYS08 so I am expecting Department value I am passing to Emp02 Employee Expenses module Here medical cost showing 36800 that is showing as wrong answer. Am I missing some thing here. Hep Appreciate.
-
Transform data in existing output module
Dear Community, I have a case where I need to transform data based on product and customer information. The basic concept is that I have certain product # 1 and that value should be changed for certain customers. I have started to investigate if I could have a system module where I specify that product and customers for…
-
Anaplan with google cloud/ Apigee
Hi Anaplanners! I was curious to know if anyone has any exposure on building Anaplan models integrated with Google cloud/Apigee. I was wondering to know if there is any native connector between Anaplan and google cloud /apigee. If there is not any connector, does anyone know what should I do in this case? Thank you!
-
Level 1 Exam Model
Hi, I was working on the level1 exam, my connectivity got lost.. Now i couldn't find my exam model Is there a way i can get it back
-
Automatically rollback the model if an action within a process fails
Description of the enhancement required: Process rollback upon failure. An example of the enhancement: If an action within a process fails, then all the prior actions that succeeded should be erased How would it help their business process: The fact that a process "half-way" runs and my end user doesn't tell me, has…
-
reading property as line item in module
What is wrong in this formula. Here I am trying to read property of Company code in this module.
-
Level 2 - Sprint 2 : Update Historic Volumes
Hello, I am stuck at step:2.3.9.2 Update Historic Volumes for Baseline Forecast I can't deduce the formula for "Offset Volumes for 1st Forecast Year" because I don't know the formula of "1st Forecast Year?" Would you please know the formula for "1st Forecast Year?" Could you help me please Thank you
-
Line items and item properties
Hi I have a question here can line item fields be populated with item property values by selecting item member in a module?
-
How to get Current Fiscal Year from Time, as a number, when Current Period is not set in the model
Hi, can I get help in how to derive Current Fiscal Year, set in Time, as a number when Current Period is not set in the model? I see how to get year if Current Period is set with year(currentperiodstart()), but what to do when it's not used? We currently have a line item in a Time Filter module that requires the year to be…
-
Request Enhancement - reference the Year from the Current Fiscal Year set in Time
Request Enhancement - ability to reference the Year, as a number, from the Current Fiscal Year set in Time...similar to how we can refer to current period with currentperiodstart(). In our case, we don't use the Current Period parameter, so are not able to derive FY from it. Thanks, this would be really helpful and even a…
-
Level 1 Model Building: Import data to SYS06 Product Details module
In Module 7 of Level 1 Model building, we are asked to import product data into the Product Details module and map to the source. However, my mapping does not seem to be accurate, and I cannot figure out the issue. I've attached screenshots of what my mapping looks like, as well as what it results in. Any and all help…
-
How to distribute the value of line item equally.
Hi, I have 2 line items where in one is Boolean and other is numeric(percentage format). if the Boolean item is checked for that property then the value has to be zero for that particular property and its value to be equally distributed to the other properties. for ex: In the screenshot the %alloc of the property 1 is 10%…
-
NUX - Limit Open Source Module option
In the Old UX we had an option to remove the "Open Source Module" option from dashboard. I couldn't find any similar option in NUX. Am I missing anything?
-
EMP02 Expenses are 0 after a certain date in my model
I am trying to figure out why my expenses stop in Sept 2020. I have reloaded my data to EMP03 three times. I have been trying to figure out what is wrong and I don't know what else to look at. Any suggestions?
-
Date formula: Month +3, Day -1
Hello Team, I am trying to write a formula that takes an inputted date and outputs a M+3, D-1 formula. The very tricky part is input for 1st of month should then be M+2 / D is last day of the month Examples: * Input 6/5 -> output 9/4 * Input 5/25, -> output 8/24 * Input 3/31 -> output 6/30 * Input 1/1 -> output 3/31 *…
-
Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi, While adding formulas to the line items in EMP02 Employee Expenses we were asked to enter the below mentioned formula BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 but it's throwing an error "Dimension of…
-
Model Name as a Field in Blueprint view
Hello there, I had an idea, I believe this idea can open up a lot of possibilities as to how you can leverage the blueprint view for Model optimization and performance management. I see that the newly released Module Name field has opened up a lot of possibilities when analyzing my blueprint views. I am trying to build a…
-
Alternative hierarchies - Numbered List Required?
Dear All, Do I need to use numbered list for the lowest level of the Alternative hierarchies? I read through couple of examples and training, which all use numbered list. I was wonder if this is necessary. Thanks, Lily
-
Add Dynamic Actions
Please add dynamic actions that only run based on a boolean line item. For example, when importing transactional data other lists may require updating if a new item is detected. If actions in a process could dynamically run based on boolean line item, model builders could improve model speed during updates.
-
Add Conditional Formatting to Action Cards
Please add the ability to conditionally format actions cards within the NUX. Superficially, may appear minor, however this would be a powerful way to guide users in apps and provide workflow. For example, a page builder could highlight any actions that require running. As a additional benefit, this would help model…
-
IRR & NPV Calculations with Initial/Start Date
Hi All, I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too I hope below Screenshots are in-detail to understand the logic.
-
Open Saved View from Open Source Module (NUX)
The functionality to Open Source Module in the New UX currently takes me to the main page of the model. Would be great if that functionality opened the model as well as the module & saved view that was published to the Worksheet or Dashboard for ease of page builders to make updates in saved views. It is not super easy to…