Data Integration

8.8.2 Activity Add Formulas to Country Margin Report
Hi Community ! 😊 So Im completing the training and Im suppose to have the same page as my screenshot below : But Mines Turned out like this : Some help would be appreciated Thank you in Advance ! @Akhtar.shahbaz Im not sure if I should change it back to sum But i dont think so .
Help on 8.5.3 import data volume inputs module
Below Im trying to map everything out. Im currently trying to complete the activity. I looked over the instructions this is my screen shot : But I have Volumes on the other tab The product code is not showing as an option just saying the word column.... @Akhtar.shahbaz Please and thank you 😄
Export action not working properly
I am not getting the export as i selected in saved and drop down
Export action not working..
HI All, I have a module there i have saved view for export. when i exporting in module its showing correct data. when i create the action button and run and see the results its diffrerent . please expain the issue.how to rectify it.
8.2.2 Add volume input modules
My dates are not showing. It is only showing Jan Instead of the training screenshot . Its suppose to look like below: @Akhtar.shahbaz @ryan_kohn Please and Thank you
2.3.9.1 Import data into DAT03 Historic Volumes module- time mapping problem
Hi, I am trying to Import from Data hub. This is my mapping: And I got this error message: Any guidance regarding this? Roya
Import Shipping Expenses into OTH01 Module
I have been trying to import for the shipping cost line item in OTH01 Non Employee Expenses Module and still getting code error. Help me in figuring out what is wrong?
S3 Integration with Anaplan
Hi All, I have a scenario where I need to import a file from Amazon S3 every month but the catch is file name will be "abcd_mm-yy.csv" where every month file name will change this scenario will be automated how can I work on this because using the cloudworks I have to choose file name manually. Regards, Venkatesh
Data Upload in Module
Hi Team, I need the below requirement. Ex:- If I already uploaded data from a CSV file for any month in the module and if we try to again import data for the same month we can't upload. Is it possible in ANAPLAN?
Too much data in view, access token expires during data extraction.
When extracting a large amount of data from a view in api, there are too many pages and the access token expires during pipeline execution. After initiating the request, the access token expires because the time spent preparing the data and downloading the page exceeds 35 minutes. The VIEW of data to be extracted has 1…
Request to retrieve data from view is not initiated
I want to import data from Anaplan to Azure, but the request to import data from view is not initiated. Also, it happens sometimes erratically. I would like to automate this process through a pipeline and would like to solve this problem. Since the request is not initiated, there are zero pages available for download after…
Unexpected API(POST) Error
I want to import view data in the Azure Synapse Analytics pipeline, but I am getting errors in creating the request. The error statement is this, is the Body wrong? ・Error message { "errorCode": "2108", "message": "{\n \"status\" : {\n \"code\" : 400,\n \"message\" : \"Missing or invalid body\"\n },\n \"path\" :…
Import Action not found in the Workspace and Model
Hi Team , Using Anaplan Connect , I'm trying to bulk import from database to Anaplan. I have created a script to import data into Anaplan and also JDBC Properties file. I'm getting an error like Action "Import Action Name" is not found in the workspace "XXXXX ID" and Model "XXXX ID" But when I check the import action list…
Use Gregorian calendar week numbers instead of fiscal week numbers
Hello community, Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601. This makes it very confusing for users to adapt to these new week numbers, especially when users…
Error in PDF export of an Anaplan report
Hello, Since this week, the PDF export of Anaplan reports is messed up. More precisely - the first slide is OK : the pdf appears exactly as the slide in Anaplan - but all others are truncated : only half the title is visible for instance (see also the two snapshots). Note that last week, all reports were fine. Now, even if…
Create Sequential Code for New Activity
Hi Team, I am trying to create automated code for the new activity I added to a numbered list The format should be like this: Department code - Activity Sequential Code (the structure attached for example) I've tried to make a system module, but the activity code still has duplicates. Is there a way to make automated code?…
Import from Numbered list module
I am trying to import from a module in a model which has weeks as a numbered list, into a module in a model which has weeks as its timescale. I cannot get the import to recognise the dates from the source module, and assign to periods in the target module. Is this possible?
Dimension Reorder affects any view or Actions
Hi Everyone, I Need to implement planual in which I need to reorder some Line items applies to Lists(dimensions). I want to make sure that this reordering of Dimension should not cause any issues in View(Custom or saved) and Actions. Please Note I am not adding or deleting dimensions in modules just reordering dimensions.…
Cloudworks internal user not showing in source model
Hej! At one of our customers, I created an import from one model to another which should run through Cloudworks. Both models are in the same workspace. Source and target model have a Cost Center list with selective access. The modules in both models concerning the import use this list. In the target model, the "Internal…
Insert and delete data in Anaplan
Hi Team , I'm trying to insert and delete data into Anaplan using below API. Insert : Delete : Is it the right API to insert and delete ? How can I get the Data's task id ? and how to ensure the insertion and deletion of data in Anaplan Thanks in advance Regards, Vinoth Kumar K.
Level1 Training 4.6.5 Activity: Import Data into G3 Location List
How can I set Mapping ? Is it correct below? -Mapping Column2: Location Name => G3 Location Column3: Country => Parent Column1: Location code => Code -Items uniquely identified by Name or Code
Boolean value from a Time Dimensioned to non-time dimensioned module
Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
2.3.9.1 Import data into DAT03 Historic Volumes module
The instructions in Level 2 model builder say to follow these steps. * Run Process 9 Import Data from the Hub. * This will pull the data into the Supply Chain model from the Data Hub model. * Make adjustments in order to avoid errors in the import process I got no errors running it and everything imported without me…
Setting ChunkCount
Hello Community, I have read the documentation of Anaplan to learn how to achieve export actions. Firstly, I have remarked that it is recommended to set the ChunkCount to -1 rather than set the exact count, but i didn't find the reason or the explication for this recommendation. Secondly, if i choose to set ChunkCount to…
Import data lists
Hi, I'm trying to import a data list, I have put all the correct details and the file imports successfully, but then in the anaplan list, nothing appears. There are 400 entries and 0 come through. Thanks Piyaa
Uniques Identifier as code for a Numbered List
Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its parent and I am Planning to use Unique identifer as a code for that List as Name(Item(Activity…
Organize Anaplan 365 Cards by Model
The Anaplan 365 Add-in allows a user to save Cards as Templates and then subsequently import then into a Microsoft Product like Excel. However, for a company with many Apps or Cards saved as Templates this can get confusing since there's no organization to Cards within the Anaplan 365 Add-In. Names also get cut off so…
Provide detailed log on cloudworks
As an integration admin, it woulf be very useful to be able to get (through api or the ui) a log detail of the last cloufworks run for a given integration. This is necessary as the current error messages are a bit cryptic to understand like "process failed"
Community perspective: IFO – UPPER and LOWER to the rescue
IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to "Its First Occurrence" to prevent duplicates being imported into its target list. This keeps the action results clean and optimizes…
Untangling Anaplan time mapping in imports
There are four cornerstones in The Anaplan Way, with data being one of them. We all know that we should spend at least 1/3 of the project time on data alone because this is the cornerstone that we have no control over, and it needs to be thoroughly investigated and understood. One of the important things to consider about…

Data Integration

Discussion List