-
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
-
Can't add a parent to a existing list
Hi all, I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine: If I try to compile the parent hierarchy column, I get this error: If I try to delete All Business Unit from the Top…
-
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
-
Building a pyramid visual using a bar chart
Author: Subham Garg is a Senior Data & Insights Architect at Anaplan. Anaplan doesn’t have a pyramid chart option for reporting. However, there are certain metrics that work better with a pyramid chart than any other chart format. For instance, sales pipeline or number of employees at different ranks in a company are best…
-
2.4.4 circular reference error
Hello Everyone can I know why there is a circular reference error when I try to enter this formula ?
-
Cant able to open Sprint 1 course in Level 2
Hello Everyone I have finished Level 1 and got the certification and continued to Level 2 introduction class, and I have finished it . but when I opened the sprint 1 class, the cursor was not changing to the input method ( hand symbol ) to click and start the course. the course open button remains like the text Can I know…
-
Used in Pages (Apps) column
On the Actions and Modules tab, similar to the 'Used in Dashboard' column it would be useful to have a 'Used in Pages' column which shows where action or module in used.
-
Edit default column width in maximized view
The ability to edit and set the default column width in maximized view would improve the user experience immensely. Now users need to adjust column width every time they open a maximized view which is very inconvenient.
-
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
-
Editable nature of cells within grid is inconsistent over time, not due to version
Hi Anaplan Community! I am working within an Operating Expense financial model, I have a module to allow for manual adjustments by department. This module contains a line item "Amount" with no formula, to facilitate the manual input of adjustment amounts by spend category. The Model's Time frame is 2022 - 2028, and I am…
-
Drag and Drop functionnality (Line Items - Modules)
Hello It's will be helpful to have the drag and drop functionnality directly on each line item in order to rearrange easily on purpose Regards Patrick
-
Data loss issue
I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloudworks, it did not work (I'm assuming because once of the action in the process has filter based on User Write Access). So we…
-
Drag and Drop Actions (Process - Imports - Exports - Others)
Hello It's will be helpful to have drag and drop functionnality in the Actions page in order to rearrange them inside their respective bloc (Process, Import, Export or Other Actions) so it will be easier to group them if need include actions into a process using the drag an drop dunctionality Regards, Patrick
-
Issue in LIS where one line item is shown as a parent of another.
Hi, I have created a LIS from two different modules with a total of 3 line items. The two line items I selected from the first module however are having a parent child relationship when I use the LIS as a dimension in another Module. This should not be the case as all the line items are independent. The First Image is the…
-
Preview Window before creating Revision Tag (Preview of the result in the target environment)
It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in the new UX in page builder mode Thank you Patrick
-
Import action failed while running through Cloudworks
According to the given screenshot, error thrown by Cloudworks is - "Hierarchy import has both Name and Code unmapped". Although, manually the import action is running fine. Need some help. Thanks,
-
How to count the number of times a month shows up minus 1?
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would like the "end" line item to display 3. Similarly, if December appears 5 times, I want "end" to show as 4. I want to use the…
-
Assigning List item based on Text line items and looking up - COMPLEX
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar one, also with Loan-Hedge ID (List) and line items as the dimensions. When importing the first file, these Loan-Hedge IDs…
-
Calculation based on variable selection from a user
Hi team, Got a problem I am trying to work through and have hit a roadblock. I am working on a forecasting tool and having trouble with dynamic selection of variables for basing my calculations on. For the purposes of this I have a list of accounts which is 62 members long. I have a driver module it is dimensioned by time,…
-
Level 3 Model Building Sprint 1: TAR01 Detailed Sales Target module
I'm working on my L3 Model Building, It has been paused for quite sometimes due to my confusion in how to fill The TAR01 Detailed Sales Target module. I can't even create a module to verify the The TAR01 Detailed Sales Target data. Here is the TAR01 Detailed Sales Target module that have been filled Here are the formulas I…
-
Hi Everyone, I am reaching out to the community for some help with a formula.
I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
-
Automatic Model Copy&Archive Functionality
Hi everyone, is it possible to automate the functionality of "Copy & Archive" of a Model? And eventually schedule this automation? Thank you in advance! Joana
-
LiS for Export module
Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Type is a subset List put in pages. So I won't be able, in my LiS to have the Forecast by each FTE Type(the selection is not…
-
Model change best practices (Sept 2023 Community Challenge recap)
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. There were so many detailed answers to the September Community Challenge — it was a challenge just to sort through all the great information! To help the Community, I thought it would be helpful to…
-
Keeping Current on Your Certification Requirements
Being a Certified Model Builder, Certified Solution Architect, or Certified Master Anaplanner means that you’re highly qualified. Staying current with the latest product releases and best practices will maintain your certification and enhance your expertise. Please review this new information about the…
-
Filter multiple dimensions as rows
Hi team, Im working on a rolling forecast module and have the following dimensions Versions (page), Time (columns) and Cost Centre, Gl and line items as rows. one of the line items is an input called temporary variance and a requirements is that across all time that the temporary variance sums to 0. My problem is, I cannot…
-
How to convert an annual amount to a monthly amount
I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by…
-
Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan.…
-
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
-
Excel Add-In - Option to Switch to design view
Please could you create a new button/feature in the Excel Add in to allow switching to design view. Excel is a great tool for presenting and autosizing column widths and for working on Module layouts and for sorting and filtering relevant columns and rows during a module build. When I do a rebuild a module. I often need to…