-
Activity 4.4 Sprint 2 Level 3
Hi team, Just need a little bit of hint regarding importing this file. The account list/SYS model are refusing to take the duplicated lines for Candyose because there's more than one value to it. Cheers Peter Z
-
Level 2 Sprint 3.3.5.5 Final Shipping Method
I think the whole system of candy corn crumbles on the change of "shipping method", because the reorder flag is based on the standard shipping method. So when the system says I have to reorder but I choose to override the shipping method with another shipping method that is slower than the standard, i will receive my order…
-
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
-
2.3.10 Activity: Create Demand Forecast
Can anyone help what's wrong here? Not getting the required values.
-
2.3.10 Activity: Create Demand Forecast Formulas
My formulas are showing incorrect data. I don't know where I'm wrong. Can someone help
-
Manage inputs to Management Reporting
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Management Reporting is a great dashboard type in Anaplan. It looks clean, professional, and provides a familiar PowerPoint look to people while it is powered by the live data from the Anaplan model. It is a wonderful…
-
REQUEST: hide categories if the Role has no access to any pages there
If a Role doesn’t have access to any pages in a category then the category should be hidden from them
-
Anaplan API Python Connection
Anyone has tried to do a Anaplan API Python connection? I have an idea that I want to build scenarios in the magnitude of 100,000s. This will not be possible if we are using the inbuilt version page. My idea is to store the parameters of the 100,000 scenarios in cloud (for example azure) and run it in Anaplan and output it…
-
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
-
A conversation with Austin van der Linden — Journey | Anaplan Community Podcast
Welcome to our second podcast episode of 2024! Tune in today to hear Dennis Lemoine (@DennisL), Director of Customer Engagement & Experience, chat with Austin van der Linden (@Austinv) — Certified Master Anaplanner, Certified Solution Architect, and Corporate FP&A Technical Lead at Dentsply Sirona. Austin has been with…
-
GeoMapping - Custom Country Codes and Grouping
It would be fantastic if we could group countries and call them as territories . Most of the organizations don't work with countries for planning as in world map due to whatever business reasons and would like to group countries as one territory like Germany and Austria for Europe and while selecting that in map we have to…
-
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
-
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
-
UX Table colours
Hello, I am trying to colour only some items from a table that I have put in the UX on a grid card. Any ideas? Idealy should look like this, only 2 iteams in purpule
-
Which is more efficient, TIMESUM( ) or [SELECT:Time.All Periods]
If I'm trying to accumulate all time periods from a source module with time dimension to a target module with no time dimension, which option is more efficient? Should I use TIMESUM with no start or end date, or a hard-coded select clause for all periods?
-
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…
-
Pivoting with more than 3 rows
Description of the enhancement required: Need to be able to pivot more than 3 rows How would it help their business process: Reporting many cases of views needed with multiple dimensions with more than 3 lists in rows. Most recent case 1) A module with many dimensions 2) Need to be imported to a flat list 3) Filtering…
-
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?