-
Prorata Calculation Using Dates
Almost done with my module. I need help in developing a formula to compute the monthly amortization that looks at dates.
-
Anaplan - Informatica Cloud Integration
Hi All, I am trying to run mapping in informatica cloud.Mapping between source and target are valid but while running the mapping I am getting below error: "Operation failed: com.informatica.adapter.sdkadapter.exceptions.MetadataAccessException: [SDK_APP_COM_20000] error [1]". Can you please suggest and resolve the error.…
-
Extend Audit log retention period from 30 days to 1 year for SOX audit
SOX requirement to retain system audit logs for minimum period of 1 year. Currently Anaplan only retain the logs for 30 days which makes the system non-SOX compliant. Hence it would be good if Anaplan is able to extend this retention period. Also it would be good if we can filter the audit log report so that we can lookup…
-
Using the Anaplan Certificate with the Anaplan REST API: A Comprehensive Guide
If you're diving into integrating with the Anaplan REST API using an Anaplan Certificate, you'll need to know certain requirements. This post is a step-by-step guide to ensure a seamless connection using Python. If you'd prefer to avoid a programmatic approach to using your certificate, then please check out the CA…
-
Error message
Hello, I need help in creating a formula that divides the sales of a single week by the sales of the entire year. I am utilizing a custom calendar. When I attempt to use the SUM function, I encounter the following error message: "The name ' used in the SUM clause is not recognized as a line item in the model." I have…
-
End date that should be a working day only
We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Duration Days we also have a module to count the weekends and holidays so to get the END DATE (working days only) END DATE…
-
"Export Directly from Spoke Model" or "Import from Spoke to Hub and Export from Hub"
Hi Everyone, This question has probably been asked before, but wanted to get opinions on the two options. I have heard hard-lined opinions that outbound data should always be brought into Hub and then exported to another spoke model or external system. I've always taken a combined approach that focuses on mitigating the…
-
Transfer boolean information from a module to another (different lists being used)
Hi all, I am having a hard time trying to put to 2 differently structured modules into communication . The goal is to get the boolean to work as filter for the so-called FAB products. Here are the two modules: DAT11, one-list module: ID Revenues this is the source module from whom I need to take the "Is Fab revenue cost…
-
How I Built It: Number lists
Author: Soumya Bhattacharya is a Certified Master Anaplanner and technology consultant at Accenture. Hello Anaplan Community! This ‘How I Built It’ tutorial represents one of the benefits of a Number list and how we can use it to dynamically update the module line-item description. This function helps to build a dynamic…
-
Cloudworks Integration Flow & Run from dashboard
Just like you can run a Cloudworks integration from a dashboard, we would like to be able to run a Cloudworks Integration Flow from a dashboard. This will really aid us in connected planning.
-
Best fit algorithm for bundling/grouping
I have a group of different products having different quantities and want to bundle them in to groups summing up to 10 as close as possible. For example, below I have 11 products and I want to break them in to groups that would have the sum of the quantity equal to or closest to 10. Has anyone tried something like this in…
-
Stop system from processing changes.
We need the ability to stop this. This has gotten out of hand recently. It is impossible to work with this. I make one simple mistake and I have to wait 20 minutes…. This is unacceptable and makes working Anaplan impossible. This needs to be fixed asap. Top priority.
-
Ability to import line item format into blue print view
The ability to import line items format while importing blueprints would be really helpful. Currently, I've set up an automated process to import newly created line items from one module into another module on a daily basis. However, I am still required to check the module frequently for new line items imported in order…
-
Getting error on UX page: "The value entered is not valid"
Hi All, I have the below module setup - New Manager Line Item has a dependent dropdown to show employees from the same department. Later I am referencing Final Manager value in a Employee Summary module while is published as a Field Card on the UX page. But, it keeps showing "The value entered is not valid" under the Field…
-
SYS12 SKU Details module
I am stuck on this. When I had my line item my board looks like this. What is wrong in my module ? I can't remove Time if in the line item I add Code, Product and Distribution center it looks like this> aren't they supposed to be in column?
-
MIN monthly value of the year on custom timelist
Hi team! I have never used the MIN function or aggregation in anaplan before and I am having some problems now. Sorry if the solution is too obvious. I have module with Plan 23 / Plan 22 lineitem with dimensions: 1. Product. 2. City. 3. Custom Months list (January, February etc.) Screenshot of module below: In lineitem…
-
FINDITEM on numbered list ( display name )
Hello, this is my problem. I import a file in my STG03 module, dimensioned by the STG03 contrat list. This list has a property "Tiers" which contains the tiers names, in TEXT. I also have a Tiers module, dimensioned by a Tiers numbered list with code, and display name which are the tiers names. I want to turn the TEXT line…
-
Block / Disable create form action based on a line item
Hello. I want to know if it's possible to block/restrict the creation of an item ( via a FORM ) based on a line item. For example, if the total wallet = 0 then the user should not be able to add and create a new item. thank you
-
Page Sync Issue
We are encountering issue related to page sync. We have hierarchy list ( level 1, level 2, level 3) and each list having subset. Each module used subset from respective list. Step 1. Based on the Page Context selector (Level 1), items of Level 2 and Level 3 will be visible on the respective grid. Step 2: Next Step , First…
-
How can I efficiently extract and integrate just the anniversary month into our existing model?
Hello Anaplan Community, I'm currently facing a challenge with aligning the payment of Objectives Bonus in our model with the anniversary dates of employee entries. The requirement is to pay the bonus on the anniversary date of each employee's entry, but our model calendar is based on the years 2023 and 2024. The issue…
-
Design a line item with a sequential numbers in it
Hello everyone. I hope you are doing well. I was wondering if someone could help me to design a line item in a module dimensioned by time which generates these numbers from the first column to the end column. The order of numbers and the numbers themselves are as below : 1,2,2,3,3,3,4,4,4,4, 5,5,5,5,5 and so one ( it…
-
CloudWorks Scheduling
The Cloud Works scheduling tool requires both a start time and an end time. Times cannot be in the past. For a continuous hourly frequency, the start time must be set as 00:10 or some other start time between 00:00 and 00:59. It is therefore impossible to start a continuous process at say 18:10, and for it to run…
-
Add Folders for Modules and Lists
Similar to the idea posted here, but with this idea could be a possible solution? * Add folders to object contents (e.g. module, list, and actions). * Allow the creation of sub-folders. It goes without saying, but this would really improve model organisation, especially for larger models. The functionality could be similar…
-
More advanced Grouping, Sorting and Filtering of the lists of Modules / Dashboards / Actions etc
During Anaplan training a user creates 5 or 6 modules / dashboard etc. Easy. Our model has a staggering list of actions, modules and dashboards. In our model are we have: * 593 Modules * 248 Dashboards * 1767 Actions Model builders need a more robust wayto manage this. Having the ability to filter these lists by a type…
-
Ability to add Folder structure to Lists, Modules, Actions etc
Being able to keep a model clean and well organised is really important in allowing model builders to understand and work with the model going forward. Often we find that as a model grows, the number of lists, modules, actions etc grows quite large and can start to become difficult to manage. This enhancement idea is to…
-
Account+Review+CYW+Scenario - Mexico values not matching the scrrenshot - L3 certification
Hello Anaplan community, I am currently working on User story 1.7 - 1.10 (Under section 8 of Sprint 1) and after building the country and segment distribution module, I noticed the values were not matching only for Mexico country.While investigating on this issue I noticed that the "Override" Boolean is checked but with no…
-
How can I change my default workspace?
Hello. I need to change my default workspace. Currently it is showing a different workspace as my default and I need to change it. I have not come across any helpful solution so far. Please help. Thanks in advance.
-
Dependent dropdowns doesn't worked
Hello everyone, I'm asking some help. I have a numbered list "CA0" : This list has two propreties : I want to use the propertie "CA2" in a dropdown list. Here is an example. I create a moudle with two line items : CA0 and CA2 The CA0 line item is formatted like that : Here is the result, I have all my list : Can you tell…
-
Smaller Time Range | Less than a year Time Range | Day granularity
Anaplanners, I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter. We have a business requirement where we have to import and export working hours for each user per project per DAY. This activity will be monthly and may not be necessary to have more than a month,…
-
DAT.01 module information
I am currently at activity Level 3 Sprint 1 5.2 but looks like I still don't have DAT.01 module. Can anyone tell where can I find details for building this module? Did I miss anything?