-
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.
-
Edit Export Action
User should be able to edit Export Action just like Import Action in case of addition, deletion of line items to the saved addition/removal of filter to the saved view which is being used in Export Action.
-
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 Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…
-
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…
-
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…
-
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
-
Challenges with Continuing to Use Version 1.3 API in Power Automate Custom Connectors
I'm currently using Version 1.3 of the API in Power Automate Custom Connectors, but our Anaplan systems have been upgraded to Version 2.0. I have a few concerns and I’m hoping to get some insights from this community: Compatibility and Functionality: Are there any known issues with maintaining the older API version in…
-
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…
-
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
-
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
-
Cloud export failed _Cloud works(Azure Blob)
Cloud export failed error while running the clouds works integration with azure blob. Do anyone knows about this error and how to fix it?
-
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…
-
Deploy mode
Hi All, I have deployed a model from development to Production and try to run a script for batch run from other source in production environment, the script was run successfully but data is showing blank? And when i tried to upload the same file manually in production, i am getting error as "Deployed ode is enable for this…
-
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…
-
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…
-
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.