-
Flexible time options - for instance on weekly time horizons
Many countries' business planners think in calendar week numbers, and there are a few different week numbering systems used globally. Customers request that Anaplan enhance the platform's native Time options flexibility to add more possibilities: To define weekly time horizons start/ end, Naming the periods, Options on…
-
Anaplan file export using Anaplan connect and process
Hi, I am trying to build regular export action / process and using in Anaplan connect to automate it . But when I create process / action with everyone access and run in Model it works . Bute when the same process I call through the Anaplan connect it gives me error "File not found in workspace or model". pls help me to…
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
Renaming a Line Item: Don't Break Import Actions
When a solution uses a line item as a source within an import action, whether model-to-model or external source-to-model, the renaming the line item will break the action. This issue impacts the model builders who need to do a rebuild of the action every time they make a change (if the model builder forgets to rebuild the…
-
How to convert month to text?
I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a text display for May 25 as AprilPayMay25). I've done a lookup table in the past but was hoping for a formula that could do…
-
How to ask great questions in the Anaplan Community
Author: Seyma Tas is a Certified Master Anaplanner and product owner at Caliber Collision. A guide to help you get the answers you need The Anaplan Community is an incredible resource to share knowledge and get help. To get the best answers quickly, make sure you ask clear, well-crafted questions. Here are some tips on how…
-
how to take average in anaplan ?
difference between average and time sum function ?
-
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
-
Multi-layer sort
Would be very useful to have a multi-layer sort (not filter) like in Excel i.e. Sort by column A alphabetically, then by column B, then by C. Acknowledging the workaround to concatenate the desired fields into a text line item and sort by that, but to me a publicised workaround is always a pointer to a needed/desired…
-
Include Dimension Index size information in module blue print for Polaris
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Polaris has a limitation that a line item can not have more than a dimension index of 64. Models can start off with a dimension index…
-
March 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our March 2025 official release notes. The information below offers supplemental information to that post. Planning and modeling Calc Effort % in Classic Calculation Effort is now available in Classic, either in Blueprint view or the Line Items section of the…
-
Scheduled export of Reports and Pages from Anaplan
Can future development of Anaplan include the capability to schedule delivery of Pages and reports to individuals via email? This would be excellent for providing reporting views to management and would be a great benefit as well as match what is standard capability in packages such as Cognos or Hyperion.
-
Add a Data setting for Waterfall Charts to select any line item as a bar go from Zero to Value
Would like to see an additional Chart setting to select a line item as a the last "Total"bar in a waterfall chart that goes from Zero to Value. For example, the EBITDA bar in the below screenshot is going ~6k to ~14k. I should be able to manually select the line item, telling Anaplan to override the bar's y-axis values…
-
Option to overwrite line items with Read Access Driver through an Import action.
Hi All, I am in a situation where the users are uploading a data file into Anaplan, that we are then wanting to create a report based on, to highlight some issues, that the end users then should be able to comment on. The problem I am facing is that loading the data file into a module, we want to show the raw data inputs,…
-
How to filter a grid using the composite list?
Subsidiary is the composite list here as an example, i want to filter my grids based on the selection at any levels. For E.g If i select RoW then i should be able to see all the data of Germany, Brazil, Australia etc.
-
Fixed Line Item vs Column Headers
HI all, I have a transaction list that I am trying to import that covers a teammates hours worked amount and the payment amount. I am trying to import it into a model dementionalized by things like Teammate ID, Location and the type of hours(i.e. Salary, PTO, etc). When I try to run the import using column headers to…
-
3.3.12 Activity: Create Product Replenishment UX Page
Hi, I hope someone can assist please. I'm stuck at below task, not sure what have I done wrong in setting-up 'Planning Period Filter' month selection setting to sync against the desired objective of "Select he months you wish to view. Then, click Refresh to apply the Planning Period Filter". Instead of showing data for the…
-
anaplan academy tag
Hello, please i want to ask you where can i find my anaplan academy tag? Thanks,
-
To show only limited list items in the dropdown while saving a scenario
We have a save scenario button on our UI, when the user clicks on this button, backend process is executed. The backend process runs a set of actions. For the backend process to be triggered, User needs to choose a scenario from the dropdown list so that all actions save against the chosen scenario. While presenting the…
-
Announcing: Statement of Direction for Anaplan calculation engines
Anaplan has just launched the new statement of direction for Anaplan Calculation Engines The full statement of direction can be read here. What is a statement of direction A Statement of Direction is a public guidance designed to inform our customers & prospects about our strategic direction at product level. It provides…
-
Power Bi service refresh error
Hi All, I am encountering a data source expression error in Power Bi service when scheduling a refresh indicating that a column was not found and with a error message "The exception was raised by the IDbCommand interface" . I have verified my data source, and everything appears to be in order. Additionally, when I refresh…
-
How to converte a Date to a text
Hello, I am trying to convert a date (Line Item "DLC DATE") to text (Line Item "DLC DATE TEXTE") using this formula: TEXT(DAY('DLC DATE 2'), "00") & "/" & TEXT(MONTH('DLC DATE 2'), "00") & "/" & TEXT(YEAR('DLC DATE 2'), "0000") However, I don't get the correct values for the month or day when the value is under 10. For…
-
L2 Model Building - Sprint 3 - confirmed PO delivery
I am stuck with building the formula for "confirmed PO delivery" In case line item "PO submitted" is 1 for week x, it should show 1 in line item "confirmed PO delivery" for week x + offset. The offset number is depending on the shipping time shown in week 1. I used formula: IF PO Submitted = 1 THEN OFFSET(PO Submitted,…
-
How to get value from time dimensioned module to non-time?
Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM03.1 (1 pic) to Date of Introducton in LIST03 SKU (Pic 2). How can I do it?
-
o
one of my friend wants to learn anaplan through self paced learning, he is not able to find the option to create account, kindly help
-
Order in SUM agregation parameters for performance
Hi hive mind, I have a tricky question. Here we go : I have a target module with 3 custom dimension (A,B,C) + Time (Month) I have a source transaction module containing line Items with A, B, C list formarted and a date column and an amount column In my Target Module, I need to agregate the Source amount with A,B,C and…
-
年度リスト→日データに適用
4月~3月を一つの年度として、認識させたい。 まず、年度のリストを作りました。(2024.2025…. そのリストを、日データ（2024/4/1→2024）につけたいです。 年度算出まではできたのですが、その後どうすればいいか詰まってしまいました。。
-
Anaplan Connect Chunk Splitting
When importing/exporting data using Anaplan Connect 3.0, if the file is 100MB or larger, it will be split into chunks according to the chunk size setting. When this happens, if the file contains multibyte characters such as Japanese, the characters will become garbled. Does anyone know how to solve this problem? Or will…
-
アプリ表でのフィルタを合計に反映
アプリ上での表でのフィルタを、合計に反映することはできますか？
-
New UX: Make features in 'Board' and 'Worksheet' page layouts consistent or give blank page layout
Hello Anaplanners, While I really like the option of choosing either a 'Board' or 'Worksheet' style for creating pages/ dashboards in the anaplan UX app, there are certain limitations that could be possibly enhanced. I have been leveraging new UX capabilities for multiple reporting purposes in my current project. The…