Recent Discussions

Hi, anaplan expert, our end users want to populate the report like my screen shot in below, there 2 hierarchy here, for example, P2 (Chocolates) and P3 (all items above Chocolates), now they want present P2 in gray color instead of white, so they can recognize different hierarchy in this report, is it possible to make it…

I have a Combined String list and a Combined String Properties module. I also have a Mapped Flat List and a Mapping module. I want to bring the mapping from the Mapping module to the Combined String Properties. How do I do that? I know I should use a lookup, but I need help with the setup?

Good day all, I've recently started the level 1 training and have a general question on the time it takes to complete a module. Each module list a an estimated completion time, however it does not appear to be accurate. Example, I'm currently on module 6 with an estimated completion time of 30 mins, however I've already…

As a Model Builder, I would like to have "syntax highlighting" when I create my formulas in order to improve readability.

I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…

According to the Polaris website, it states that the higher the sparsity of the data, the better the memory efficiency. What exactly does this “memory efficiency” refer to? Does it simply refer to the model size?

As Anaplan continues to evolve with advanced capabilities especially with recent AI driven innovations like CoModeler, Agent Studio and planning agents there is a strong opportunity to further enhance the learner ecosystem alongside the platform's innovations. One idea would be to introduce sandbox environment, along with…

Author: Paola Malafaia is a Certified Master Anaplanner and Associate Consultant at Cornerstone Performance Management. After setting up Territory Maps, I had a few learnings and I thought it would be helpful for other developers to put some notes about the basic settings of this mapping feature for dummies. The goal here…

While configuring Notification button, from UX Page, either we can pre-select all the person need to be notified, or notified based on line item/role configuration. Idea: It would be good if we can let Users choose people who need to be notified, from UI. Like a checkbox based on User list. The user will then check the…

Hi Community, I'm looking for the standard best practice for formatting column headers in a module export. When I export a list and use one of its properties as a column label (e.g., the property Code), the exported header defaults to the "List Name.Code" format. To create a cleaner and more integration-friendly file, I…

Hi everyone, I’m facing an issue in Anaplan when combining Actual, Forecast, and Budget data into a single line item using IF logic to get P&l I want one calculated line item (revenue) that returns: Actual values in Actual periods Forecast values in Forecast periods Budget values in Budget periods the actual data in single…

In the FCR Journal module, the Search menu always pops up when you first enter the module. This makes no sense when it is likely that the user will want to create a new journal more often than not. Remove the pop up and make create new journal the first option / page and allow the user to select search as an option

User Feedback: We use the copy data form to delete those unnecessary data in the model. However, we observed that when “Same as source” is selected, the target slicer values do not become blank; instead, they remain displayed in the form. Although the calculation correctly ignores the target slicer values, this behavior…

Mini Resume Name: Thiago Liberman Trajano Location: São Paulo, SP, Brazil Certification: Anaplan Certified Model Builder (Level 1 & Level 2) SCRUM Master Oracle Cloud - Data Science Educational Background: Degree in Economics from PUC-SP Master Degree in Economic Development UNIFESP Professional Master Degree in Data…

Hi, I have started Building a Cash Flow Model for my Excel Spread Sheet and I need advice on how to decide the structure of my Model. So far I have made Module's made after the Yellow Tabs in my Excel Model and made the Line Items of my Modules the First Columns in my Excel Sheets (The things that I need to calculate and…

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: Anaplan currently does not provide a native connector for Microsoft Power Automate.In our enterprise environment, this is a critical…

Hi All, I am currently working on a requirement to cumulate the value of a line item. For this line item I have opted for the Summary method - "Formula" but I dont want the overall total sum for this column; I tried to change the "Time summary" for this line item , but it is throwing me error - Invalid combination of…

BACKGROUND For my outgoing data integration, I've configured export actions to not include the default list columns so that the csv doesn't contain columns which may be incompatible with BigQuery e.g. `G1 Market# - Display Name`. Instead in the export module, i've replaced these with a dedicated column which has a custom…

Author: Miki Sato is a Product Manager, Product Management Team (Data Management) at Anaplan. Earlier this week, our CPTO Adam Thier announced a set of AI-driven innovations designed to advance enterprise decision-making. Three products — Custom Analyst, Agent Studio, and CoModeler — are now generally available, and…

I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…

Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case A client requests a flat list for time that will change year over year and does not want to manually update the list, and does not want to use native time. Instead of creating a production list to update…

Why I don't have access to the Workflow tab ?

If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?

Hello, I need a way to route authentication credentials through LDAPS instead of LDAP. Customers have made changes in their security departments and now require all communication to go through LDAPS. Initially, we tried blocking the LDAP port, but unfortunately that caused ANAPLAN XL to fail. However, this is such a…

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: NPV function in Anaplan gives the final NPV value unlike Excel's XNPV which can be extended to calculate in each period. We had to…

If you missed the first two articles in this series, read Part 1 here and Part 2 here. This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new users to models. If you have enabled…

Could not enable filters on UX page. Created Planning period Filter and apply filter on column is disabled. Any help on this

It would be great if workflow templates can be grouped by admin, so I can filter on workflows that are related to the overall high-level process.

For access reviews, it would very helpful to have the ability to export a view like below for all roles. The below screenshot shows page access for one particular role. For models with many pages and roles, there is currently no easy way to show access summaries to business owners.

I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…