-
Data Import : Ignore all by default in mapping
It could be great to have a feature that allows to ignore all fields by default during data import mapping. As of today we have the options to "Match", "Ignore" (unitary), "Clear" (unitary) and "Clear All" mappings. It would be great to have an "Ignore All" button to handle only exceptions.
-
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi everyone, I'm having trouble importing this into DAT03 Historic Volumes. I've been at this for 3 hours and I'm not sure what's wrong. Can anyone help? I can't move on to the next activity until I get this right. Thank you.
-
Search Function within Edit Process
It will be great if there is a search functionality for a specific action within the Edit Process (or Create Action -> Process), especially useful for a model with long list of actions. At the moment, I need to search the action from Actions pane, note where its position is i.e. top, middle, or bottom of the list, and use…
-
Pulling data from Power BI to Anplan
Hi All, Is it possible to pull data from Power BI into Anaplan. I know it's possible to do it the other way round. But I need to take data from Power BI and push it into Anaplan. Thanks, Stu
-
Not able to access Level 2 Model Building: Conclusion
Hi Team, I have achieved 80% for Level 2 Sprint 3. But I am not able to access Level 2 Conclusion. Can somebody please help me with this? Thanks
-
Import Data from a saved view to another module - Production Data or not?
Hello Anaplanners, I have a saved view from one module that essentially captures the line item quantity at a moment in time and is saved into another module which is then referenced as the "frozen data". I know I need to change the settings for the import or the import data source as production data but am not sure which…
-
Regarding Anaplan Connect Script issue while intrection to Anaplan system via middleware route.
Dear all , we are trying to import via Anaplan connect script .Actually we have system flow as mentioned. Windows server(Anaplan connect script run) -----> Data power Server(middleware for security reason) ---- Anaplan Cloud system(model ,workspace) if we are executing script via using certificate based authentication…
-
Anaplan-Informatica Cloud Integration
Hello, I'm hoping someone has had this error and was able to resolve this. Would like your help on it. I currently have a Dev and Prod model setup and I'm using a simple import to a date-formatted line item action to refresh the current date. I was able to set it up on my Dev model and it works perfectly. But when I…
-
Data Export Script error.
Dear Expert , Looking for your kind guidance , I am trying to export the data via script . we have been given process to use in script to export the data from Ana-plan . When i am passing the Details in Script i am getting below shown error And Script sample as below which i am trying to run. set…
-
Anaplan Tableau Connection error
Hi, We have a refresh extract set up between Anaplan and Tableau Server however it's not very stable. Here is an example of the error message we are seeing: com.tableausoftware.nativeapi.exceptions.DataSourceException: Name: Ajax Module unhandled error Message: {"jqXHR":{"readyState":4,"responseText":"<html><body><h1>504…
-
Import Numbered List
Hi, I'm trying to import into a numbered flat list using a module saved view and the list is returning only the Number ID and not the names. I checked the numbered list option in the General Lists menu and added a display name property formatted as text and selected it from the dropdown menu in the General Lists menu. I…
-
level 2 1.3.3
Hello I was wondering if everything imported correctly. The excel sheet is what I was taking the data from.
-
Talent Builder Beta Access
Hi there I have registered for Talent Builder free 90 days beta access and was able to complete Level 1 and halfway through Level 2 certification. Unfortunately, I wasn't able to complete it within the allocated time. Would like to find out what are the options for me to complete the pending Level 2 certification. Should I…
-
Questions about Statistical Forecast
Hi, we are trying Monthly Stat Forecast Model. (https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359) And we are doing the functional verification. I check the model, but there are somethings I don't understand. Q1. Can we use specific history data? ex) Using 2018-2019,2021-2022 data as…
-
Anaplan Connect: Master Script
Prerequisites: * This article is designed for those more advanced with Anaplan Connect. * Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The Master Script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more…
-
What Is The Use Of Dashboards And Reports In Anaplan?
Hello I wanted to have information about the dashboard and report in Annaplan. Thank you for your help.
-
Level 2 DAT01 Inventory
I have imported data into DAT01 but the inventory amounts are not correct. I have attached my mappings but my issue is with the Distribution Centers. They aren't matching and when I check my data against the import, the values don't match correctly. I also added a filter to not show inventory that is 0. Thank you for your…
-
Anaplan Excel Add-in 3.4 Error
Hi All, A colleague of mine is working with a report in Excel using the Anaplan Add-in version 3.4 and is receiving the attached error even when opening the spreadsheet. On other occasions when she clicks on the Anaplan ribbon in Excel the spreadsheet crashes without an error message. She had issues with Excel crashing…
-
Question on how to map miss-matching dates
Hi, I would like to know how to match my flat file's when my dates on my flat file and Anaplan do not match. Usually I end up having to manually match them. Please advise. snap shot attached below. Thank you
-
[Start Here] Power BI - This is how we use it. Part 1: The basics.
Welcome to the best practices series about the Anaplan Connector for Microsoft Power BI. This is the first of a three-part series designed to help you understand why and how to use the Power BI connector by covering the basics, the set-up, and a real use case. Let’s begin with Part 1: The Basics. What is the connector for…
-
Level 2 Sprint 1 SYS07 mapping
Hi, I'm trying to import data into SYS07 module. I'm not sure why the region and countries are not being mapped. As fas as I think it is due to the region being names(America, Europe) and not being codes (EMEA, APAC etc). Same with the countries as well. Is that correct? If yes, then how do I resolve it? Thanks.
-
History update lag
When tracking the bulk data imports in my model, I'm noticing there is a lag of what is presented in the history export. In other words, if an import happens at 4pm and I check the last 24 hours history at 4.10pm, I will not see the changes yet. If I check some time later (around 1 hour later), the updates appear with the…
-
Retrieve Anaplan Field from API? Cannot export in platform.
Is there a way to retrieve the following field via API or Transactional API? I noticed that there is no way to Export it via the Anaplan interface but am hoping there is a pathway to retreive it through Python or some other API tool.
-
Maximum Number of Chunks to upload huge file using API
Hi, I have a 5GB file to upload in Anaplan using API. The API is working well for smaller files with 500MB data and 25 chunks. But when it comes to the huge file, it gives the below error. Import connector: Error obtaining input stream (caused by: File not found) Is there any limitation on maximum number of chunks to…
-
8.3.2 REV02 Upload Issue
Hello! The imported data for REV02 repeats each month, I checked all the common issues/how to fix it and I am still stuck. * Header Row: 2 & First Data Row: 3 * Time: YYYYMM * G3 and P2 hierarchy is correct + matches with the import data * model calendar is set for 2020 with a year prior and future. First time posting in…
-
Looking for my first Anaplan role
Hi, As a long time consultant and solutions architect for Oracle Demantra (20+ years) I appreciated the capabilities and approach of the Anaplan platform and saw it as my next career direction. I am trained and certified Model Builder (1,2 and Anaplan Way) thanks to the talent builder program. However, without real life…
-
tenant swticher - copy models
Hi I have a partial solution but I want to : I want to copy a few models from Anaplan Employee Training tenant - to my tenant - Anaplan Employee (Ravinder Basra) - please advise: see attached Models I want to copy are : L1MB-RavinderKBasra Formulas & Functions v1.3.0 March 2018 ravinderBasraLevel1ModelB2.0(newUX)(27) thank…
-
Power BI - This is how we use it. Part 3: Use Case - Leveraging Power BI Service.
Now that you know the basics of the Power BI connector and how to set it up, let us move to a real use case; Why using Power BI Service could help you to get the most of the Power BI connector? The blocking nature of exports When a user performs an export, the model is blocked from usage (entering or manipulating data).…
-
Power BI - This is how we use it. Part 2: Setup [Updated March 2022]
[Update: March 2022 - Limit increased to 5GB] In Part 2 of our Power BI - This is How We Use It series, we're diving into how to setup the Power BI connector. Need a refresher on the basics of Power BI? See Part 1. Ready? Let's start. Anaplan export setup Anaplan connector for Power BI supports Export actions to extract…
-
3.3.11 Activity: Create Saved Views for UX
Hi Team, This issue is not related technical just typo issues in the Level2 Sprint3 3.3.11. please have a look the screen shot which i have highlight. Just to make correct. G Hari vinay kumar.