-
Provide your thoughts on Anaplan's Excel add-in
We are looking for Anaplan Analysts and Report Builders to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of…
-
Performance of Comparision of Boolean using = sign over using NOT function
Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where "Approved?" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THEN 1 ELSE 0 IF NOT Approved? THEN 1 ELSE 0 Please advise to optimize performance of the model.
-
Notification Action increase characters limit
Hi Community, Currently the "Create Notification Action" is limited to 300 characters and this is a very low value when we (the Dev Team) set an email template ant then the end user needs only to complete that template. Is it possible to extend the limit to an higher value (e.g. 1000 characters or more)? Thanks, Alessandro.
-
Data Load through One Cloud problems
Hi, I'm having a problem with a Data Load that comes in from One Cloud. The Process works fine when the Flat Files are loaded in manually, but when we try to do the same Process through One Cloud not all the data is coming through, (all my List Items are not pulling in the data). I need help trying to figure out what the…
-
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
-
Formula to sum with condition
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Best regards
-
L2 2.3.10 Growth rate % formula is working however cell remains empty.
I am stuck with an issue which I can not solve. Pretty sure this is a simple thing I am missing. Please see attached screenshots. Growth Rate % is not showing any value, however the formula in "Default forecast" is using the value from "Growth Rate %" and calculates a value.
-
How to set up a Admin Account with a e-mail address in Anaplan
Hi, Need to know how to set up an Admin Account in Anaplan with a email address. Would I be able to do this a a Model Builder, or would the main admin administrator have to do this? Thank you
-
Something about setting multiple Source Models of a UX Page
I noticed the following message when setting the source model of a UX page. "Only models that you have access to are displayed. 1 additional model is associated with this page" I doubted the reason and finally realized what happened. One of the associated model was archived. So even I removed other models and left one…
-
3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE…
-
Display Status (Pending, In-Progress, Complete) in a Dashboard
Hi, I want to display the status of each dashboard in a landing dashboard. And i want it to look like the photo below: Can someone suggest their ideas with this? Thank you and Regards
-
Timestamp using data write action
It would be nice to have it displayed the action run time stamp or a Boolean check timestamp using a data write action in New UX. we can bring by text formatted line item as we dont have time stamp data type. it will help to calculate several time related calculations. which will definitely help in several use cases.
-
Line Item Subset Formatting
This post is a bit of getting ideas to work around but also see if people are experiencing similar issues. I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from. In the situation where you had a KPI which was a %, a number and a…
-
1.4.3.2 Import Data & Add Formula in Sprint 2
I am not able to find why time is coming ? Please help , I am completely stuck.
-
3.4.3 Activity: Create Country Summary Module
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family] When…
-
stuck on level 2 sprint 3.3 activity
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
-
Create Shipping Export Module and Create a Saved View
@jagadishdash @alexpavel Can u let me know what's wrong? In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: * Module Name: INV05 Shipping Export * Dimensions: G3 Locations list, Time (months) * Category: Inventory * Functional Area: Inventory Line Item…
-
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
-
Model Optimization
Hi Experts, I am trying to optimize the model size. Can you please suggest me the main ways to reduce the size. Thanks and regards, Mahesh
-
WARNING: App availability depends on referenced model existing
Yesterday, I refreshed our Dev and Test models from Prod to start a new development cycle. The Dev and Test models were actually brand new (only about a week old -- no in-model development, only App development) and didn't think I had any actual need to keep the previous versions since I was just looking to refresh data. I…
-
Process ID
Hi, We are trying to integrate with Onecloud to have automatic uploads of files. For this I need workspace, model, and process ID. I have found the workspace and model id by just looking at the url. How can I find the Process ID?
-
3.3.7.2 Add DCA to INV01 Inventory Ordering - first step
Hi there, In Level 2, Sprint 3, activity 3.3.7.2 Add DCA to INV01 Inventory Ordering we're asked to add Read and Write Access Drivers to INV01 - but in the previous activity we are only asked to to create three Write? line items: So should my first step after creating AD02 be to create three Read Only line items by putting…
-
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
-
Distinct count of Agent with comparing Date and Program
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
-
List property formula functionality to match module line item functionality
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time. This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is…
-
Create Shipping Export Module and Create a Saved View
Hello Community!! I am stuck at the above activity, can anybody please guide me what the mistake is?
-
Page selection default to environment of choice
Hi, Is there any way i can configure Production users( who has access to both prod and UAT) to show default model as prod at the same time Non production users basically QA and Dev to default to their environment accordingly. There are chances to update the wrong environment as this option keep changing.
-
Data Load Time Setting help
Hi, Having trouble loading in the attached data set. I'm getting a error with my time settings. Please advise. The Flat File is attached. Thank you Error Time Setting for the mapping Blue Print of module
-
Create Shipping Export Module and Create a Saved View
Hi, I need help regarding this activity. 1) When I pivoted the view during Module creation - INV05 , I have an error regarding the G3 'location - saying " No Items" 2) The formula for Code is 'SYS06 Location Details'. Code' , but my SYS06 module seems to be unuploded Can anybody verify and let me know the exact mistakes.…
-
Change default message process completion message to an error message/ LOCK button
Anaplanners, I have a process which stores the end user's inputs in the system. Currently users press the button without completing ALL their inputs thereby storing incomplete data. 1) I wanted to figure a way to lock the button when they have not completed their inputs AND/OR 2) At least throw an error message when they…
