-
Dev and PROD desynced following a backup restoration
Hello Everyone, I have taken over the Workspace Administrator responsibilities within the business and I am still learning about the basic model maintenance tasks. We've had a deployed PROD model synced with a DEV model to sync any structural changes and using revision tags. Recently, I have taken a copy of a PROD model…
-
Error parsing key for this row; no value
Hello, I am importing data from a saved view from Data-Hub into A2 Account>Product# list but i am facing this error "Error parsing key for this row; no value". Here is the way I mapped the import: What am I doing wrong? P.S, the data has been loaded to A2 Account>Product# but I am afraid if it is incomplete. Thanks,
-
How to Get Current User and Time stamp In anaplan
How to get the current user for a line item and is there a way to get the time stamp
-
Level 3 4.6.5 Sale Planning Model: DAT02 module
For the "4.6.5 Sale Planning Model: DAT02 module" step under Level 3, the data of Previous year is in a module having account flat and product flat. however, it needs to be imported in DAT02 PY Revenue to CY module, which will have A2 Account>Product# list which is a numbered list. Any clue on how to do move data between…
-
Get the Total value from another module
Hi everyone. i want to create a new module where all the total of Amount Drawdown in another module will reflect. if the below total of Amount Drawdown is 2B how can i insert this total in my new module. i use this formula but it doesnt work. 'REP04 CB Loan'.Amount Drawdown[SELECT: Drawdown.Total Drawdown]
-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
SYS03 Account>Product Details
Hello, Any reason why I am not getting any data here. I double checked the Lists. They are all look good. Please advise. Thanks
-
"Clear target prior to import" feature has been changed?
Hello folks! We are facing a problem with our existing imports. It's set up to clear target prior to importing the data, and in the past, accidentally, the line item mapping tab has been set to clear All Items. Until last week, the import was cleaning only the mapped line items, but now it's cleaning literally all line…
-
Can a student learn Anaplan? And is the training and certification free?
-
あるポイントから５日後の稼働日を取得したい
module 2のPOINT日から５稼働日目の日付をGOAL moduleのように取得したいです。 現在ある関連moduleとラインアイテムは以下です。
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
How to grab value for chosen selectors to another module?
Hello Guys, I need your advice, I have created a Store Cost - Category % module and I have a second module PLD08 - Group P&L, I need to get one value from it for selected specific list elements. I would like the original value 2 for these specific selectors to be in Value in Store Cost - Category %. At this point he…
-
Steps for building a model
Can anyone help me understand why the following order of the steps is wrong? I have tried two attempts but still can't get it right!!! Step 1. Build centralized dimensions in the model (time, version, lists) Step 2. Build Modules in the model Step 3. Build centralized Import data into modules Step 4. Create User Experience…
-
Level 2 Sprint 1 1.3.6.1 Create Build Region Saved View
In the instructions, it says to include Code and items. However, i don't see items anywhere. See screenshot below. Please advise!
-
How can I find Line item ids?
Using the following: https://us1a.app.anaplan.com/2/0/workspaces/Workspace ID/models/Model ID/files to retrieve file ids. One can substitute "modules", "processes" for files to get those ids. Is there a way to line item ids?
-
How to optimize space in Anaplan by unifying versions without affecting the production model?
Hello everybody! We are working on optimizing a model in Anaplan with the goal of freeing up more space. For this, we are evaluating the possibility of eliminating some versions that are not in use and unifying them into more functional versions. Currently, the model includes many versions, such as FPC 2022 - I and FPC…
-
Is there a way to get current user value in a line item for a module that does not have user dimen
Is there a way to get current user value in a line item for a module that does not have user dimension
-
Level 3, model building
Hello, I created INPUT1 module to add stretch goal % per country by all products. However, even I select specific products the percentage works fine (I can adjust the percentage) but upon selecting to all products it grays out and won't let to change the percentage. please advise. Thanks, Farhad G.
-
Convert Period to text
Hi all, I just had another query related to my previous one. with the help of an expert I was able to capture the next month on my time system settings. Now I need to capture the Time period into text formatted line item. i need to convert the line item Month text 2 into text formatted for Month (text 2)+1 line item. so…
-
Get count of total records in list without top level.
Hey Anaplanners, can somebody help me how can I get the total numbers of records in a list given that list does not contains top level?
-
Maintaining Month Names in English for Anaplan Import Across Different Regional Settings
Hola Anaplanners, I'm encountering an issue where month names in an Excel file change based on regional settings. When I export data from Anaplan, the month names display in English (e.g., "May-25"). However, when my client (who uses Dutch regional settings) opens the file, the month names are automatically converted to…
-
How to change date format DD MMM YYYY
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
-
Boolean: TRUE if any of the children is TRUE
Hello Guys, in this Module I am checking eventual input errors in the "Amount" line item. The 'Error?' line item works fine. This module uses 'Employees#' list, that is hierarchically under 'Business Unit' list. In another module that uses 'Business Unit' list, I am trying to populate a Boolean to check if there is an…
-
Use filter from a module with different dimensions
Hi, I have a Input module dimensioned by Unique Identifiers. This module has Product list formatted line item 'Product name'. Attributes products module has 'Product Type' filter, 'Budget' filters dimensioned by Product and Users. Now I need Product Type filter, Budget filters to be applied on the Input module dimensioned…
-
Network traversal algorithm using Anaplan
Has anyone implemented a network traversal algorithm in Anaplan? To explain the problem, refer to screenshot below. What I want is to generate a path that goes through all the nodes, e.g. Node 1 to Node 3 then to Node 4 then to Node 2 that returns the path with the lowest weighting. So Node 1 to Node 3 is 7 (as per…
-
Add Product Names (without codes) to a Numbered Product List via UX Page
Hi All, I'm a bit stuck and needed help here. I have a numbered list of products and user now want to add a subset of products under this list, specifically to a new subset called "Subset - X," which doesn't have codes. The users would like to create new products in "Subset - X" via the UX page and as model builders we…
-
How to copy data from one line item to another line item in one module?
Hi, I want to create an action to copy data from original value 2 to planned value?
-
What are the scenarios in which the ALM sync between Standard and Deployed mode will break
-
Anaplan History Description Definition
Hi, Is there a definition of all "Description" in the Anaplan history extract? Like "Change Line Item" - what are the activities related to this description? Thanks, Tom
-
Custom date log / History Log
Anaplanners, Currently, our user group updates a checkpoint where they record completed tasks, such as onboarding tasks, by entering the completion date in a date-formatted line item. We have developed a custom-built grid that displays changes in a funnel chart format, showing the latest update for each project, with the…