Modeling

Restricted Currency Conversion
Hi All, I have been working on a scenario where for users of a particular country, I want to show the output in Euro and USD but for other countries it should be only Euro. Is there a way I can control this through logics or I have to create separate pages for users of both countries? Thanks in advance! Best, Shekhar
Sorting in module view/list view
Be able to sort / filter by items in module view/list view etc. Eg sort by cell count, filter only modules dimensioned by time etc.
Time Function in Anaplan
Hi Team, Need your help with the below requirement, We are using 5 line items with a date Format. Line ItemsEmployeeABCDEMahesh12-02-202101-01-202110-01-202112-12-202010-01-2021 Based on the available Dates, we want to find the earliest date through the formula. how we can achieve this Anaplan? In the above example, the…
Missing Data in Production Model
Hello, These line items are working properly on DEV Model. I can choose a value on drop down menu of the line item "DATE CREATION (MANDATORY)", and the data will populate in the other line items. However, in the Production Model there is no data. I can choose a value on "DATE CREATION (MANDATORY)", but the data will not…
Filter Issue
Hi, I have a module with 2 lists (currency and tasks) as dimensions and a boolean line item. Im trying to apply filter on the boolean line item, if TRUE then only the respective currencies satisfying the boolean condition from currency list should be displayed. Im trying to apply filter but its not working as Task and…
Toggling between Regular and Blueprint views
This is a really simple suggestion that should (hopefully) be very simple to implement. Problem: When switching/ toggling between Regular and Blueprint views the scroll bar defaults to the top of the module. In modules with large numbers of line items, this means you have to scroll down every time you switch between the…
User Filter Filtering
Hi Guys I have been trying to solve this issue and having no luck. Reaching out if anyone had a similar issue and was able to solve it with clever tricks Module 1:- dimensioned by the user ( native user list) A user enters no of lines as a numeric value Module 2 :- Dimenshioned by List 1 and List 2. Please note that this…
New UX Selectors on worksheets
Community! I'd like to follow up with @xin question regarding selectors in the new UX. And the answer @Puneeth H P gave in this response,which appears to only work for pages. My worksheet uses one list, P6 SKU which is part of a structured Hierarchy (P1 to P6). I would like to use a selector on the top of the page that…
Help with SUM
Hi Guys, I have a target module containing a dimension which I need to map into a line item. Taking the system module containing the source dimension I have created a line item subset containing the line item in the target and mapped the target line item to the source dimension. In addition to this I have a line item…
How to take the count of a text value that repeats
I have got a text field (column) say X, it has got values x1 x2 x2 x3 wanted to creat a new line item to take the count with same value, for eg: x2 count will be 2 since it has got two entries.
Model Not reloading/opening back to its original state even after cancelling the task
Hi, I am facing an issue in terms of opening a data hub model to its original state for past 6-7 hrs but it is not opening stating “The system is currently processing changes by user XYZ”. I tried cancelling the task, closing the model from “Manage model” section but nothing worked to my respite. I only see “closing” being…
Timeline Chart with Dynamic Start/End Date
It would be nice if Timeline Charts allowed for the start and end date settings to be dynamic (or assigned to a line item). Currently, you have to choose a start and end date when you create a timeline chart, which effectively limits the chart to your initial publication. For example, if you are using a timeline chart to…
Order List Action
Hi We can use "order list Action" to sort the list but the sorting is possible if line items are formatted by Number and Text. Is there any way that we can sort the list by the line item which is formatted by date by using "Order list Action". Kindly resolve this question soon. Thanks Shirisha.
Copy Branch Workaround for the User Experience
The ‘Copy Branch’ action hasn’t currently made its way onto the UX, so I was recently challenged to create a workaround. This is my relatively simple solution, which could be amended for “Assign” by deleting the items in the ‘copy from’ list once copied. It should be noted that it is not a best practice for users to run…
Calculation on opening Balance
Hi Anaplanner's, Need a help on a calculation: Have a module where Time is not a dimension, we have system created list to be used as year, and there is a line item where we need to get the ending balance as the opening balance in another line, which formula can help us attain that? In the below screenshot, we need to get…
Circular Reference
I am creating a model. But when I input something on the line items, then there are errors "circular reference" popping up". Would you help?
You can't access a card
I am getting this message "You can't access the card" contact your workspace administrator. It has been happening to me for the last two days. Any solution for it would be highly appreciated. Thanks
How to remove a filter from a module
Hi Everyone, I made a saved view for the module REV03 Margin calculations which is "Forecast Periods". I was able to make it and put all the required filters inside. But I am not sure why there is a filter sign on REV03 Margin Calculations itself. I am not even able to delete the filter or edit it. If I make any change to…
Level 1 - New UX and lesson differences
Hi, I am starting my level 1 training course and I just started to notice that all the lists, products, etc have all been prefilled despite the exercises telling me to generate them. I am currently using the Level 1 Model Builder 2.0 New UX. Are the current lessons on the anaplan learning tailored for the classic versions?
Unable to open model-how to perform workaround | anaplan/loaderutils#loadReduxApp: App not deployed
I am using the 90-day trial version of Anaplan and was really enjoying building models, until today the following issue popped up: Sorry, failed to load application: Error: anaplan/loaderutils#loadReduxApp: App not deployed This issue is not letting me access any of the models! I understand that it is a known issue and…
Acceptable uses of SELECT
Hi All, It is generally accepted that we should not use SELECT if LOOKUP can achieve the same outcome. Therefore, when is it acceptable to use SELECT? I have been working on generating a variance report where we can retain the original line item formats. Therefore, I can not use a simple LISS to generate the report where…
Looking for Best Practice in combining text parameters and monthly amounts
Hello! There's a situation where I've seen in many models and already there in the two companies I've worked with Anaplan. I've also seen several solutions, none of them being great. I'm looking to the community to see if anyone has a better idea or if there's already a Best Practice available for this. I tried looking for…
Actual Years Boolean in Time Filter Module
I'm sure I'm just overlooking something simple, but I'm hoping to get a quick answer out of the community. I have a global Time Settings module with the current period in it (Current Month line item and Current Year line item). In a Time Filters module, I have a boolean for Actual Months (all months preceding Current…
Data import
Hi, I was trying to import the volume file to REV02 Volume Input (Level 1 lesson 8.5.3), but I received an error message about the column header in the file do not match the import definition as below: I had selected (see below) or attached image I believed the column header was wrong. Will appreciate someone could assist…
Connecting Models - Data Not Flowing in Correctly
Hi AP Community, I have 2 models, one was a prior forecast and the other is the current. I have identical modules and I'm trying to import the data from the prior forecast model into the current forecast model so I can do variance analysis. I am able to import the prior forecast model data successfully, however when I see…
Designating Sales Reps to Accounts Process
How the scenario for New Territories and New Sales representatives are handled? when there is no previous year data , when the New territories is planned not starting from First month. What if new sales representatives are planned?
Fetching data from one module to other module
Hi Team I have one module called SAP inventory detail which consists of one numbered list, and other module called Aggregate Demand schedule which consists of another numbered list. I need to fetch the line item called demand from Aggregate Demand Schedule to SAP inventory Detail module. Can anyone please help me on this.…
TEXT() function to follow Excel rules
Being a Anaplan builder, I would like to extend TEXT() functionality to work similarly to excel function, exactly: 1) Follow different format conversions 2) Follow preset patterns, to exclude unexpected text from numbers results etc. Example of wrong work to be prevented with new functionality: Text(1504322.40)= 1504322.4…
Question: Action Timestamp Obtainable in a Line Item?
Community, Does anyone know if the Action Timestamp can be shown on a page or dashboard, most likely through a line item? Or, is it just on the action tab? Can the action timestamp be retrieved with the new Transaction APIs?
Allocate data of 1:N within same list.
Hi, I have a list with items A,B,C the data of A should be mapped to B and the data of C should be mapped to B. and it is 1:N mapping A1->B1 A1->B2 A2->B1 A2->B2 C1->B1 C1->B2 C2->B1 C2->B2 I have done the above mapping by creating a concatenated list but I am not able to fetch the data by using this mapping to target…

Modeling

Discussion List