-
How does this new fluence/Anaplan disclosure management work?
I want to understand on how I can get access to new fluence/Anaplan disclosure management Is it part of the license? Also can multiple users work on a single report at the same time using this tool?
-
Code formula
Hi All, Just another simple one this time. I need to capture the code of the L0 Hospital subsidiary. I tried code(item('L0 Hospital Subsidairy')) formula in a text formatted line item i keep getting an error. i need to put the L0 code on the hospital code column to match the L3 department. the hospital code column is text…
-
Avoid the roll back every time the formula is wrong
Every time we create a wrong formula the system runs a roll back that takes about 8 minutes!! We would like to avoid this roll back... it takes so much time during the development phase! They could just send a warning message!
-
[UPDATED] Summary Calculations with the User List
Author: Rob Marshall, Director of Architecture and Performance at Anaplan, Operational Excellence Group (OEG). Prior to the February 2024, users were not allowed to use aggregation functions (SUM, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK) when having the Users list in a module because the system could…
-
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
-
Did not import data for those months but the module still display numbers
I have my .csv file are all Feb data But after I imported to my module, the Feb data are correct, Mar are zero, but all other months before should be zero. They are not: May I know if I have forgotten to do some settings ? Thank you.
-
Import into new User subsets
Super excited about User Subsets. However, we will need the ability to import into the user subset to make it useful. Another potential workaround would be the ability to use roles to auto populate the subset.
-
Time filter not working properly
Hi everyone, I have a grid where i show Products in rows, time/multiple line items in columns (Sales, Py Sales, %growth etc..). I want to control the time dimension based on selector provided to user (Attaching Screenshot). There is a final time filter line item and it is at month level and works fine if i use it when…
-
How to Aggregate Monthly Data to Yearly When Time Summary is Set to None
Hello Anaplanners. I have a module dimensioned by Month, but the Time Summary for my key line item is set to None to optimize space. However, I need to bring this data into another module that is dimensioned by Year. Since the time summary is disabled, the values don't automatically roll up to the yearly level. Would…
-
Stackable UX Cards
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: Lots of our UX pages have a summary grid at the top, then a series of grids below with the same column headings and more detail…
-
L2 Sprint 2 - 2.3.9 Activity: Historic Volumes to Baseline Forecast
Hello, I keep seeing the following error message: Invalid formula: 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DEM02 Volume Growth Rates by Week'.Growth %, -52, 0) ELSE 0 For function OFFSET, all line item arguments that vary by time…
-
Allow for line item subset to be more than just number formatted
Description of the enhancement required: Line Item Subsets are often used to build filter modules, as an alternative to using the Show/Hide functionality. Using a Boolean against a Line Item Subset on a filter module makes it very easy to select which columns should be shown or hidden on a dashboard. An example of the…
-
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module
why the numbers is not shown in margin % , unit price growth % and unit cost growth %? although all functions and format are right? thanks in advance
-
Anaplan & MS Access Transactional API using Python
Hi, I'm trying to update the data in Anaplan module line items directly from MS Access by converting into json format using Python transactional APIs. I'm keep getting the "Status code 400" , "Message - Post body is not a valid json". I have tried by printing the json format before sending the data into Anaplan and format…
-
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.
-
App: Formular and Function Resources
Hey, new here and starting out with the Model Builder I course. In Lesson 6 there is shown how to download the Formular and Function App. Unfortunateley this Video seeems outdated so i can't find this resource. Any trick here?
-
About DAC Drivers
Hi Team, I understood that we can use only Boolean drivers in DCA, why can't we use other data types? One reason is space, Boolean consumes less space than other data types. Thanks in advance.
-
Model Integration details
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
-
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…
-
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…
-
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…
-
More dashboard formatting options (bold grid lines)
Description: When publishing a Dashboard, we would like to have the option to modify or customize the thickness of the borders to better segregate the line items from each other. We want the ability to add bold borders, hashed borders, double borders, etc. Benefit/impact: The border must be able to surround the entire…
-
List of subprocessors
Anaplan provides documentation that lists the affiliates and subservice organizations that are material to the provisioning or support of our hosted service. For the latest information regarding third-party subprocessor vendors, see the current list of subprocessors. To subscribe to this page and receive notifications when…
-
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…
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
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