Data Integration

Year Total Showing Before Quarter
I have not had this issue before (or at least I don't think I have), but I created a revenue view and the year totals show before the quarters. I'm not sure why. I checked some other models I've worked and this isn't an issue. I have not "selected items to show" on time so that's not an issue. There is no sort on the…
Anaplan & OneNote... What tools do you use?
Hi All, I've always been a fan of OneNote, but I really began using it extensively when I starting working in Anaplan. It even maintains my nice-looking A+ for Anaplan formulas. I'm curious if any of you have other tools you'd recommend using with Anaplan?
I am stuk at 1.7.3.2 Import into SYS08 SKU Details module
I am trying to use the data hub saved view 'SYS12 SKU details:Import SKU Details. But could not map the source data. Please help.
Anaplan Excel Add-in 4.0 Crashed every time after clicking on Sign-In
We have observed an issue since today(Oct-9) Issue:Excel getting crashed when trying to Sign-in and observed it in multiple systems.is there any work around for this? Steps:1)Open Blank Excel work Book 2)Click Sign-In and enter details 3)Click on Sign-in and Excel crashes post clicking on Sign-In Thanks, Uday
Condition-Based Trigger for Email Reporting
The current MAILTO function requires clicking the cell in order for an email to be generated. It would be very helpful if this click action occurs automatically only if a certain logical condition is met. For example, if the sum of all sales from last week reaches a certain threshold or is below a certain threshold, the…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Level 2 - Introduction - Lesson: Project Stakeholders
Hi I have just started Level 2 - Introduction. I have read that the SKU of products will be used in this level and wanted to refresh my memory with Level 1 SKU imports. This is when I noticed that the SKU in Level 1 exam file is EN for all of US, UK, Canada and Australia. File attached. Was it meant to be like this? The…
Question on Beta(90) access
Hi Anaplanners/experts, i am new to this Anaplan world, i opted for 90 days access and it was approved. i am not sure how to get the Platform access to Anaplan. please advise. thanks in advance. Regards, Sai
Default Export File Type to CSV
This one is simple. Anaplan's recommended export file type is CSV, yet the export dialog defaults to Excel / XLS. Yesterday we had an integration mysteriously run for 7 hours, later realizing it was because the export file type wasn't changed to CSV. Please allow model admin to set the default export file type to CSV. This…
CloudWorks
Check out our Community Page for the latest on CloudWorks and contact your BP for more info! GA currently scheduled for approx. 24th October 2020 so keep watching!
Order Issue when importing to a numbered list from a HUB module
Dear Community, Background: I have an attribute module in the HUB to manage a list (non-numbered). Further, I've built a process to build (by importing) the list in the spoke model as a numbered list. A numbered list is required in the spoke model because it is the lowest level of a hierarchy with duplicated names. Issue:…
Alphabetically ordered list
Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ? Regards,
Anaplan Connect Import source file
Hi Experts, I hope all is well and safe. Would like to seek your assistance with regards to Anaplan Connect script source file. Noticed that when I run the Anaplan Connect script it keeps on getting the old source file in the import process instead of the new source file declared in the script. Please see attached file as…
Cross-workspace data link
Hi, need some explanation as what is "cross-workspace data link" which is eligible at enterprise level edition ? Tried a few search, but nothing relevant showed up. * Could you please enlight me and what use cases you believe this has the most value for you ?
Level 1 Model Building Exam - Model Buliding Activity 4
Hi, I'm trying to download "Employee Details By Role.text" data but it down loads in to the internet explorer. I have attached the screen shots. Can I please request some help on this. Regards, Nayani
Easily Integrate Data From Google BigQuery With Anaplan Connect
Users can leverage Anaplan Connect for bi-directional integrations with Google BigQuery. This free connector makes integrations between Anaplan models and Google BigQuery via Java Database Connectivity (JDBC) drivers that leverage the power of BigQuery's standard SQL. Users can easily pull any data from BigQuery—such as…
Partial Mismatch in Anaplan vs Scrum Methodology
Colleagues, hi! Is there any specific reason why in Anaplan Way we change the terminology for basic definitions? Project Sponsor = Product Owner Master Bucket = Product Backlog Sprint Bucket ? Not even sure as based on Anaplan Way training Sprint Bucket populates specific sprints in a release This is especially odd when in…
Level 1 training program Anaplan model builder | Level 2 training program Anaplan model builder
Hello guys. how long does it take to complete the Level 1 training program Anaplan model builder? how long does it take to compete the Level 2 training program Anaplan model builder? it seems a lot of learning material. what is the best practice; (only to fly above as fast as possible)? or take a note of everything that is…
Refresh button and Pivot button Disabled
Hi All, I had installed the upgrade version 4.0. Now when I login, the Refresh button and Pivot button is disabled. Kindly help in getting this resolved. Thanks Ujjwal
Duplicate item in the import file
In User storry 2.2 we need to update the territory with the accounts name, but each account should be map to a Single territory. At 4.4 we should update Territory to accounts with the file. But the file have one duplicate and generate the followint Warning.
Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)
Hello, I am trying to run an export action using Certificate Authentication but i am getting an error. Below is my script and the error, any help would be appreciated! My script is: @Echo offrem set CertPath="C:\certs\cert.pem"set KeyStorePath="C:\certs\AC1.4_keystore.jks"set KeyStorePass="keystorepass"set…
How to upgrade from 1.3 Anaplan API to 2.0
Hello community, Could you please tell me how to upgrade from API version 1.3 to 2.0? Thank you
Level 1 Exam - Model Building Activity 4 importing data file Employee Details by Role.txt
Hi The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help. Regards Thiru
Filter with time as page selector
Hi, I am trying to create an import with user input and have time as pageselector. When I created a filter to import data with the rows having user input and time as current page it actually filters first and bring the data for all time periods. Now if I bring time period to row and apply filter it bring multiple year data…
Upload a file (internal error)
Hello, I try to upload a file in my model, with API via a windows script like below. I try to upload like the api use requirements, but I ave an internal error on the second step STEP 1 : upload a file as a single chunk CURL --user user@xxxx.fr:password --header "Content-Type:application/octet-stream" -X PUT -d…
Clear the Target for a Module Import
Hello everyone: Anaplan provides a lot of flexibility in regards to clearing data prior to imports. You can read about all the available options here. In particular, I am referring to: * Clearing the Target for Time * Clearing the Target for Dimensions other than Time I have always used the default settings such as Clear…
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
Need help in importing data into module
Hi I am trying to load data from .csv file into Module using import option. Data from one column 'PO Approved Date' is not getting loaded into the module.Please see the screen shots attached. Any help would be appreciated. Thanks Regards Prabakaran
Consuming Anaplan Rest API 2.0 from Java
Java Spring Boot Framework Provides an easy way to interact with the API. It can call any application Base API and process the Response according to our needs. This article explains how we can invoke Anaplan Rest API using Java Spring Boot Framework. To start with, we must install the below software and SDE to run the…
NEW BUTTON I ADDED TO EXPORT THE GRID, DOES NOT ACCEPT THE FILTER SETTING
Hi guys. previously, my task was to add a new button to a dashboard, that include an export action. 1) now this is completed because of your help. 2) this new button exports all the data and this is problem 3) new button and included action does not accept the grid filter setting, and the export is always like everything…

Data Integration

Discussion List