-
Model Schema
Model design should always come before model building. A model schema is used to diagram the relationships that will be built between the dimensions (time, versions and lists), the modules, and the dashboards in an Anaplan model in order to meet end user needs. Organizations may also have schemas detailing the…
-
Level 1 9.2.5 Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]…
-
Event recording available! Modeling tips and tricks
Last month we hosted a challenge inviting Community members to share their thoughts on modeling best practices — over 30 tips were shared! Yesterday, we held an event highlighting that guidance every model builder should know. Jason Blinn (@jasonblinn), Principal Solution Architect and Employee Community Boss at Anaplan,…
-
Level3. Territory>Account module
Hello, I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some…
-
Anaplan does not sum the filtered list items but it sums all list items
Is there a way to sum only the list items that I filtered? Now All directions is always the sum of all the list items and not only the list items that I filtered
-
Level 3 Check You Build 4.7 User Story 1.3
Hello , I have already begun with anaplan level 3. im stuck for a week with the next problem. The exercise need to be checked on the next numbers: I have the next numbers: I have the next formula: 'DAT021 PY Revenue FY19'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product…
-
Option to add page numbers to Management Report PDF files
In a Nordics User Group - Anaplan Roadmap session, a participant raised the request that Anaplan Product enable the option to have page numbers added to the pages on a Management Reporting report when printed out to PDF.
-
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…
-
Loading .csv File issue Numbers dots, commas
Hello, I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please? thanks
-
Multiple Models | One Page
We have multiple models, Model A is where user inputs the data, Model B is where the submitted data would eventually sit. Model B receives data from Model A via an action. So once input is done as a user can i press a button (from model B) to technically import data from Model A to Model B. Can we have the action in one…
-
Embracing the journey: reflecting on 2023, anticipating 2024
I was recently reading a LinkedIn News article, 34 Big Ideas that will change our world in 2024, and one quote from it made me laugh — “Humans just aren’t very good at predicting” by Freakonomics Radio host Stephen Dubner. While this normally may be true, my first thought was, “I can — with 100% certainty — predict that…
-
L2 Model Building Conclusion: Failed Import into Shipping Expenses OTH01 Module
Hello Anaplan Community, I've been stuck for too long trying to import the shipping costs from my Saved View into OTH01. I've tried numerous saved views but can't seem to resolve the errors. I've deleted all Saved Views and started over because I think I am confusing myself. Below are screenshots of where I am currently…
-
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
-
Anaplan Level 2 Conclusion - Create Demand Export Module and Create a Saved View
Can someone help me why I am getting different demand number pulled up? Instruction: My Anaplan Blueprint Mode: My data Check your Work:
-
Level 3. QUO01 Territory Account
Hello, In the QUO01 module, I am using formula below to get target number, but I get 0.00; I even tries to add LOOKUP account names but still no luck. Also, for Assing>1 I am writing this formula, but it errors out: IF 'SYS07 Territory Account Details'.Count[sum:'SYS07 Territory Account Details'.Account> 1 THEN TRUE ELSE…
-
3.4.3 Activity: Create Country Summary Module formula is wrong ?
hello I have put the formula for Safety Stock Flag Count but in the exam it says wrong when i pasted it . i dont why couple of times it got rejected ? any advice will be helpful
-
Cloudworks Data Encryption
Referring to Anaplan CloudWorks guidelines (published in May 2023) :“Your cloud sources (such as AWS S3, Azure Blob, and Google BigQuery) must be accessible via public APIs. Make sure your data is not encrypted or compressed.”“CloudWorks supports these file types: csv, csv000, xls, txt, xml, and pdf.” Is there any plan or…
-
Model Building and Correct Role
I just started at a new company that uses Anaplan. My boss would like me to learn to build models and dashboards in Anaplan. I understand that I might need to have a workspace administrator role in order to build models. Is that correct? What would you advise is the best course of action for someone learning Anaplan who…
-
Filtering a subset
Anaplanners, Is there a way i can filter a subset ? So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item. However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the…
-
Level 2 Sprint 3 - 3.5.4 Percentage Full
It's funny how whenever I use None for Summary settings, I do not get anything populated. See below. But whenever I used "Average" in Time Summary, I do get some numbers. Why is that?
-
Link is no longer working 3.5.5 Activity
-
Superset Choice (from Time Ranges)
Could someone please explain what's the use of this particular time lookups function?
-
Route Rejection and Approval Notes back to Line item selected users
I may be overlooking something, but I can’t find a way to route comments collected by Workflow after approving or rejecting a Decision Task back to a specific user. This limitation complicates taking action on rejections. Since Workflow mandates a comment input, it would be beneficial to have the ability to send that…
-
PLEASE HELP !! IS THIS CORRECT ACTIVITY 3.4.4 !!
For this I created 3 saved views 2 from module INV-02 I pivoted them and synced them with page , 1) I made first view using Region(row) , Safety stock line item(page), Time(column) 2)I made second view using Product family (row) Now I made 3rd view using INV-01 module 3) I made it using SKU(row) after that I applied SYS00…
-
Anaplan level 2 sprint 1 exam passed but not count
-
'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price & 'REV02 Volume Inputs'.Volumes * 'REV
I am facing problems with both formula's. Please help me i have been stuck cant move forward if anyone could explain what the problem would be and give me solution to it.
-
Add Notes/Comments on Management Reports
Users(Stakeholders/CEO etc) must have access to add Notes/Comments on the Management Reports they view for better understanding, similar way we have in powerpoint
-
Organizing templates for data imports
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. I am sure many of us have seen the below message many times in our experience, and at times it may be very time consuming to retrieve the file which was used to create the import action. And there are also chances…
-
Alternatives to Rank in Polaris engine
Hi Community members, I am looking for some alternatives to assign sequential ordering in Polaris model as the default "Rank" function is unavailable there. Thank you!
-
Average of previous year and current year
Hello community, I need to calculate average of previous year end (e.g FY23) and current year end (e.g. FY24). Logic should be FY24 + FY23 / 2. How can I return these vales from a line item which has both FY23 and FY24 numbers. Any ideas much appreciated. Thanks Kal