-
1.4.3.2 Import Data & Add Formula
Hello, What formula should I use for the code line item? Instructions did not specifically describe the code. Thank you in advance!
-
Module Naming Conventions
Is there any article on best practices for module naming conventions in Anaplan? If yes, please could you share the link for the same. Thank you! :)
-
Writing information back to a blank module
Hello, I have an idea that I'm hoping can be done. I can't think of a way to do this now. I have a module at a Job level. I would like to write all the details of a particular job (Name, Code, location, salary) into a blank module that is not dimensioned by Job. I need this because I want to track a history of requests…
-
Using Users Dimensioned Line Item in a Formula With No Users Dimension
Hello, I have L1 and L2 lists, and recently I added a new flat list as A, and A is actually acting like parent of L1 that determines the groups L1 list members belong to. Since I do not want to mess the existing hierarchy and model functionalities, I prefered adding A as a flat list. In an L2 system module, I have an L2…
-
Is there a way to send context through a MAILTO function?
Hello, Has anyone found a way to send a MAILTO email with specific conext filters? For example, I would like to send a request to my dept manager. I have a MAILTO setup that will send to the right person based on the dept we're in now. This is setup in the Dept Properties module. But I would like the Request ID (numbered…
-
Scenario Planning
Hi Team, I have an unique issue which requries a uinque.. Lets say I have a List called - "Scenarios" -Scenario1 -Scenario2 -Scenario3 Using the list in a module called "Data Scenario" I want to copy data of Net Sales from Scenario 1 to Scenario 3, I know I can use the import action, however in that case, I will have to…
-
Import complete with failures
Hello everyone, I'm in need of assistance with a problem I'm facing. I have a module where I enter data (Product, Quantity). Everything was fine until I used the time dimension(Periode, Product and Quantity). However, the results are not accurate. Instead of giving me the quantity of Product X in January, it gives me the…
-
Need a filter toggle to show data for all 12 months or only the year
Hi I need a filter to toggle between showing all 12 months of data from jan to december or just the FY data essentially to show hide columns. I have been trying for a while and am not sure how to do this for example show only fy22 or all 12 months like in the screenshot above
-
Versions-> Actuals display as of current month
Hi how can i show only actuals as of current month right now actuals and foreacst are showing based on forecast time range setting(current+next 5 years) when i select actual version it should be As of Apr'23 and for forecast scenario it should be as of 2025
-
Automatic import of failure dump
I have an action that imports data from excel into Anaplan. When the data fails to load, it is due to a missing list item (a project). When the items fail, I would like to extract the failure dump, and import those projects into another table, which heads off an import action that brings these missing projects into the…
-
Aggregation of values based on the same list values
Both has same dimesion . now where ever the alternative the should be input by user and default is calculated based on then alternative i means . if alternatives have 20 and 30 the default should be 20+30-100. if mean default is 100. when ever they enter the aternatives default should be minus from them
-
Aggregate from a source module to a module with common but less dimensions
Hello, I somehow struggle to find an answer to this problem: I have my line item "Sales" in Module 1, which is formatted with Dimensions A, B, C, D and Time (Year) and I want to aggregate these sales in the line item "Aggregated Sales" in Module 2 which is formatted with Dimensions A and B only (no time format). Could…
-
RATE formula help
Hi, I am trying to replicate the Excel formula RATE in Anaplan. It seems to work for Q4, but not for the rest of the quarters. The excel formula is: =RATE(FRAC,,-$C$30,H30) where -C$30 is -100 and H30 is Total Return Index for that period. I have created below in Anaplan: Why am I getting different returns? Thanks
-
Aggregate data based on dimesions
In source module i want to select the Defalult and alterenative is input. based on that target module percentage should calculate(if it is bdefault the 1(100% ) else balank) . now i am getting error mismatched levels how to go about it
-
4.5.1 Activity: Rename Organization List, what to do:
Hello I am trying do the the Model 1 Lesson 4 but I am stuck. 4.5.1. In the model you are building, click the Lists icon on the model settings bar to open the General Lists tab. This allows you to see all of the Lists included in the model. When a new model is created, the Organization list is created by default. This list…
-
Manual Entry for Cells
Hello, I have a question in regards to manual entries in a schedule. I have a schedule below and for the three highlighted line items, users should be able to enter manual entries but they are not. Can anyone provide guidance on how I would go about unlocking these cells for line items so they can be editable?
-
Restore model when its in deployed mode
hello team members, I have attached a screenshot where I am getting error to restore my model. I have archived this model and copy archive. Does deployed mode cause any effect?
-
How can I create a dashboard for a interview and import data from get hub?
I have an interview upcoming and have been asked to created a Anaplan dashboard. I cant seem to find where to create one or any updated forums! I just want to know where I can go Anaplan itself, or Anaplan community that will allow me to create a dashbpard and inport my Gethub data from there. Thank you!
-
Options to improve performance when loading flat list used in reporting
Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 lists + time and also requires summary to be on so data can be reviewed at aggregate levels. As a result the import action…
-
Inventory Age Calculation Optimization
Hi Everyone, I am working through a calculation where we are trying to determine the average age of our inventory backlog each day in time. We are using FIFO to determine what inventory is processed first. If in Day 3 I have 1000 1 day old widgets and 500 2 day old widgets, and I have the capacity to process 750 widgets,…