-
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…
-
Women’s History Month: Spotlighting leaders in the Anaplan Community
March is Women’s History Month, a time to celebrate the achievements and contributions of women — including the incredible members in the Anaplan Community! Over the past year, women across the ecosystem have shared their knowledge, experiences, and insights through blogs, videos, and member spotlights. Their expertise…
-
Anaplan XL : How to writeback
Hello, I would like to know how to Input data from Anaplan XL to Anaplan, the lesson about it only refer to Fluence and not Anaplan … Thanks
-
L2 - Spring 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks For this task, I have applied the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but this formula seems to be incorrect. The values in the weekly columns are 0 instead of monthly value/no of weeks in…
-
Access to Coplanner in any Application
I have completed the Coplanner training on Anaplan Academy and would like to practice this functionality. Is Anaplan Coplanner accessible in any demo application? If so, could you specify where? Does it require activation/special request at the tenant level within the organization? How does it work?
-
Not able to fetch the history for particular cell
Hey People, Does anybody know why I am not able to fetch the history for particular cell, or has anybody faced similar issue. Ss below even after using the 'Export' option, text file is blank. Any inputs ?
-
Question about Boolean line items
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.…
-
Give us the ability to rename the default title "Additional Insights" in Worksheet side panel.
We sometimes use the side panel for data entry, and the title "Additional Insights" may not always align with our use case. It would be helpful to have the flexibility to change the title to something more relevant to the panel's purpose.
-
Export Formats
Hi, Just wanted to know that while exporting from the New UX is there any way in which the pdf export format be obtained as an A3 page. Currently the export is landscape oriented by default so is there any way out that this can be changed. Thanks in advance!
-
Need to create a form for users to fill out and the resulting data logged with several requirements
Objective: To create a reusable "data entry form" that allows users to Create a 'Project' The form requirements are as follows: Project Name, text Project Description, text Estimated Funding Cost, number - currency Projected ROI, number - currency Projected ROI (%), number - percentage Funding Required by - Date, date VP…
-
Dynamic Average Calculation
I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data is already available in the module in one of the line item. Can this be achieved through MOVINGSUM() ? If yes, how do it…
-
Preventing Duplicate Imports and Handling Data Changes
Hi ALL, I have an input module where users enter project input details such as Project, Country, Size etc..These two modules are connected through Project 'Libe'. Users uses a Boolean called 'Import to L2 Page' to import these records to the 'L2 ' page using an action. After the import, the Boolean('Import to L2 page) is…
-
NUX - Add several entries at one time in a module dimensioned on a list
Hi in the classic interface, when a module is dimensioned on a list, it's easy to add several entries at the same time with the action of creating items as showed below (which eases also the fact to copy-paste information which can be the same on several lines created): In the NUX, it seems that the only way is to create a…
-
Variance reporting - not using native versions
Just to give context we do not use the native versions in Anaplan, rather we use a list name forecast versions and then have a subset of these that we have of these that are marked as those we wish to do variances on, which seems to work well. We predominantly look at variances at a certain level in our cost centre…
-
how to place the total full year on the chart using the Classic DB?
just a simple question on how can I place the FY25 total also in below chart? I always included the FY25 in my module when I created the chart but it is not appearing.
-
LOOKUP Problem!!!
Hello community, I am going through something with Lookup formula as below. I have a module (say module1) dimensionalised by Account list with Account code column. I also have a List (say list1) with account code, employee code and names. In the module 1, I have created line items for employee code and name. For which I am…