-
complex load from SAP to Anaplan that cause performance issues ?
Q :When dealing with complex data loads from SAP to Anaplan that causes performance issues ?What are the approaches need to consider in mind before or after the load ? Q : And the load happens now model is taking more time to load ? How to tune the model in this scenario?
-
Pulling list property into a module
Appreciate that it is recommended to avoid using properties in lists, however we do have a couple of instances of this in our model. Just looking to pull one of these into a module that we have already created, shown below and was looking for advice as to what formula is best to try and achieve this.
-
Quick 5 minute Test : ADO Navigation - Share your insights !!
We are looking to capture your feedback on the new navigation system compared to the old one. With a quick 5 minutes un-moderated navigation test. You don't have to currently use ADO to participate — if you have experience with ETL Tools, Data Warehouse Tools, or similar systems, we’d love to hear from you! We currently…
-
Issue with Ascii characters in Anaplan
I’ve encountered an issue while importing data into Anaplan where certain special characters, specifically ASCII characters like ü, ä did not show properly, it showed as question mark Instead of importing these characters correctly, the data gets corrupted or replaced with incorrect symbols. As shown below, Although it was…
-
Level 2 Sprint 3 INV01
I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching. I have a couple of questions about INV01. For Beginning Inventory: My numbers are good until week 4. Then I realized that when triggered the PO Submitted boolean, it showed up in the confirmed PO line for the…
-
workflow
workflow - in a group task of 50 people. each assignees (50 people) has complete task button on the task page. but it doesn't make wait to see all the 50 people hitting complete button, we want anyone out of the 50 assignees to hit the complete button to work for all and push the task to the next step
-
Time to Tidy: No More Mess in Your Models
As winter is now behind us and the annual process of “spring cleaning” begins, I find that it is a good reminder to not only clean and organize my house, but also to clean another area that most likely needs some organization: my Anaplan models. The beauty of Anaplan’s platform is that it gives the model builder an…
-
I am currently self learning L1, on Anaplan and unable to set this prompt in a practice session.
Can someone please view this and help me how to set this in a right way? 7.2.3 Activity: Import Data into Employee Details Module In the model, open the SYS08 Employee Details module Download data file: Employees.csv(opens in a new tab) Preview of Employees.csv DO NOT open the .csv file in Excel before completing the…
-
Issue Bringing List-Formatted Line Items Across Modules with Different Dimensions
Hi Community, I'm currently building a report where I need to compare Budget and Actual values. As part of the client requirements, I need to include additional attributes for each employee (Resno), such as: Position Title Grade Supplier These values are list-formatted line items in the source module, which has the…
-
Modeling Performance
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next year so we can use either LOOKUP or TIMESUM . I would like to know which function is effective between LOOKUP and TIMESUM.
-
Module Mapping History Check
Hi All, I have a mapping module that maps GL account to P&L line items. please how can I check the historic changes in the mapping module. Is there a way to check it rather than going through the model history? Your help will be really appreciated.
-
DCA for "Field" cards in NUX
Hello, Currently, when applying a DCA on the field card, the card shows up as usual without greying out but does not let user select if the write is false (Field on the right in the image attached) However, this can be confusing at times. Is there anyway to avoid this? Thanks in advance!
-
Need help related to custom Time Dimension
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum…
-
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…
-
Power Shell Script Usage with Anaplan
Hi Team, I have received a project that requires experience with PowerShell scripting. How does it work with Anaplan Connect? I have experience with CloudWorks, but I would appreciate any resources or insights on using PowerShell scripts with Anaplan. If anyone from the group can share guidance or useful links, it would be…
-
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
-
Error anaplan connect
Hi team, I have problem with anaplan connect 1.4, sometimes i get error 2020-07-13 09:21:25 INFO 88 |-- Initializing Service... 2020-07-13 09:21:25 INFO 88 |-- Authenticating via Basic... 2020-07-13 09:21:47 INFO 88 |-- Retrying API request: Attempt (1) 2020-07-13 09:21:50 INFO 88 |-- Retrying API request: Attempt (2)…
-
Importing timestampted files with cloudworks
Hello, I am implementing integration with cloudworks for a client. I managed to export timstamped files easily as it is mentionned in the Anaplan technical documentation. Howerver, is it possible to import timestamped files when selecting the data source ?
-
Can you find the mistake in my formula or somewhere else?
It looks like my formula is not working because nothing is filled in? how can I solve this problem? it should get data from here: And here: Thanks in advance! Kr, Eva Lagae
-
Team- I am looking forward to free workspace as I need to complete my Anaplan certifications
Team- I am looking forward to free workspace as I need to complete my Anaplan certifications
-
Export Filter Issue
Hi Anaplanners, I am using a classic dash board and have a module saved view with 4 lists pivoted in the row and Time, then I have a native version on the page. The problem is when I filter for a version and time using a filter module, the filter works perfectly to filter the module based on the filter selection and when I…
-
How should I form this formula?
I have the modula SYS08 employee details where my bonus% is 0 but I know the role and department. And I have this modula EMP03 empolyee drivers by role where I know the bonus for every role in the end I want to know the total bonus for the sales department in December. So I want to look in EMP02 Employee expenses to my…
-
Level 1 Model Building Exam Activity 5 - Stuck!
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Role] ELSE 0 And…
-
Line Item Sums per applied dimension
It would save a lot of space if you could specify the sum option in the Line Item based on the applied dimensions. Especially on hierarchical dimensions this would have effect. Sometimes a sum is only needed for one of three dimensions. This would safe space consumption a lot. This feature could added in the sum options:
-
Implementing Polaris: Lessons learned
Author: Philipp Erkinger, Certified Master Anaplanner and Principal Solution Architect at Bedford Consulting. There are days in your professional career where you get to observe something special. October 20, 2022 was such a day, when I received access to a Polaris workspace to build a model proof of concept. Having worked…
-
how to add workspace to user in Admin in Access Control - Assignments
Hi everyone i have encounter today as an admin in Anaplan. one of the user has no access in one of our workspace. this is the users access under Users-Internal-Workspace. but upon checking in Access Control - Assignments, FP&A is not selected.
-
How to import text formatted line item from the module saved view which has no dimension
How to import text formatted line item from the module saved view (no dimension) to the module which has dimension When I was trying to do import the name of the Line item got imported: Pivot of the SV was: Line item in rows When I changed the Pivot of the SV for the line items to columns it wasn't importing any thing I…
-
What is the method for notifying all users with a specific user role?
Hey everyone, I'm reaching out to the community to see what methods you all may find most effective in notifying all users of a specific user role. I believe creating a user role module may be an effective route, but would require the user role module to be manually updated. I thought perhaps you could export the Users…
-
L2 Sprint 2 - 2.3.9 Activity: Historic Volumes to Baseline Forecast
Hello, I keep seeing the following error message: Invalid formula: 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DEM02 Volume Growth Rates by Week'.Growth %, -52, 0) ELSE 0 For function OFFSET, all line item arguments that vary by time…
-
Show all data labels in graph
In the NUX, line chart will not show data labels that are within 0.5% of each other or bar graphs that are within 3% of each other. This is a big issue for reporting purposes in the apps as it's hard to compare various KPIs and metrics to each other in the same period. This primary affects business/end users. We need a…