-
I NEED HELP ASAP
Hello, I have already a production model and i need to create 2 models X and Y . The X and Y models should be deployed and linked to the production using revision tags. Therearefore, i copied the production model twice. But when i pass a revision tag in the production i can only synchronize the Y model ( because it is the…
-
Why does my model gets logged out after 10 mins of inactivity
If I am inactive for 10 mins or more, my model gets logged out, I mean I am working on 5 different tabs, it should atleast be active for an hour. Is there any way to fix the timeout in the model??
-
Generating the sequential number with formula
Hello everyone . I have a module with 2 dimensions and only one line item . I want to generate the sequential numbers with formula like the numbers shown in the picture. I would be glad if someone could help me with this. Thanks
-
Mapping Issue for CC mapping to Driver List
Hi All, I'm having issue mapping Cost centre and a Driver List. Conditions on the Mapping are :- Driver List items to be mapped to all the Cost Centre Some Driver List item to be mapped to some of the Cost Centre What would be the best practice to do the mapping? How can the mapping be done. Below is the screenshot for…
-
Cannot Lookup nor Firstnonblank, how can I solve this?
Hi All, I have been trying to come up with a solution to this problem; I need to let the "belong to fab category?" boolean be checked whenever a cost element list item belong to that particular fab category (e.g. "direct labor") Now, the user has been already giving me this information in another module: However, the list…
-
Tracking import date
Hello, I'm having a little difficulty with something in Anaplan. I want to set up a system (module) where every time the end user try to import a new file in a page, we can note down the date it happened. We have different files, and I'd like to keep track of the last date data was brought in for each file separately. i…
-
Add KPIs as line items and steps to define its calculations. Can an admin user do it ?
There is a requirement where I need to give user/admin a feasibility to Add KPIs, define calculation steps. How can it be done ? Any suggestions? As per my understanding, if KPIs are my list items, then we cannot retain the calculations. KPIs need to be line items.
-
Import Error Issue
Hi Anaplaners, I'm importing a list hierarchy with 3 levels. I have added a prefix "DR1 -" for level 1 code and "DR2 -" for level 2 code & "DR3 -" for level 3 code to the hierarchy items to make them unique for successful import. But yet I'm getting an error "Invalid Parent" Below is the screen shot of the highlighted…
-
Running week of sales anaplan
Hi Team, I am trying to get Running week of sales in Anaplan. Below is the scenario. I have 1500 quantity in current week .. i have a forecast of 500, 500, 1000 for next 3 weeks. want to see value of 2.5wks in running week of sales i.e.based on forecasted numbers . Can any one help on it
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
TIMESUM from a Module with time dimension to a Module with a fakeweek dimension.
Good afternoon, I am trying to map the data in day format to a fake week dimension using a timesum. I have a start and end period in DATE format but the formula only gives me a result when this two are the same. This is the formula: This is the source module: With the data imported to day. And this is where I map each week…
-
Finding duplicate combination/inputs in different dimension
I have module dimensioned by TRID(1-100), Business Type(Type 1, Type2, etc.) and Region(EMEA,APAC,NA,LATAM). This module is used to define rules for each business type and Region. For example: So, these are the inputs/rules for each region . In this example For EMEA we have 3 rules Rule 1. Segment = A Partner = C Rule 2.…
-
using the cumulate function
Hi all, I am trying to use the CUMULATE function to cumulate actuals (number formatted line item) over a subset of periods 'SS Periods Current year' (a subset of custom list, not Anaplan time). I first thought that I could not cumulate because I was using a subset, but even replacing the subset with the full list did not…
-
Transfoming Numbers
Hello, I am trying to get the figures from Eur in KEur. The figures in Eur they are in a Module and if I just apply the classic formula, I will increase the size of my Module as I need them both : in Keur and in Eur (I don't want that).The figures in KEur I need to show them in the UX, so I am searching for a way to show…
-
Revenue Distribution Help
Hello all , I am trying to find the best way to distribute forecasted revenue across multiple periods based on a distribution chart (so to say). I will attach screen shots to better explain. Each month has a forecasted value: Each month's forecasted revenue will be allocated based on this chart: Period 1 would correspond…
-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Need Help with Exporting parent list item in different tabs
Hello Everyone, I Would like to know is there any way to get an export in such a way. Like, let's say we had a module with hierarchy list. I want the parent items in Different tabs of an export and all the child items associated with that parent should reside in respective parent item tab. For Eg, we had R1 Request ID, R2…
-
Usage of First Occurrence formula with conditionals
Hello, I'm using the ISFIRSTOCCURRENCE formula to assist in creating hierarchies so the processes don't return a bunch of errors when generating the hierarchy, but now I'm facing a little issue, I want the first occurrence formula to return true only if other columns match some condition, but I can't find the correct…
-
Data Display in a UX page
Hello everyone, I have a table displayed on a UX page (a worksheet) containing multiple line items in the columns and a list of months also as a column (where each month is a child of a quarter, which is a child of a year). I need to address two challenges: Filtering Data by Months or Quarters: I aim to enable users to…
-
How to Achieve in pre-built Anaplan Eco-System , Hierarchy into to flat list & Replacement
Hi All, Currently the Anaplan eco-systems has multiple workspaces and multiple models[8 workspaces ~55 GB], now there is a proposed hierarchy change(as some models are quite complex and have Dependency on that flat list to create further Folded Lists for Reporting) 1. The List to be eliminated is a Flat List 2.Against that…