-
Anaplan Data - Real Time Access
Hi All, We are trying to access Anaplan Module level data using Python. I just wanted to access Anaplan data (Module Level Data) in real time by using Python or Java without getting data from Anaplan with flat file. Also wanted to establish Connectivity between python & Anaplan in the real time. So we can get updated data…
-
Experiencing Occasional 'Basic Authentication Failed' errors under SSO
We recently switched majority of our workspaces over from Basic Authentication to SSO for security. To populate our models with data that is rapidly changing we push data through our internal data store through an ETL (Workiva formerly known as OneCloud) hourly sometimes more often than that. There is a dedicated service…
-
Better solution for a nested IF... but I can't think of one
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIAL and LABEL TYPE. Within the material list we have several labels (FRONT, REAR, DECAL + 6 others) In the module i need to…
-
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…
-
Salesforce CRM Analytics to Anaplan Connector?
Hi all Anaplanners, Does anyone know how to connect Salesforce CRM Analytics to Anaplan to enable one way/two way data transfer? Thanks, Jim
-
Power BI Enhancements/Limitations
The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…
-
Integrate Anaplan in Power BI
Hi community, Have you guys have any experience integrating Anaplan data model into Power BI? If you do, please share. Our company is planning to integrate Anaplan data soon, and I am just researching for a proof of concept.
-
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
-
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
-
Anaplan error - Error parsing key for this row; invalid data: , , ,
Hi All, When I am importing a file to a list I am getting an error as "Error parsing key for this row; invalid data: , , ," even though there is data in all the columns. Its a transaction data set that I am trying to import into a list with list properties using a combination of columns as unique identifiers. It shows…
-
Source Object Name refresh in Import Data Sources tab of Actions (Model Settings)
The Source Object Name in the Import Data Sources tab of the Actions section in Model Settings is a very helpful piece of information when tracing source module views used in Actions. Model builders normally export this information to an Excel output and filter on the source object name to check which actions are dependant…
-
Unlocking High-Efficiency Data Uploads in Anaplan: A Multithreading Approach
In cloud-based business planning, the ability to swiftly and effectively upload large datasets is an important aspect of maintaining up-to-date planning. This post introduces the concept of multithreading to enhance data upload speeds to Anaplan significantly. This approach, however, is specifically tailored for data…
-
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
-
S3 - Anaplan Integration
All - Quick question on the S3 to Anaplan integration. Does Role ARN ? required in order to establish the connection Thanks Krishna
-
Adding items to numbered list using Create
I want to achieve this but getting a little bit of a problem: * End User can add an item in a number list by clicking a button. * He can choose Product Family from the drop down (Page Selector). * And after that whatever he wrote in Product Name gets imported to the list under the Product Family Selected. I tried using…
-
Tableau to Anaplan integration
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh
-
What is Data Management System that was talked about during Anaplan Kick-off this year?
-
Anaplan - Informatica Cloud Integration
Hi All, I am trying to run mapping in informatica cloud.Mapping between source and target are valid but while running the mapping I am getting below error: "Operation failed: com.informatica.adapter.sdkadapter.exceptions.MetadataAccessException: [SDK_APP_COM_20000] error [1]". Can you please suggest and resolve the error.…
-
Using the Anaplan Certificate with the Anaplan REST API: A Comprehensive Guide
If you're diving into integrating with the Anaplan REST API using an Anaplan Certificate, you'll need to know certain requirements. This post is a step-by-step guide to ensure a seamless connection using Python. If you'd prefer to avoid a programmatic approach to using your certificate, then please check out the CA…
-
Ability to import line item format into blue print view
The ability to import line items format while importing blueprints would be really helpful. Currently, I've set up an automated process to import newly created line items from one module into another module on a daily basis. However, I am still required to check the module frequently for new line items imported in order…
-
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
-
Exporting CSV from Anaplan, incorrect date displays in Excel
When exporting information into Excel by month it brings the dates through as text, ex “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for…
-
errorwithclearrequeststatuspoll exception?
Getting this while inputting in a value in a column.
-
Creating a Data Integration Schema for your Models
A data integration schema describes the integration and flow of data across systems. It will typically consist of a combination of diagrams, tables, and other visual components that provide the ability to quickly understand the flow of data. In an Anaplan context, a data integration schema outlines the movement of data…
-
Model Map Export
I really appreciate the new Model Map feature. What is the best way to export my entire map to a printable format? My model is rather large and I can't get the view with details out in a usable format.
-
Fix ability to use zip files in Cloudworks and UX
While using import actions in UX and Cloudworks I discovered with the help of Anaplan support that zip files cannot be used except through the backend and old UX. We would like to have the possibility for Anaplan to use zip files in UX and Cloudworks as it is indicated in the Planuals best practices. This is required to…
-
Incorporate daylight savings in Cloudworks time zones
Now if I select London time zone in Cloudworks schedule, it will not automatically change the time in accordance with daylight savings in UK, forcing us to adjust the schedule manually. The same goes for other countries with daylight savings. It would be great, if daylight savings were added to Cloudworks schedule time…
-
Cloudworks Additional Time zones for Australia
Hi Team, Can I please ask that Brisbane and Perth time zones become available in cloudworks for selection. In Queensland we do not have daylight savings and as a result this could impact integration tasks for a misalignment in timing of the integration files coming into Anaplan and a cloudworks process schedule being run.…
-
Time change in integration
Hi, After daylight saving time, we have to change our integration timings as well by 1 hour, or it will automatically change the time. Thanks, Vicky
-
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…