-
ALM - Updates to Module Import Action - Manual Mapping not promoting
Has anyone seen this behavior? Is do, how did you resolve? Module Import Action that includes manual mappings by code to a numbered Production List. DEV Model - Aircraft Type List - numbered, production list - Import Action to Module - update the manual mapping to Aircraft Type List using Code (Action is NOT marked as…
-
Disagreegation logic
Hi Guys, I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back . I there any functionality available for this scenario
-
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.
-
Export data from Anaplan to SQL server through Anaplan Connect script
Hi Anaplan Connect experts, I need some help. I know how to write a Anaplan script to load data from SQL Server to Anaplan module. I need sample script from you, how to export data from Anaplan to SQL server. Could you share me your sample script please? Thank you & regards, Anil
-
Edit Saved View to include New Line Items
Hello! I have a saved view that currently include 16 line items/columns in an exported report. In the exported report, I need to include 3 additional line items/columns, that has been added along with calculations, to the reporting module "REP005 Deferred Tax Report" (see attachment). My questions is, how do I edit the…
-
QUARTER FORMAT IMPORTING PROBLEM
I have a csv file with Quarter value in this column header Q1_2022 we can't change the column header format, so while importing I'm facing problem (Expected fiscal quarter number in date/period). Is there any solution of mapping to import the file without changing the csv file column header? Thanks, Jagadish Dash
-
Data Import with different level hierarchy
Hi All, I have a data hub model from where data is exported to multiple spoke models. Hierarchy in data hub is as follows L1 L2 Whereas in one of spoke model the hierarchy is as below L1 L2 L3 I want to make a data import from Data Hub to Spoke model for loading the data at L2 level. The above screenshot in target module…
-
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
-
disaggregation logic
Hi guys I am working on an example we have a hierarchy as per my image: whenever i input the country wise then the country data should disaggregate to state level and also, from the state level to district level and
-
resetIndex
Hi I am trying to resetIndex on Anaplan numbered list. And I am running a POST through POSTMAN. https://-----/models/45B36E7BA9BB4A0/lists/101000000309/resetIndex - However, I am getting the "threshold has not been exceeded.. " error. The reason I am trying to run it is to ensure that we run the script to reset the index…
-
Different numbers being imported
I have 2 modules, both with exactly the same structure (2 dimensions, multiple versions, no time scale, and with only one line item). I created a simple import from one module to the other, however, once the import has run successfully with no errors, I'm getting different numbers landing in the corresponding cells in the…
-
Referencing line item of module into list
Hello Friends, I use the import from module functionality to update the list from a module line item. However since its a manual process and the list wont get updated for any changes in the line item of module unless i again start the import process, is there any way wherein i can reference the line item of module in the…
-
Cloudworks Integration "There was an internal server error" for BigQuery Data Source option
Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of "There was an internal server error" under the Data Source option. Can anyone provide any advice on how to resolve this?
-
Reset a line item
Hello all, I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one. I would like to reset a user…
-
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
-
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
-
Unable to load special characters using .CSV file
I am unable to load special characters in Anaplan using an import where file is the source. Kindly note the following: 1) Import is setup with text encoding set as UTF-8 2) The format of file that is being loaded is .CSV Following is the text i am trying to import and the text that is getting loaded in Anaplan: To…
-
Connect Anaplan from Databricks
Hi Team, I need to copy my Delta Tables from Databricks to Anaplan. Can someone provide details/script on how can I achieve this task as there are not much open source details available to achieve this.
-
Data integration - Members are not added into numbered list during import with Cloudworks
Hi all, I need to import data from view and I have to import all records from differents views so I am using numbered list for the import. The process is working well when I launched the process with my user, all members are correctly added but not with Cloudworks 🤔 As you can guess, I want to schedule the update and I…
-
import file error
Hi Anaplan Community, Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.