Recent Discussions

I may not be clear because I'm using a translation tool to convert Japanese to English. I'm in a lot of trouble and need your help. The problematic area: level 2 sprint 2.3.9.2 When I try to execute Process 9. Import Data from the Hub according to the instructions, I get an error as shown in the third image. Please tell me…

Issue: When building dashboards for users, we ensure column widths are consistent across all columns. However, users often filter data and adjust column widths based on their specific needs. They can save these adjustments in a Personal Copy, but upon re-login, the column widths are reset, requiring them to manually resize…

One of the foundational elements of any Anaplan model is hierarchical lists. When creating hierarchies there are two basic choices: balanced or unbalanced. In this article, we'll look at the differences between balanced and unbalanced hierarchies, areas where they behave differently in Anaplan, and some questions to…

DON’T MISS OUR INFO SESSIONS Register now for the July 9th ACE session on updates to the Anaplan Certification Program. Partners should plan to attend the partner boost session in June for more information. ANAPLAN ACADEMY SYSTEM DOWN TIME – JULY 6TH & 7TH Anaplan Academy will be unavailable on July 6th and 7th due to…

We are looking to capture your feedback on the usability and find-ability of the new navigation system compared to the old one. The goal is to evaluate how the new system performs in comparison to the previous one, especially as the ADO architecture evolves with new features and options. You don't have to currently use ADO…

Some customers have dimensions/lists with more than 1,000,000 list items. When leveraging Anaplan's options for connecting Excel to an Anaplan Module, the user will usually filter the selection (and the user may be limited to a subset based on Selective Access), so the user will not need the full data set. Unfortunately…

Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch…

Hello, I am working on a project that requires conditional formatting for a graph, such as orange for bottom 10 products and blue for the top 10 selling products. Is it possible in Anaplan or is there any workaround for this? Please see the attached picture for a sample graph I want to create. Thanks

Can you set up a bulk copy between models? I have two models. One is a stand alone Financial Forecast with numbers adjusted in various modules and saved views. The version in that model is named the working forecast. The other model is our main Financial Forecast and I have created a version specifically for the data to be…

I'm attempting to show the 'remaining' months eg everything after the current period in the time settings - is this possible ? or would I need to create a fake period list?

I need to build a Slope and intercept formula where my X values are dates. Like in the screenshot. Since in Anaplan (the normal build) way we calculate by using the formula as mentioned. How to convert dates into number format or otherwise how can we achieve the same Example :

Hello everyone, on my activity, the totals for the other expenses are not populated as the same with the should be result in the activity. Here are some screenshots. This is my model: This is the should be: Any solutions to this? Thank you

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…

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…

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.

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…

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…

If you missed our event today, Understanding the Customer Care Portal, a recording is now available. In this event, I provide a demo highlighting the value of the new comprehensive case visibility, self-service tools, and dynamic case submission form to reduce resolution times. Topics covered include: Seamless access to…

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…

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

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…

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?

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.

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

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…

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…

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…

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…

New UXの機能アップデート ・列幅の上書き ・散布図とバブルチャートの絶対サイズの指定 ワークフローの機能アップデート ・メール通知のコンテキスト設定 ：モバイルのオフラインタスク作成 ADOの機能アップデート ・ソースデータセットから変換ビューを直接作成 ・データ系統マップ ・モジュールからのデータセットの同期 ・S3とAzure Blobのレガシーコネクタの廃止 Anaplan Disclosure Managementの機能アップデート ・サブフォルダ管理者 ・フォルダごとのデータソースステータスの変更 ・テキストとしてのExcel範囲 ・ホーム画面のレイアウト ・最初のページのプレビュー…

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?