-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi, I am getting the wrong values for "Beginning Inventory" and "Forecast Demand" in INV01. I have used the following formulas.. Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory Forecast Demand: 'DEM03…
-
[In Saved View] column in Blueprint
Hi everyone, As the model grows and everchanges to client demands, model builders have to gradually clean up unused/irrelevant line items. For me, I can detect those unused line items when checking the [Referenced By] column in the blueprint, but for those that aren't referenced by any other line items, I need to check…
-
【2024年12月】プラットフォームアップデート
New UXの機能アップデート ・Line Itemsに関するフィルタ機能追加 ・階層リストの折り畳み/展開機能追加 ・Gridの行/列項目に対する書式設定機能追加
-
Distributing values based on Mapping.
Hi All, I have a module MOD1 which is dimensioned by Product Group, Customer and Time and has line item Cost. I have another module MOD2 which is dimensioned by Product, Customer and Time and has line item Sales. I have a mapping between Product Group and Product Lists. Every Product Group has multiple products. I want to…
-
Request for Hints on Level 3 Q2 and Q3
Hi all, I hope you're doing well. I’m looking for some hints regarding Level 3 Q2 and Q3. I tried re-importing the data provided in the files, but for some reason, I can’t retrieve the Amount Increased or the Initial Country Sales Target for Chocolates/US. Could anyone provide a hint on what I might be doing wrong? The…
-
Getting Invalid date format while data import into module
hi, my source file contain time in format 201901 201902.. etc as line item. while importing i am getting error as above . which time format i have to select.? adding source file below. please help to resolve the error. Thanks Jerin
-
why all roles empty?
-
Level 2 training 1.5.7.2 Add Formula to SYS13 Line Item
Help please!! Line item: Has Data? Format: Boolean Formula: IF TIMESUM('DAT03 Historic Volumes'.Volume) <> 0 THEN TRUE ELSE FALSE Somehow, it did not give me correct result. Not sure what's wrong here.
-
Integration via Amazon S3
Hi, I created a connection via Amazon S3 without any problem, the status is "Connected", but I don't manage to select a file when I try to create the integration : Thank you in advance for your help. Best Regards Alex
-
Compare value on current logged in user email
I have a module with historicals captured by different users via another Model. My module has one line Item which has the email ID(Customer Email) of that particular user, however this module is not dimensioned by Users. For this module i only have one dimension which is basically the Index for the records, rest other data…
-
How to retrieve Current user
Hi everyone. i read some of the post here regarding retrieving current user but unfortunately cant find the answer. Since retrieving current user without user list dimension is not allowed, how can i transfer the current user from module with user list dimension to a module without user list dimension. thank you.
-
Hot fix
Hi All, I couldn't get clear outlook of implementing hot fix in prod environment, when we have development in progress in dev mode. We don't need the development to go to prod only the issue needs to be fixed and later we must progress with the dev model with out loosing the development. I am unclear of how many revision…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
why I importad data from csv show 100x bigger than the original file?
hello I tried to finish the L1 training and in the 8.5.2 steps when I import the price book data in the anaplan model I saw values that 100x bigger than the original values in the csv file. like example csv file show: 0,84 in my model I see 84.0. not sure what cause this problem. is it coming from my local xls settings? if…
-
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
-
source to target data is getting loaded partially via IICS
Hello, i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been…
-
Links in page tasks in a workflow are not working
Hi all, I have a problem: in a workflow I use a page that contains links. Before when starting a task that takes you to that page you could navigate from those links. Now, the page is "static" and the links do not work when you are in the task page. Is something new? Can it be changed?
-
Management Reporting - notes commentary boxes
Raising for @EmmaPF In management reporting it would be really useful for end users to have the ability to make notes for presentation - similar to the notes function at the bottom of PPT slides that allows users to add a commentary that doesn't appear in the presentation/pdf version.
-
Timesum with Date
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some…
-
Level 3 Sprint 1 9.3 small differences
I have reviewed each step and I dont really know how to get the number of the example… here i have the example given: and here my results after each formula… I have used the next formulas: Percentage %: Initial Account Sales Target / Initial Account Sales Target[LOOKUP: 'SYS99 Lookups'.Target Year] Initial Account Sales…
-
File format vs Anaplan
Hi, I want to ask for help with why while importing, it keeps on reading my code like this xxxxx+12? Attached photos for reference: File: (.csv format) Anaplan: Thanks,
-
Level 2 Sprint 3 3.5.5 Activity: Create Distribution Center Summary UX Page
Hi…I've been trying to create the "Product SKU by Distribution Center" grid in 3.5.5 activityI(L2 Sprint 3). I don't understand why it's showing all the values unlike the expected results. I have applied show/hide for the levels required. Please help. Thanks in advance!! Expected o/p
-
Activity: Prepare Data Exports: Create Demand Export Module and Create a Saved View
Hello, I am doing this activity and below is the request for the activity. and this is how it should look like. Now, below the thing what I have created. but I am not getting the correct output as shown in the Anaplan Training document. So, can anyone help me to understand what I am doing wrong here? Thanks !!
-
Configurable default selection for context selector
I recently had a question from a client who asked if it was possible to set a default list member (or the top level of a list, eg. all products) as the default for the context selector at the top of a page. They wanted to be able to select a particular layer, list member or top level of a list and always have it revert…
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Can you please help? I coppied formula i think no issue about formula. Expected: Mine
-
CSV Handling - Blank first row
When a CSV is imported if the file does not have headers and the data in last column (or multiple last columns) of the first row is blank the last column is ignored and not available as part of the import. How often is this impacting your users? This impacts multiple clients, when it is an issue then it impacts frequently.…
-
October 2024 Community Member Spotlight: Cianna Bramley
This month, we are excited to feature @cianna.bramley as our Community Member Spotlight! Cianna is a Model Optimization Manager, Community Boss Employee, and has been with Anaplan for over seven years. Cianna, who leads the Model Optimization Team, worked with her team this year to launch an eight-part series in Community…
-
Management Reporting - Undo/Redo buttons
Raising for @EmmaPF In management reporting can we get an undo button? Allows you to undo accidents made during editing
-
3.6.1 Activity: Create Roles & Test as End Users
Totally lost as to what the ask and action to take here is. Selective access, enabling the viewing and/or writing of information for lists is determined at the user level, so what has that got to do with Roles?
-
Is there an easy way to clear prior inputs with a roll forward?
When we roll forward our FP&A model to a new year at the start of our budget cycle all the prior year inputs are kept. We have to manually go into each section of the model and clear all the inputs/uncheck booleans etc. This is very time consuming. Does anyone else have the same issue and is there an easy way for us to…