-
Email Notification
I created a action - to add list member. Additionally also a notification to notify me via email if there will be a new List member added. But unfortunately it is showing me two different buttons to execute the process. Is there any way i can create in one process the adding of list member followed by Email notification?…
-
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…
-
ANY formula issue
Hello, I can't seem to properly make this aggregation formula work correctly because it's based off a boolean which apparently is not filtering the list items correctly. TARGET MODULE, WKK51 Sales Returns - Actual/Forecast lists: week, scenario, customer group. timescale: NOT APPLICABLE SUM Formula: IF…
-
Same line item to be editable and formula based
I have one line item and I need data to be formula based for first 5 years (Already defined in a sys time module) and next 5 years (i.e future years) to be manually inputted. We dont want an extra line item for that editable part. How can I do this.
-
How to lookup transactional data without having many-dimensioned calculation module?
I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis. I want to create a module that end users can input into for their department where they're entering details for their next year's budget. For this,…
-
Lag inside an If statement , best practice?
Hi I need to put a lag function inside an IF statement. What is the best practice for this to optimize model performance? Should I break it into to line items? Or would it be more efficient to do: IF NOT x > y THEN 0 ELSE LAG() ? Thank you
-
How to get around circular reference with an average?
Hi all , I have been having trouble with this problem. I created a simplified example of the issue. I have a daily module. First I must manually calculate the Average balance with the sum & average line item because I only want the average to be calculated with "Working Days" (not holidays and weekends). (I must select all…
-
Running alternate hierarchy
We currently run the following hierarchy within our system This works for how the business currently reports, however in the future will need to still be able to report in the above hierarchy but then we would also need to report in the following structure. As you can see the bottom level would be the same, however I would…
-
Want to make an action card that allows me to insert new data into a list
want to create an action card for a list lets call it user list ( Numbered List). I want to make an action where i type in a new name and it makes a new entry into said list. I thought Create Actions should work but they dont seem to apply here.
-
How to create a Filter Of Time based on a combo with different time
Here i want to have a time filter based on the combo . Where user filter highlighted(Red Colour) year . then dynamically the time filter should be applied 2025 to 2026
-
Summing Previous and Current Weeks Open Orders
Hello, I am looking to write a formula to incorporate orders that were placed in previous weeks but are left out of current week. In the example pictures, the current week has 312 units open, but the current open from previous weeks and current week is at 10,056 units. The residual is not included in my module is throwing…
-
Incorrect % line item summary
Hello Everyone, I've a list with 10 members where each member has a value of 10%. The summary for this line item shows 0.999.. instead of 1 in the backend. When I'm comparing the summary with 1 it gives me incorrect value. Does anyone know the reason for this? The summary is correct as 1 when the value entered is 50% for 2…
-
Splitting single line item into multiple line item
Hello Team, As project requirement I need to split the total annual amount into month wise and under different heads. I have created one input model where end user will input the amount. expected output is as below Amount will get spit based on certain rule defined. I am clear about the calculation of amount and output…