-
CloudWorks Integrations & Processes General Columns
I don't want to waste the space to create an extensively long name to identify what Model my Integration corresponds to, especially when we add many new integrations. Can you please add the Workspace and Model to the columns available when looking at Integrations so I don't need to click into every single one to check…
-
Domain and IP range updates
Anaplan provides documentation that lists the domains and IP ranges you can use to connect to our platform in an allowlist. The most recent version of our allowlist can be found here. To receive a notification when we update that page, please follow these steps: Sign in to your Community account. Select the "ribbon" icon…
-
Introducing Improved Anaplan DX: a browser extension for Anaplan Modelers
We at valantic are excited to share our latest development: Improved Anaplan DX, a browser extension designed to enhance your modeling experience and increase efficiency. Please see below for more details. The extension is now available in the Chrome Web Store (can be installed on Chrome and Edge): For any feedback,…
-
Certified Master Anaplanner Exam
Certifications offer a way to prove your skills. When you want to be recognized for achieving the highest level of skill, that of a Certified Master Anaplanner, you want to be sure the testing process is secure and that all applicants are treated fairly. To achieve that end, we have partnered with Kryterion Global Testing…
-
Calculate the difference between two dates (days/months)
Calculating the difference between two dates is a common requirement and one that you will likely need to do at some point. Below you will find the best practice for calculating the difference between two days, and the best practice for calculating the difference between two months. While there are multiple ways to get to…
-
Management report should support more dynamic layouts (e.g. filtering on columns to display)
Below is an issue which is stopping me from using Management Report (UX Page type = Report). The issue is that once a card is published to the page: * Dynamic columns are not respected if based on a filter there should be more columns than initially published, it won’t show * Dynamic columns are not respected if based on a…
-
[SUM: 'SYS06 Product Details'.Size]
What does this formula do'REV03 Margin Calculation'.Revenue[SUM: 'SYS06 Product Details'.Size]? I am trying to understand this specific part: [SUM: 'SYS06 Product Details'.Size], can in some way I can compare it with Sum & GroupBy in SQL?
-
How can I filter a time dimensioned module using data from a sys module
Hi, We have 2 modules - a) SYS Module Dimensions - 1) List A (have numbers 1,2,3,4…,so on) 2) Line Items (various line items like region, status, name, etc.) b) Time dimensioned module Dimensions - 1) List A 2) Months 3) Line Items (All numbered formatted ) We have both the modules published on the same NUX. We want to…
-
Issues for L2 Model Building (Activity: Import Data into FP&A Model)
May I knowwhat might hve cause the issue? I downloaded the G3 location list as instructed in the L1 Model.
-
Excel equivalent for TEXTBEFORE
Need to pull text out of a string. Starting from the beginning but going varying # of characters. Last character will always be immediately before an underscore. So in Excel I could use the TEXTBEFORE function. No exact counterpart in Anaplan but wondering if someone has already solved this with a workaround?
-
A conversation with Clarissa Hassfurder — Journey | Anaplan Community Podcast
Join Dennis Lemoine, Sr. Program Manager of Community Events, for our sixth episode of Journey, an Anaplan Community podcast. This month we bring you Clarissa Hassfurder (@clarissa), Certified Master Anaplanner, Certified Solution Architect, and CEO at Double10 Consulting. Clarissa has over a decade of software…
-
Date format
I want to change the format of the column header to be the actual date in format MM/DD/YYYY. A user in another country set everything up in format DD/MM/YY and I want to change it.
-
Column settings update
Currently, column setting is only allowing to select 1/2/3 lines for label height. It would be great to have the flexibility in setting the pixels rather than selecting 1/2/3 lines (which can also be adjusted by dragging the column height similar to row width).
-
Remove space/indentation from list items when parent levels are hidden on UX worksheet
When parent levels are hidden on worksheet, there are a lot of white space for list items which is a big waste and also not good visualization. See screenshot below. It'd be great if the space will be shortened or removed when one or more parent levels are hidden/deselected.
-
New UX: Context Aware - Board and Worksheets PDF Exports
Currently Management Reporting has the ability to export in bulk for static context selectors. It would be a huge improvement for both Management Reporting and Boards if we have the ability to export PDFs that are context aware. For example, if I have a a set of cards on a UX page and I have items in that list (1-5), then…
-
How create an Assortment List with more than 6 Dimensions?
I am trying to Create an Product Assortment List based on 6 different dimensions, but I just want to create the elements for which I have information (an Input from the user). The problem I am facing is that, when I add into consideration Line Items to use as filter for the elements and to create the concatenated code for…
-
Date not pulling through
Hi I've got one module with data - timescale by quarter and 2 lines: Early repayment period - quarter format Early repayment date - date format Then I've got another module, no timescale, with 2 lines: Early repayment period - quarter format - formula to link to the module above: C_Early Repayment Period.Early Repayment…
-
Quickly add/remove/change models for pages that are linked to more than one model
Currently in the UX manage models area, you can quickly change the model connected with a page if that page is only linked to one model (green X). If that page is connected to multiple models you can't (red X). Propose increasing functionality to allow quick add/remove/change options in the UX manage models area. We…
-
Stop the mistake research processing
As a Model Builder, I would like to be able to stop the mistake research by using an action button. This processing can be very long when we are building an heavy model (5-10 minutes) and most of the time we already know where is the mistake (format, etc.). That's why we can save a lot of time if we could click to stop the…
-
Sum based on the Two time scale
-
Error when changing list dimension to subset
HI, I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message; "To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target…
-
NUX Forms: Exception handling when duplicate code entered
When using forms to add to a list (where the code can be entered), users can accidently re-enter an existing code which triggers a model roll back, as it's considered a duplicate. There's also no notification the model is rolling back so it looks like the app is spinning its wheels. This leads to confusion and potentially…
-
Create Demand Export Module and Create a Saved View - Level 2 conclusion
I am having an issue of this - Though the formula is being put. I have no idea why it returns as empty values for all the cells. Thank you.
-
How to remove the HY & Annual summary?
Do you just hide those summary columns or there are some more systematic way to do so?
-
Filtering with nested dimension
Hi Anaplan community, I need help setting up a filtered view to only display list items with value in any of the time periods in the selected Fiscal Year. And by any, I mean Q1 or Q2 or Q3 or Q4 or FY. Because for a line iten such as Headcount - there could be a value in Q1, but the corresponding FY has a zero value…
-
What is a subsidiary view?
I have read the video a few times but still don't have a good idea on that? Anyone can share the main geez of it with me? Thanks
-
Import values from previous period into current period
Hi, I am trying to build an import which should take the values from a month to the next one, in order to create a baseline the user would then modify as he pleases. Once he's done so, he should then import the new values into the next months. The import seems to work, however, it deletes the value from the previous month.…
-
Can't submit another request
A user that has workspace admin access submitted a few requests and then Anaplan no longer allowed them to submit another request. This user still has full access as a workspace admin and no DCA has been activated for them. Any suggestions?
-
Is it possible to check capacity for each Module?
So I want to change my module. But I want to know how much capacity before and after implement new changes. Current now I only knew that we only can see the capacity for a whole model. Please someone, could you tell me about this information? Thank you!! 😄 BR, Dian Suci
-
Stock Re-balancing between Stores
Hi Anaplan Experts, I'm trying to calculate the re-balancing of stocks from one store to another based on the logic below. Step 1: Rank Supplying Stores based on their available stock to give (OUT) Step 2: Rank Requesting Stores based on their needed stock to take (IN) Step 3: Re-allocate available stocks from Supplying…