-
How to set a serial number based on multiple properties
Hello, I want to set a serial number based on multiple Properties. I'm trying to set a serial number based on a TEXT type key item, but I'm not getting the expected results. I'm trying to implement this using the RANK Function. If there is an implementation method, could you please guide me? The "RANK_2" in this diagram is…
-
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…
-
Sum on dynamic filter selections
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account). Sometimes fields are blank so a simple SUM wouldn't work. Ultimately the summation would live in a P&L statement so also…
-
CloudWorks AWS S3 file list
It would be great if once you have input S3 access credentials and established the connection, CloudWorks would present you with a list of available files to choose from, instead of having to input the filename. Furthermore the ability to reselect the file to be imported by the connection will speed up integration admin a…
-
Level 3 Sprint 2 US 2.5 Account Exception UX
JaredDolich I created the dashboard Account Assignment Exceptions, but the button "Finalize Assignments" did not work. I created the Action " Finalize Assignments" with "G4T Territory>Account#.Display Name". How did you realize it? Can you please suggest if I am missing any other instructions? I went through all the use…
-
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…
-
Module with no dimensions
Is it possible to build a module with no dimensions that will allow us to import a file with thousands of rows? The current file we receive does not have a unique code. We would like to import this file into an ANAPLAN module and then create a unique code using the data in the line items so that we could then create a…
-
Show and Hide Selections in the UX - The Basics
Show and Hide Selections: why use them? When building out your apps and pages in the UX, there are often instances where you want to hone in on a specific set of data. With Show and Hide selections you can surface or remove particular rows and columns from view, providing end-users with a faster route to the insights they…
-
Adding lines of data from a list to a single line in a module
Hello all, Could anyone advise of an easy way to add multiple lines from a list or module based on my list to another module in a single line? So my list is a list of products, descriptions, etc and in the list-based module I have a boolean to select specific products, I then would like the list of data to appear in the…
-
Level 2 Sprint 1 1.3.10.3 Import Data into G3 Location List
Having trouble importing from a saved model. I've searched through the community for answers but still stuck. Can't seem to figure out how to get the column with the Boolean list. This is the activity and the end result: This is what mine looks like and the error I'm getting: Any help would be appreciated.
-
Could you tell me how to check the number of Model Builders in a WorkSpace?
Our organization has not been tallying the number of Model Builders until now. However, we have received a requirement from a client asking for the number of Model Builders to enhance trust for obtaining projects. Could you please let us know if there is a way to check how many Model Builders are registered among the users…
-
Anaplan Integration with Azure Blob
I have integrated Anaplan Cloudworks with Azure blob to automate daily export files, I have scheduled my exports. I want to add date to my daily export files, like if today the export runs it adds a date to the file name, and tomorrow it adds the respective date and so on, so I can distinguish between each looking at the…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, I don't know to change the time range for FY19. Any suggestions please?
-
Need ability to automatically run Workflow template as an action button in UX page
Would like the ability to go to add an action button in a UX page that would run a specific workflow template that has been pre-configured against the action button. At the moment you have to go workflows and manually select the workflow template you want to execute and add extra information as an instance name for the…
-
Create DEM03 Demand Forecast Module
I try to create my DEMO3 Demand forecast Module. But I have this message. What does mean that SKU flat List does not have a built in top level please? Any idea?
-
How to access Anaplan workspace?
-
How can I get data to be imported to the next open row
I am trying to get a row of data to be automatically uploaded to a row that has not been filled yet. (I currently have it set up where you have to manually select the row every import) Also is it possible for the "ALL TRANSACTIONS" grid to automatically create new rows of transactions when all rows are filled? Here is an…
-
Training - Import Data into E2 Employees# List
Hello I'm having issues to import the data into Employees list. Instead of showing the employees names its showing a number with # in front of it. Could you please help me?
-
Could you tell me how to check the number of Model Builders in a Tenant?
Our organization has not been tallying the number of Model Builders until now. However, we have received a requirement from a client asking for the number of Model Builders to enhance trust for obtaining projects. Could you please let us know if there is a way to check how many Model Builders are registered among the users…
-
Can we export data from anaplan and directly load into other tool via Rest API?
Hi, Can we export data from anaplan and directly load into other tool via Rest API, without exporting csv or text file.
-
質問 モデルでは、$250の表示なのに、グリッドに表示させると、250 となる
デルでは、$250の表示なのに、グリッドに表示させると、250 となる。 なぜでしょうか・・・
-
Ability to add multiple values to a text filter
In as much detail as possible, describe the problem or experience related to your idea. Please include specific examples or workarounds: End users want to be able to set a filter on a text line item for more than one value without creating multiple filters. This works with list formatted line items, but not text. How often…
-
How to do Automated Testing in Anaplan?
I have a good amount of experience using Selenium for web application testing, applying it to Anaplan is a new venture for me. Therefore, I would greatly appreciate any insights or advice from those who have ventured down this path before. How effective is Selenium WebDriver in interacting with Anaplan's web interface? Are…
-
YTD Workaround?
I have an issue with the way Anaplan calculates YTD and need help figuring out a workaround. The YTD value in Anaplan includes the current week, which is NOT how I would like it or need it. i am in a weekly system and do not have actuals for the week I am in. So when comparing YTD Actuals against YTD Forecast it is always…
-
Certification
Hello, I've just got the Level 2 Model Builder Certification. I would like to ask 2 questions. First, I would like to publicly show my certification on Linkedin. For this I would need a hyperlink that would point to my certification for any person that clicks on the link in my profile. Is this possible with Anaplan and if…
-
Pavith17111993
Hello Pavitha, Could you please let me know how to access anaplan workspace? When is the next anaplan workspace application open? Best, Prasanna Venna
-
Trying to SUM revenue by account and product, getting datatype mapping error
I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting the same "Datatype mapping used for aggregation doesn't match any dimension of the result" error. Line item types are all…
-
How do i stop Summaries being sorted in a new UX grid
HI, i have a grid in the New Ux and i have data summarised by the Country in the hierarchy If i sort the data by Change the summaries get sorted amongst the data, and that is not useful. I want the summaries to remain at the top, and the other line items to be sorted. How would I do this please?
-
Ability to place context selectors Top Right/Left and Bottom Right/Left
It would be great to have the additional option of placing context selectors at the top right/left or bottom right/left of cards…this allows for the ability to decrease wasted white space if we need to show both a context selector and a title on a card. In the example below if we could have the title at the top left and…
-
OEG Best Practice: Performance issues with CUMULATE over lists
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the function is running on a single CPU thread, which differs from nearly all Anaplan functions. Anaplan gets its efficiency from…