-
Scheduled exports from Anaplan to Power BI
Hi all, I have a question, is it possible to schedule exports from Anaplan to Power BI? Thank you in advance
-
4.8.2 Activity: Import Data into E2 Employees# List
Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you!
-
Update Current Period Action from Data Hub Not Working
I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…
-
Model Archival through API?
Hi All, I have a requirement of archiving Anaplan models. Please let me know if this can be achieved by using API? I am unable to find an API that archives the Anaplan model. Thanks in advance for providing the answer!
-
Non Workspace Admin Integration Admin
Hi, Just wanted to understand if it is possible to assign someone with the 'Integration Admin' rights but not the 'Workspace Admin' rights. Could not find any related literature. Regards, Aakash Sachdeva
-
How to connect azure blob storge in Cloud works to integrate Anaplan to Azure. Facing an error.
I have created a SAS token for azure blob storage, but when i enter it in Anaplan to create a connection it is giving me "Failed to create a connection. Azure Blob HTTP Error." I have followed technical documentation Steps, but unable to find a solution.
-
Filtering Archived Models from Tableau Connector
Hi, In our implementation, client is using a Tableau Connector to refresh data from Anaplan. To refresh the data, client has to select three values from drop-down menus. Workspace Model Export In the Model drop-down, all the archived models are also visible to the client. Is there a way we can restrict these archived…
-
Facing Timeout error while running a process using Anaplan connect batch script
Hi, I am trying to run a process through Anaplan connect but it throws timeout error while executing the process, though correct details for Workspace ID and Model ID are set in the batch file. When tried to execute the same process through REST API using the Postman platform it works fine. The error says that model is not…
-
Auth problem for below python code
Hi , I am getting either an invalid path for (api 1.3) or not authenticated for (api 2.0) to get the transactional API for line items and IDs. I am using basic auth with base64 encoding. below is my code, I believe my code is correct. guide me if i am missing anything in the code. Note that, I have used GUIDs and auth as…
-
Exporting data to different tabs in excel
I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each…
-
[Part 2] Script example: Leveraging the SCIM API to bulk remove users
* Prerequisites * Getting started * High level process * Recommended usage * Script walkthrough * Section 1: Libraries * Section 2: Logging configuration * Section 3: SCIM API configuration * Section 4: Authentication * Section 5: Parse CSV file containing Users * Section 6: Call the SCIM to perform the selected operations…
-
How can i call a batch script residing on external server, from Anaplan ?
-
8.5.3 File Upload
I'm having trouble uploading the volumes files to REV02 Volume Inputs module. I couldn't figure out which source should I map for the REV02 Volumn Inputs Lines Items(Volumnes) Target. I tried everything but still having trouble uploading the file.
-
8.5.3 File Load
I am loading the Volume Inputs file and I am not getting all the Sources to load. I have the Header Row on 2 and First Data Row on 3 but it is only showing 2 sources instead of 4.
-
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
-
Anaplan Excel Addin
In the excel addin, the YTD & YTG time dimensions have dropped to the bottom of the time list. These were placed after the current year. Does anyone have an idea why this changed.
-
Alteryx Connection issues
Hi all, I am currently trying to connect Alteryx to Anaplan using the Alteryx connector tool. I have done a bunch of reading but cannot seem to find an answer to the issues I am having. I have checked the SSO, so from all I can find, I should be able to connect to Anaplan via Alteryx using Basic Authentication, (username /…
-
Import from SQL Receiving Error - "Anaplan API: Cell text cannot contain tab character"
We are attempting to switch our source from excel files to a SQL server and are receiving this error when running the scripts for Anaplan Connect. The job is successful for the initial two tables but we're experiencing this error on the final table. The formatting and configuration is similar for all tables so unsure why…
-
issue on loading the import file chunks
Hi all Our integration partner is having issues setting up the upload of text file based data objects towards our Datahub model. They are using the setup of importing file chunks (Upload a text or CSV file - Anaplan Technical Documentation). Somehow, it seems the import of the chunks is interfering, not causing the chunks…
-
What is the difference between Modules and views. can multiple views creation possible in a module?
3.) What is the difference between Modules and views. is it possible to create multiple views for one module.
-
Anaplan Cloudworks - Azure Blob Storage Integration
Hi All, I am trying integration via Cloudworks to import csv files from Azure Blob Storage. As per Anaplan Documentations, its just mentioned Azure Blob storage. Is it the ADLS2 Gen 2 Blob storage or normal azure blob storage which is required for Cloudworks integration. Thanks
-
How can I filter a grid on a UX page that does not have that dimension
Use case Module - Emp Details List Used - Employee Line items - State (List), Emp Start Date (Date) On my UX Page, I would like to create a State filter that allows me to filter only those employees that belong to that site. Since Emp Details doesnt have State as a dimension, its not available as page selector.
-
Excel Add-in login Issue
Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…
-
Does Anaplan offer integration with Python scripting
Hi Team, We currently have a science model written in Python that takes input and provide a set of input. We would like to integrate this with Anaplan. Input to the script will be calculated in Anaplan and passed. Output generated from Python will be loaded back into Anaplan. Is this that is possible via Anaplan? Is there…
-
ERROR 40032 |-- Anaplan API: Cell text cannot contain separator
Hi Everyone, I have a problem since I receive this error when running a batch file through Anaplan Connect. Do you have any suggestion for solving this type of error? Cannot find any literature linked to it within Anaplan Community. Thank you, Joana
-
Anaplan Connect using Bat Script For Windows - How to dynamically load a file in bat script ?
I have a file for the month of January on my local system, using that file I created a batch script using Anaplan connect. I defined my January month file name and file path in batch script so that my script works fine with Anaplan connect. Suppose I am in the month of February - I am planning to upload the February file…
-
CSV Upload - Help
Hi, I have a CSV file with Time Period, however, this fails to upload into Anaplan. How do I fix this? Thanks
-
Invoking Informatica jobs from within Anaplan on a button click
Hello, We have a bunch of Informatica Integration jobs that receive data from other systems like Salesforce and generate csv files to be loaded into Anaplan. We use Anplan Connect (Anaplan_Client.bat) to invoke the actions to load the files. These jobs are scheduled via informatica and few of them are through Windows…
-
DEM01 Volume Growth Rates - Import issues
Hi, I am having some issues re- uploading the data to module DEM01 Volume growth rates. The current view that I have is the following and is not picking up the growth rates by product category. However when i do the import, it shows as it has been successful. See below my selection and successful screenshot message Any…
-
Anaplan connect error - Anaplan API : Basic Authentication Failed!
Hello Anaplan Community, I am currently facing an issue with Anaplan Connect. I have made an import script and when I run it on my laptop it works completely fine. But when I sent it to the client IT team, it did not work! The command keeps attempting to request the API until it gets to the following error message :…