-
Filtering based on initial 2 letters
I want to apply filter for users based in initial 2 letters of data. So, if initial letters contain say (ac or bd) then user group A shall be able to see only data having initial letters ac and user group B shall be able to see only data having initial letters bd. Any suggestions on approach , please?
-
Referencing a list property
Hello fellow builders, I'm a bit hung up on this. I want the Display Name formula in the "Job Title by Cost Center" list to follow the same naming convention in the "Cost Center" list. For example, I want "BOBL-CAACPAY" to be "Accounts Payable (BOBL-CAACPAY)" The two lists are independent of each other, i.e. there is no…
-
Activity : Filtering and Displaying Hierarchical Data
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Product Family ( LVL 1) P2 Products ( LVL 2) P3 Products SKU ( LVL 3) Requirement : When a level 1 item is selected , display…
-
Summary: SUM , Time Summary: Average ERROR
Hello, Is it possible to set two different summaries at a time? This is what I am currently trying to achieve in the following module, "Forecast - Cost per Layer" and "Actual/Forecast - Target Cost" line items: However, in both cases I get this error: Is there any workaround to this? Many thanks, Luca
-
Driver Line Item for UX Action Card - Not Working all of a sudden.
I've configured a series of UX action card with data write and Action runs driven by a driver line item . for approval workflows. All of a sudden the driver line items didnt seem to work and does not allow me to run the underlying process in the prod environment The Load invoice pricing card triggers an action run based on…
-
How to Split A Model into Two Separate Models
Hello All, Our current model is about to hit the max workspace size of 130GB, so we divided it into two models based on the region. Imagine having 1000 stores, and creating a new model with 500 stores. My question is how to remove those 500 stores in the new model from the original model. What are the best practices and…
-
Import Action not working anymore
Hello, I have an import action that used to work perfectly well until today. It seems like Anaplan can't catch the module information. Here's the action: the action goal is to import the data from "previous mask" line item to "No of masks" line item: Here's the module view I use during the import: What's wrong with this…
-
Dropdown Selection - Deletion & Deletion of Data
Anaplanners Is there a way we can restrict the end user from deleting the data. For example a line item A is list formatted and has 3 options, currently Anaplan enables the user to click delete and remove all values, can this be restricted where users are forced to choose from the 3 available options all the time ? Thanks
-
model to model import : Failed to locate model
Hello Anaplanners, I am working on a deployed model and i am getting this error when i tried to model to model import data : 'Failed to locate model ' Can anybody help me on this. I am attaching the snip below FYI : I am having full access and admin access to both the models. THANK YOU 🙂
-
Optimiser for Minimising transport cost & transit Time:
Hi All, I've one situation where I need to build a optimizer which will minimise the transport cost & transit Time, Below are the details: Inputs : 1) Factory Supply Qty 2) Distribution center Capacity 3) Applicability of mode of transport from Factory to Distribution Center - Mode of Transport i.e by Air, By Road or water…
-
getting errors in p2 products list
above are the errors
-
Rank Cell Limit Clarification
Hello, I see there is a 50M cell limitation on being able to use the rank formula. I'm trying to clarify what I look at to determine if the line item I want to rank would be under or over the limit? For example, Do I look at the Cell Count of the line item I'm trying to rank or is it different? Second, I see in the…
-
Excel Add-In and Anaplan Versions
i'm new to the Excel Add-In for Anaplan. If I point an Add-In model at cells in a particular version, say 'Working' and then deleted it, can I create another 'Working' version and will the pointers in the Excel Add-In still work? Gut feel tells me no, but I want to be sure. Any thoughts appreciated. Chris.
-
Dynamic Filter Dimension
Hello, I would like to build a filter where the user can select the dimension (list) by which they want to filter and then have another grid next to it where the selected dimension's members appear. Is this possible to have this flexibility ? Example: I have a module with the dimension "Orders" containing the sales of my…
-
2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, My line item is reverse from left to right. Any idea why?
-
2.4.6.1 Create AD01 P3 by Account by Week Module
I don't understand why I have this on my AD01 P3. How can I remove it?
-
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
-
Dependent Dropdown
Hi All There is a list formatted line item in which the list is at lower level of hierarchy. I need dependent dropdown for particular items in the list without showing higher levels of hierarchy. Is there any possible way to achieve this by using the same list instead of creating a flat list.
-
What to map at REVO2 volume inputs
what to map here
-
what to set at the source and data values here? at modules
what to set at the source and data values here?