-
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
-
Network traversal algorithm using Anaplan
Has anyone implemented a network traversal algorithm in Anaplan? To explain the problem, refer to screenshot below. What I want is to generate a path that goes through all the nodes, e.g. Node 1 to Node 3 then to Node 4 then to Node 2 that returns the path with the lowest weighting. So Node 1 to Node 3 is 7 (as per…
-
Data Label Option in Charts
Would like to be able to change the method on how to put the percentage label on the pie/donut chart. When the portion is too small to fit the label, it's fine to have a call out style (current style). But when we only have 2 or 3 categories, we would like to have the label directly laid on the portion so that the chart…
-
users dimension for filtering
In my model user dimension is used across the model for filtering so that the users do not overlap their data. If my understanding is correct this is the standard practice. I searched community for best practices related to usage of users dimension i could not find anything. So my question is i have a model which is almost…
-
Best Practise of creating List
Which is the best practice for creating List in a Spoke model from Data Hub model ? Is it a List to List import OR Saved View to List import ?
-
Apply Dynamic Cell Access based on two modules
Hi, I need to add DCA to enable this functionality- I have a module (MODULE A) where budget is input by markets in a budget input line item. I have another module (MODULE B) where once the market has input the budget, they can check the boolean "Submit to HQ". Once the "Submit to HQ" boolean has been checked, the budget…
-
Model Building
Hello, I have one requirement where line items should be filtered based on the Year(FY24, FY25) Dimension. For eg: there are 12 line items, which contains both text and number formats. If User selects FY 24, The first 6 line items should be shown in the page and if user selects FY25, last 6 line items should be shown . Any…
-
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
-
Passing parameters to system modules
I have more than five modules where "reporting date" is a line item and I import values for them. In each of those modules I have another line item to calculate the reporting period based on the reporting dates. Here is the formula for that. IF DAY(reporting date) <= 15 THEN PERIOD(reporting date) ELSE PERIOD(reporting…
-
how i can login to anaplan workspace
-
Enable Highlighting / Selecting / Copying Row labels in UX Grids
Some customers have raised a request about being able to highlight/select/copy the contents of a grid row's label. For instance, in the screen shot below, the grid's row labels include Bookings, Pitch Rate, Revenue, Payroll, etc. If a user clicks one one of these row labels, it doesn't select that particular label, rather…
-
Dear friends, I am taking the L2 spint2 test. I want to know the correct answers to the wrong questi
-
Model Building and Correct Role
I just started at a new company that uses Anaplan. My boss would like me to learn to build models and dashboards in Anaplan. I understand that I might need to have a workspace administrator role in order to build models. Is that correct? What would you advise is the best course of action for someone learning Anaplan who…
-
Power BI connection to Anaplan -- multiple times credentials asked
In my project we have power BI linked with the Anaplan. Working in Power BI everytime there is some issue with the connection with the anaplan and it keeps asking for credentials. And also for password reset which is very frustrating. What can be done to have a secure connection?
-
Level 3 Sprint 2. Assign button greyed out on UX
My 'Assign Accounts' action button in the UX is greyed out. Thus, not allowing me to see the expected pop up window to be able to update or remove the parent. Have watched the microlesson but not able to determine why. Tried changing the context of the Action card to the highest level in the hiearchy as well as syncing to…
-
Change in model size on importing
I have a prod model which is of almost 120 GB size. For some test purpose i simply imported the model to another workspace but now when i check the size of the model it is 75GB. When i checked at module level yes the cell count differs for some but not sure why the change in size. Kindly suggest.
-
3.3.5.3 check your work
Need some help please, as per example, Safety stock target line item is blank In my module have got summary values here, any pointers please?
-
A case where general lists unique key were mapped to name or code now wants to map for code
A case where general lists unique key was mapped to name or code now company wants to map for code. There are 300 dimensions need to have this change. How the Downstream impacts for this change ? What are the cautious things need to keep in mind before making this change ? Please suggest .
-
Performance Comparison - YEARVALUE(x) vs x[LOOKUP: FY]
Hi all, Was hoping to get some insight into the performance implications of obtaining the year value of a line using either YEARVALUE(x) or x[LOOKUP: FY]. Both will retrieve the same result assuming summaries/timescales are setup correctly, but they are definitely not calculated the same (based on anecdotal tests). From…
-
Filtered Picklist / Dependent Dropdown using values
Hi all Is it possible to set up a dependent dropdown based on a value? The scenario is that we have a list of orders with an order quantity, with a line item for the user to select the destination. However, we have a capacity constraint in the destinations, so we want the line item to only display the destinations with the…
-
Workflow adhoc triggering
Hi, we have workflow enabled now and I was looking at it for Invoice approval process. Some days we have no invoices, and then other days we may get multiple invoices arriving. From what I can see Workflow needs a schedule to run (daily, weekly, monthly etc), does that mean we can't trigger a workflow when we want to start…
-
Model Schema
Model design should always come before model building. A model schema is used to diagram the relationships that will be built between the dimensions (time, versions and lists), the modules, and the dashboards in an Anaplan model in order to meet end user needs. Organizations may also have schemas detailing the…
-
January 2025 platform releases
Check out the latest Anaplan feature updates and enhancements in our January 2025 official release notes. The information below offers supplemental information to that post. Integrations & Extensibility Metering improvements in ADO The metering lozenge on the Overview page now includes consumption of storage and datasets,…
-
How I Built It: Time and Version filters
Author: Stacey Gibbens is a Certified Master Anaplanner and Solution Architect, Financial Planning & Analysis at Globe Life. Greetings, Anaplanners! Today I’m excited to share my ‘How I Built It’ tutorial on minimizing import/export toaster time by utilizing time and version filters on source data saved views. In my video,…
-
Can we create actions from one prod model to the other prod model?
In my organization, we have two prod models and one dev for both of them. Can we create an action in this case? The user asks to reflect the data from one UI page to another, but they are from two different models and a common dev. Is this doable?
-
Model Building - Avoiding Circular Reference
Working on a use case to reproduce following psuedo code in Anaplan Start Recommendation_given=0 for tranche 1 to 6 if tranche =1 then tranch_contribuiton = 0 else if tranch recommendation <= recommendation_given or tranch_recomendation = 0 then tranch_contribuiton = 0 else tranch_contribution = tranch recommendation -…
-
Bulk deletion of comments on Cards
Hi Community, We have got this requests from our stakeholders if there is option to clear out the comments they have entered over the cards month on month. But we wanted to check here, if there is a bulk delete option to clear these comments when we shift from one month to another.
-
Issue with ISFIRSTOCCURANCE funtion
Issue: One of our Integration task failed with an Error : Too many cells for ISFIRSTOCCURRENCE calculation: actual=50144479 maximum=50000000 Steps taken to avoid this was to chunk the files to less number of rows. The error still appears. What is the actual reason for the error? Or what need to be done get any error that…
-
Workflow - Notify people on rejection
Hello, If you have a decision task in workflow and you choose "Continue after rejection", you don't get a choice of messages. If you choose not to continue then you can't add a notification telling people the task has been rejected. How would you notify someone that the decision was rejected?
-
Why does it take Anaplan so long to reject a formula?
I make mistakes when entering Anaplan formulas. If rejected the message "Closing" comes up, and it then takes Anaplan between 1 and 5 minutes to finalise the rejection and come up with an error message. Why does it take so long?