-
Format while manually exporting data
When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…
-
Make Bulk Copy between Versions an Action
Currently our team EVERY WEEK, has to bulk copy the current version to the previous version because there is no way to automate this. That is 52 manual interventions every year. If you could create an ACTION that would allow you to bulk copy and have user select source version to target version, than we can schedule an…
-
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!
-
Level 2 1.3.6.3 Create Build Location Saved View
Hi, I am not able to find the parent column so I cannot do a saved view. Can someone let me know what happened to this? Instead, there is only country column. The task is asked us to save Code, Parent, and subset line items in a saved view. Thanks! Also, locations flat is a flat list, right? Why do we have a parent column…
-
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…
-
1.5.6.2 Import Data into Historic Volumes Module. Need some help
Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you
-
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…
-
CloudWorks: sequential process startup
Hi everyone, In addition to the scheduled startup, please implement the ability to start the process sequentially. We have 30+ night integrations and we've spent a huge amount of time setting up start times for each of them. Since the duration of each integration is not a constant value, but can vary widely (instead of 4…
-
Ability to combine processes across models in CloudWorks
The use case is to orchestrate a data integration workflow in one CloudWorks schedule containing steps executing model-to-model imports from many processes residing in various models, e.g. update DataHuab lists and modules, then update planning model lists and modules, then update reporting model lists and update.
-
Sort Workspaces in Model>Model Import View
When setting up an import and selecting the "Connect to Anaplan Model" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…
-
January 2023 releases and February sneak peak
Hopefully you've all been able to get your head around the new Community platform. Hint: always go to product.anaplan.com for new platform related stuff! No doubt @Paul & @CatherineH will bring this up in March but there's been a tonne of new-ness released and we're only in February. For me shapes in Management Reporting…
-
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…
-
Automatic DocuSign Workflows
The native DocuSign integration with Anaplan makes it simple to share information between Anaplan and Docusign, but the process to issue envelopes or track changes back in Anaplan can sometimes be quite manual and time-consuming as envelope counts begin to increase. This article will walk through a script to automate this…
-
Workflow triggers Import/Export
Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?
-
combination of properties import code creation
Anyone who has imported on a combination of properties into a list will understand the frustrations that can arise. For me there are two specific frustrations that i can think of a simple solution to. The problems: 1. Importing into a list using a combination of properties ALWAYS creates a new list member even if the same…
-
Export - Data Source
Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…
-
Export defined in a model should be connected to a view
Hello Team, Currently, when we create exports and save them in actions - they are disconnected from real module views. Example: if you create a new export definition, based on a current view (with a filter or smth else) it is not possible to revisit and amend this view after some time and see what view is feeding an export…
-
Native scheduling action in Anaplan (w/o API. Connect or 3rd party integration tool)
Could Anaplan action iteself allowing for scheduling? (i.e. a common use case would be you have an action that brings data from Data Hub to Spoke models and data in Spoke models need to be refreshed everyday) - It would be super helpful to have this function built-in at the time the action/import is set up in Anaplan,…
-
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.
-
Cloudworks Integration Email "Cloud works integration broken."
Hi Team, I have a few requests for cloudworks: * Can we have the ability to select the users that will receive email notifications for cloudworks * If an integration file is processed via cloudworks and it has any records that come up with ignored or any rows that that failed an email is sent that says "Cloud works…
-
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
-
Ability to include Line Items within DocuSign Workflow Names (& therefore DocuSign email Subject)
We would like to have a small number of DocuSign Workflows which can be reused to complete standardized processes which are initiated in Anaplan and completed in DocuSign. Currently Anaplan uses the DocuSign Workflow name as the Subject of the email which is sent from DocuSign. This means that each email recipient receives…
-
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…