-
Dynamic Aliases for Line Items (and other objects)
We are currently experiencing considerable product complaints from key stakeholders and project owners that need dynamic aliases, and for them to be dynamic (formula driven). The closest Idea exchange in the community can be found here. Competitor tools like IBM and Oracle, have this capability. An example of a specific…
-
How to integrate from Anaplan to ETRM through API.
Can you please help me on how to integrate data from Anaplan to ETRM, with API's, or if I can get API's script by which I can change workspace and model id and use that script.
-
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
-
Creating QUARTILE function within Anaplan
This is a method of building the Excel “Quartile” function within Anaplan – it requires 11 Line items, requires that the Data dimension has a ‘top level’ value, and uses the RANK function which has an upper limit of 50 million cells. To start, create a module (or use an existing calc module) dimensioned by your base data…
-
How to re-distribute or retain a value that is linked with a product, even product is deleted?
Hi there, I've situation where the Customer wants to keep the Overhead Values associated with a product, even though the product is being deleted from the hierarchy. I think of it as a manual entry for the value to be retained to that it can be re-distributed among the rest of the products or add to the total in the end. I…
-
Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hello everyone, I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this? FORMULA: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning…
-
Anaplan API : Could not connect to database!
Hello, I'm following the Data Integration Training - Part 2 on how to use Anaplan Connect to import data from a relational database. The training suggests an access database named Employees.mdb. Upon execution, I encountered an error (please refer to the screenshot attached). Any help will be highly appreciated. Thank you…
-
How to upload multiple files using multiple import actions with one Anaplan connect script?
Currently I am using this script, it is unable to upload the second file @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit…
-
Allow user to have more control over expand/collapse feature in context selector of NUX
The newly released expand/collapse context selector for pages in the NUX does not seem to "hold" the choices within the selectors. For instance, if I collapse all levels in the context selector, I would expect those levels to remain collapsed the next time I open/refresh the page. However, when the page is closed and I…
-
Macroeconomic Variables
Hello Community, Is there a way to source into Anaplan for modeling purposes forecasted/consensus macroeconomic variables such as GDP, benchmark rates (Fed Funds, SOFR), Unemployment, etc? Thanks! Daniel
-
Automate workflow start based on line item trigger
As a process owner, i need to be able to set up workflow template that can be started automatically based on a trigger event with when a line item is set to true lr false. The trigger would allow to start the workflow with a machine task allowing to run cloudworks processes, send notifications and / or assign tasks to…
-
Model Builder Level 1
Hi, I am new to Anaplan and have just started the Level 1 Model Builder course. I am in the Activity 7.2.3 section and have been stuck for a few hours now. Need some help to find out what I am doing incorrectly. I have attached a few screenshots Appreciate help from the community. Thanks Jacob
-
Graph time
Hello, I try to show on my UX graph only several weeks, but now, there are all the weeks shown and the graph is not lovely. Any tips?
-
Can any one tell me how to add categories and how categories defined?
Can anyone guide me on where to find the standard Category values for the Module Functional Area and List in Anaplan? Also, is it possible to change these options?
-
Formula DCA to lock cell
Hello, I need some help with a DCA. So I have 3 line items weekly dimension : X (number), Y (number manually input) and Z Yes or No. So : If I select No on line Z, then line Y should be 0 (blank) If I select on line Z Yes and if line Y is not 0, then the line Y for that week (cell) should be locked If I select on line Z…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
Certified Master Anaplanner Eligibility
Certified Master Anaplanners are Anaplan’s most experienced platform evangelists who share a common technical language and are involved in the structural development of their models. Anaplan's current customers, registered partners, and employees are all eligible to become a Certified Master Anaplanner, given they're…
-
How many hours of work would you estimate it takes to obtain "Certified Anaplan Model Builder"?
Specifically referring to the timeline from the beginning of level 1 trainings, through "Intro to Polaris". If you could also provide an hour estimate to becoming a certified solution architect. I understand there should be 9-12 months of real-world project experience. For this I'm just concerned about the hourly…
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
regards to talent builder program..
I submitted a request for access to the workspace this Monday, but I haven't received any updates on my application so far. Is there a way to contact Anaplan members to inquire about gaining access to the workspace for practice?
-
Collapsed view of Hierarchy/List
Having Ability to start with Collapsed view of Hierarchy is one of key requirement for many end users. This gives end users a capability to start a report with collapsed view and only drill down on need.
-
CA Certificate Quick Start Guide using Sectigo
Creating an Anaplan CA Certificate using the Sectigo Personal Email Security (S/MIME) certificate involves several steps. Here's a quick start guide to help you through the process: Step #1: Purchase the Sectigo Personal Email Security (S/MIME) certificate from Sectigo's website. You can find it here. The cost is $15 for a…
-
Anaplan's Device Grant API Flow: A Seamless Machine-to-Machine Authentication Option
In the world of modern application development, seamless authentication is key to providing a smooth user experience. Anaplan, a leading platform for planning and performance management, offers a versatile approach to authentication through its Device Grant API Flow. In this blog post, we'll explore the Device Grant…
-
Anaplan's Authorization Code Grant API Flow: A Seamless App-to-App Authentication Option
In the realm of contemporary application development, achieving seamless authentication is paramount for delivering an exceptional user experience. Anaplan, a prominent player in the realm of planning and performance management, presents a flexible and robust solution for enabling resource authorization between Anaplan and…
-
L2 INV05 Shipping Cost Conclusion
Hello, Im having an issue where my values for the Shipping costs on the INV05 Shipping Export module are much larger than what the training check your work has presented. I know there is a disclaimer at the bottom of the check your work that the values may be different but mine seem to be much larger. I want to know if…
-
Where can I find Location details for Accounts in level 3 Sprint 1
Hi, I am completing the Level 3 Sprint 1 and there is repeated references to Accounts rolling up to Locations. I can't see anywhere in the Model or the Data Hub where that relationship is spelled out. There is room for Location and Country in SYS02, but the field is blank so none of the formulas work. I assume that you…
-
level 3 Model Builder
Hi, I'm going through Level 3 at present. When I complete a task in the Sprint, I can't view the details when it tells me to compare my work. The worksheet to compare is not viewable on the screen. Is there any way that I can download the comparison files so that I can log my progress as I'm going along?
-
Replenishment modeling with circular reference
Dear Anaplan Community, I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition: If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety…
-
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?