-
Need help with better approach
Hi, I am facing issue with the below senario. If someone can help me out with what is the best possible approach I have hierarchy with lists from L1 to L6 levels and a flat list D with list items from D1 to D5 Current setup: There are several hundreds of modules with combination of flat list D with one of the hierarchy…
-
Model間インポート
ワークスペースが異なるModel間のインポートで特定のModelだけ取得情報元のModelが見つからない、インポートに失敗する理由が知りたいです。 どんな原因が考えられますか？
-
Anaplan to SAP journal posting
Hi All, I am working on automating journals from Anaplan into SAP via SAP BTP/API. The API is linking to saved exports with a saved view. Journal data updates on a monthly basis but the changes in data don't get picked up by the API and instead old data gets posted into SAP. Has anyone encountered this before? Is there…
-
Add option to Plot Leading Zeros on Charts
Within the Data options of charts, Anaplan currently has an option to configure whether trailing zeros are plotted or not. This is very useful. However, there is very often also the need to control whether leading zeros are plotted or not and this option is not currently available. This idea request is therefore to add an…
-
Error while updating formula for REV05 unit %
HI There, While updating the formula for REV05,I am getting the following error. Can anyone help me out. 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product family]
-
Lvl 2 Model Building - 2.3.10 Activity: Create Demand Forecast
Hello everyone, I'm having problems with the formulas and I'm not sure where my mistake lies. Maybe someone can help me. These are my formulas: These are my results: Best regards Tobi
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Level 3. Build Sales Role and Sales Reps
Hello, Sales Role and Sales Reps# are flat list in Sales Planning Model. In the Sprint2, the ask is to create import to build them up. I am using SYS09 Employee Details module in Data-Hub, but it is not working. Any Advice? Thanks
-
2024 Recertification Requirement Announcement: Using Workflow in Anaplan!
We're thrilled to announce our 2024 recertification process for Certified Model Builder, Certified Solution Architect, and Certified Master Anaplanner. Being a Certified Model Builder, Certified Solution Architect, or Certified Master Anaplanner means that you’re a highly qualified and valued part of the Anaplan ecosystem!…
-
Boolean Filter for Salary Rank function
Hi, I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below). I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK…
-
Level3. Create Action with filter
Hello, As explained in the Level3 study material, I added country and segment as properties to "G4T Territory>Account#" but I still can't see them in filter section when I create an Action. Please advice. Thanks
-
Actions Tab Improvements
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: Looking to review trend Process executions and durations. How often is this impacting your users? We are currently implementing API…
-
Celebrating 100K Community members!
Thank you, Community! We’re thrilled to announce that we have reached 100,000 registered users, all thanks to you — our incredible members! Your creativity, commitment to helping others and continued enthusiasm has made the Community a special place for our members. We know the Community is the one place within the entire…
-
Help needed to get the data by pulling from two time scales
Hi, i want to get volume data based on the line item 2 to my target module which is at year level. But my source having the time dimension while i am writing the formula no values are coming
-
Time Aggregation from Time to All Periods
Hi everyone, while working on a module containing Sales Data by Month and then referencing the same into another module containing Sales Data without Time Dimension, I noticed that Time doesn't aggregate on All Periods (which is set on Time Calendar) as other custom lists do through Top Level setup. It seems that for Time…
-
YTD / YTG Functions
Hi All, Looking for a bit of guidance here, around YTD / YTG functionality, do people tend to use the elements that are shown in the model calendar, or do they do in a different manner and if so how? I would appreciate any guidance and pro's / cons that people could advise. For reference, we don't use native versions,…
-
access to apps level 1 model builder
Hello, i have a question Regarding the level 1 model builder course i have just got access to it but when i click on get started i receive this message : " You currently have no apps — please contact your page builder " what should i do should i just send to the support or someone else. Thanks
-
Setup your ADO Demo using an AWS S3 Connection
Author: Noel Rocher, Partner Success Manager at Anaplan The problem statement "I would like to Demo the ADO S3 Connector with a CSV file hosted on AWS S3 as an ADO Data Source." The solution Use a free AWS Account to host the example CSV file. Steps to take We will walk through how to setup an AWS environment using a free…
-
CloudWorks Failure Status Description Definitions?
We have CW jobs that are failing. These jobs do not have an error log, all we have is the Status Description on the Activity page. Is there a list of status descriptions and their meaning for CW job failures available so we can troubleshoot these failures?
-
明細データの合計
下記のようなデータで、Flgの合計が1以上ならXのような式を作りたいのですが、どうすればいいでしょうか
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
level 3 training sprint 2 2.3.1 Assigning accounts to territory question
hello everyone I am facing a question that after I reading user story 2.2 , which is about how to use count formula, I have to write some formula of items in QUO01 Territory Account Validation Moducle, and the Assigned>1?: item is asked for finding if one accout is assgin for more then one terrior. so I create a new…
-
How to do use aggregate value?
Hey everyone, i am stuck at the part where i have to devise a formula for Subtract 1 line item,for that i need the extra value which is 5% in this case ,can be seen in Override-Allocation line item and i need to divide it in those members which do not overriden the values like for LM1,LM2,LM3,LM4 and LM5 which looks like…
-
Synchronize Line Item Subset based on Line Item in the UX
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: The line items which the LISS were sourced from are not sync in the apps or UX pages. This is confusing for our users where some…
-
How to import date from one model to another
I'm not sure if there was a new update that changed the process? I cannot import a date from one model to another. I am trying to import the dates from A01 to A06. I think the checkbox on the mapping page is new. I've tried different variations but can't seem to get it to work. Thanks in advance
-
Using a calculated % from Actuals for Forecast
I am calculating an Actual % of Total in the CY. I need this % to roll forward into the Forecast years (3 forecast Years). Previous() only pulls in the % for the first forecast year and then solves back to zero for the last 2 forecast years. I also tried time lookup to no success to qualify an "If zero" as well. Any tips…
-
Synchronized Sort w/ Synchronized Scroll
The synchronized scroll feature is probably the most useful and innovative feature to date. I have noticed that I did not sort my list before I imported, and wanted to sort codes ascending in one grid. There are a total of 4 grids synchronized for scrolling on a common dimension, vertically. I sorted the first grid which…
-
Enable Show/Hide Functionality for Pages in New UX
Description: I would like to propose an enhancement to the Anaplan New UX that would allow users to display or hide pages within the content. Currently, this functionality is available in the Classic UX, and its absence in the New UX limits the flexibility and customization of user experiences. Rationale: The ability to…
-
Import status
When the end user imports a file on the UX, he gets this success message: But in fact on the view details part, we can see failures : Does anyone knows why the message the end user gets ain't "completed with failures" instead of completed successfully ?
-
Multiple Sheet Add in Connection
Hi everyone, I have 2 questions about excel add in Refresh Multiple Connections function: Does the refresh multiple connections functionality refresh only the dimension selected on the selector (for example July 23) of the module/excel sheet or all the data present in the module? 2. In case of many sheets connected to…