-
My SUM formula is only bringing back data for 2 list items but not the other 300 odd lines.
I have 2 modules set up, one with source data by line item that contains a 'Fund' code (CAL13) and then one with list mapping data by fund code (SYS34). I have set up a 3rd module and added in this formula 'CAL13 Consolidation by Fund'.Actual by Fund[SUM: 'SYS34 F4 Fund Details'.Account Mapping] They both have a level of…
-
Unexpected Model Size Increase After Updating Custom Time Range
Hi Anaplan Community, I recently updated a custom time range in my model and noticed an unexpected increase in model size. Previously, my custom time range started in FY22 with 4 periods, and the total model size was 78 GB. After updating the start period to FY23 (keeping the number of periods at 4), the model size…
-
Conditional Formatting for User-Based Search Functionality
Hello Anaplanners, I have created a search functionality in Anaplan that allows users to search for specific text within the project descriptions, Project one liner, Project StoryBoard line items within a module where Projects are a dimension. The search functionality is user-based, meaning each user can input their search…
-
Axis for Charts
Hello all, Does the auto-axis functionality not work for waterfall when you have negative numbers? Case 1 - Positive numbers Case 2 - Negative Numbers The numbers are exactly the same & its the same chart with the auto axis turned on. In case of positive, the variances can be observed very well with visible bars for the…
-
【2025年2月】プラットフォームアップデート
New UXの機能アップデート ・列幅の上書き ・散布図とバブルチャートの絶対サイズの指定 ワークフローの機能アップデート ・メール通知のコンテキスト設定 ：モバイルのオフラインタスク作成 ADOの機能アップデート ・ソースデータセットから変換ビューを直接作成 ・データ系統マップ ・モジュールからのデータセットの同期 ・S3とAzure Blobのレガシーコネクタの廃止 Anaplan Disclosure Managementの機能アップデート ・サブフォルダ管理者 ・フォルダごとのデータソースステータスの変更 ・テキストとしてのExcel範囲 ・ホーム画面のレイアウト ・最初のページのプレビュー…
-
Not able to create app or pages in L1 training
I am about to complete L1 training. But I don't have the page builder access and I am not able to build pages in the model as well. I am not part of any company and I am a student. I am not sure what to do now. Can anyone please help me with this?
-
Conditional Formatting in Page using Line item from Other Module
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: How often is this impacting your users? Our client wanted chart in right side panel on Worksheet and this required a module with only…
-
Anaplan batch files need both JRE and JDK or JDK is enough
we are planning to reduce number of software and driver in server. Also we are using batch file to import and export data in the server. Do i need both JRE and JDK
-
IFP &OWP available in Polaris?
Hello, Do the new Integrated Financial Planning (IFP) and Operational Workforce Planning (OWP) applications support Polaris, or are they only available out of the box on the Classic Engine? Thanks in advance to anyone who can help!
-
Functionality to Delete a user account at Tenant Level
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: Use Case: - Functionality to Delete a user account at Tenant level does not disable. Problem: - For system integration in any…
-
Import/Upload restrictions on Flat List and Flat List Modules
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users from different regions upload Planning data to this module using offline csv files. The…
-
Bulk Copy Run Not Visible
Hello, has anyone ever encountered this before? I am trying to execute a bulk copy from one version to another and when I come to the "Are you sure" page the run / ok button is not visible, therefore I am unable to execute the action.
-
Anaplan isn't showing previous certification.
I had completed my level 1 and level 2 sprint 2 trainings a few months ago, now I wanted to complete my level 3 so came to resume my training sessions, but Anaplan tells I haven't even done level 1. I have a copy of completing L2 Sprint 1 exam, but now it says I don't have any certification started.
-
Anaplan Data Orchestrator (ADO) - AMQP Connector
We have implemented a event driven architecture in order to interface our application (including Anaplan) in "close to real time". However, the Advanced Message Queuing Protocol (AMQP) is not supported for the time being by ADO, which forces us to use an additionnal middleware. This would allow us to implement a seemless…
-
Most efficient way to apply bandings to employee list
Looking to apply the bandings below to employee list depending on what salary is and whilst I know could do this by using combination of IF and AND statements I'm thinking there must be a more efficient way to do this calculation wise - any tips or suggestions would be much appreciated.
-
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 provide integration access to a user
I am tenant admin and I want to give integration access to one of the user, can anyone help me with how can I provide that access to a user.
-
Access Restrictions on Flat List
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users upload Planning data to this module using offline csv files. The Process has 2 actions,…
-
Getting rid of the dimensions in a dashboard
Hey little (maybe stupid) question, A couple of months ago, I was able to get rid of the dimensions in a dashboard by clicking twice on the line between the dimensions of the rows and the grid itself. So when I did this, the dimensions disappeared and only the data was visible. Now, is it possible that this functionality…
-
The ability to view Anaplan UX adoption data in specific categories
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: As an Anaplan Tenant Administrator, I need to be able to view my Anaplan UX adoption data in the following specific categories:…
-
Leveraging Synchronize Scroll on Same List Structure with and w/o Time
Hi Everyone, Looking to see how others are addressing a certain build request. We commonly get the request to have attribute information next to a metric that is also dimensioned by time. An approach we have started using is having two modules on the same UX page leveraging synchronize scroll. This allows us to have…
-
Filtering Actuals based on selected Version in UX
I have (simplified): Actuals Module - dimensioned by Time only Forecast Module - dimensioned by Time and (let's call it) Version List (not the native Version - just a normal list) Settings Module - dimensioned by Version List, which has a line item called "Forecast Start Month" (format: Time/Month) System Module:…
-
Field no showing on Add Entry screen for some users
Hello, we have a Dashboard and there is a New Entry form, we added a field (unrestricted) for currency in the module, and added it to the entry form. Some users are seeing the old list of fields to add Others are seeing the new field included I cannot work out why this is not showing for all users as there are no selective…
-
Many to Many Sum in a single step?
I am in the middle of a model build and am running into a situation where I feel like there should be an efficient option to do a calculation, but I can't figure out a way to do it without a 'staging' line item that bloats the model. As the title says, I have a 'Many to Many' relationship - a single Deal can be tagged to…
-
Unable to show tax rate which is a 2-variable lookup from another module
Hi guys I am facing a problem and thought any kind soul here might be able to help out. In this module HR02, I am unable to display a "Tax" rate which is essentially a look-up from TAX01 Any idea what would cause the lookup to not work? Thanks!
-
3.3.5.5 Update Inventory Ordering to Allow Override of Shipping Method - Final Shipping Time Weeks
i'm stuck while following the hint, it said The formula for this line item is similar to the Shipping Time Weeks line item, except it should reference the Final Shipping Method line item. and the formula for the Shipping Time Weeks is 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Shipping Method, LOOKUP:…
-
3.5.4.2 Create Distribution Center Capacity Module
Hi everyone, My values don't seem to be very realistic, would just like to ask for guidance if I'm doing something wrong. Or if someone could check the values.
-
What Does User Admin do?
Hi all, I couldn't find much useful information on User Admin so I hope someone can shed some light on it. When I dedicate a user an User Admin, will it count towards my WSA limit? Can User Admin who is not WSA create new users, update role, update selective access via a User Management module or import action in NUX?…
-
Case study: Challenges faced before introducing Anaplan
Author: Jonathan Cushing is a Certified Master Anaplanner and Senior Consultant at Vuealta Consulting. My first experience of Anaplan was building an FP&A model in the company I worked in group finance. The company operated within the construction sector all over the UK with regional offices along with a centralized group…
-
Make the "model open analysis" available
It is very common to face performance issues with Anaplan models. Examples are not lacking, you just have to have a look to Anaplan Community to realize it. Several “best practices” exist: https://community.anaplan.com/discussion/33530/oeg-best-practice-plans-this-is-how-we-model Moreover, a tool exists, the “Model Open…