-
How we built the famous word game : Wordle!
You all must be aware of the global phenomenon of “Wordle”. The way this little and simple word game struck the world is amazing! We loved this game so much, we tried to test our beloved software, Anaplan’s, limits yet again and tried to recreate this game on it. This is how we built Wordle on Anaplan inspired from…
-
Sort on the Users list
Hello all, Hopefully this is a quick solution. I'm looking for a way to sort the Users list based ontheir Read/Write properties. Example: I have 25 users that have Write access to different cost centers. They should be ordered based on Center alphabetically. Is this possible?
-
NUX, two data write actions in one button?
Hi, I am trying to create a support ticketing dashboard. I need one button to do two things: 1. Submit? boolean to equal true, 2. Change the status to submitted. It shows two buttons. Is it possible to make both actions under 1 button? I need the "sync on selection" to select the ticket to apply these edits. Any ideas?…
-
How to make a Boolean line item disables other boolean line item
Hi Anaplaners, How can one set up a system where selecting one boolean line item disables the other two boolean line item. Example: When you click on Boolean 1, Boolean 2 and Boolean 3 will be disabled (not clickable). Similarly, clicking on Boolean 2 will disable Boolean 1 and Boolean 3, and clicking on Boolean 3 will…
-
Formula to return the latest date and hour
Hello, I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula? Thanks
-
Is it possible to have a boolean that once checked, cannot be unchecked?
Hi, I am trying to build something for a support ticketing dashboard. I would like to have a "Submit?" boolean line item. Once this line item is checked, I want it to be locked so that they cannot uncheck it. Any ideas? Thanks in advance
-
How to make Home Dashboard or Default Dashboard
Hi Team, I have created following three new dashboards in Anaplan model, how to make one of them as default dashboard when we open the model. Below "Home" dashboard should always open automatically when i open the model. I appreciate your help on this question. Thanks, Suman.
-
Unable to Login to Anaplan
Some user are unable to login to Anaplan and they are not getting an option to reset the password, showing as failed to assert user. Attaching the screenshot for your reference. user. Attaching the file for your reference.
-
How to connect my list to module for filter
Hello everyone. i would to seek for your assistance on how can i connect my list to module for filtering. i have a list which has Soft Opening, Pre-Grand Opening and Grand Opening in my module i have the details where i can input all the details of the contract including Opening Category. i created a new module where i can…
-
Display Actual and Budget in one Module
hi everyone how can i display the actual budget according to the filter month that i have chosen. i have module Actuals and Forecast. and is it possible to change the color for actual as blue and orange for forecast? thank you.
-
Is there any way i can convert number to text format but still following the number format for comma
Unable to convert number to Text following comma format, Could anyone help me out of this problem? Thanks in advance
-
If parent is numbered list is it necessary for child to be a numbered list
-
Best Practice to combine two or more model data into one output model
Hello Team As project requirement I need to combine information from two different model (i.e. Actual Payroll information and Plan Payroll Information) In different model have calculated this information since calculation is different and in plan payroll end user will make the changes. List used in both models are number…
-
Adding hierarchy using a boolean
Hi, I have a list hierarchy where till level 3 we have imported and now for Level 4 and 5 we want to get a checkbox that will say Relevant data. Once I will check that and click on Add to Hierarchy Level 4 and subsequent Level5 will be created. Level 4 have a fixed 3 items that gets added to all Level 3 items as a child.…
-
Level 2 Sprint 1 1.1.5 Activity: Download Copy of Data Hub Model
I am trying to import the model in the Anaplan application which Calendar property should I select I am confused. Can someone help me with the same?
-
Level 2-Conclusion: Import Shipping Expenses into OTH01 Module
Hello, I am trying to import data from my Supply chain model to FP&A model however, I am getting some errors. Here is the source module (from Supply chain model). The timecard is "Month" for shipping cost And here is the target module (from FP&A model). The time card is "Month". I am trying to import the shipping cost data…
-
How to create filter in Multiple axis rows and columns at the same time
I need the user to be able to filter the combos in the rows. For instance, when they select combo 1, the time dimension in the column should display with non-zero values corresponding to combo 1.
-
Optimizer General Constraints
Hello All, I'm working on developing my current model with the Optimizer to add some levels of complexity. I am looking to use a General constraint (OR), does the Anaplan integration of the Optimizer support this? For Example I wish to constrain to a zero value OR a value above the minimum. Working: 'OPT04…
-
One to many mapping
Hi, I have a requirement where i want to realign/ redistribute the Sales History from 1 SKU to many SKUs. Lets say, i have SKU A with 1000 units sales history. I now need to realign 400 and 300 units from SKU A to SKU B and SKU C, who have 500 and 200 units sales history of their own, respectively. So after the…
-
Synchronizing count for two (or more similaire items )
Hi All, i have been wondering if it was possible two synchronize two items for a count. Here is the case : We have a person called Williams Peter A1 arrived at first is the "Centre de coûts" (Cost Center) called TestCC1 in 04/01/2024 as we can see with the Date d'import. But along the way, he changed the cost center to…
-
Hierarchy Mapping from flat list
Currently we report our P&L using list Entity L2 which contains all our entities as a flat list. We want to create a new module that reports the same P&L information but not on a flat hierarchy. The dimension of this module is New Hierarchy L6 which rolls up into our highest consolidation level (TopCo) This is the mapping…
-
Select data based on Month
Hi, I have data spanning five years, and I need to filter it to extract information for a specific three-month period within one of those years. What is the best way to do this?
-
Year-on-year growth rate
I have a line item 'Revenue' with monthly data. I'm trying to calculate the year on year growth rate for this line item. Currently, I tried the formula below: Revenue / OFFSET (Revenue, -12, 0) - 1 This formula is working fine for all the months, but it is not working for Quarters or Half or Full Financial Years (FYs). The…
-
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
-
Retrieving a date to a module without time dimension
Hi All, I have a question regarding the last date of an item, to a module without dimension. Let me explain, i have this module : with thoses dimensions : My purpose is to get the result of the input in a module only dimensionned by "s Active" (subset of my employee list) and regarless the version, to get something like…
-
Dealing with monthly Dinamic Hierarchies.
Hi, I would like to hear from the community if you have dealt with the same issue that I have and how you solved it. The issue is as follows: I have 2 lists: Cost Center (with selective access enabled, so an owner can access only one Cost Center) Employee (Employee is a child of the Cost Center list) The problem is that an…
-
How to create a module with a Boolean option that switches off "write access" on all Boolean boxes?
I am familiar with how to create DCA to switch off the write access for a list item. This example is costs for a land appraisal. Here is a module with rows that are editable. Here is an override module where I can change access from Write: To read: Now the Pricing method for the first 3 rows are greyed out: I can create…
-
Between Anaplan Time Range and Model Calendar, which is the optimal approach for model optimization?
-
Displaying Total but not the underlying Items
Hi all, i have an unusual demand regarding a dev, I am asked to display the value of a parent but not the childrens value, however the items are displayed. Basically, i have a Hierarchy that goes from C1 to C5, but the focus here is on C4 and C5. I need to do something like this : The "A" Parent is on C4 Level, and the…
-
YTG & YTD Calculation by using custom list
Hi All, I've one use case where I've create list which includes YTD & YTG as list item. Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot. But when I am using sum to get data which is dimensioned by YTD & YTG List, result is showing 0. Can anyone explain why I am getting 0…