-
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
-
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…
-
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…
-
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…
-
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…
-
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…
-
native time and snapshot period
I have two different modules. Source is dimensioned by Study top level & using snapshot time (only previous month will populate at the end of every month). My target module has native time with a subset of active Study. I want to get the data in my target, if any study has a value in my source that should populate in my…
-
How to rank values of a list item across Time
I have module with List A and Time Dimension(Months) Line Item - Value I want to rank Values to display only top 3 contributing across time period for each list item. In the screenshot below I want to display only Apr 20, May 20 and Feb 20 for Item 1.
-
Adding lines of data from a list to a single line in a module
Hello all, Could anyone advise of an easy way to add multiple lines from a list or module based on my list to another module in a single line? So my list is a list of products, descriptions, etc and in the list-based module I have a boolean to select specific products, I then would like the list of data to appear in the…
-
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…
-
Get 1st week of the quarter
Hi, How we can get the 1st week of the quarter? Thanks in advance for helping, Tom
-
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…
-
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…
-
Performance Comparison - Direct SUM vs Line Item Subset
Hi all, Was looking to get some community feedback on two different SUM approaches and which one would be more efficient from a model engine point of view. The scenario, I'm looking to SUM line items into a central P&L by account. The source module lines do not have account as a list, so we'll be using something similar to…
-
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
-
error Invalid date or timescale identifier
Hi, I have this message "Invalid date or timescale identifier" when I try to import a data file. The date format in the file is : 30/06/2020 for example. Unsuccessfully, I tried to fix whith a "Custom fixed-position pattern" DD/MM/YYYY. Any idea? Thanks a lot :)