-
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
-
Importing is not working
Hi, We are trying to import from one source to Anaplan but we are not able to import anything. We are able to export the data. please find the output below that we are getting when we are trying to import. { "meta": { "schema": "https://api.anaplan.com/2/0/models/B97129A7835A44D484A5008266AB711E/objects/file" }, "status":…
-
Any Way to Switch a Cloudworks Integration from AUTO_DEACTIVATE
Is there any way to force a cloudworks integration to toggle back to ACTIVE from AUTO_DEACTIVATED? Context: We built a number of integrations and scheduled them to run on the weekend. If an integration is scheduled to run during the regular maintenance windows, eventually the integration in cloudworks will flip to…
-
Is it possible to have an anaplan export automated having 2 dimensions in columns?
I am trying to create an automated export of a view that has time, as well as line items in columns. I have tried this via Cloudworks and Informatica but it is not working. When I am manually running an export in anaplan its working fine but not via integration.
-
Anaplan API 400 Bad Request retrieving token
Hello all, I'm trying to do a request from SAP middleware where I pass 'Authorization' header and 'Host' header to retrieve authentication token. Once I send the request, I've got a 400 Bad Request HTTP response. If I send same request from Postman I'm able to get the token. Could you help me, please? Best regards.
-
Impact of model archival on Cloudworks
Hi all, I had to archive the production model, and when I restored it to deployed mode, I've noticed that the connection to Azure scheduled for last night didn't work (I had it rescheduled but it failed). The status is set to "auto deactivated", however if I manually run the processes, they are successful. I have…
-
Issues with CloudWorks Integration
we have been facing issues with CloudWorks integrations from couple of days. Below are some of the observations: When a integration runs on CloudWorks on one of the model, the whole workspace gets stuck. Integrations are failing with no error logs. Getting notifications about the integrations failing but those actully…
-
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…
-
Formula error
In my Stat forecast I have some items mentioned as "End of Life" and it has a date until which the item will be active for forecast but after that date it will go inactive. But the formula that I have now isn't giving me forecast for that item. For e.g.- For Item A - EOL = Jan 2025. (so this should give forecast till Jan…
-
How to add colors to worksheet
My current worksheet has color highlight for some rows, now I want to create a new page and add highlight other rows with colors, how do I do that?
-
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…
-
Adding a parent hierarchy to the existing lists
I have a hierarchy of brands which was set up a year ago. Now I want to add a parent to L1 (i.e. L0.5) as a parent of all, which should separate all brands into Private Label and Owned. Because now when I build pages and I want to see only the owned brands altogether I can't do that as in the module the brands are listed…
-
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
-
Anaplan Connect JDBC issues - SnowFlake - jdk.internal.misc.Unsafe
I have successfully connect to snowflake, and extract file, import to anaplan file csv, but it seems the connect api did not call the action to import into anaplan. (Because I have seen the file of anaplan has been updated, but the process/action has not been launched) It seems the problem coming from…
-
Introducing Improved Anaplan DX: a browser extension for Anaplan Modelers
We at valantic are excited to share our latest development: Improved Anaplan DX, a browser extension designed to enhance your modeling experience and increase efficiency. Please see below for more details. The extension is now available in the Chrome Web Store (can be installed on Chrome and Edge): For any feedback,…
-
Is there a way to change which browser is used by Excel Add-in for SSO authentication?
Using the latest Excel Add-in, it appears this is using an embedded version of Edge browser (version 95.x). Our organization has blocked this browser being used due to the age of the version. Is there a way to change which browser the Excel Add-in uses for SSO authentication so that it will use either system default…
-
Anaplan Connect JDBC issues - SnowFlake - (solved)
I have encountered some issues when configuring and running connect script. But I didn't get a specific error message, as following picture : PS: I have configured the snowflake properties files and java, anaplan connect installed etc. Can anyone give me some tips to figure it out ? Thanks
-
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 Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
-
Summary method for time
I have a reporting module that shows me gross and net revenue totals by month, with line items for each member of a hierarchy as well as the period. I can select each period to see each month's data, but I'm wondering if there's a summary method I would need to be able to see all of the months when I have the whole fiscal…
-
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…
-
Integration of custom Machine Learning model's with anaplan
I'm working on a Marketing Mix Modeling (MMM) project to analyze marketing spend across different media channels, calculate ROI, saturation points, etc., using various machine learning models. I'm interested in integrating these models with Anaplan to make them accessible to any brand within our FMCG company. How can I…
-
Get Request from API returns 'success' but doesn't include the desired list of chunks data?
Trying to follow the method described here: And I'm finding I don't get the list of chunks for our file. This has worked using basic authentication in API version 1.3, but we're trying to upgrade our process to Cert Authentication in 2.0. Is there any reason the list of chunks wouldn't be included here?
-
Dimension limitation while creating exports from Anaplan Cloudworks
I am trying to create an export via Anaplan Coudworks to azure blob. File generated at azure container is blank if I am keeping one dimension(list) in row and the other in column while creating the export. I created another export which had all the dimensions in rows and only line items in columns, export generated for…
-
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…
-
How to make/create subsidiary view?
Create Shipping Export Module and Create a Saved View In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: Module Name: INV05 Shipping Export Dimensions: G3 Location list, Time (months) Category: Inventory Functional Area: Inventory Line Item Format Purpose…
-
S3 - Anaplan Integration
All - Quick question on the S3 to Anaplan integration. Does Role ARN ? required in order to establish the connection Thanks Krishna
-
Question on Python Update Data
Hi all, I have been seeing the use case of python to run actions and processes. I am wondering if there is a way we can use python to write data into anaplan? (not in form of importing a list but directly writing to it) For output The use case is that I would like to run 100s of scenarios (through changing the inputs)…
-
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…