-
Value is not getting exported
Hi Friends, I am trying to export but only Time and Lists are getting exported. And no Line Items and their values. Please tell me, when it happens and what do I need to do?
-
Efficient way of exporting large number values from Anaplan
I have a line item which contains number values, usually 13 to 15 digits long. While exporting these number values data is converted into scientific format. For example in Anaplan grid, we can see number as 1,522,731,938,281.0 . Whereas, in the export the same number gets converted into 1.522731938281E12.(Scientific…
-
New List creation
Hi Friends, I have an existing module with Order ID. I want to create new List as follows.
-
Understanding the APIs of Anaplan particulary using the Upload API from http client
I am looking to integrate Oracle SOA with Anaplan, specifically my requirement is to feed data from a Oracle SOA BPEL to Anaplan. I have gone through the Anaplan API documentation and looking to use Upload and Import APIs.Approach I am planning to follow is write the content from Oracle SOA to a file and then upload that…
-
transform data's timescale
if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A? Thank you.
-
Importing data Module-to Module
I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’ and it doesn’t exactly tell what is the problem. I want to import data in Module F from Module A and Module B. I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would…
-
How do edit an action mapping
If I try to click edit on the mapping of an action, it just says the following error, but i am unable to change the mapping. Manage Import Data SourcesThe uploaded file is no longer available; please upload the file again - another question. If i create a new action and rename it the same as my previous action, does…
-
Using Mulesoft for integration
Hi all, Question if anybody uses Mulesoft for integration with Anaplan. Is it possible to trigger Mulesoft action, that basically starts import ore export in Anaplan with https:// link? The reason is to have ability to start loading porcess directly from Anaplan dashboard
-
Formulas Text
I want to write Sweet for all taste. Please tell me, how can I do it?
-
Help Post ---- Import Parent Level data
Dear Friends, I am in urgent need, to find the Parent level total in a different module. But I am unable to do so. SUM, LOOKUP didn't work mentioning issues. Kindly help me, I am in really dire need.
-
ALM synchronization
Does ALM synchronize Dev Data with Production Data and vice-versa? Even though they are in different environment? Please respond friends, as I am new to this.
-
Create non-numbered composite hierarchy with List Import where parents and children have same names
Hi Anaplanners, I am struggling with creating a non-numbered list composite hierarchy through List Import. As described in the attached file, a list I am trying to create include a child whose parent has the same name. I could create such a list manually but it failed when I try to create this list via List import from the…
-
Production List
Please tell me friends, if I mark a list as a Production List, then will it be visible to end-user? And how can the end-user update that list? By clicking insert as we do from development? Or we have to create action button for this?
-
Retrieve information from subsidiary view to use in a Boolean
Hi, I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item. I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month. I needed to see it with a yearly time scale as well so I created the view below with time scale…
-
Anaplan error 404 when importing to Anaplan
Hello, I have error when importing data to Anaplan using new CA certificate and version 1.4.1. This command working in Anaplan connect 1.3.3.3 java -d64 -Xmx48m -Dhttps.proxyHost=XXX -Dhttps.proxyPort=8080 -jar "XXX\anaplan-connect-1-3-3-3.jar" -c "XXX\xxx.cer" -workspace "XXX" -model "XXX" -file "XXX.txt" -put "XXX.txt"…
-
Series of Action (Process)
Hi Friends, I want to know, I have 6 Modules. Mod1 data flows to Mod2----> Finally Mod6. Now can I create any Action to automate the full process?
-
Anaplan connector 1.4.3 not giving output
Hi Guys, We are upgrading the anaplan connector to v1.4.3. We are using a .net application to consume the connector and import data. We are having 80+ lists to be imported everyday and the .net program used to pick one by one and import the data to anaplan. Based on the output, we are considering the data is load…
-
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
-
'Upload File Not Available' Errors / Default File Setting for Deployed Models
We have occasionally experienced failures in import actions (on deployed models) called via Anaplan Connect with the error ‘Upload file no longer available’. Our understanding is the default file should to be specified as ‘admin’ instead of ‘private’. This setting can’t be changed via API call, so we updated the mappings…
-
rename the filename of a file before export
Hi Community, I have a module in which I created 2 saved views in order to have 2 different export actions (1 for region A and 1 for region B) . I saved the export definition and used Export name: forecast_A for the first export and forecast_B for the second export. In the actions overview, I see those 2 different export…
-
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
-
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
-
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.
-
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
-
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?
-
Trouble importing System module to Numbered List
Hi, I'm trying to import a system module containing flat list dimensions (store, product) containing line items that combines store and product code into a combined numbered list that up until now only have stores in it. When running the import I get below failure messages although import was completed: * Another row has…
-
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
-
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
-
Excel Add-Ins with password protected spreadsheets
Hi, does anyone know if there are any workarounds when using the Excel Add-In, if you want to password protect your spreadsheet? We have an end user who wants to do this, but is getting error messages when the spreadsheet is password protected (fine when he takes the password protection out). Thanks, Andrew.
-
Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system. This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs. How can I bring this efficiently to…