-
Mapping Issues due to dates
can anyone tell me in this case how should i choose the time mapping?
-
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…
-
Error on Excel Add-In
Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
-
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…
-
Collapse / Expand Hierarchy Functionality in Modules and UX Grids
In current standard grid modules and UX Grids you can't Collapse & Expand hierarchies of Lists/Line Items/Sublist like you can do in Excel (see below). Considering that sometimes hierarchies can be huge or you want to Collapse one part but Expand another - it would be good to have such functionality
-
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…
-
List of subprocessors
Anaplan provides documentation that lists the affiliates and subservice organizations that are material to the provisioning or support of our hosted service. For the latest information regarding third-party subprocessor vendors, see the current list of subprocessors. To subscribe to this page and receive notifications when…
-
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…
-
How to Integrate with the API Using a Modified File Name
Hi, Is it possible to change the file name for each integration when using the Anaplan API? We are facing an issue where files get overwritten when multiple API requests are executed simultaneously. To prevent this, we are considering adding a timestamp or making the file name unique before sending it. If modifying the…
-
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…
-
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 -…