-
8.5.2 Activity: Import Data into Price Book Module
I can't import the Pricebook.csv data into my plan successfully. I have attached screenshots of my mapping which was done exactly as the example screenshots in the 8.5.2 Activity. Any help would be appreciated. Thanks
-
Regarding workspace
Hi Team, I have registered for free trial access but still I am not able to access workspace. Could you please help me to set my access for Workspace so that i can start working on my certification Thank you.
-
Level 2 Sprint 2 Forecast cf formula
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the Final…
-
How to check Currency based on Company Code?
Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. Thank you in advance for your help!
-
Current Fiscal Year setting in Time?
In the Time setting of the model, I just updated the current period to Jan FY22. The Current Fiscal Year still shows FY21, and I don't seem to have an option to change it. I'm not sure if it is doing anything? But how do I update it and shall I update it? Is there any risk? Please see attached the time setting screen shot.…
-
DEM 01 Volume Growth rates
Hi there! I've uploaded the file as per the exercise, changed the date to the MMM-YY format. It says 96 items updated. However, the module is showing the value only for January. Please help me with this! Tulsi
-
REP04 Employee Expense Summary Formulas
I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula. First Attempt (1A): Created a basic…
-
Bulk Copy Action
Hello all We are refining the functionality for Bulk Copy as an action. We could do with some clarity over how you see this being used, specifically with regard to ALM. Just a couple of initial points 1. We are not changing the existing functionality of the Bulk Copy action on the versions screen 2. We are going to allow…
-
REQUEST: allow the model builder to change the name of an Import action before hitting Import.
Save them from needing to find that import in the Actions list and change the name there.
-
level 3 - 4.6.5 Sale Planning Model: DAT02 module
4.6.5 Sale Planning Model: DAT02 module In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters * For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data…
-
Level 1 Model Building Exam Activity 4 - Roles Import Error
Hi there, I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below: I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. Here's how I set up the Roles list: and I've added…
-
Input module
Hello everyone, I've created an input module where user can fill automatically some data. I need to create a rule to load the new data entered by the user in a collection module. The collection module should has the same dimension as the input one, but I'm not sure which formula I need to use. I don't want to use a Boolean…
-
Level 2 trainer led course
Hi....does anyone know why there are no trainers led course for level 2? I know the course is available in the academy, but I have done the level 1 in a trainer led environment and I found it easier to learn that way. Many thanks
-
Order list function issue
hi Having issues with end users being able to run the order list function. I as workspace admin can use it fine, and if I set my access level to their level, it works. but the end user cannot all actions, modules and list access is granted to the end user as it should be. but they get the below error. I tried removing one…
-
NOW Function
Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we want to display the last time the button was pressed.
-
Level1: EMP03 Employee Drivers by Role does not return any data
Hi Experts, Below formula does not return any data, i tried many different types but it does not work. but the EMP01 employee driver returns the data. 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department] Regards, Kiran.
-
Can't refer to Lists in a new formula editor NMX?
Looks like with the last change in NMX in a Formula Editor is not any more possible to refer to Lists. So the only way is to type them in. It's very time consuming and error prone. Could you please have a look if it can be changed.
-
Rename List Items
Hello, I have a List with names only and no codes. The names in the source system are now increasing beyond 60 characters. I want to change the naming convention in order to accommodate the size limitation. I know I will need to add a code in order to change the existing names. However, if I rename List items, will all…
-
Exporting Saved View & Tabular Multiple Column
Before I go off to support and see if it's a "problem" just want to make sure that it's not me! Have a saved view that has filters on the page selectors and am then looking to export this view using the tabular multiple column option (there are three dimensions as rows already) but when the export is run I get every…
-
Merged: Ability to Enable / Disable a button based on a formula
This discussion has been merged.
-
How to Identify Number within text and show number as final result.
Hi All, Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula. E.g. Line item 1: Text Format : VV123BO Line Item 2: Number Format : 123 ( the line item 2 should automatically identify number in Line item 1 and…
-
3.4.4 Activity: Create Stock Exceptions Review
My numbers are coming out larger than the given numbers. Lloyd
-
Dropdown list vs Radio buttons
We have radio buttons for Site selection on the new UX and I am asked to change that to dropdown list. In order to make the line item a dropdown list, I created the line item with the List format (Site). It seems I can't make Site a dimension of this line item. A lot of the filters in the system were set up based on the…
-
Create DEM03 Demand Forecast Module
When using the formula: 'DEM02 Volume Growth Rates by Week'.growth%[LOOKUP:'SYS12 SKU Details'.Product] for Growth % I get a mismatch dimension error. I realized I was getting that error because my SYS12 module does not map to the parent, I've looked back at the course in Sprint 1 where this module was supposed to created…
-
Management Reporting Use Cases
Rachel Goering (@rachel_goering), James Fleming (@JamesFleming), and Belinda Ha, discuss examples of how to be utilize the Management Reporting features of the new modeling experience.
-
Introducing persona-based resources to support your individual Anaplan experience
The Anaplan ecosystem is vast, and no two experiences are alike. As an active model builder, you are at the forefront of building, delivering, and optimizing models for your organization. API and integration developers are focused on successful connections between platforms, and UX designers are aligned around the common…
-
xlookup
Hi All, How do i do a xlookup in Anaplan? I would like to have a Boolean identifier for the plant column based the locations in the rows. Basically search the Loc 1 in the plant Column and give a true output against the plant for every occurrence. Added module diagram for better understanding. Thanks in Advance
-
Version Lock-Data Upload
Anaplanners, I have module dimensioned by Line items, region, Employee, Version and time. Its an input module for the end user to update the Employee cost for employees by region and by time and version. I have set a Dynamic Cell Access for read and write of the above module which locks the version based on the admin's…
-
List Management - Column Width
I constantly run into an issue where the name of list members is longer than what is displayed in a list. There needs to be a way to adjust the column widths when looking at a list. Current options are to export or copy and paste to XLS. Or to search, assuming you know exactly what you are looking for.
-
Get Consolidated Data from a User dimensioned module to a module without User dimension
Hi, I have an input module with a user dimension, published in a DB where End users can enter the inputs. I want a consolidated module where I can view all the entries/data but without user details or dimension as it has nothing to do with users. I used the User dimension in the input module to avoid overlapping or…