-
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…
-
Level 3 Training
I just completed (1/29/25) level 2 certification and would like to continue with level 3 training. However, all level 3 courses are locked for me. May I know the reason and when I can expect the courses to be available for training? Thanks RP
-
ADO connection to SAP
With the ADO connection to SAP. Can a SAP report be created and then ADO will connect to the SAP report rather than having to export the SAP report in to a file. My understanding is that ADO can connect to SAP directly but not sure if can only connect to SAP raw tables or whether it can connect to an SAP custom report.…
-
Python Anaplan Connector
Im trying to learn about the PYTHON Anaplan Connector, can someone please share the correct documentation starting from scratch and best practices using PYTHON Connector? I need to understand about File upload, File Export PYTHON SCRIPTS how we can implement and what are the Prerequisites.
-
Issue: Informatica Cloud Connection to Anaplan Success but 0 rows processed.
Hi Anaplanners, I am trying to use IICS to establish a connection between my oracle db to Anaplan module. But everytime I test my IICS process, it's giving me a success status but showing 0 rows processed, and when I check the module, nothing was imported in. I also tested my action manually and it worked fine. I also…
-
SUM data in time dimensioned module based on Boolean
Hello Everyone, I have the following scenario, could someone please help me to solve this. I have a module dimensioned by Native time and I have 3 line items one is Boolean, Value and Target. Now I have to look at the Boolean line item if it is true then copy the current period value from value to target if its not true…
-
Notification when a user is added as Tenant Admin
As a part of security, Shell would like to see Tenant Admins notified via email about their access level. This will be key feature that will help keep people notified internally and to ensure logs can be reviewed for security purposes.
-
Apps- Best Practise for older copies
What is the best practice to keep copies of the entire apps page in a periodic manner in case of reference required in the later period.
-
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…
-
Sequential code creation with department(code+1 ?)
I have a requirement where I need to create sequential codes with department (based on user selection) in a list .The user will click "Add item" from the dashboard and codes will be created and added in the list in a sequential manner . Example : 1st time : New code : 6759_00000 2nd time : 6759_00001 Similarly starts from…
-
Mapping Issues due to dates
can anyone tell me in this case how should i choose the time mapping?
-
Error on Excel Add-In
Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
-
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
-
Network traversal algorithm using Anaplan
Has anyone implemented a network traversal algorithm in Anaplan? To explain the problem, refer to screenshot below. What I want is to generate a path that goes through all the nodes, e.g. Node 1 to Node 3 then to Node 4 then to Node 2 that returns the path with the lowest weighting. So Node 1 to Node 3 is 7 (as per…
-
Data Label Option in Charts
Would like to be able to change the method on how to put the percentage label on the pie/donut chart. When the portion is too small to fit the label, it's fine to have a call out style (current style). But when we only have 2 or 3 categories, we would like to have the label directly laid on the portion so that the chart…
-
users dimension for filtering
In my model user dimension is used across the model for filtering so that the users do not overlap their data. If my understanding is correct this is the standard practice. I searched community for best practices related to usage of users dimension i could not find anything. So my question is i have a model which is almost…
-
Best Practise of creating List
Which is the best practice for creating List in a Spoke model from Data Hub model ? Is it a List to List import OR Saved View to List import ?
-
Apply Dynamic Cell Access based on two modules
Hi, I need to add DCA to enable this functionality- I have a module (MODULE A) where budget is input by markets in a budget input line item. I have another module (MODULE B) where once the market has input the budget, they can check the boolean "Submit to HQ". Once the "Submit to HQ" boolean has been checked, the budget…
-
Collapse / Expand Hierarchy Functionality in Modules and UX Grids
In current standard grid modules and UX Grids you can't Collapse & Expand hierarchies of Lists/Line Items/Sublist like you can do in Excel (see below). Considering that sometimes hierarchies can be huge or you want to Collapse one part but Expand another - it would be good to have such functionality
-
Model Building
Hello, I have one requirement where line items should be filtered based on the Year(FY24, FY25) Dimension. For eg: there are 12 line items, which contains both text and number formats. If User selects FY 24, The first 6 line items should be shown in the page and if user selects FY25, last 6 line items should be shown . Any…
-
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
-
Passing parameters to system modules
I have more than five modules where "reporting date" is a line item and I import values for them. In each of those modules I have another line item to calculate the reporting period based on the reporting dates. Here is the formula for that. IF DAY(reporting date) <= 15 THEN PERIOD(reporting date) ELSE PERIOD(reporting…