-
How to Dimension ID and Item ID ?
Hi Team , I'm trying to get Subsidiary module data in a CSV using below API. How to get Dimension ID and Item ID API Used : curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/views/{viewId}/data?pages=dimensionId:itemId&format=v1&exportType={TABULAR_SINGLE_COLUMN}&moduleId={moduleId}' \ -H 'Authorization:…
-
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…
-
"Error" message using Import to clear user input date data
Hello, Community In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets): ADS Values (number) ADS % Changes (%number) Cancel Order? (boolean) Manual Order Input (number) Override Delivery Date (date) Hence, I…
-
Import to numbered List
Hi People, I want to import transactional data into the model from excel csv file. I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number…
-
Copy from one list member to another
I have an Input module by List:A,B,C,D The user wants to make the input for member A and copy them to all the other list members B,C and D so they don't have to make the i/ps multiple times. How can I do this ? If I have an import action then can I map 1 to many for the List?
-
How to automate the mapping of the Import data to the current version?Current Version is Dynamic.
Hi Everyone I have a module dimensioned by 2 lists, where one of the lists is Versions #. The versions # list is not the default one that is present in Anaplan, but it is created by us according to our requirements. The end user will select the current version from the list of items available in the Versions # list. Now I…
-
500 Internal Server Error occurs with requests made with API V2.
To export data from the View, a request is made with an API call to download all pages. The View has a lot of data, so the number of pages will be about 100~3000. I am using Azure pipeline to download one page at a time, but when I finished downloading about 120 pages in 50 minutes, I got a 500 HTTP Internal Server Error.…
-
Batch Emails with Content in an Attachment
Hi Community, My team and I are looking for any ideas on meeting the following use-case: A client would like to have as part of their Workforce Planning functionality, the ability to have Anaplan send out automated emails to individual employees detailing that employee's compensation details (yearly raise/salary/bonus…
-
Cloudworks Error on integration task datasource dropdown
Hello I setup a Cloudworks connection to big query for the first time and according to the connections screen it was created successfully and the status shows as connected. However when I try to create my first integration I select the connection but then I receive an internal server error in the Data Source drop down and…
-
how can i know the line item reference in action buttons
HI Please let me know how can i find out the line item refence in action button, Please let me know
-
Importing module into list without time summary
Hi All, I need to import several modules which have Time as one of the dimensions into a list. I'm able to save views with hierarchies removed from all dimensions except Time. When I import this has the impact of creating errors (duplicate lines which are not copied over). Not a massive issue but I would like to be able to…
-
Export Data ( Along with subsidiary table data)
Hi Team , I have main module with 6 columns. each columns has many line items. each line item is having subsidiary modules. I wanted to export the main module data along with subsidiary module data also. Is it possible ? how it can be done ? I could able to export has two export files. but i need as one Screenshot attached…
-
Export Action not working for User
Hi All I have created an export from a saved view and saved the export definition with a default file type of Everyone. However, when I include the action on the UX page Action card the user gets a blank file. When I recheck the action the default file type has reverted to Private which I assume is causing the blank file…
-
Internal Server Error while exporting data from view.
Hello. I want to export data from Anaplan view to Azure Synapse Analytics. I have consulted Anaplan's API documentation. I followed it to initiate a request and download all of the downloadable pages in sequence. Due to the large amount of data in View, there are 156 pages available for download. We ran the pipeline and…
-
Export action not working properly
I am not getting the export as i selected in saved and drop down
-
Export action not working..
HI All, I have a module there i have saved view for export. when i exporting in module its showing correct data. when i create the action button and run and see the results its diffrerent . please expain the issue.how to rectify it.
-
S3 Integration with Anaplan
Hi All, I have a scenario where I need to import a file from Amazon S3 every month but the catch is file name will be "abcd_mm-yy.csv" where every month file name will change this scenario will be automated how can I work on this because using the cloudworks I have to choose file name manually. Regards, Venkatesh
-
Data Upload in Module
Hi Team, I need the below requirement. Ex:- If I already uploaded data from a CSV file for any month in the module and if we try to again import data for the same month we can't upload. Is it possible in ANAPLAN?
-
Too much data in view, access token expires during data extraction.
When extracting a large amount of data from a view in api, there are too many pages and the access token expires during pipeline execution. After initiating the request, the access token expires because the time spent preparing the data and downloading the page exceeds 35 minutes. The VIEW of data to be extracted has 1…
-
Request to retrieve data from view is not initiated
I want to import data from Anaplan to Azure, but the request to import data from view is not initiated. Also, it happens sometimes erratically. I would like to automate this process through a pipeline and would like to solve this problem. Since the request is not initiated, there are zero pages available for download after…
-
Unexpected API(POST) Error
I want to import view data in the Azure Synapse Analytics pipeline, but I am getting errors in creating the request. The error statement is this, is the Body wrong? ・Error message { "errorCode": "2108", "message": "{\n \"status\" : {\n \"code\" : 400,\n \"message\" : \"Missing or invalid body\"\n },\n \"path\" :…
-
Import Action not found in the Workspace and Model
Hi Team , Using Anaplan Connect , I'm trying to bulk import from database to Anaplan. I have created a script to import data into Anaplan and also JDBC Properties file. I'm getting an error like Action "Import Action Name" is not found in the workspace "XXXXX ID" and Model "XXXX ID" But when I check the import action list…
-
Error in PDF export of an Anaplan report
Hello, Since this week, the PDF export of Anaplan reports is messed up. More precisely - the first slide is OK : the pdf appears exactly as the slide in Anaplan - but all others are truncated : only half the title is visible for instance (see also the two snapshots). Note that last week, all reports were fine. Now, even if…
-
Create Sequential Code for New Activity
Hi Team, I am trying to create automated code for the new activity I added to a numbered list The format should be like this: Department code - Activity Sequential Code (the structure attached for example) I've tried to make a system module, but the activity code still has duplicates. Is there a way to make automated code?…
-
Import from Numbered list module
I am trying to import from a module in a model which has weeks as a numbered list, into a module in a model which has weeks as its timescale. I cannot get the import to recognise the dates from the source module, and assign to periods in the target module. Is this possible?
-
Dimension Reorder affects any view or Actions
Hi Everyone, I Need to implement planual in which I need to reorder some Line items applies to Lists(dimensions). I want to make sure that this reordering of Dimension should not cause any issues in View(Custom or saved) and Actions. Please Note I am not adding or deleting dimensions in modules just reordering dimensions.…
-
Cloudworks internal user not showing in source model
Hej! At one of our customers, I created an import from one model to another which should run through Cloudworks. Both models are in the same workspace. Source and target model have a Cost Center list with selective access. The modules in both models concerning the import use this list. In the target model, the "Internal…
-
Insert and delete data in Anaplan
Hi Team , I'm trying to insert and delete data into Anaplan using below API. Insert : Delete : Is it the right API to insert and delete ? How can I get the Data's task id ? and how to ensure the insertion and deletion of data in Anaplan Thanks in advance Regards, Vinoth Kumar K.
-
Boolean value from a Time Dimensioned to non-time dimensioned module
Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
-
Setting ChunkCount
Hello Community, I have read the documentation of Anaplan to learn how to achieve export actions. Firstly, I have remarked that it is recommended to set the ChunkCount to -1 rather than set the exact count, but i didn't find the reason or the explication for this recommendation. Secondly, if i choose to set ChunkCount to…
