Data Integration

Ability to add dimension headers in exports
There should an option to add the dimension header that are placed in rows while exporting by end user using the export option is grid. For example if I am using the SKU list as the row dimension and user is trying to export the data from the grid published in pages, there should be an option to get the SKU as the header…
Anaplan Connect concern
Hi, I am currently having issues with my script using Anaplan connect and I hope someone could help me with these: 1. How to do a loop in a file directory in Linux? - I have this file directory where all my files are starting with Test prefix (Sample: "Test1, Test2, Test3"). I should be able to run all Test*.txt items in…
L2 Sprint 1 G2 import from SYS06
I am trying to import SYS06 data into the G2 Country List. I have reloaded my Country flat list. When I ran the import this is the result I got:
Mapping error with dates
Hi, I'm getting a mapping error with my dates because they are not formatted identically. How can I fix this without going in and mapping each date to one another manually? Thank you Pics attached
L2 Sprint 1 G1 Import from saved view in SYS05 Region
I have been trying to import the saved view in SYS05 Region and I keep getting errors and I don't know why. It seems like there is a disconnect between what is in my G1 list and SYS05 Region file. Thank you for your help.
8.3.2 REV02 Date Upload problem
Hi All, I am uploading data into the Level 1 Practice model for lesson 8.3.2 and am having trouble mapping dates- the format I am using is showing invalid, even thought I have selected the periods>YYYYMM format. Any troubleshooting ideas would be appreciated!
Sort function missing "OK" button
Hello, I am trying to complete Activity 12.4.6 in Module 12 of Level 1 Model Building, but my sort function is missing the OK button to implement by sort. I've tried restarting my browser and computer, but no luck. Has anyone else run into this issue?
PowerPoint Add-In
Hello, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the PowerPoint Add-In? I am unable to select a module that I want to export to PowerPoint.
Setting chunkcount for export actions
I noticed that every time I save an export definition, the chunk-count definition is set to 1. However other files created earlier have their chunk-count set to 0. Is there a way to select the chunk-count definition when creating an export action? (small file, no need to chunk. And only files with chunkCount 0 or large…
What should be the date format for jan-20 while importing in to lists
In the attached source file how to import in to the list with format jan-20 and what should be custom fixed position....
Anaplan and Google
Hi Anaplan community, Last month, Anaplan published an interesting video about Google Cloud. I wanted to learn the study case or training materials that explain Anaplan functions in Google Cloud, AI & ML. I need advice for the Anaplan community, please. Thanks,
L3 MB Instructor Led Training
Is there any instructor led L3MB course that I can purchase?
DigitalCPX 2020: Expert Advice: Anaplan API & Python w/ Christophe Keomanivong
Fully on board with Connected Planning? Looking at expending your sources to the world wide web? In this session, we will illustrate how to use Python to import data into Anaplan from any remote source. https://www.youtube.com/watch?v=MyhxirGAGI8 We will focus on getting started using Python as your steppingstone for…
Number of Actions assigned to Process
Hi All, Is there any limitation of numbers that have to be assigned to a process? Ideally how many actions a process can run via Anaplan? Thanks, Aish
Delta load to Anaplan with informatica cloud(hyper connect)
Is there a provision to load only the change or new data instead of importing the full file to an Anaplan module in using Anaplan/Informatica Hyperconnect?
Anaplan with google cloud/ Apigee
Hi Anaplanners! I was curious to know if anyone has any exposure on building Anaplan models integrated with Google cloud/Apigee. I was wondering to know if there is any native connector between Anaplan and google cloud /apigee. If there is not any connector, does anyone know what should I do in this case? Thank you!
Fail a process if any subsidiary action contains errors
I would like the option to fail an entire process if one or more actions within that process contains errors. For example, if any errors exist when updating a list, I do not want the next import to run that loads properties of that list into a module.
Level 2 badge
Hi I completed my level 2 on 23/02/2021( attaching the certificate for proof) still I haven't received my badge. When can I expect the badge to get issued? @Misbah
Anaplan Connect Error
Hi All, I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error. > > _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO…
Level1 Model Building: Import into DAT01 PL Actual and Budget module failed
Hi All, I am facing issue on importing data into P&L Actual and Budget Module For your information, i have mapped time as Period (YYYYMM) Import into DAT01 P&L Actual and Budget module failed: The column headers in the file you are attempting to import do not match the import definition. Have attached mapping and error…
Scheduling refresh in Power BI
I am using Anaplan Connector for Power BI to export data from Anaplan to Power BI, instead of manually refreshing, is there a way to schedule the refresh in Power BI ?
Import failure based on module cell count?
I have just submitted this to Anaplan support, but wanted to run it by the Hive Mind. Any insight into what's going on here would be appreciated. I will update this thread with any answer I receive from Anaplan support! We had a very puzzling issue last week that prevented loading of data. We resolved the issue, but the…
Jumbled Process
Hi All, I have a process named "Import From Data lake SP SG FOM" where lots of actions were placed. For instance, My actions in the following order . Today date.csv and import stock Expiry DC-9205,9209,9207 are to be uploaded files. When I publish the process in the dashboard and click to upload the files, the upload…
Level 1 Model Building: Import data to SYS06 Product Details module
In Module 7 of Level 1 Model building, we are asked to import product data into the Product Details module and map to the source. However, my mapping does not seem to be accurate, and I cannot figure out the issue. I've attached screenshots of what my mapping looks like, as well as what it results in. Any and all help…
level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module
Hi Community, I am getting an error when i am running process to import historic volumes, beginning inventory and shipping metrics from my data hub model. i think it is due to list used in both modules. In datahub module according to instructions i have used " SKU flat list" and in supply chain module "P3 SKU" list is…
Excel Add-in options
When we produce monthly cost report, we need to keep apart every department because are confidential data (every department can't know the other departments expenses). With the previous tool (BPC) we could exclude empty/zero cells, select the single department and refresh data every month: was not waste of time. Now, if…
How to Edit Status setting in Informatica cloud under Monitor tab
My teammate can see a resume option when she hovers over the status under all jobs in the Informatica cloud. I don't want to restart my job but unfortunately, I cannot see that option.
Anaplan way training not able to access
Hi, I am trying to do Anaplan way course and I am on Lesson 5 . I have completed the lesson and knowledge check some 5 times but still the next lesson is not getting activated. please help. it shows 95 percent complete. only knowledge check left. even i have done the test 10 times. it remain same as 95 percent. what could…
Pull the mapping for Imports and source for each model in a tenant
Currently, the only way to extract the information for Import and source mapping is from individual model through the Anaplan interface. These mappings are very useful to track how the data flows across different models and files. To be able to identify how the data flows using this metadata is going to help eliminate a…
Anaplan Connect - Java Keystore Authentication Failure
Hi Everyone, I am currently trying to get past the authentication stage of Anaplan connect using a batch file with java keystore. However I am unable to get past the authentication stage, below is the screenshot of the error: Was wondering if it was an error on the or my batch file (and not the authentication details) The…

Data Integration

Discussion List