Data Integration

Excel Add-in: Filtering options
Hi, The Pivot & Filter's Filter dropdown functionality does not operate how most people (generalizing) are used to dropdowns working in hierarchical list . Please see screenshots below. Here I have regions, manager names, apartment properties, and floorplans coming from anaplan in a hierarchy. When I uncheck an item at a…
Excel Add-in - Add Ability to remove connection from tab
Hi, Currently there is no button or feature to remove an Anaplan connection from an Excel tab, only to add a new one or modify an existing one. Please add a button to delete a connection. Thanks,
Show/hide data labels for end users on a chart card
It could be great if end users can have the choice to show/hide data labels on a chart cards, or as an option for export. we think it's more ergonomic to hide them on a board and display the tooltips. However, this poses a problem when a user wants to export the chart card because he does not have this option.
Excel Add-in: refresh all connections in a workbook at once
Hi It would be great if you could refresh all connections at once in one excel workbook. Currently, each sheet has to be done manually. In some of our excels we use for reporting, I have 15-20 sheets as currently you can only have 1 connection / 1 sheet. This would help a lot in efficiency. Thanks Kinga
Google Sheets/Google Slides Add In
My team at AdRoll along with many other customers that I know of spend countless man hours every month/quarter exporting our Anaplan dashboards into google sheets and then into google slides just to get data in front of our ELT. I have seen this in this forum before which I believe speaks to the level of impact it would…
Excel Add In 3.2 Last Refresh cell
In Excel Addin 3.2, the 'Last Refresh' cell has been moved, adding a new row before the data compared to 3.0. There should be an option to keep the old format. This will allow users to upgrade from 3.0 to 3.2 where they have many formulas referencing data in a row which would be moved.
Excel Add-in: remove 1m cell limitation
Hi, Anaplan connection to MS Excel is limited to 1mil cells only. This considerably limits as to what we can do with auto update of data straight from Anaplan to MS Excel. Removing the ceiling on cell count will really boost the efficiency for data analysis. At the moment, users have to either reduce the selection by…
How to get job for anaplan L1 fresher In india
Hi, Do we get job after completing L1 for fresher ? Company Wants experience person only they don't want fresher then how we will get experience. Is there any chance for fresher also in anplan / (EPM)
Excel Add-in 3.2: increase cell extract count
In the current version of the Excel Add-in, it is not possible to create a connection to a saved view or module with a total cell count of the dimensions (rows x columns) greater than 1 million. Any saved views with hidden line items or filters applied will not have an effect on the view size and will therefore not…
Sprint 2 Question 6
Hi, I am unable to select an option for question 6 in sprint 2. I press the REVIEW PERMISSION DESCRIPTION after that I press CONTINUE and then I cannot select any option Does anybody went through the same problem in the past?
Trying to Run a Process in the Supply chain
Hi Team, I am trying to run a process, named "9. Import Data from Hub" in Supply chain Module to pull the data from the Hub When I am running this process then I am getting an error. And I am not able to understand what is the error about. I have attached the pic. Please guide me through. Thanks
8.5.2
I am having an error with importing to rev1. Check photos
Excel Add-in: Drill Down and Drill through to Transaction
In Order to effectively compete with Oracle, it would be beneficial to have Drill Down and Drill through to Transaction available in Excel.
Error
I am struck in middle of Anaplan way any one can help me
Custom Time Mapping
Hi Community, If the client has a custom time dimension file how would you go about mapping this file into Anaplan and then dynamically sum the sales by region by account by product by month? Find example data set below. I would normally do a custom time mapping to map from the clients time to Anaplan inherent time period…
Regarding Go To Market Certification for Partners
Hi, I'm trying to do the GTM Certification for Partners but not able to find the link or any other info for the same on the portal. Regards Naman, Wipro
Utilized import dashboard and pages disappeared
Has anyone else encountered the following: I imported dashboards using the Import Dashboard option within the APP. Renamed the dashboard from the generic name with the date and time of import. Lost all the page imports and am unable to create a new page or import the dashboard again and use the same naming convention. My…
Activity 11.3.2 Import data into P&L Actual & Budget - not working
Hi, I have been trying to import data into the DATA01 P&L Actual & Budget Module with no success. I have also checked the Example model and noted that there is no data in this module - I am not sure why? Please see my mapping screenshots Please help as I am stuck
7.2.3 mapping errors
I am having trouble mapping but can not figure out what I am doing wrong. I manually put in the dates for start and leave in the format YYYYMMDD as well. Can anyone help me get past this point without errors? Thank you.
Exam 1 review
@noelle_murphy Hey Noelle, I remember you mentioned that you were going to post a Exam 1 review session. Did you upload it yet?
Level 1 Model Building Lesson 10 - Import Data
Hello, I encountered a mapping issue when I tried to import the Employee drivers into the model. The source data has no time period but the mapping requires a time period. How do I fix this? Appreciate your help! Many Thanks Rachael
Docusign - Create Flexibility for Signing Order - Data Population
The Anaplan Docusign Integration currently has the following limitation: When the text fields are assigned to a non-first signer recipient, it will not work. Only the first recipient can be assigned those text fields and the data from the model will populate. For companies that follow the signing order of 1) Employee, 2)…
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…
Filtering text and numbers (NaN) in same module
Hi there, I have one module(saved view) which is the basis for an export to another system. This saved view consist of number and text (format), the export in the other system blocks when one of the number returns a NaN. Therefore we need to exclude these NaN. We thought we found a solution by creating a Line Item List…
"error parsing key for this row no values" error while Importing a list from a list in another model
Hi I do not have a module setup for an import of the list from another list from other model. and I get this error 'error parsing key for this row no values'. How can I get rid of this error. Thanks in advance!
Anaplan Way Online Training
Not so long ago I was able to start an online only version of 'The Anaplan Way' which didn't cost anything. There were quizzes to take, videos to watch, etc, similar to online level 1 and 2 trainings to some extent. Now it would seem the training is only available in person and for $1500? Hopefully I've just failed to see…
Data import error in Level1 training
Hi. I receive the below error when uploading the Employment Details csv file. It doesn't refer to a particular part of the mapping, so I have a hard time figuring out where to find the issue. My mapping setting is as follows. Can you please help?
How can I change my email id
Hi, Please help me here as I have changed my organization and for new organization I will be using different mail id. How can I change my email id from old organization to new organization in Anaplan community. Thanks, Vicky
API Python Workspace and Model IDs
Hello, I have successfully setup my Python environment. I did have a question around a specific requirement. https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150 From the above link, I have tried the “get models”, “get modelinfo”, and “getworkspaces” Python scripts. What I am…
Indicate the source module in a worksheet
Our users need to know the source module in a worksheet in order to be able to use the Addin Excel extension. It's possible to see it in a card on a Board, it is regrettable not to offer this information also in a worksheet. Board: Worksheet 😞 :

Data Integration

Discussion List