-
Create a Boolean-formatted line item to select the first week of the timescale (Year)
Hi everybody! Can someone help me with this simple excercise from level 2 please. I need to create a boolean line item that flags the first week of the time range (Year). Thanks in advance!
-
Polaris - How is the memory used calculated?
Hi, I have a scenario where I was comparing 2 approaches & noticed something strange. Even when the populated cell count is the same the memory used by 2 line items is different (almost double?) There is a difference in the calculation complexity but I haven't seen any article mention that in the sizing for Polaris. Does…
-
Model Data Tags
Hello model builders, I am looking for some ways to make model building and maintenance more efficient. Potentially data tags can be a useful feature. Unfortunately it's not entirely clear to me how to use "Find Tagged Data…" functionality. What shall I put into "Search For" field? I can put anything there and as long as I…
-
Size of the Optimizer Toolbox model?
What is the approximate size of the Optimizer Toolbox model?
-
Change a summary calc
I am creating a balance sheeting planning in Anaplan with a list below. For "Net Assets" line, how do I make it "Assets" - "Liabilities" instead of sum of assets and liabilities
-
Ratio Summary method against two dimensions
Has anyone tried using Ratio Summary against two dimensions in Classic? I have managed to get it working on Polaris before but for some reason doesn't want to do it in Classic
-
Applying Formulas to Specific Rows in a Flat List While Keeping Line Items as Columns
This question may have been asked and answered before, but I’d appreciate your thoughts on the following scenario. If a Flat List is used as the rows in a module, is it possible to apply formulas to specific rows within that list? In the example below, Revenue and COGS are pulled from a DAT module by using a SYS module…
-
How do you decide when an Anaplan module has become too complex?
As an Anaplan model grows, modules can gradually accumulate more line items, formulas, and business logic. At some point, splitting a module into smaller ones might make it easier to maintain, but it can also introduce additional dependencies. I'm curious how other modelers decide when it's time to split a module rather…
-
Notification Step Not Sending When Workflow is Triggered by Non-Owner
Hi, I have the following issue with configuring a Workflow. I want to create a Notification Step in the Workflow where I assign users using the "Assign to users from a line item in a module" option. The step is configured correctly, but the problem occurs when I run the Workflow. When I run the workflow myself, where I'm…
-
Changing User to Role - No Access
Hi, As an admin, when a user leaves the business, i will inactivate them in the administration screen. If i go to the modules, and review the users screen, i can also change their role to no access. What are the applications of doing so? For example, if they've input data into a grid, will that data be lost, or if they've…
-
Anaplan P&L Design: Should I Use a Flat List for P&L Rows and Line Items for Reporting Columns?
Hi everyone, couple questions here: I’m building an Actual vs. Budget P&L reporting model in Anaplan and would appreciate advice on the best structural approach. I’ve attached a screenshot of the desired layout. The report needs P&L items as rows, and the following as columns (line items): Actual Budget Variance $ Actual %…
-
How can I calculate % of Revenue dynamically for each P&L line item in an Anaplan reporting module?
Hi everyone, I'm building an Actual vs. Budget P&L reporting module in Anaplan using a Line Item Subset (LIS) to display the P&L items. I would like to extend my report to include three additional columns under a "% of Revenue" section: Act % = Actual amount / Actual Revenue Bud % = Budget amount / Budget Revenue % Var =…
-
Alternative to LOOKUP for Parent-to-Child Mapping [As Lookups in Polaris are worst performing]
Hi Community, I have a module dimensioned by L3 (Category) and need to display the values in a module dimensioned by L4 (Items), where L4 rolls up to L3. Example: Category 1 = 10 Category 2 = 20 Category 1 ├─ Item 1 └─ Item 2 Category 2 ├─ Item 3 └─ Item 4 Expected result: Item 1 = 10 Item 2 = 10 Item 3 = 20 Item 4 = 20…
-
How should I structure a Line Item Subset (LIS) module to display Actual, Budget, and Variance
Hi everyone, I'm working on recreating a P&L reporting model in Anaplan and would appreciate some guidance on the best way to structure the underlying modules. In my current setup, I have a Line Item Subset (LIS) containing P&L line items, which I am using in a reporting module to display Actual, Budget, and Variance side…
-
How Can I Recreate Anaplan’s “Reporting Tips & Tricks” Showcase Model for Learning Purposes?
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
-
What takes the most time when optimizing an existing Anaplan model?
When you inherit or start optimizing a large Anaplan model, what usually takes the most time? A. Understanding the existing model structure and dependencies B. Finding and optimizing slow or complex formulas C. Cleaning up unnecessary modules, line items, or lists D. Documentation and understanding why certain design…
-
Ran into two issues this morning with selective access, and no items available for selecting
Hello, One of my models is generating this issue: "PLANNED Position # has selective access enabled and you may not have been granted access to any items." When I try to adjust the selective access, it then says "no items to select". I'm unsure what caused this issue and how to correct it. Any help sincerely appreciated.…
-
Level 2| Sprint 1| 1.4.3.2 Import Data & Add Formula; Error: Item Not Located in P2 Products Family
The blueprint view screen shot for SYS12 SKU Details is shown below: The P2 Product Flat screenshot is: The P3 SKU Flat screen Shot is: The error detail message is: And the SYS12 SKU Details screenshot is: Any suggestion/advise what I am doing wrong. Thank you.
-
Anaplan Estate - turning model exports into practical improvements
Greetings, fellow Anaplanners. I’ve always wanted something that could take thousands of line items and help me work out where to start improving a model. So I built it. It’s called Anaplan Estate. Give it your Line Items and Actions exports, and it brings optimisation findings into an action plan, with evidence and…
-
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…