-
Lesson 13.6.4 doesnt show the year information in the UX but it shows in the module. Why?
Lesson 13.6.4 doesn’t show the year information in the UX, but it does show it in the module. Why?
-
Anaplan L3 Model history upload issue
Hi, I successfully completed my Anaplan L3 course and both exams on Anaplan Academy. While submitting the sales planning model history by mistake I uploaded the Model history of DataHub Model. How can I resubmit my actual L3 Sales planning model history ? Please suggest. Thank you
-
Talent Builder Graduate Mini Resume - Sandeep Reddy
Hello Everyone, I’m excited to be transitioning into the Anaplan and EPM ecosystem after 11+ years in business consulting and strategic research across automotive and industrial sectors. I have completed the Anaplan Certified Professional Model Builder certification with hands-on exposure to Connected Planning, FP&A…
-
Powerbi Issues
Hello - I've had perfectly working powerbi extract from Anaplan until this Monday. We havent introduced any changes in the model. The query fails in the navigation step right after source. I get the error "The column: Column1 not found in the table". Experimenting with a clean file i get the same error before i do any…
-
🚀 Stop Writing Nested IFs in Anaplan - Use LIS Instead
If you’ve built complex Anaplan models, you’ve probably written formulas like this: IF A THEN IF B THEN IF C THEN Value1 ELSE Value2 ELSE Value3 ELSE Value4 It works. But it’s slow. It’s hard to debug. And six months later… even you won’t understand it. Let’s talk about why nested IFs hurt performance and how Line Item…
-
Is it possible to color line item header for single line item ?
Hi Is it possible to color any line item in NUX we can color the cells but can we color the header of any line item in NUX. So i wanted to color only the WP0 part not all the line items in the view i have used cf for cell but is it possible for line item
-
[Part 2] Enhancing Anaplan Audit Log Data Extraction with a Streamlined Python Solution
The Anaplan Audit History project, consisting of several Python modules and a configuration file, works synergistically to streamline the process of fetching, formatting, and loading Anaplan audit log data into a preconfigured Anaplan Model. The project leverages the Anaplan REST API, the Python Pandas library for…
-
Set the delimiter for CSV Exports
The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…
-
UX Native selector Supress Zero
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: Polaris specific Use case: In classic we stage lists to only have the nodes with numbers being created (e.g. Customer_account) to…
-
L2 1.7.4.6 Load Employee Details
In L2 Training when i am trying to complete 1.7.4.6 Load Employeee Details, in the actions tab, i am unable to Edit the file. It say file not avaible. I am unable to complete the activity, any help?
-
Anaplan XL - Setting a Report Property: Which Sheet Is Displayed Upon Opening?
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: Setting a Report Property to Determine Which Sheet Is Displayed Upon Opening When a file is saved, the report currently opens to the…
-
Workflow historization for auditability
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: Currently it is possible to delete a completed workflow. Unfortunately this does not meet internal requirements for auditability. Who…
-
Action to reset Index
Hello, It would be beneficial if we could add an Anaplan action to reset the index of production data, so we can use it in our processes right after cleaning the lists. At present, we use the API for this, but it's done outside our main processes. Regards, Roba Sajadian Improvement Manager
-
"Select All Search Results" option for filtering the list line item in Grid Card
Hello, As a representative of people working with Anaplan on a daily basis, I would like to add an option to select all search options for List Line item in the grid card. Our users often search for items based on a specific phase in the product description or product name etc. These items are added to the lists line item…
-
3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
I inserted the formula, but there was no change. Could you please send me a screenshot of your DAT01? Maybe the issue is there.
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Anaplan Level 3 Assign accounts to territory
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
-
YTD Should Exclude Current Month and Include Actuals Only
Currently, Anaplan’s native YTD (Year-to-Date) calculation includes the Current Period, even when that period contains forecast values. Issue From a financial planning and FP&A perspective, YTD is expected to represent Actuals only. However, Anaplan calculates YTD including the Current Month, which can contain forecast…
-
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
-
Show List Name in Blueprint Format Column (or as an additional column at the end)
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: When working in Blueprint view or exporting module blueprints, list-formatted line items do not clearly display the list name. In…
-
Activity: Prepare Data Exports
Hello, i had a trouble to understanding to fill the formula on "Code" line item, if the purpose was to get the code on G3 Location, why don't just make the line item format List and refrence G3? well i try that, and i got another question, why you cannot refrence straight to G3 grid Code? and what the downstream mean in…
-
User story 3.3 To derive Monthly Commission Forecast
Hi, My values of monthly commission forecast is not matching the Check your build values. Please help to identify where I am wrong. As I have attached screenshots of the blueprint and module grid view. Thanks, Sre Varshaa S
-
I need to flow data from a model DAT01a in PBF Dev to PBF Consol
I need to flow data from a model DAT01a in PBF Dev to PBF Consol, we use connectors to do this OUT3A and OUT3B Any instructions or tips on how to build or test the data can be flowed through to PBF Consol?
-
1.8.5.1 Import Data into G1 Region List
Hi Everyone, I am unable to import G1 Region List code from Data hub to Supply chain. Could anyone help with this please? The GI region meant to pick up from SYS05 Region Details 2 code but it didnt. I tried to import it through general list. I dont know what went wrong
-
How to, plus an evaluation of ways, to do version comparison
Author: Kevin Beltz is a Certified Master Anaplanner and Principal Platform Adoption Specialist at Anaplan. Budget vs. Actuals. Last Year vs. This Year. What-if Scenario A vs. What-if Scenario B. As an Anaplan model builder, solution architect, or end-user, you know that comparing versions is a foundation of insightful…
-
Question for 4.8.2 Employee Mapping
I am having issues with mapping. The upload is successful but in the code, some of the employees have names instead of the country code. Can someone assist and let me know what I am doing wrong? I went back to previous lessons to make sure I am doing the right mapping as well.
-
PlanIQ algorithm properties
Review the table below for information on each algorithm and its specific properties. Question? Leave a comment!
-
Ability to change Pivot in Google Sheets Add-on
The Google Sheets add-on doesn't let us change the dimensions in the Pivot when setting up the connection, unlike the Excel add-in. We need to create custom views in the model to be able to pull the data in the format we want. This is a big deterrent towards adoption of the Google Sheets add-in and restricts the…
-
Pivot feature for Google add-ons
The information toolbar suggests that we pivot in Anaplan using filters and pivot feature. This is an inconvenience from the user experience perspective. If that were to be the case then we are better off creating views for everyone. Moreover, this feature that's been mentioned as information does not work as intended.…
-
3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
What is the correct formula to display Beginning Inventory?