Data Integration

Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Postman
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and Postman Resources Required: Internal Expertise: IT Developer / API User Tools Needed: Postman, CloudWorks Access Requirements: CloudWorks, Postman, Anaplan Integration Admin Estimated Level of Effort (LoE): Low Approximately 1-2 hours…
Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Python
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and python scripting Resources Required: Internal Expertise: Python Developer / API Expert Tools Needed: Python, CloudWorks, Code Editor Access Requirements: CloudWorks, Anaplan Integration Admin Estimated Level of Effort (LoE): Low A few…
Connecting Anaplan Connect to Snowflake Using JDBC Driver with Java 16 or Higher
Addressing JDBC Driver Compatibility Issues Intended Audience Level of Difficulty: Intermediate Requires some familiarity with APIs, scripting, or database concepts Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, Snowflake, Notepad Editor Access Requirements:…
OEG Best Practice: Imports and exports and their effects on model performance
Overview Imports are blocking operations. To maintain a consistent view of the data, the model is locked during the import, and concurrent imports run by end users will need to run one after the other and will block the model for everyone else. Exports are blocking for data entry while the export data is retrieved, and…
Excel Add-In OLE Action
Hi All, I wanted to see if anyone has been encountering this issue with the Excel Add-In. Oftentimes members of my team will go into Excel, log into the add-in, and then the whole Excel Application feezes. It freezes for a few minutes and then comes up with a message box saying "Microsoft excel is waiting for another…
Get self-service and lower cost of ownership using CloudWorks
Now that Anaplan has rolled out CloudWorks, more clients are asking about how to leverage it as the main data integration tool for their Anaplan platform. After years of implementing Anaplan at a partner firm using mainly Anaplan Connect for integrations, I have been pleasantly surprised at how CloudWorks performs and how…
Is it possible to access Amazon Redshift data warehouse via ADO?
Hello, Brain Trust! My organization uses Amazon Redshift data warehouse and some data we need for Anaplan will be stored there in the near future. The current assumption is that we will use Informatica to query, stage, and then import to Anaplan, BUT…. I really was hoping we could use ADO. In a prior life, I used Anaplan…
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…
Data Export Options in Anaplan Data Orchestrator ?
Hi Anaplan Community, I'm new to Anaplan and exploring integration options for moving data between Anaplan and cloud services. I successfully exported model data to Google Cloud BigQuery using the CloudWorks integration. However, I couldn't find an option within Anaplan Data Orchestrator (ADO) to directly link model data…
Anaplan Partners for FP&A
Hey there, Has anyone implemented Financial Planning & Analysis in Anaplan for an organization without an Anaplan partner or a light one? If so, how was your experience? Thanks! Andrew
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…
Excel Add-in: Clone Workbook button
Currently on the Excel Add-in I am able to clone worksheets. I would like to have the ability to clone an entire workbook or multiple copies of a single sheet rather than doing this 1 sheet at a time. Why? * Currently the Excel Add-in does not allow for copied workbooks to be opened simultaneously * This will facilitate…
True ALM for Anaplan Data Orchestrator
Currently ADO only has a single tenant level environment to all store source data, transformations, and links. This can make managing ALM challenging. Being able to have separate (and sync-able) ADO Dev/Test/Prod environment(s) would be more manageable than housing everything in a single tenant wide space. Having true ALM…
Model Migration from Anaplan Cloud workspace to Google Cloud workspace
Hi Anaplan, Does anyone know if it is possible to migrate a model from the Anaplan Cloud to the Google Cloud and vice versa? If a model has been constructed in a customer's Anaplan Cloud workspace can it still be migrated to a different customer's Google Cloud workspace using a Model ID and Workspace ID? Any information…
CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message failed_row While the documentation outlines the table structure, it lacks details on how records 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…
Error in Uploading Screenshot for Anaplan ADO Maps.
Hi All, Facing an issue while uploading the screenshot as it is showing "error while uploading the file". Is it only for me or is anyone else facing the same. Can anyone help in resolving this at earliest? Attaching the screenshot of the error below. Thanks,
Issue: Informatica Cloud Connection to Anaplan Success but 0 rows processed.
Hi Anaplanners, I am trying to use IICS to establish a connection between my oracle db to Anaplan module. But everytime I test my IICS process, it's giving me a success status but showing 0 rows processed, and when I check the module, nothing was imported in. I also tested my action manually and it worked fine. I also…
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
Import 2 number list with identic Parent and Code
Hello, In Model 1: I have 2 Number List: Payer Sold to, with parent Payer Every line in organization, also exist in Sold to list. As example: Name: Parent: Code: Aushan _______ 12 - Payer Aushan Aushan 12 - Sold to Aushan Aushan 15 - Sold to In Model 2: I have 2 Number List, as well: Payer Sold to, with parent Payer I copy…
Can a parent numbered list and child numbered list have the same code?
Hi All, I have a parent hierarchy in numbered list.Both are uniquely identified by code. Parent List : Program Child List : Project So When I am importing into child list(Project), it is ignoring some of the records. After the analysis, I found that the records that are being ignored have their codes already present in…
Stop a process in CloudWorks
I kindly ask to add a "stop" option in CloudWorks Integrations Menu, because I have a process which is stuck and I need to spent a lot of time to delete and re-create it every time a process doesn't work. Thanks in advance!
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
Cloudworks Integration Flows in UX
At the moment, we are able to add Cloudworks Processes to the dashboards and the addition is great. Could we do the same with the Integration Flows? I see multiple benefits from this for several customers and I do not think that the implementation would be too different from what is currently in there. Is this currently in…
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
What is Managed By functionality?
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
1.7.3.1 Import into P3 SKU list
I am having trouble importing the data from the Build SKU saved view. When selecting my sources for the data, I don't have many options to link the properties to the sources. Is there something I am missing?

Data Integration

Discussion List