-
Anyone who can help me configure the SAP HANA JDBC driver?
I have a SAP HANA JDBC driver (ngdbc.jar") in my ANAPLAN CONNECT lib but am not able to configure it. I have attached a screenshot of the SAP HANA JDBC driver window. https://developers.sap.com/tutorials/hana-clients-jdbc/jcr:content.github-proxy.1698070514.file/JDBC-Driver-Trace-Config.png
-
We'd like your feedback on the App Hub
Hi all, We are currently looking for Anaplan customers to participate in 60 minute research sessions. Sessions will take place remotely from March 2nd to March 11th. Participants will receive an e-gift card as a thank you for their time, if their company policies allow them to receive these. For this session, we will be…
-
PowerPoint Add-in 1.6, 1.7 "Ghost Installation"
This item has been identified as an outstanding known issue. Issue When installing a later version of our PowerPoint Add-in, if a machine has both 1.6 and 1.7 installed, you will be left in a state where both programs exist in your list of programs but neither function (missing in the ribbon of PowerPoint) and you will…
-
User unable to refresh a connection on PPT
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue The below error message is displayed when a user attempts to refresh a connection after authenticating using the dropdown for login as shown in the image below: Workaround This issue can be…
-
Anaplan cloudworks integration with Dynamic 365
Can Anaplan be directly integrated with Dynamic 365 using Anaplan cloudworks? Or do we need to integrate Dynamic 365 with a cloud data source first?
-
How configure the authentication token in the Talend
Hi @,@ Thank you so much for creating this detailed document. , We are following this to create a Anaplan Integration with Talend. But instead of CA Certificates we are trying to do it with the Basic Auth. If possible can you please let me know how to configure the Components in talend for Basic Auth and share if you have…
-
Model Builders & SAs: Help us understand your model optimization processes.
The Anaplan User Research team wants to better understand the model optimization process, including view clean-up. We are looking for model builders and solution architects to walk us through the process of optimizing/cleaning models. During a 60-minute remote research session, participants will be asked to share their…
-
File ID + Module ID via Web Browser
Previously you used to be able to do something like the following in a web browser to get IDs: E.g. https://api.anaplan.com/2/0/workspaces/WORKSPACE%20ID/models/MODEL%20ID/files Now when you try this you get a 401: Not authenticated error. Is this intended behaviour going forward? Can certainly set things up in postman but…
-
Can we capture a tenant-based date/time value?
With CloudWorks, we can schedule based on date/time with a selected time zone, but that is not involved in any user-facing functionality. As I am working through the new Workflow training, I realize that the platform is now providing interactions with end-users based on date/time values in a selected time zone. This has me…
-
Cloudworks Limitations for a global scale deployment
Hi Guys, I am new to Anaplan Integration. We want to create a standardized design for a deployment which has multiple models based on regions. In the Community it is mentioned that we can have only 500 integrations per tenant is there anyway to increase them. And also are there any limitations for cloudworks if we want to…
-
Excel Add-In: Flattened Data with Rows Labeles
Hello! I'm using the excel add-in and, unlike when I export from the model, I am unable to flatten my data and retain all the row labels (A below). Instead they get grouped like they do in the module display (B below is what the add-in is giving me). Is there any way to use the add-in and have it pull the data into excel…
-
Power Query - Get Data from Anaplan
I use Power Query within Excel to connect to online sources such as Salesforce. Is it possible to connect Power Query within Excel to Anaplan and how do I do this? I have seen an article about the Power BI connector but I cannot see a link to where I would download it from or whether I can use this with Power Query in…
-
File/Data Encryption During Export using Informatica
Need guidance around how to encrypt data for an Anaplan export using IICS (Informatica). As soon as there is an data export and before it hits target (FTP location or Cloud service), data in transit has to be in encrypted status. So I guess, the question is - how do I encrypt the data as soon as export action runs. I was…
-
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…
-
Response from adding item to a list. Success but not added or ignored
I'm calling the API to insert an item into the list. { "items": [ { "code": "test", "properties": { "Display Name": "test", "Time/Date Stamp": "2023-10-27 13:19:19", "Amount": "Data Unavailable" } } ]} I'm getting a response back that show it has not been added or ignored. { "added": 0, "ignored": 0, "total": 1, "meta": {…
-
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