Data Integration

Error in DAT03 Historic Volume from Data Hub
All data is not getting captured , please help why data is getting ignored.
Time Ranges vs Model Calendar
Hello, I had a technical question around Time Ranges. Let's say my Model Calendar is set to FY21 Jan-Dec, I have 2 past years and 2 future years. I have some planning and assumptions modules that are only relevant for me for the Planning period. So I develop time ranges to save sparsity and reduce cell count in my model.…
NO Values is coming in DEM03
Need help for getting data to be updated
Level 1 Exam Time
Hello! I am getting close to taking the Level 1 Exam and was curious to know if there will be a time limit for this first exam? I just want to make sure I can plan my day for taking this test. Also, are there any lessons or resources that you would suggest I review again prior to taking this exam? Thank you!
Excel Add-in for Mac
Some of our clients use Mac computers and it would be great if you could develop excel add-in for Mac OS too!
Delete list items based on a line item value selection and then clear the line item value
This seems an easy solve and I thought I'd done this on a previous project, but still having trouble. What I want to do is delete items from our Transaction module based on a Period selected in a Data Management module and then run another import to clear the selection made in the DM module. The Transaction module in the…
delimiter options for exporting files from Anaplan
I love the two way integration that Cloudworks brings but there is a need for more delimiter options when exporting from Anaplan back to Data Lake. Example changing the delimiter from "," to "|". More export file options is needed.
How Do You Upload Future Fiscal Year Calendar?
Hi - Our fiscal year is ending 12/31/22 and I need to upload our 2023 calendar into Anaplan but do not know how to do so - does anyone have documentation or a manual on how to do this? Thank you!
List of entities does Anaplan has.
Hi All I wanted to know the list of entities that Anaplan has. also wanted to know the supporting data types and operators too. Kindly help.
whether Anaplan provides JOB BASED ID or ANY ID or JOB BASED QUERY or JOB ID
Hi all Wanted to know whether Anaplan provides what kind of JOB BASED ID or ANY ID or JOB BASED QUERY or JOB ID. Whether Anaplan supports Google BigQuery? If yes what is the process. (Any API Support for this)
How to export result as .csv file through Anaplan Connect script?
Hi Experts, I'm trying to explore on Transactional APIs scripting. When I execute below script is working fine and extracting all the List items. But I want to export this data as .csv file, how to achieve this? set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -L I tried…
Data Load through One Cloud problems
Hi, I'm having a problem with a Data Load that comes in from One Cloud. The Process works fine when the Flat Files are loaded in manually, but when we try to do the same Process through One Cloud not all the data is coming through, (all my List Items are not pulling in the data). I need help trying to figure out what the…
Distinct count of Agent with comparing Date and Program
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
Create Shipping Export Module and Create a Saved View
Hello Community!! I am stuck at the above activity, can anybody please guide me what the mistake is?
Data Load Time Setting help
Hi, Having trouble loading in the attached data set. I'm getting a error with my time settings. Please advise. The Flat File is attached. Thank you Error Time Setting for the mapping Blue Print of module
Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module
I'm attempting the following...In your model, open the SYS03 Country Details System module in Blueprint view. Add the formulas to the line items: Line Item Formula CodeCODE(ITEM('G2 Country'))RegionPARENT(ITEM('G2 Country'))Country Only?TRUE When I add the formula, PARENT(ITEM('G2 Country')), to Region line item I receive…
Import Question
Hi, I currently have a Process that uses the same flat file to load data into my List and than my Module. I do not know if I need to upload the same file twice for both the List & Module like in the pic below? please advise.
Clarification on Anaplan API / REST API
Hi Experts, One of our customers would like to integrate through API / REST API to pull and push Anaplan data. Can Anaplan API's do push? meaning can Anaplan call the Client APIs to push data to client’s database? Thanks for your attention. I'm looking forward to your reply. Thanks & Regards, Anil
Import clearing data that's not in the saved view
Hi all, I'm stuck in an weird import action. My goal is to clear data in few line items via an import. My module has 2 dimensions (one is native time and the other one is sales reps). This is a screenshot of my module view. This is the saved view I used for import. First I created clearing line times with No Data format…
Is there anyway to omit weekly summary when export or hide weekly summary
Hello, Is there anyway to hide the weekly summary level when export. when i check omit summary it also omit monthly levels Select levels to sow is also disabled
Populate Currency module using Currency Rates.csv
Hi I am trying to do import but there is no 'column header' option to select for time why? how to resolve? Roya
Create Demand Export Module and Create a Saved View - DEM04
Hi, I am trying to do this activity: Here is what I did for DEM04: And this is my export view: There are two problem comparing with the expected result 1. The SKU Code and Location Codes does not appear in my saved view.( I put all line items as column) 2.The Demand amounts are not correct, here is the expected view: I…
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
Create Shipping Export Module and Create a Saved View
Hi All, Can someone help? I am currently Working on INV05 Shipping exports Module. I have set the Formulae As attached screenshots Below. But the shipping cost In inv05 is mostly zeros. Attached screenshot is form Inv01 module Thanks.
level2- Import Shipping Expenses into OTH01 Module
Hi, I am trying to import to OTH01 module from this saved view: Ans this is my import setting: I got this error message: Could you help me to find the issue please? Thanks Roya
Duplicate Process feature
Need a way to duplicate the Process instead of manually creating new process and adding actions again
Restrict Users who can Run Action
Hi, I want to restrict users who can run import Action. There is Role function in Anaplan, and it can restrict users. But I think the master management of Role function is too difficult, because Role function has another Modules and Lists roles. It is set None as default. So I should set modules and Lists Roles. I want to…
Trying to filter by a Yearvalue with a nested Lookup to pull list parent
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add the ability to filter by a third category, Division. The way the module is currently filtering the data in the export action…
Historic Volumes data
Hi Can anyone reply to the below I am also facing same issue with time scale the Hint says NOTE: The Historic Volumes data includes the ACTUAL sales volume of product SKU from FY19. The Supply Chain model's Model Calendar begins in 2020 and does not include any previous years. If you run the Import Process as-is, you will…
Date Format Issue when exporting from Anaplan to BigQuery with CloudWorks
Anaplan is using an unique date format “1 Jan 22” and “Jan 22” as opposed to “2022-01-01” and “2022-01”, which are common in data science. Therefore, when exporting data from Anaplan to BigQuery through CloudWorks, the date column needs to be formatted as string, because BigQuery can’t read “1 Jan 22” as a date. There are…

Upcoming Events

Anaplan Academy Open Office Hours [AMER]
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Anaplan Academy Open Office Hours
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in February as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process…

Data Integration

Discussion List