-
How to calculate Percent of Total in hierarchy and Put on a chart
I'd like to do two things here and would appreciate your help. I think I could do it with 15 steps but there has to be a better way. I've got a hierarchy called Workstreams with Products, Projects, and Unallocated that accumulates employees hours worked by month. In this module, W2 Workstream detail is the rows and then…
-
level 1 model builder 4.6.5 Activity: Import Data into G3 Location List
Hello guys still my first week with Anaplan and I have an issue that when I import the list locations an error say invalid parent as shown below and I do not know what i am doing wrong 😞 this is a screenshot of what my mapping
-
UX - Export cell history
Oftentimes when looking at the cell history in the UX, it gets truncated. I understand that narrowing the date range can fix this issue, but it is not always feasible. Having the ability to export the cell history from the UX would remedy this problem. Plus, it is an available feature in Classic dashboards. Therefore, it…
-
Recording now available! January 28 platform release event
If you missed our January 28, 2025 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…
-
Workflow : Skip on Blank Assignees
Half a question and half a thought on the below toggle that I noticed has appeared recently Does this mean that you could setup a flow which was Task A - Task B - Task C where you could go directly into Task B if you weren't part of Task A? Or does Task A still need to be fully completed before going to Task B? And…
-
[UPDATED] Summary Calculations with the User List
Author: Rob Marshall, Director of Architecture and Performance at Anaplan, Operational Excellence Group (OEG). Prior to the February 2024, users were not allowed to use aggregation functions (SUM, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK) when having the Users list in a module because the system could…
-
Delete Dormant Users from the Anaplan Tenant Admin Tool
The ability not only to disable but also delete dormant users directly from The Anaplan Tenant Admin tool. The assumption is that the Anaplan Tenant Admin tool can also offer a feature to enable the Tenant Admin to identify how long a specific user or group of users have not logged on to Anaplan models facilitating the…
-
Interpolation
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
-
Timeline Chart improvement - Event Calendar
As a User I want to navigate my Events from a Calendar view on top of the current Grid view. This to leverage the insights which a Calender view provides for visualizing the time relationship of an event and between events. To establish this the current Timeline Chart is to be enhanced by functionality such as: Actions The…
-
Change of E-mail Domain - User History and information
My Org, will be undergoing a rebranding soon and as a part of it the domain name of the email addresses will change user@oldco.com → user@newco.com We use Anaplan SSO for Login and Authentication, Once the SSO is reconfigured expect change reflect in Anaplan user base. How will Anaplan treat this change? Will the new…
-
Optimizer OR
Dear Community, is there a possibilitly to use the logical OR in a constraint for the optimizer? I am trying to compare a variable to a constant. The constraint should default to TRUE if the varible equals zero or is the variable equals the constant. I came up with a non-linar equation (x * (x-y) = 0), but I do not know…
-
How can we retrieve Module IDs & Line item IDs?
Hello, Is there a way we can retrieve the module IDs & line item IDs? It'd be really helpful in understanding the MAPS report instead of having to copy paste & check the id for each line item. Thanks!
-
Browse new file when running import action.
Hi everyone. i created an import from CSV. now i want to publish this using page. my only concern is everytime i click the action/import. it wont let me browse to a new file. it only import to the old csv the i used to import when i created the action.
-
CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message failed_row While the documentation outlines the table structure, it lacks details on how records are…
-
RANDOM() Function
Excel Having two functions RAND RANDBETWEEN both function generates random numbers, it will be very useful for model builders and end users to use same function in anaplan. please suggest can we get same function in anaplan.
-
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…
-
CloudWorks—This is how we use it, Part 3: The CloudWorks API
In Part 3 of our CloudWorks - This is how we use it series, we will introduce you to the CloudWorks API. This is typically for an audience comfortable with REST APIs concepts and programming. If you need a refresher on What CloudWorks is, see Part 1 or, for how to set it up, see Part 2. CloudWorks API will allow you to…
-
Filtering a Custom Report Based on User Selection
Hello, We have a series of reports that we want users to have the option to select a Year over Year comparison (such as 'FY25B vs FY25A' in the dark blue) and the corresponding light blue to be filtered. Below is an end result of one selection: If a user were to select 'FY25A vs FY24A' the result would look like this: This…
-
To access Level 1 Model building course (Talent Builder Program)
Hello everyone, @AnaplanAcademy I have been completed the Anaplan way, and I’m interested to complete Level 1 Model Building certification but could not be able to access in the academy, could anyone please assist or provide suggestion for this.
-
Export module data specific to a page selected using an action
Hi Team, I want to create an action event through which I want to export specific page data to a CSV file. I have a page selector which has 3 pages. (version 1, version 2, and version 3) I want to export specific version data by passing the version number as input. Refer to the attached screens. How can I achieve it Any…
-
Selecting a month boolean line item then only month data should be displayed in other module
in Module i need to give 3 boolean line items named year ,month, quarter. in other module i need to have a line item named order amount . so the thing is if i select a year boolean line item in the first module then only year data should be displayed in other module where i have a order amount line item same for month and…
-
Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item
Hi, Can I please get some help with the formula for this? Thanks
-
INV05 Shipping Export Shipping Costs return 0
When building module INV05 my shipping costs are returning as 0 and this is due to my INV01 needing manual intervention on 'submit purchase order request?'. Surely this needs to be automated otherwise I would have to tick every SKU. I cannot find within Level 2 where the instruction is to automate.
-
Model Calendar update
I have one model where we have 5 years of Past and Future period set up. The year roll over happens on 1st Feb. (Feb to Jan year rollover) Now at the latest year rollover on 1st Feb 25, I have increased the current fiscal year by 1 year so that the new year will be available for the data load. (The Calendar year has ended…
-
Data Import from Model A to Model B
Anaplanners, Had a query, i have data in Model A, in Revenue Module which is dimensioned by Country List, Time & KPIs as line item. I need to import this data into Model B, in same Revenue Planning Module, which is again dimensioned by Country, List, Time & KPIs as line item. However here we have an additional plan type…
-
Filter list formatted line items based on list property
Hello All, I have a challenge where I need your expertise to achieve it. I have a system module for Resources where I have attribute called Employee Type (Permanent, Temporary). I have reporting module applied with Territory and BU. In this I have line items with Resource list formatted. I need to create a filter line item…
-
Null Pointer error : While exporting data to Snowflake
Hello Team , I am getting NULL POINTER error while exporting data to snowflake , below are the development scrips and error screenshot . Anaplan connect version: anaplan_connect_4.2.1 Snowflake drivers used: Almost tried with all latest snowflake-jdbc-3.13.22 / 3.21/3.16 Error: I am able to import the csv file but it is…
-
Error in Uploading Screenshot for Anaplan ADO Maps.
Hi All, Facing an issue while uploading the screenshot as it is showing "error while uploading the file". Is it only for me or is anyone else facing the same. Can anyone help in resolving this at earliest? Attaching the screenshot of the error below. Thanks,
-
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
-
Is there a bug or... Show/hide level filtering doesn't have an effect
There is a need to filter levels of subset but it looks that it doesn't work. Level filtering works good if you have a list. Is there a bug or… (subset is built with boolean rule). Pic1: trying to filter levels through Show/hide option on board Pic2: even selecting / unselecting levels, there is no effect on board to…