Data Integration

Anaplan Connection - Invalid Credential
Hello team, We are getting an error frequently, almost daily baysis, related to "invalid credentials" between Anaplan connection and Power BI Desktop. Every time that team (two developers analyst) needs to work with the data, we need to reset the password and we are worried about this for the future. Do you know if this…
Share your Experiences of Data Preparation Processes in Anaplan
The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…
Kindly help with steps to configure S/MIME certificate
Kindly help with steps to configure S/MIME certificate
Export line item codes
Description of the enhancement: To be able to export the line item codes instead of only the line item name. Description of business use: I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account…
Text Formatted Line item character Limit
Hi Team, Just wanted to know do we have any Limitation of character for a text formatted line item value entered. I am aware that Max of 60 Character can be entered for a line item name , but for value to be entered.is there any Limitation and will it effect my model size aswell. Thanks Madhu
CA Certificates for Service ID (Password less Connectivity)
Do we have a list of CA Certificates that are mostly used to implement password less integration with Anaplan and if anyone has an estimate of pricing & validity of those certificates? Our client is looking for the feasible options while choosing the Certificate Provider - So a consolidated list will actually help the ask.…
Anaplan API 2.0 Python Library Certificate Error
Hi, We are trying to change from basic authentication to using a certificate. I am using the Anaplan API 2.0 Python Library. When running AnaplanConnection function I am getting the following error that I traced to the anaplan_auth.py. TypeError: from_buffer() cannot return the address of a unicode object I have tried…
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
SKU.csv file on level 1 exam
In the first part of the level 1 certification exam it tells you to create a new list using the SKU.csv file they give you. The SKU.csv file you download ends up being multiple files in one folder. When I try to import the one of the attached files (SKU) into my new list (P3 SKU) nothing happens on my screen. Then on the…
How to calculate Anaplan model size?
Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model…
Integrations Specialists: Help us test a new method of connecting third-party systems with Anaplan
The Anaplan User Experience Research team is looking to speak with Integrations Specialists to provide feedback on an innovative new method of connecting third-party systems with Anaplan. We invite you to join us for a 60-minute, remote research interview during which you will be asked to weigh in on this key innovation…
Google Sheets Add-on: Send formula driven figures back to Anaplan
The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.
Import Shipping Expenses into OTH01 Module
Hi everyone, I'm still struggling with the import into the FP&A model (Level 2 Conclusion) Here's the mapping I have had: And here is the error I have got: Here's how my INV05 Shipping Export module looks like in a Blueprint mode: Is there any chance someone could help me, please?
Clear all items reset to "Match items in source" when a dimensions mapped on "Fixed item in" or info
Recently I had and issue with a Model where the import setting “Which target items to clear prior to import?” was set to “All items” but not visible in the import screen because the Diemension was remaped to single item. Altough the Dimensions was mapped to a single item, it was still cleared all items but that setting was…
How can I add dimension item ids/names to a module through a transactional API?
Hi I'm currently trying to use the write cell data transactional API to fill a module in Anaplan with required information. However I can only currently add to dimension ids/names already defined in my module. For reference, in my current module Dimensions sequentially increase in number #1,#2,#3 etc. I can add to these…
Anaplan Implementation Requirement Gathering for Retail Sector
Hello RAG Members, I hope everyone is doing well! We might have an Anaplan Implementation project coming up in the retail space, and I was wondering if you can share any material on requirement gathering. I am mainly looking for sets of interview questions that can help to define dimensions and modules in Anaplan. My…
Internal access (Full access) for Cloudworks to work on Selective access in Admin Portal
Hi Team, At present for the cloudworks actions to read the lists with selective access, 'internal (full) access' must be enabled within the list, which is quite tough to do in a live production model without disturbing the user's access. It would be ideal and intuitive if the access was controlled externally either through…
Issue with download SUM Demo Model
Hi, I'm trying to import model 'SUM Demo' Model into my workspace but I can't find it. Can you please help me? Thanks, Ana
Size.csv missing - unbale to import the data
Hi, I'm not able to import the Size.csv file into workspace due to the fact that I can't find it into the training or into the Anaplan. Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
Cloudworks Integration "There was an internal server error" for BigQuery Data Source option
Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of "There was an internal server error" under the Data Source option. Can anyone provide any advice on how to resolve this?
Format while manually exporting data
When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…
Make Bulk Copy between Versions an Action
Currently our team EVERY WEEK, has to bulk copy the current version to the previous version because there is no way to automate this. That is 52 manual interventions every year. If you could create an ACTION that would allow you to bulk copy and have user select source version to target version, than we can schedule an…
4.8.2 Activity: Import Data into E2 Employees# List
Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you!
Level 2 1.3.6.3 Create Build Location Saved View
Hi, I am not able to find the parent column so I cannot do a saved view. Can someone let me know what happened to this? Instead, there is only country column. The task is asked us to save Code, Parent, and subset line items in a saved view. Thanks! Also, locations flat is a flat list, right? Why do we have a parent column…
Update Current Period Action from Data Hub Not Working
I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…
1.5.6.2 Import Data into Historic Volumes Module. Need some help
Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you
Non Workspace Admin Integration Admin
Hi, Just wanted to understand if it is possible to assign someone with the 'Integration Admin' rights but not the 'Workspace Admin' rights. Could not find any related literature. Regards, Aakash Sachdeva
How to connect azure blob storge in Cloud works to integrate Anaplan to Azure. Facing an error.
I have created a SAS token for azure blob storage, but when i enter it in Anaplan to create a connection it is giving me "Failed to create a connection. Azure Blob HTTP Error." I have followed technical documentation Steps, but unable to find a solution.
Filtering Archived Models from Tableau Connector
Hi, In our implementation, client is using a Tableau Connector to refresh data from Anaplan. To refresh the data, client has to select three values from drop-down menus. Workspace Model Export In the Model drop-down, all the archived models are also visible to the client. Is there a way we can restrict these archived…
Facing Timeout error while running a process using Anaplan connect batch script
Hi, I am trying to run a process through Anaplan connect but it throws timeout error while executing the process, though correct details for Workspace ID and Model ID are set in the batch file. When tried to execute the same process through REST API using the Postman platform it works fine. The error says that model is not…

Data Integration

Discussion List