-
data showing -infinity
Hi, I am having a data value showing -Infinity. How can i convert this to zero value? Thanks, Tom
-
Anaplan Excel Add-In: Lost Connection due to Reordered Columns
Hello, I am using the Anaplan Excel Add-In to organize my data in Excel. The issue is that when I reorder the columns and then change the context selectors, the columns that were moved no longer update based on the new context selectors chosen. However, when I change the context selectors, every other column that was not…
-
what is DataHub and Spoke Model?
-
How to update existing records(s) and insert as new records if not exists like UPSERT
Hi, How to update existing records(s) and insert as new records if not exists like UPSERT through Anaplan Connect script for MS SQL Server? Thanks & regards, Anil
-
Anaplan File Upload Automation - iPaaS Reviews
We are automating data uploads from our Snowflake tenant to Anaplan. Our current iPaaS solution fails constantly on the upload process and doesn't provide much feedback. Can anyone provide their experiences with other iPaaS platforms and their Anaplan connectors? We don't have developers in-house so we have steered a way…
-
Possible to extract Workspace security using API ?
Hello, We have a requirement to send security extracts on a weekly basis, since we have 10 or more workspaces, is there any way we can extract this information via APIs ? It's jus the Extract option on the users screen that we are looking for
-
Need Advice on Integrating Anaplan with External Data Sources
Hi everyone, I'm working on Anaplan integration with external data sources and could use some advice. Any tips or tools to recommend? Thanks in adavnce!
-
Import Fail - Invalid Date or Time Scale Error
Hi Team, In Level 3, I have imported activity 4.6.1 Historic Revenue by Product. I'm facing issue with the Time Dimension even though I used the Time Range concept Any ideas on why this is 'Failing'? Is this because of the Model Time scale as a "Week" SS Thanks Devika
-
Can we update Source Model mappings using an Action or through an API in Anaplan ?
Hi, Can we edit Source Model mapping in Anaplan using an Action or through an Anaplan API? e.g.: We want to import metadata from 2 sources into 1 target model : We have same module name, line items, metadata (codes) and saved views exist in Model 1 & Model 2. Model 1 ⇒ Model 3 (using "Action 1") Model 2 ⇒ Model 3 (using…
-
How to INSERT or UPDATE a record in MS SQL with AnaplanConnect export action (jdbc properties)
Hi ALL, We have a requirement to export Anaplan data into a Microsoft SQL Server database. We have requirement that, need to insert in a table if new records or replace with existing records. As per Anaplan Connect latest user guide shows it’s achievable with REPLACE or INSERT IGNORE SQL commands. But I’m facing following…
-
Excel Add-In "Send & Receive" detects no changes
I am very new to Anaplan I have become proficient at extracting data, but this is my first attempt to update our forecast. But I can't even get past the first step. I change the data, but when I hit "Send & Refresh" it detects no changes
-
CloudWorks Integration with Amazon S3: "There was an internal server error"
Hello, I'm trying to get Anaplan to an Amazon S3 bucket. I have set up a connection and it seems to work, however when trying to pick a data target I keep running into the issue of there being an "internal server error". Any thoughts on how to resolve this?
-
Excel Import - Month Format on csv
I'm in the process of building a bulk load export/import process. The (no time dimension) module has 2 lines" Start Month and End Month (both "Month") When I export to csv, the date format looks like "23-Jan" (Formula bar looks like: 1/23/2023). When I try to reimport the file, it gives an error saying that "23-Jan"…
-
Running multiple export actions in parallel
I am using the API the execute multiple export actions and download the resulting output. I notice that if I start the first export with the call to /workspaces/{workspaceId}/models/{modelId}/exports/{exportId}/tasks Then the request will return in under a second as the export starts. However, if I call the endpoint again…
-
[ANAPLAN CONNECT] Execute multiple operation with only one authentication
Hello, I hope you're all doing fine. I would like to seek help on looking for a best practice that could reduce significantly the running time of my anaplan connect script. I am using Anaplan Connect basic Import authentication. The script I am running the script consists in the execution of set of operation for each…
-
How to get Export output in json format?
Hi all, I am running a download API in logic app to get a list of my exports, i am able to get the result, but its in octet-stream format while i want the data to be in JSON format so that i can create a blob file with it. Any ideas how i can achieve this, also the Apiary links says that my result will be in JSON format…
-
Date Format - Custom Mapping
Hi! I am having trouble in importing a file with a YYYYMMDD date format and it says that I can set the data as a custom mapping for those line items when I map the source to target before mapping. I mean how I can successfully upload it without revising my upload file?
-
sample code for rest API
Hi all, Is there anyone who can share a sample file with code to use for REST API. We would like to setup a data integration between SAP and Anaplan using REST APIs, but it is hard to get started without sample file. Thank you!
-
Loading file with different file names for the same action in deployed model
Hi All, I am trying to run the action through Anaplan Connect with different files in deployed model. But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing. Attaching the screenshots for reference. Screenshot1:File name same…
-
Pulling data into Anaplan from a file (.csv/.xlsx) which is stored at a share location
Hi team, For one of our enagements, we have a requirement wherein the client wants Anaplan to refresh the data that exits in file on a regular interval. Following are the assumptions: The file data can be simple text formatted and will come to Anaplan inside a line item. The data in the file will be altered by multiple…