-
3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount
Is this the correct formula? If not, please help.
-
Selected Time from another module
Hi everyone. is it possible to get the selected time from module 1 to module2 as line item.? thank you.
-
Potential Typo in 3.3.5.2D Remaining Line Items
I thought it should be "less" instead of "plus" Thoughts?
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
Source Model and moving model between workspaces
Hi All, In one of my workspaces (Workspace1), I have two models HubModel1 and HubModel2 where some of the lists in HubModel2 are created based off saved views in HubModel1 (meaning the imports in HubModel2 are pointing to HubModel1. Say, I want to move the models to a different workspace (Workspace2). Looking for options.…
-
Mapping Native Versions to a Versions List
Is there an elegant way to map native versions to a versions list? I know we cant use SUM as this will only recognise and map the 'current version'. Therefore, is there another way?
-
How to make an export that contains the dimensions' parents in separate columns?
Hi guys! I would like to know if there is any way to create an export of a model so that the parents of the dimensions are in separate columns, for example: This is my module When I export, the table looks like this: I would like each "parent" to be a separate column, even if it repeats the information. No problem. In a…
-
Roll up when DCA applied
experts, I have an input dashboard where users input their data at base level in hierarchy. But these numbers are not aggregating at parent level. This is happening because I have a DCA applied to the module to prevent input when its locked. Question - is there a way for user input the data and also roll up when DCA is…
-
Check list at the end of the User Story?
Hi All, I came across a question, what would be the check list we should keep in mind after the user story has been completed before deploying the changes to the UAT and Prod?
-
Level3 - Redistribution Rate
Hello, Any idea why my Final Total sales target by country is slightly less than Total Initial Target? Thanks,
-
Match data between two modules that have different dimensions
Hi, I am trying to match data between two modules that have different dimensions. The target module has the following dimensions. And, the sourcing module has the following dimensions. As seen above, the only difference is the time dimension. The Sourcing module has one Time dimension, but the Target module has two Time…
-
How to convert text to date
Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12/10/2012 but what about 2/3/2012 ?? Note -- Can't change source text to date…
-
Access Driver Behavior - Workspace Admin vs Regular User
I have a module X, that has two Line item Line item A which is Boolean Formatted and Line Item B which is Number formatted but has Write Access Driver set to Line item A. I have a process that Import data from Module Y to Module X. I am noticing a unique behavior depending on who is running the process on UX screen. If…
-
Question about ALM 1st time deployment
Hi everyone, When we synchronize the model for the 1st time from Development to Production(deployment), the data which is entered in modules for testing purpose in development environment( standard mode), how can we delete it in one go. It should not go to production environment(deployment). Please advise
-
SYS03 Account>Product Details, P2 Products
Hello, I am trying to load data in P2 Product line item. I am using FINDITEM(List, Text) but I am not getting any result. In my module ID and Code are in Text format but they didn't work. I created DAT03 module to turn P2 Product list to Text and referred to DATA03 in the formula but still didn't populate the data. What am…
-
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…
-
Reducing Extra Space Before List Item Name in UX for Multi-Level Hierarchy
Hi Everyone, I’m working with a 6-7 level hierarchy in Anaplan, and at the lowest level, the list item names are quite long. In the UX, I’m seeing extra space before the list item names start at that level after hiding the other higher level list members, which makes the display less clean. I have already tried adjusting…
-
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!