-
Can't add new CloudWorks Connection
I'm working with a new client, and I can see CloudWorks, but whenever I click the drop-down menu to connect to a service, it appears empty. I assumed it wasn't a permissions thing because I can access the UI. Anyone seen this before/
-
ISFIRSTOCCURRENCE not providing the correct result
Hi Anaplanners, I was trying to setup a simple isfirstoccurrence formula and I couldn't get to the correct result: In screenshot below, I have the module dimensioned by #P3b_Child Territory, which has a parent. I want to use the isfirstoccurrence formula to only show true for the first appearance of "Americas" in the LI…
-
Level 1 8.5.3 Volume Inputs
I thought I did everything correctly, received successful confirmation that it uploaded. However, data does not match source data. What am I doing wrong?
-
I have a source module that has FY time period (eg- FY25 to FY29) and target module have
I have a source module that has FY time period (eg- FY25 to FY29) and target module have dimension with product and country as other dimension. I am not able to connect as getting Time format error. I have selected Period- YY in the mapping. Please help.
-
10.2.5 Activity: Add Employee Expenses Module
I completed all the activities for adding all the formulas to the line items. However, after checking the data looks alright I am just not able to see the Employee Full name in the Page instead I am just able to see the number. Can someone please help me and tell me what I am missing here?
-
Unable to Populate Data for Parent Levels in the Workforce Hierarchy List.
Hello, I'm trying to utilize the new hierarchy card in the UX for workforce planning model but struggling with pulling any attributes/amounts in the personnel org hierarchy list (7 levels) created specifically for this new UX card. The source data is in a module dimensioned by the regular hierarchy list of employees >…
-
Is it safe to roll back model for calendar update?
Hi all, Did anyone do a roll back for model calendar change and encountered any loose of data /issues when syncing later revision normally to PROD? Time is structured in the model : weekly(4-4-5 , 4-5-4, 5-4-4), 1 past year, 2 future years and 2 time ranges( current +2 and +3 years) . Of course previous year will be lost ,…
-
alternative hierarchy
Hi Anaplan community, I get a request from the business to add another view to the aggregation of the organizational hierarchy in an existing model. Currently we have a couple of sites, rolling up into platforms, rolling up into "Global Manufacturing" or "Global Overhead". This is currently setup using hierarchical lists…
-
Formula to Calculate the Representative Week (number) for each Date
I need to calculate which date each week represents, I have a Weeks Attribute Module. I have tried some formulas but they did not work. I would really appreciate if someone could give me some advice or a direction.😊
-
Import Final Demand Forecast into DAT02 Module
Good Morning, While doing this activity in the Conclusion course, I got stuck Indeed, they are asking us to Import the Demand data into the DATA02 SKU Volumes module. But in the Level 1 model, there is not a module called data2. So do we have to create this module? If yes which line item, what to put as page selector, rows…
-
3.5.4.2 Create Distribution Center Capacity Module
Hi everyone, My values don't seem to be very realistic, would just like to ask for guidance if I'm doing something wrong. Or if someone could check the values.
-
What is the best way to secure employee salary data to a central admin?
Hello - We are designing our first FP&A model and currently employee data is within that model. We would like only one person in the organization to be able to have access to all company salary data to keep detail by person secure to all other users. The issue we are running into is if you have a model builder role, you…
-
Suppress Zeros on Graphs
Hi All - Is there a way to suppress zero values from displaying on a NUX line graph? Thanks!
-
Response from adding item to a list. Success but not added or ignored
I'm calling the API to insert an item into the list. { "items": [ { "code": "test", "properties": { "Display Name": "test", "Time/Date Stamp": "2023-10-27 13:19:19", "Amount": "Data Unavailable" } } ]} I'm getting a response back that show it has not been added or ignored. { "added": 0, "ignored": 0, "total": 1, "meta": {…
-
How to create a view and dashboard with data like this.
I have been given a sheet like this I have uploaded it into a single ( Master Flat) list using properties for each of the columns I then went ahead and put the data into a module and then created lists for columns ( region ,state, department ) that have duplicates using a view with the first occurrence formula to help the…
-
Anaplan Optimizer - Balanced Allocation
Hello everyone, Really hoping one of you bright-minded individuals can help me progress on a persistent issue. I am essentially doing a replica of the "T1.3 Allocation with Product & Line Compatibility" from the Optimizer Toolbox: But! My objective is not to minimize cost. Instead I have a guideline allocation of the…
-
OEG Best Practice: Governance for the Office add-Ins
General information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If you would like to contribute or comment, please contribute to…
-
Help Needed with COUNTIF Equivalent Formula in Anaplan
Hi Anaplanners, I have a doubt about Anaplan. I know it's a silly question, but I'm not able to solve it in Anaplan. If anyone has an idea, please explain it to me. I have attached a screenshot to this post for reference. Problem:In Excel, please refer to the N column, which is already highlighted. They are using the…
-
Applying "transparent" conditional formatting in the UX
When we apply conditional formatting to a grid in the UX, there is no option to set a transparent color. However, with some creative use of specific color codes, we can simulate the transparent effect. I will focus on two specific cases below: editable cells and read-only cells. Both of these cases follow the same approach…
-
NUX - Allow users to review/remove applied sorting
Problem Statement Similar to another item I raised here, NUX has no way for end-users to remove an existing sort already pre-defined in a card; worse still if the sort is based off a line not published (e.g. a dedicated sort line item), you'll never know it's been applied. An interesting behaviour is that you can attempt…
-
NUX - Allow users to filter using other modules AND see/remove applied filters
Problem Statement Problem #1 Unlike classic, NUX has no way for end-users to apply filters using a separate module with common dimensions (e.g. a central time filter or list attribute module). The filters must be available locally within the module which severely limits the reusability of centralised modules. Example of…
-
NUX Show/Hide for line items as selectors under the grid
Hello, the request concerns Line Items as Page Selectors in NUX. It is great that we can use show/hide functionality when Line Item is displayed as Context Selector on top of the page. If I have 5 line items, but 3 of them are technical and I want to let users toggle only between two, I can do that. This also limits my…
-
Edit Multiple 'Source Model' Settings for Pages Simultaneously
The ability to edit the source model of multiple pages at once would be a huge quality of life update for page builders. Currently, model builders have to edit settings for each page one-by-one. This idea proposes that page builders can apply the same change to multiple pages at once: image below shows how this could work.
-
Automate model copy
Is there a way to schedule or automate the process of copying a model?
-
Anaplan users and inherited user rights for models in the same workspace (workspace admin)
Hi I think Anaplan should change the inherited access rights to models in workspaces. When creating users, it is easy to give a user access level when creating a user BUT the problem is this becomes inherited in other models in the same workspace. There is a workaround - give no access when setting up the user then specify…
-
Level 2 - Conclusion: Export data from INV01
I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to the example .csv and the screenshot from the course. I am wondering if there is something obvious I am missing, or if I need…
-
A conversation with Philipp Erkinger — Journey | Anaplan Community Podcast
Welcome to episode 14 of Journey, an Anaplan Community podcast. Tune in today to hear Dennis Lemoine, Director of Customer Engagement & Experience, chat with Philipp Erkinger (@PhilippErkinger) — Certified Master Anaplanner, Anaplan Community Boss, and Principal Solution Architect at Bedford Consulting. Philipp loves to…
-
L1 Model Building - 14: Additional Topics progress not updated
Course 14 redirected me to Lesson 1: What is Workflow? Who benefits from using Workflow? Why do you need Workflow?. I have finished this lesson and went back to course 14 and finished it. However, in my record of learning, it still says i am 0% progress. I wonder what is should do. Besides, before taking exam, do we need…
-
Line Item Subset Formatting
This post is a bit of getting ideas to work around but also see if people are experiencing similar issues. I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from. In the situation where you had a KPI which was a %, a number and a…
-
ALM related question
I made some changes to our development model today and when we came to promote via ALM, the comparison report shows some item that we had not anticipated or expected. The comparison report has a section headed “Data Source Changes”. I made one change to the actions to add a new import action changed it’s sequence to the…