-
Supply Chain Related Functions
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like End of Stock, Beginning Inventory, etc based on input parameters?
-
Automate refresh from Anaplan to Google sheet.
Hello, we've established a connection between an Anaplan module and a Google worksheet through an Add-on. What are the available methods for setting up an automated refresh schedule from Anaplan to Google Sheets?
-
Level2- Sprint1- 1.3.8 model to model import-unable to import parent from saved view build location
Level2- Sprint1- 1.3.8 model to model import -unable to import parent country column in G3 Location list from saved view - build location. Please help me out to resolve the same.
-
Right-Click + Copy Doesn't Work on Grids
From what I can tell, right-clicking and selecting copy on a grid will always return this warning: Is there a reason why that right-click + copy is an option on a grid if it will never work? Or is there different behavior between right-click + copy vs CTRL-C?
-
OEG Best Practice: Anaplan Python OAuth Example
The Anaplan Python OAuth Example demonstrates using the Anaplan REST API with OAuth with device-based authorization. The code highlights how to generate a device_id, access_token, and refresh_token. Additionally, the code highlights a multi-threaded approach to request a new access_token while performing other,…
-
Use fake week to replace default week calendar
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Some businesses run their planning or operations by weeks. However, setting the Anaplan model default Calendar Type to Week format can be inconvenient. For example, converting dates to monthly format can sometimes be…
-
Level 2, Sprint 1, 1.7.3.1 Import into P3 SKU list
Hi all, I'm trying to import data into the list P3 SKU, and faced some problem. Please attached the screenshots of the step-by-step of what i did and the problem. Kindly need help to resolve this issue. Thank you so much!
-
Summary Method for Lookup function
Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All…
-
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…
-
OEG Best Practice: Using Anaplan Connect with OAuth
How to Use Anaplan Connect with OAuth Authorization Anaplan Connect is a powerful command line interface that allows you to automate your Anaplan environment, enabling seamless data integration and synchronization between Anaplan and other systems. While Anaplan Connect offers various authentication methods, including…
-
Anaplan Connect API not found
Hello, I'm trying to use Anaplan Connect. Everything seems to be OK (Java, authent, proxy). But I have an "API not found" error. It's a simple script listing all processes (It works with Postman) @echo off setlocal enabledelayedexpansion AC_PATH=C:\Users\UBQLZC\Desktop\anaplan_connect_4.2.1\ set…
-
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
-
Is it possible to colour input line items for ease of inputting. For eg as added in the screenshot.
Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
-
l2 INV01 Inventory Ordering - Confirmed Purchase Order Receipt
I currently have used two different formulas for this line item. They are: IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0 And: IF Confirmed PO Delivery = 0 THEN 0 ELSE POST (Final Shipment Amount, Final Shipping Time Weeks) These both appear to work perfectly fine in my…
-
CloudWorks API - Increase the "Get integrations" retrieve limit
I use the API below to get CloudWorks integrations list: The retrieve limit is set to 250 which forces me to create multiple API calls to get the full list (using offset and limit parameters). It could be a good idea to remove this retrieve limit (the number of integrations in Cloudworks is already limited). Thanks!
-
Plan IQ forecast model - is there any way to detour a limit in forecast horizon
Hi I'm new to PlanIQ - I'm curious with simple prediction setting can I make a prediction of, for example, data in 2022 with the historical data of 2020 in planIQ when my forecast horizon is limited? (without setting 24 prediction months & giving more data?) since it has a forecast horizon limit when creating a forecast…
-
Bi-directional Integration: Bridging Workday and Anaplan
Intended Audience Level of Difficulty: Advanced Requires an experienced developer, solution architect, or data engineer Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, SQL Database, Text Editor Access Requirements: Database access, Anaplan model/s Estimated…
-
L2 INV03 Distribution Summary - Stock Exceptions
I wanted to get some help with my formula for the Stock Exceptions line item. Previously my formula for this line item was: INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product] This worked, but was giving me large stock exceptions and was unsure if it was correct or not because the…
-
Prior Year YTD total option for Time Ranges
Hi, We have a large reporting requirement for reporting versus prior year for reporting month and Year to date. The month is easily achievable but if we want to create views that compare Prior year to date versus current year to date its a lot more fiddly. Alot of our monthly reporting is done through the Excel Add in and…
-
Anaplan Connect - No errors but no data uploaded
Hello, I'm working on the first activity in Anaplan Connect training-Part 2. The Goal is to upload a list of employees to the Financial planning module. I have diligently followed each step outlined in the training. Upon executing the script, it reports that the file has been uploaded. However: I am unable to observe any…
-
NUX Synchronized Filters across cards
A couple months ago, Anaplan rolled out a new feature where cards can have synchronize scrolling if they show the same module that shares a dimension. Similarly, it would be helpful if we are able to apply a native card filter that can synchronize across multiple cards that show the same module with the same dimensions. *…
-
Adding list items, but only display the result when a list item is selected
Hi all, I'm experiencing an issue in my module where when selecting a certain list item ("online" - in the screenshot), the numbers aren't displaying as they should, and I'm getting 0 in every line item. I think this is a build issue, however I want to try a hotfix by adding two different list items that I know total to…
-
Level 3 - Ask the Stakeholders - Assigning Accounts to Territories Process Questions
Level 3 - Ask the Stakeholders Assigning Accounts to Territories Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Assigning Accounts to Territories Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…
-
UX, App-dropdown need to have category
In new UX there are many apps we are creating as per models. now we have 59 Apps there is very difficult find app names.. Can add category or search (find) option in that section so we can find any app easily.
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hello, What am I doing wrong here color coded DCA not working ? Below are formulas for AD02 module and access setup for INV01 ? 'INV01 Inventory Ordering'.Submit Purchase Order Request? 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount? 'INV01 Inventory…
-
Behavior Change in UX Pages - Double Click to Active Dropdown menus?
Has anyone else noticed that list formatted line items now require a "double-click" to active the drop down selection menu? I haven't found any documentation highlighting the change in behavior but the cell would previously active with a single click. Will take some getting used to as users may perceive they don't have…
-
Level 2 Sprint 3 - 3.4.4 Stock Exceptions UX
Hello! I am struggling to complete the 3rd grid for the stock exceptions review UX. It is not syncing with the Region context selector. Grid 1 and 2 seem to be working correctly. Grid 1 and 2 pull from INV02 Country Summary Grid 3 pulls from INV01 Inventory Ordering INV01 doesn't have a geographical dimensions, I'm not…
-
Integration Account Access Settings
Hi Everyone, Hoping there is easy setting for this that I am just not aware of. We are trying to keep our integration account that we use with Anaplan connect as a non-workspace admin user. Occasionally we have to take the model offline, but still have hourly connect scripts running. Because the user is a non-admin and the…
-
Moved: Anaplan Certified Solution Architect FAQ
This discussion has been moved.
-
Calculations with list items
Dear all, I created a line item "Figure" and a list "Divisor". The list just contains two values: 12 and 24. I further created a line item "Result" which should display the result of Figure divided by Divisor. So my module contains three line items: Figure: Number Divisor: List Result: Number Unfortunately Result = Figure…