-
UX Page ability question
Hello, I am trying to figure out below two things for UX pages Is it possible to add status of a running import job on the page. I have user action button that starts a cloudworks integration job. Anyway to show status of the job like its running or is complete? Also I notice that once the import is finished, the data on…
-
How can I go get an old account number?
Hello Anaplan friends, I have an issue that I just can't figure out. I need to switch account numbers since our project is getting new account codes. I have a conversion table from old account to new account. (100 - 100100) I created a list for the new account and Properties module. Now I want to have a reverse lookup…
-
Boolean that checks all the days in the current month
Hi, I am working in a daily module. I want to create a time filter (boolean line item) that checks all the days in the current month. How can I do this? thx
-
How to set actions between PROD models (via DEV models)
Hello, I have a question regarding interactions between models and ALM. I have 4 models: Demand DEV, Demand PROD, Supply DEV and Supply PROD, I need to establish a link between the Demand PROD and Supply PROD models. My question is how shall I set the action in the Supply DEV that will then be deployed in the Supply PROD…
-
FINDITEM(Manipulation)
Hello All, I have a situation where I need to do a FINDITEM on a bit different situation. I have one list called Org with codes such as 1001_AX_501, 1002_BX_503, etc. Other list called CC with the same set of members, however, the codes are 1001, 1002. In order to map them, I need to do a FINDITEM with some twist so that…
-
Get first & last date in list of data
Hi, How can i get the first and last date in my list based on the time it was created? I need to have a boolean to get the : First Date = 05/30 Last Date = 06/15 See below illustration of my data set: Thanks in advance for helping. Tom
-
I can only use SELECT and not LOOKUP
I thought that SELECT and LOOKUP where basically the same thing and can be used interchangeably. In the first ss I have a formula where I SELECT a facility. When I try to replace the SELECT with a LOOKUP, it give me an error. The second ss is an image of the list hierarchy. Why does this happen? Is there anything I can do…
-
UX Time Filter based on user selection
I am curious if there is a way to filter TIME dimension based on USER FILTER. This is the use case. I have module that has ORG dimension and Time. In the UX Page, we have Time as page selector and ORG in rows. There are some line items, for example Active/inactive, code, member name, etc. I would like a field to be…
-
Target module with less number of lists
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO). Target dimension has one dimension EMP and Time and line item that is list formatted (GEO). I want to bring in the Geo from source to target in this case. Since the target has…
-
Importing file that has one column whose first row is empty
Hello everyone, I'm struggling with the import of a file: there is one column that has the first row empty, therefore the file won't upload properly. I can't remove the column from the combination of properties because I need it to generate the unique key. The only solution I've found so far is importing the file with…
-
Import action not getting filtered
Hi, I'm working on an approval process that should work as follows: Global team take choose if SKUs in my product Hierarchy should be Kept or Disco. Module: OUT000_SKU Planning with dimension: SKU 9 Digit. Global team click a action to send data to Regions: Module used: INP000_SKU Planning Global Approvals; dimension Brand…
-
Regarding ALM
Hi All, Can someone tell me how can we push development done by one model builder to prod model , when the other model builder's development is under progress and not finished. This is intended in order to meet the urgency of the requirement. Thanks in Advance.
-
Selecting entire List items at one go
Hi All, I am having a module dimensioned with Time and a List 'New' with items 1,2,3,4. It has one line item named True or not? having boolean format. The requirement is that If boolean is ticked against one list item 1 or 2 or 3 or 4 , then automatically the boolean must be ticked for all remaining list items. Screenshots…
-
Variance
I have a requirement as follows: Module SYS 00: From Version (Version list format) , To Version line item (Version list format). Module 1 : Versions , Cost Center , Line Items . Months In versions (customized list) , I have Actual , Estimate and Variance. Line item Cost , Cost Final In the line item Cost Final, I want to…
-
Help on P&L What-If Optimizer
Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward
-
RE Create Inventory Ordering Saved View and Export
Hi , Please guide me how to filter out parent in rows to make exactly same as export view. Thanks Abhishek
-
How to delete Anaplan Community Account
How can i delete my Anaplan Community account which i deleted by mistake.
-
How to Apply Finditem for Lists loaded with Combination of properties
Hi All Say I have a list A (Numb List) loaded thru combination of properties having item count of 10. Then List B (Numb List) again loaded thru combination of properties having item count of 6 We cannot have code in both the lists. I want to find items in List A which are matched in List B items, so as to delete them. i.e…
-
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…
-
Can I use the time stamp of the user from different Time Zones on the Admin dashobard ?
We have a requirement from the end user that they want to track the "start time" and "end time" based on the "Time Zone" they are working from. Can this be done ? If "yes" how can we approach this. Thanks in Advance.
-
Options for Override
Hi I have a module containing values that need to be reviewed and adjusted by an end user. The values are likely to need to be changed and there is often a high possibility that the value to override with is zero. The data is often copied between different dimensions. What options are available for methods to override…
-
why is my formula not returning any values
I have a numbered list in Anaplan (#Job Profile) this list has a Unique Code for each of the members in the list. the list also contains property line items called "Comp Code" and "Comp Location" I have data module that is being populated with Comp Code values and Comp Location values. What I am trying to achieve is to use…
-
L1 Question 6, getting 0s
Hello, I have entered the following formula and I'm getting zeros on the Employee Expense Summary. Any ideas?
-
Get 1st week of the quarter
Hi, How we can get the 1st week of the quarter? Thanks in advance for helping, Tom
-
Using LOOKUP on multiple properties in a Numbered List
Hi - Wondering what is the best/practical process here. I have a Numbered list (#Job Profile) with "comp code" and "comp location" as properties (Attached for reference). I have a module has the Job Profile Code (Job code = comp code) and Connect Comp Location, the data/line item by itself is not unique but the paring…
-
Sprint 2: DEM02 Module Formula
Hey, When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to…
-
How to filter values based on non-source model dimensions
I've got models A, B and C. A is our forecasted IS. B is an IS of confidential acquisitions. B has one additional dimension that A doesn't have - the list of confidential aquisitions. Connected to B is a SYS module that allows our Treasurer to check a Boolean that controls whether a confidential project flows through to…
-
write the following code in Anaplan.
Hello everyone, I have two questions. Firstly, I am attempting to write the following code in Anaplan, I am using a calendar time setting (time scle :week) picture attached. IF Week = 'Week N' (where in my model N=25, representing the 25th week of the year) THEN Flux_Disp = Starting_Stock - Security_Stock - Demand_Global;…
-
Line item Formula
Hello everyone, I require your assistance with a module I have created. Module 1: Forecast per month, taking inputs such as the forecasted quantity and the number of working days in a specific month. The result obtained is the CMJ (quantity consumed per day). I have also developed Module 2: Forecast per week . It takes the…
-
how to convert date to text
Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)