-
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.…
-
How to Avoid an old "Default File" from importing into Anaplan via Anaplan Connect if no file loads?
Here is our setup: We have an Anaplan import that runs via Anaplan Connect. The file drops into the folder location daily on the server. Then Anaplan Connect picks up that file & loads it into Anaplan. Here is our problem: If no file drops into the folder location on the server, then Anaplan Connect will default to an…
-
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?
-
Sprint 3 isn't launching for me
I've completed sprint 2 (in Level 2) and its exam. But the sprint 3, for some unknown reason, isn't being made available.
-
Show whether a line item is used in an action
I'd like ability to see, in blueprint mode for a module, whether a line item is used in an action. This, along with an existing Idea requesting to see if a line item is used as a filter for a Saved View, would significantly speed up model clean-up time
-
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…
-
Document Storage
Would nice if Anaplan had even a small document repository/storage/library. Example: uploading a PDF and then having the ability to hyperlink to that PDF from an Anaplan dashboard. In the incentive compensation world, we have a lot of PDFs for signed/executed plan docs, and being able to store/view them in Anaplan would be…
-
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…
-
How I Built It: Flagging hierarchy list levels
Author: Timothy Peterson is a Certified Master Anaplanner and Senior Delivery Associate at Spaulding Ridge. Greetings Anaplan Community! Hello and thank you for checking out my ‘How I Built It’ tutorial. In this video, I will showcase how you can leverage ratio and formula summary methods to flag different hierarchy list…
-
Recording now available! October 30 quarterly platform release event
If you missed our October 30 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrates new features and innovations, provides a technical deep-dive and “how-to”, followed…
-
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,
-
Incorporate daylight savings in Cloudworks time zones
Now if I select London time zone in Cloudworks schedule, it will not automatically change the time in accordance with daylight savings in UK, forcing us to adjust the schedule manually. The same goes for other countries with daylight savings. It would be great, if daylight savings were added to Cloudworks schedule time…
-
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…
-
Easily Get Current Date Using CloudWorks
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…
-
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
-
Level3 - Initial Sales Target
Hello, I followed the level 3 lessons and created a module for initial country sales target which matches with the one in the lessons. My issue is related to the percentages that are provided in the lessons to apply. since this is a stretch goal for a country, how should I distribute them among the product families in each…
-
Comments to be mentioned at a cell level
Current we can mention comment at a card level or at a cell level, This becomes slightly tedious for a the reviewer. If we can input a comment a cell level then this will enable the reviewer or action performer to review a specific cell , just to state as a example. as A Brand Development manager i might have many Key…
-
UX - Ability to add expandable/collapsable sections to Boards
This idea is for a new card type called a "Section". This card type could be added to a board and then other cards added to it. It would give the functionality of effectively creating sections on a board which could then be expanded or collapsed. This would allow users to collapse areas of the board which they are not…
-
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,
-
See Locked Accounts Due to Non-Successful Logins in Administration
We recently had a situation where a user 'locked' their account because they tried to log in multiple times with as a non-SSO user, by providing email address and password, when they were checked as a SSO user in our environment. The result was that their account was 'locked' on the Anaplan side, however we had no…
-
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