-
How to calculate project end month & project start month based on data.
Hi, I am trying to calculate last month & start month basis on DAT01 TestData. For E.g.: For list Item A: Start Month should be Nov 24 & end month as last data value. Source Module:DAT01 TestData Target Module: CAL01 Start & End Month
-
Use Generative AI to summarise commentary from bottom of hierarchy upwards to top of hierarchy
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Different roles enter and consume "contextual" data (commentary) at different levels of a product / customer hierarchy. It is the…
-
Snowflake Integration : Anaplan Connect with Private key
Hi All Anaplan connect is unable to extract private key while making a JDBC connection to snowflake. Error says “Try setting the JVM argument: -Dnet.snowflake.jdbc.enableBouncyCastle=TRUE” I believe I am using the supported version of Java (v8) & the latest version of Anaplan connect(4.2.1). I have converted.p8 to .pem…
-
UX Grid Filters: After initial filter is applied, how do I get subsequent filters to reduce options?
I am working with a grid with a large amount of data. After an initial filter is selected and the end user moves to further filter the data with a second filter, all available options are still shown. I was expecting to see the options in the second filter truncated to just the options possible after the first filter. For…
-
How to create multiple actions with same source type and source target type?
How to create two actions with same source object type and target object type without creating new saved view and the two actions has a different mapping in line items?
-
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
-
Saved view different in Dev & Deployed - same revision tag
Hello model builders! I'm running into something I don't understand; it appears to be a bug though I'm not sure. We've got a specific saved view that does not match between our dev. & prod. models. I've tried to override the saved view, then pushed a new revision tag (it contained no changes). Dev. Model Saved View:…
-
I need to change Model Calendar Time settings 4 4 5 Structure.
Currently the system is allowing me to use Last Sunday near to the end of month. Ideally my requirement is I need third Sunday / Second Last Sunday near to the end of the month. For Ex: 28th Oct 2024 to 26th Oct 2025, is Current fiscal year which came because of the the end of fiscal year selection - Last Sunday near to…
-
Introduce scrollbar arrows
Can you please introduce scroll Arrows at the ends of the vertical and horizontal scrollbars for easier navigation across the dashboards (in similar to excel style).
-
Text Concatenation | Model Optimization Team series
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Managing number formatting between countries
Hi everyone, I'm looking for advice on how to dynamically change number formatting in both the Anaplan model and UX based on the region or country. We have a development model that will be deployed across two countries, but they use different formats for decimals and thousands separators. For example: Canada uses a comma…
-
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
-
What is the typical Workspace size for a medium size Anaplan project not complex and not simple?
-
Essential Anaplan topics
The best way to hone your expertise is practical experience. We recommend one or more years of hands-on experience using Anaplan to uncover all you can do with the platform. Training can also help you advance your technical skills and learn best practices for working with Anaplan.In addition to our required training, the…
-
Retaking Quiz in "The Anaplan Way" Chapter 9: Center of Excellence
Hi all, I am currently in the process of completing the Anaplan Way course. However, I encountered an issue with the quiz in Chapter 9: Center of Excellence. Unfortunately, I did not achieve the required score of 80% and am unable to retake the quiz to proceed to the next module. Could you please provide guidance on how I…
-
Customizable Default Time zone
Whenever I create a new user account the Time zone is set to GMT, which is the Default time zone. I'd like to be able to configure the Default time zone for my environment to Mountain Time. This would result in new users being automatically configured to Mountain time.
-
4.6.5 Sale Planning Model: DAT02 module
In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year Hello, I am trying to…
-
1.5.6.2 Import Data into Historic Volumes Module
Hello, I'm struggling with importing data into the 1into Historic Volumes Module. I saw other threads on this topic, but I did not solve the problem again. this below is the mapping blue print module The error I get it seems caused by the no-aggregation of data Please help.. I've been struggling with it for hours.. Thanks
-
Analogue of SELECT CASE function
This would allow to exclude nested IF-THEN-ELSE constructions.
-
GTM certification - where to find the certification
I have just completed the GTM - Go To Market course, but couldn't see the certification in my profile in Anaplan community. Does anyone know where I can find the certificate? Also I often see people share their Anaplan badges on LinkedIn, how they got the certification image? Do you just take a screenshot and make your own…
-
Dynamic Workflow Design
Hey builders! I'm tasked with designing an approval process through Workflow and doing this for the first time. This is a CapEx Request approval flow in which CapEx Projects roll up to Profit Centers. Approvers are assigned at the Profit Center level and go through several sequential stages of approvals. Below is my 2 step…
-
Need a way to identify line Items being used as Filters.
There needs to be a way to identify line items that are being used as Filter in same module or any other module, This would be totally helpful while deleting line items that are no longer required.
-
Sort Module Overview in Settings by Cell Count
I was wondering if it is possible to sort the modules by their cell count in the settings. At the moment there is only the possibility to export the model overview and then sort it in Excel for example. This extra step would be saved by having a built-in sorting function. For me it is important to sort the modules by their…
-
NEED HELP ON LOOKUP
Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the Peak Week from a date value (Peak Date). » So it's like the Weeknum function using the 'Peak Date Mid" value. I have another…
-
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…
-
Level 3 Certification query
I have completed my L1 and L2 from a different organization and then moved to a new place. I have asked Anaplan team and they migrated my certificates in the new account. Before doing the Level 3, do I need to do the L1 and L2 once again in the new account? Or I can start L3 directly here.
-
How to add badges for earned certifications?
I have completed all the training and earned the Anaplan Certified Model Builder certificate but there are no badges reflecting on my profile. Please advice.
-
L2 Model Building - Sprint 1 - 1.4.3.1 Create SYS12 SKU Details Module
Hello, I am stuck on this: when importing the CSV file to populate the newly created above module I got an error I'm struggling with. This is the SYS12 SKU Details Module created as requested in the training exercise: this is the CSV file to import this is the message I got after importing the file It seems that the codes…
-
Anaplan Consultant Expertise Accounting knowledge
Do Anaplan Consolidation /Fluence consultants could not be accountants? How they will understand the consolidation process if they don't have the accounting and practical expertise? Thanks !!!!
-
Pivot Table