-
Facing issue in column separator
Hi everyone, In the source we are using pipe to separate the columns .In anaplan i have created action using .csv file and now changing the column separator from import data source ans using "|" instead of column. For some data element this is working fine but in few in module i dont see any data. also when open the action…
-
Time is missing as Context Selector
I am actually building a UX page following the instructions given in 3.4.4 Activity in which I create grids from saved views, but Time is missing as context selector on the top right corner which end user should be able to filter. PS: there's not filter applied in the grid nor the saved module views Could anyone advise…
-
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
-
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
-
HELP IN IMPORTING DATA
Look when i am importing weekly data in my INV01 when i want to map time with column headers Time (2019-12-29 - 2020-01-04, 2020-01-05 - 2020-01-11, 2020-01-12 - 2020-01-18, ...) this shows up but data in my 'csv' and 'inv' in form of WEEK 1 FY20 but in mapping dialog it shows Time (2019-12-29 - 2020-01-04, 2020-01-05 -…
-
3.3.5.4 I AM CONFUSED,
Please Help I am not able to understand what we have to do in this particular section Here are my queries 1)The formula hint shows IF/THEN condition and then it says The next condition is override suggested amount? line item, so do I have to nest both the conditions ?? Please let me know 2)Also it says Update another line…
-
Introducing our new Community Boss Employees program!
We are pleased to announce the launch of our Community Boss Employees program! In 2023, we rolled out our re-imagined Community Boss program to hand-selected customer and partner Community advocates. This year, we are excited to expand the program by including a select group of exceptional Anaplan employees. These…
-
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
-
Inquiry Regarding Anaplan Integration Process and Schedule
I have created an 3 Integration Process and added it to the Integration Flow and Schedule using my ID. I have a couple of questions regarding this setup: If the update schedule is modified using a different ID, will the process continue to run under my name, or will it reflect the name associated with the new ID? In the…
-
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
-
Level 2 Spring 2 2.3.10 Baseline Forecast
I believe the problem has to do with my time range, but my 2nd year forecast isn't populating anything. This is my baseline Forecast formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) ELSE OFFSET(Baseline Forecast, -52, 0) The time range is fy19-fy20 to…
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
Excel Add-in for Anaplan
Hello, We have been planning to incorporate excel add-in for a finance use case, and would like to take experiences of others using excel add-in. More specifically, we would like to hear and learn how excel add-in is beneficial for your team (does excel add-in facilitated collaboration or improvements in managing Anaplan…
-
How to enable Override? button for end users and allow them to enter the Override Forecast Value?
I am not able to enable the Override? button for selection and neither I am able to enable the manually enter the Override forecast value for the end user, hence please help me get both of them enabled for the end user.
-
Graph time selection?
Hello, I have a table and a graph based on a table. The selection that I have in Years, Quarters and Month. The Table should move on every selection of Year, Quarter or Month but the Graph I just want to stay only on the year selection. So my graph should show all the month of the year regardless of the selection of the…
-
How to create in a module a quarter option?
Hello, I have a forecast module, with monthly TimeScale and I want to create, in this module, an option for a quarterly view. So basicly, if the client wants to see the data quarterly, he should be able. I also have a MOD02 Quarter Time Settings and also a filter module for the quarter part. At this moment, my data is…
-
Impact of model archival on Cloudworks
Hi all, I had to archive the production model, and when I restored it to deployed mode, I've noticed that the connection to Azure scheduled for last night didn't work (I had it rescheduled but it failed). The status is set to "auto deactivated", however if I manually run the processes, they are successful. I have…
-
Workflow Notifications
Hello! I'm currently building out a workflow template using the new workflow feature. However, when I kickoff the workflow I receive about 10-15 emails. Is there a way to control the notifications that are sent to the end users? Thanks!
-
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
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
-
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
-
2.4.7.1 conditional formatting add new rule option is not avaliable
Hello Can i know why I cant able to apply conditional formatting? why there is no new rule icon available when i select conditional formatting icon ? I have selected even a line item row or column and selected conditional formarting icon but still i there is no New rule option avaliable
-
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
-
Can I add in Cloudworks a Delete Process using Selection?
Hello, I want to do the dete function automaticly with Cloudworks. Can I do it with slelection? if Not, what options do I have? thanks
-
Filter / Drop Down Selection
Hey I´m trying to add a drop down selection to use as a filter on a grid I´m working on. The grid has data by client and each client has a zone as a atribiute, I wan to add the posibility to select a zone in the drop down selection and filter the clients based on the selected zone. Is this posible? I appriciate any help,…
-
Percentage Format issue on UX page
Description: I have a module with PV(dimension) Filters as dimension and I am displaying the Value line item on UX which is same as the Module dimension. But the Value line item is getting the data from other line item Actual vs Scenario 1 % which has ss_Actual vs Scenario 1% (dimension) - Which is a subset of PV filters…
-
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 the code instead of the display name in dropdown list
Hello My client does not want to have any display name, just the # generated by anaplan. In the same time, it is very complicated to choose an item in a dropdown list seeing only #s. Is there a method for me to show code of the numbered list ( which is existant ) instead of the #? Thanks
-
Searching for community members-- functionality removed?
There used to be the ability to search for a name and find community members. Was this moved to another area? If it was removed, why? This helped to facilitate hiring, validations of certifications and more. You can still see someone's profile if you know their username or click through a link on an idea exchange. Please…