Data Integration

Transfer the value from one time period to another time period
hey guys Please let me know is there any function for Transfer the value from one time period to another time period Without using offset,post,lag need to transfer the values directly
Power BI enhancements and upcoming improvements!
For all of you PowerBI users integrating via the connector, have you seen the latest enhancements - the big step being the increase from 1GB to 5GB for data export. Also...I know this has been a bugbear for some and it is scheduled to be resolved as of next month - no automatic 35 minute timeout on authentication! Changes…
Importing data Into Half Year Columns or cells
Hello, I have a module where I taken time ranges in weeks and Available Aggregation as Half-Year. Now I have a source file with the time range of Half Year (H1 FY20, H2 FY20) (Except half years, I don't have a data in weeks or months in my source file) . In my module my half year values are aggregation of months and weeks.…
2.3.9.1 Import data into DAT03 Historic Volumes module - DAT03 Historic Volumes'.Export" failing
Hello Community, Need your help I am not able to pull the data into the Supply Chain model from the Data Hub model. I get following error. I checked older posts, didn't find a solution for my problem. I have attached all related screenshots. Can someone take a look and advise. 9.1 Import Historic Volumes Model object…
2.3.9.1 Import data into DAT03 Historic Volumes module
I am unable to match my training screen with Anaplan document. and i received fail message for 9.2 Import opening stock. attached documents is the screen shots of my actions please support .
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
CloudWorks—This is how we use it, Part 3: The CloudWorks API
In Part 3 of our CloudWorks - This is how we use it series, we will introduce you to the CloudWorks API. This is typically for an audience comfortable with REST APIs concepts and programming. If you need a refresher on What CloudWorks is, see Part 1 or, for how to set it up, see Part 2. CloudWorks API will allow you to…
export to S3 using cloudworks failing
I am trying to export data from anaplan to S3. I have set up the connection and it went fine. But the export fails with the message as follows: Your integration failed because of invalid connection. Check your integration setup and try again. Not sure what I am doing wrong here.
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…
Level 1 Activity 6 - No Medical Costs
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…
Importing and Exporting Data 1.4.3
Hi May I know how do I get rid of the "time"?
Will the Order list action works for End users?
Hi, Just want some clarity on the order list action in Anaplan. If I include order list action in any of the process which is being used by the end users will that action works for end users? I heard that the order list action only works for the admin. Can somebody clarify on the same Attached screenshot for reference.
Excel Add-In - Labels
Hi, When we export data from Anaplan we have the ability to add 'Labels' to the export. These cannot be added to the view as it would be too complex, but are pulled down for the Export, which is really useful. If we connect using the Excel Add-In can this be replicated. We connect to the view but i cannot see the option to…
1.3.4.2 Update SYS06 Country Details Module
Hi, I am unable to understand what's wrong in my selection. Please support
3.3.5.1 Create Inventory Ordering Module
Hi, may i know how to i import TRA01 to DAT02? Anything part which i may have miss out? not sure why my data is 0
2.3.9 Activity: Historic Volumes to Baseline Forecast
I am having trouble with 2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1 Import data into DAT03 Historic Volumes module. For the first part, I'm unsure what needed to be done, if anything. Then when I tried too run process 9, this is the error message I received. Can anyone help me with what I am doing…
Import a time range
As a model builder, I would like to be able to Import settings into Time Ranges. This would enable me to make Time Ranges more sustainable by driving their settings from an Admin Screen with actions.
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, Can someone help me out with this issue of running 9 Import Data Hub:
Import Shipping Expenses into OTH01 Module
I don't understand why we added the code line item to INV05 module. I deleted that line item and I was able to complete the import process without a problem (I changed the time format to MMM YY). However, I am getting errors in the presence of the code line item. I got the error "Invalid date or timescale identifier". When…
API call to determine if a model is currently busy
As a data integration owner, I want to be able to check if a model is locked/busy running a process before I initiate a new process, so that I can avoid running excessive processes and have smoother orchestration between my calls. I'll know this is successful when there is an API call when I can submit a model guid and get…
Azure Cloudworks navigation
Hi, At the moment its quit difficult to navigate through Azure Cloudworks processes and imports/exports. We are planning of having around 70 - 80 different integrations. Only thing what we are doing is naming Process names by numbers, but even so, number order is not working in all cases. It would be great if there could…
Anaplan Connect Export to remote server
Hello, I'm trying to run a script to export a file from Anaplan to a remote server. Here is the line: set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "myFile.csv" -execute -get "\\myRemoteServer\myFile.csv" But when i run it, it instead tries to find a repository called…
Data Integration Micro Lessons
Hi All, I have recently completed Level 3 model building and realized I did not have a background to understand all the data integration lessons that were part of it. I did get most of it but did not really get to appreciate the REST APIs and CA Certifications and the lessons/granularity around them. I wanted to understand…
Special characters import problem with Java Spring Batch
Hello, I have a problem when importing data to Anaplan. All the connexions work well, from my database to Anaplan. But when trying to import data with special characters (like "é"), they will be messed up. My database is in UTF-8 and the Anaplan model is too. Do you guys have any idea to where this could come from ? Thanks…
Anaplan Connect Error
Hi, im trying to create one anaplan connect script and when im trying to run its getting error . im passing the model id and workspace id as number only not in the string. but i think its takes the value as string. Server files not found: Server-Files not found for Model-ID= (Feign: status 404 reading…
circular reference issue
hi, I am facing the below circular reference issue. what can i do to calculate "carried interest"?
L2 Conclusion OTH01 import Shipping cost
I am not having any problem during the import process. The import was successful. The problem I am facing is after the import the data that are imported was not imported. I haven't received any errors or failures during the import. I am attaching the screenshots. I am stuck here. I don't know what is missing. Someone…
Email Notification : Cloudworks
Hello Experts, I am trying to leverage Cloudworks for automation from one Anaplan model to another Anaplan model and just wondering how can I add email ids of the team how needs to be notified on the status of the scheduled job. Currently I get the notification as I am the owner of the integration process in Cloudworks. ~AB
Refactor the action "Imports" tab
The action import tab should include: - all the info that is in the first tab the source ID ( especially the last execution date) - source object should be exploded into workspace/model/module/view fields - the data source ID should be available here as well - an export button, just like on the first tab - the ability the…

Data Integration

Discussion List