-
Production Adjustments in ICM model - looking for ideas
Context: * We have an ICM (Incentive Compensation Management) model with a DAT03 module that is an upload (from our data hub > SQL query) of all the monthly transactions we need to pay IC on. It includes all the production amounts, sales reps, product type and many other dimensions. * Our module also applies production…
-
Anaplan Power BI connector - can't refresh data as a non WSA
Dears, I am using the Anaplan PowerBI connector for the first time. For our use case, we want users to connect to Anaplan from PowerBI and refresh data that will be used for analysis. Some of these users won't have WSA. When I tested this case, I couldn't refresh the data. Instead, I received the error message "the key…
-
Selective access for lists from dashboards.
I am trying to enable the user to give selective access on a list via dashboard. I published the list to the dashboard and can clearly see the "Read" and "Write" columns on the dashboards, however if I save the dashboard and close and reopen it , the columns of "Read" and "Write" are not visible. Can somebody explain what…
-
Best Practice for Initiating Many Actions via Python Script
I have managed to piece together a script to initiate one of several scripts. Now that I can start one, I would like to ask what is the best practice for starting several? Should the script pause until each action is complete before starting the next one? If so, what would a simple wait and check to see if task is complete…
-
While running an actions,How can we get warningsRowCount/CreateCount/UpdateCount Errors in anaplan?
Hey Team, I have created an batch script to upload file to the Anaplan, Once batch process completed i will get an Reconcile report (Attached Screenshot below): HierarchyName to CreatedCount fields are standard in Every Reconcile report. Wanted to know when we get "WarningRowCount/CreatedCount/UpdateCounts" are created? or…
-
Cloud Export Failed - Bigquery Integration
Hello guys, I got a problem when i try to integrate Anaplan to Bigquery through Anaplan Cloudworks. I make the integration successfully, but when I run the integration it shows me an error. You can see the error below. The table in bigquery is also filled, but only 50 rows. I make sure the connection is built successfully.…
-
create a filtered, saved view that displays data for only months in the Forecast period.
Hello Everyone In the Level 1 exercise 12.4.1 Create saved filtered views , I couldnt find how to add filter only for the forecast period Hint: The SYS00 Time Settings module has a line item for only the Forecast period. I couldnt undersatnd this hint and how to apply this filter condition to show only the forecasted year…
-
Repeated 'Illegal Argument' ERROR when pushing data through to a DataHub
I've been having an issue pushing large quantities of transactional data from an externally uploaded .csv file into a data module within a DataHub model. The .csv file is generated directly from an internal operational data store that queries data by client. I can populate its referential list with no issues which is the…
-
Avoid creating empty export files
I have an export action triggered by Anaplan connect (export of POs) So a file is created and placed in a folder, the ERP system then read from this file and creates POs in the ERP system. This action runnes quite often and often the exported file is empty (only headers) so there is actually nothing to export. I would then…
-
Anaplan API to run a Python Script to Import File and Run a Process
Hoping someone can provide me an example of the Rest API code/syntax (for a Python script) needed to run a process which utilizes a file import to execute several action steps. Have accomplished in Anaplan Connect via the below: set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model…
-
Anaplan Connect - ERROR: Cannot locate anaplan-connect-@rel@.jar
Hello Anaplan Team, Any one the solution for this error in Anaplan connect while running ".bat scripts".I have attached the the error("ERROR: Cannot locate anaplan-connect-@rel@.jar"). I have looked in the User Guide & online but cannot find a solution, appreciate any help Thanks!
-
HI All
I want to add one more member in my number list using Action button. My number list is a serial number list which does not contain code but parent is 'Total' for all the members. How to add #11 after #10 in that list using an Action button for end user. The list contains a top level item 'Total'.
-
Anaplan Excel Add-in Series 4 crashes my excel
Hi community, Not sure if anyone encounter such issue, but recently, I have downloaded the latest Anaplan excel add-in and tried to open my excel file. However, before the file fully loaded, it just crashes. However, if I were to open my normal excel file without Anaplan add-in, it opens properly. Any advice on how to…
-
Powerpoint Text Help
Greetings, Is there a way other than Copy and paste each word (text), to create 10 separate slides of a 10-word sentence on PPT using a command or Plugin? (Task - 700 to an 800-word essay has to be separated into slides. One word per slide.)
-
Excel Addin Issues
Hi, Has anyone recently updated to the latest MS Excel 365 version (2310) and have issues with using the Anaplan Excel addin? For some reason I can no longer open any Excel file that has an Anaplan data table. I also cannot even create one from scratch before Excel force closes itself. Thanks!
-
1.5.6.2 Import Data into Historic Volumes Module | Invalid line item identifier
Hello All, Can someone help me to point where this is going wrong. I am getting Import complete but with failures : Invalid line item identifier please see the screen shots for details. Thank you
-
Size limit import data Using Talend ETL & API
Hi all, i need to load a lot of data in transaction level AP & AR. For now, i still don't have any idea how big. just wondering about : 1. is there any size limitation when import data using API? 2. Is there any timeout when import data using API? Thanks a lot
-
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
-
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
-
[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…
-
Changing source model for select actions in bulk
There are currently two options for changing the source model of an action. The first being in the Import Data Sources section in 'Actions' where users can change the data sources for actions one by one. The second is by going to 'Source models' and editing mapping for a source model. This changes the source model for ALL…
-
Process ID
Hi, We are trying to integrate with Onecloud to have automatic uploads of files. For this I need workspace, model, and process ID. I have found the workspace and model id by just looking at the url. How can I find the Process ID?
-
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…
-
Run Action Concurrency
Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?
-
Data Integration Challenge: Seeking Guidance on Anaplan Platform
Hello, I am currently working on a project that involves integrating external data sources into the Anaplan platform. recently I completed splunk certification and I am facing challenges with efficiently importing and synchronizing large datasets. Here are a few key points to consider: Data Volume: The datasets I'm dealing…
-
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
-
Saved Export Actions
For saved exports from Anaplan, how does the export remember what to export? I'm used to creating a saved view to represent the export, however, if a saved view is not created and potentially certain list members and/or line items were hidden/visible when the export was created, is that what Anaplan remembers for that…
-
Delete models using Anaplan Connect/API?
Is it possible to delete models using Anaplan Connect/API? A sample script would be much appreciated.
-
How can we add the multiple cloud works actiones in a procees
I have multiple cloudwork action.now i want to add into one process. is there a way
-
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!