-
Level 2| Sprint 1| 1.4.3.2 Import Data & Add Formula; Error: Item Not Located in P2 Products Family
The blueprint view screen shot for SYS12 SKU Details is shown below: The P2 Product Flat screenshot is: The P3 SKU Flat screen Shot is: The error detail message is: And the SYS12 SKU Details screenshot is: Any suggestion/advise what I am doing wrong. Thank you.
-
Anaplan Estate - turning model exports into practical improvements
Greetings, fellow Anaplanners. I’ve always wanted something that could take thousands of line items and help me work out where to start improving a model. So I built it. It’s called Anaplan Estate. Give it your Line Items and Actions exports, and it brings optimisation findings into an action plan, with evidence and…
-
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
-
Help with developing a formula for an employee longevity report
Does anyone have advice on building a formula that properly calculates longevity for employees that includes an escalator based on their job effective date? I have everything built in the model but I cannot figure out how to get it to include the increases. Assuming someone is paid 20 dollars per month for every 2 years…
-
Polaris - Booolean formula to select current FY
I am in the process to transfer a model from classic to polaris. One of the formula is not accepting in Polaris when the system will auto select the current FY. Classic formula is ITEM(Time) = TIME.'Current Period' I've tried every formula I know but Polaris is not accepting it. Any help or suggestions are welcome
-
What's the #1 bottleneck in your Anaplan build cycle?
What's the #1 bottleneck in your Anaplan build cycle right now? A. Model documentation B. Onboarding new builders C. Optimizing slow formulas Curious which one takes the most time for your team and how you're currently addressing it.
-
Anaplan Offset Formula is looking for value outside timeranges
Hi, I'm using the OFFSET formula, where a calculated and number-formatted field determines how many previous weeks the formula should look back. Based on this value, it retrieves the corresponding week's data into the output line item. The formula works correctly for some products; however, it fails for others. The issue…
-
How can I add the column: _ab_source_file_last_modified in TV on incremental Data Source
How can I add the column: _ab_source_file_last_modified in TV on incremental Data Source
-
Delete Revision tags from any model
Is it possible to delete all these revision tags from a model and start fresh? My bet is , it is not possible and I start a new model:
-
2.5.8.2 Run Processes to Update Production Data - error message
I am getting this error message, how can I investigate this? Where should I start looking to fix this step so that it can continue ? Any suggesitons are highly appreciated.
-
Any Way to get Process IDs Without Postman?
Since Anaplan inexplicably refuses to put process ID as a backend field (like on the actions panel where it would make perfect sense) + has now deprecated the way you used to be able to get it in the browser, how are folks getting this information now? My company has limited postman licenses and does not want to be…
-
Polaris Performance Optimization Help Needed – Large Boolean Line Item with Multiple Flat Dimensions
Hi Everyone, Greetings! I'm looking for recommendations on further optimizing a performance-intensive line item in Polaris. Background I have a module (Expense) containing a Boolean line item (X) with the following dimensions: Time L5 Flat Product L3 Flat Channel L5 Flat Expense Expense Actions Note: All flat lists are…
-
Anaplan models not loading
I am facing the above issue while loading my models. Can anyone help?
-
1.5.3.2 Create Additional Saved View for DAT01 Module - DEV_View? formula
Stuck on writing the DEV_View? formula that would help me to check all these 3 at the same time? : Beginning Inventory <> 0 Distribution Center is in the Location DEV list SKU is in the SKU DEV list Any suggestions or similar formula I can look and try is highly appreciated. Steve
-
"Failed to retrieve field list" error when importing saved view across models
Hi everyone, Has anyone run into this issue before? I am trying to import data into a Marketing model list using a saved view (Update B3 Product Dist in Mktg) from a source model (FinancialPlanning_Dev_Polaris). However, when I try to set up the import action, I get the following error: Select SourceFailed to retrieve…
-
Summing over time period and list item
Hi, I am struggling to return any values and wondering whether this is even possible? I have created a fake Period End list and can determine according to the day in the time module (ACC04) what the Period End should be. I then created another module dimensioned by Period End and summed Day in Office but its coming up as…
-
Stable User Access Export
Hi all, Has anyone found a way of exporting User Access from a saved view rather than directly from the Users tab? We're feeding the export into Azure Blob Storage and have had a couple of issues recently where changes to the standard Users export altered the filename/structure, impacting downstream processes. Ideally,…
-
Row Count as an ID for ADO
Hi all, I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO? Basically how would I do row_number() in SQL?
-
Capturing enhancement requests from end users
Hi everyone. Has anyone built a model designed to capture enhancement requests from end users with a view for CoE to assess, triage & prioritise. Looking to provide end users with a UX page to submit enhancement requests and for CoE team to be able to track.
-
Building a User-Filtered Export from a Module with Multiple Selectors
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…