-
Conditional Parameter
Hello, I hope everyone is doing well. I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length. In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID…
-
Text to quarter ?
Hello Everyone, what is the best formula that we can use to go from this to this: Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)
-
Show a name different then line item
Hi in a application, how do i change the name of an line item? Thanks
-
How to create an Error action to stop the process
How to create a simply Error action to stop the process, Such as use a False/True filter, I want to stop the process when other user execute the process in the same time… Thanks
-
MIN Function Help
Hi, I'm trying to get the MIN for Customer Tier based on the parent customer of the chain. Any help to understand what I'm doing wrong here? I'm trying to get the specific line items to adopt the MIN, not just the parent. I.e. if the MIN is 2, I want all the child stores to equal 2. Thus in the example below, all stores…
-
Avoiding the same priority values for different items
Hello everyone, I am facing a wall regarding a dev… Here is the need, i have one table, with a dimension called : Layer 3 This table is published in a dashboard, where users can imput data on the column "Layer L3 Priority" displayed in yellow. Now, i was asked to do the following : "We don't want the user to imput…
-
Optimizer Help
I am trying to learn and understand how optimizer works in Anaplan and need some assistance in overcoming a roadblock. I am going over a practice problem that I have created in excel and am having difficulties with one of the constraints. The Problem: Without getting to into the weeds this practice problem is about making…
-
How to add time dimension to existing module
-
How to sum a previous period value and current period value (multiple times)
Hi all, Have been trying to sum the values from the last week and the current week to obtain a new cumulative value; this value will be the new value to be added to the current week value. Unfortunately, this does not seem to be so easy in Anaplan. WEEK1 I start the first week with one value (layers-actual) and, of course,…
-
Is it possible to retain data when amending the Week Ending Label?
Hi Is it possible to keep existing data already in the model when amending this time setting? I originally set up the model to be W/E on Sundays but now the requirement is to change it to Fridays. We already have a lot of data loaded in against weeks, is there a way of keeping this in the relative week?
-
How to sum the values of specific days of the month. Ex. sum the values of all the mondays.
Hello, I have a requirement for the client to find the ratio of the days of the week over the value of the month. To do this I need to sum for example the value of all the Mondays of the month and then divided by the value of the month. I though about making line items with just the value of that day of the week that I can…
-
Numbered list ?
I am unable to get this right i am getting this but the correct one must be
-
Best Possible solution - Master data changes
Hi, I would like discover best possible solution. The integration happening from SAP to Anaplan (daily basis). The issue is that whenever there is a change in the master data , it is impacting the final #s of budget / actuals / forecast which is obvious. How do you overcome this scenario? Like budget needs to be locked…
-
What have you found to be the biggest roi in terms of model optimization?
I have a very slow model that I want to start optimizing. There's obviously a lot to do. Anyone have any great success stories? What did you do? Where should I start?
-
How to Identify First Month of Every Year?
-
Delayed amort of assets at category level
Hi Team, Need some help with a bit of a head scratcher. I am working on an asset forecasting module at a category level (due to requirements outside of my control we cannot input the values in at the individual asset level). The categories are in their own list and I have a simple module that houses their life for…
-
Transfer boolean information from a module to another (different lists being used)
Hi all, I am having a hard time trying to put to 2 differently structured modules into communication . The goal is to get the boolean to work as filter for the so-called FAB products. Here are the two modules: DAT11, one-list module: ID Revenues this is the source module from whom I need to take the "Is Fab revenue cost…
-
"Export Directly from Spoke Model" or "Import from Spoke to Hub and Export from Hub"
Hi Everyone, This question has probably been asked before, but wanted to get opinions on the two options. I have heard hard-lined opinions that outbound data should always be brought into Hub and then exported to another spoke model or external system. I've always taken a combined approach that focuses on mitigating the…
-
I want the Minimum value of a product amongst same months but different years
Hello everyone . I have a question that could not find an answer for it . I would appreciate if someone could find a way to solve it . thanks . Question : I have a module that has two dimension : 1. Time dimension that has 2 years and the scale is month. 2.Product list In this module I have a line item named Value which i…
-
Getting error on UX page: "The value entered is not valid"
Hi All, I have the below module setup - New Manager Line Item has a dependent dropdown to show employees from the same department. Later I am referencing Final Manager value in a Employee Summary module while is published as a Field Card on the UX page. But, it keeps showing "The value entered is not valid" under the Field…