-
Retrieve more than 1000000 cells using anaplan API
Hi Everybody, I am trying to automate some task by retrieving data from Anaplan using the Anaplan API. Seems like the maximum of cells we can retrieve using the API is 1000000 cells. Since I have a lot of models that have more than 1000000 cells, I am wondering if there is a way to get the data by chunk or any other way.…
-
Deprecation of Excel Add-in Series 3
Hi, Is there a deprecation date for Series 3 of Excel Add-in? Thanks, Alvin
-
Data Integration
Suppose any clients wants our view to automate integration .Which platform is good to start like mulesoft,dell bhoomi ,informatica or any ETL tools or REST API. Please suggest some pre-requisites or some basic question/information which we can ask to the clients.
-
Level 3 Model Building (Importing Module data into List from Data Hub)
Hi, I'm having problems importing data from my Level 3 Model Building Data Hub into the other Level 3 Model's List. I need to Import that from my Module SYS14 Create Account> Product into the List A2 Account>Product. I created the LI's in the Module in the List as Properties, but I'm having trouble pulling in the data from…
-
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
-
Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
-
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
-
L2 Conclusion Import Currency Error
I am trying to import Currency List but somehow it doesn't work.I am stuck at this activity. I am also attaching the screenshots of Error. Don't know whether its a mapping issue or something. Also I tried mapping via Name or Code but still it doesn't work.
-
Level 2 - Conclusion - Create Country Currency List
Hello, While I try to import the currency data, the data for EUROS is not getting updating because it is similar for 3 countries. I tried selecting the name or code also, name only and code only. Tried selecting countries as parent and deselecting it. But facing the same error. Kindly help. Sneha
-
Level 2 Sprint1 1.3.10.3 Import Data into G3 Location List
The expected result is : But the result I got is as below : Can anyone please help me why my result is not as expected exactly? Do I need to delete the rows I have highlighted to get as expected result?
-
Excel Add-in v4.x
Hi, Prior to v4, the was an update.exe file that automatically asks whether you want to upgrade to a new version. Can I confirm that this is no longer in v4 series as the upgrade is via the Anaplan ribbon? Thanks, Alvin
-
Level 2: Conclusion Create Inventory Ordering Saved View and Export
For creating the export and saved view for Inventory Ordering, my beginning inventory is different from the data given by Anaplan to check. This is due to the data imported while attempting my Sprint 3 exam to update Submit Purchase Order Request? So shall I delete the data imported to match it to the exported data? Kindly…
-
Hiding or removing the line item (on the 1st line) of an export from a module
I am performing an export from a module and the user of my export wants to have the extract so that the line item name is not appearing at the top. The line item is sitting on the "pages" dimension on the "pivot" view. In the layout tab, I have it set to: Grid Current Page Omit Summary Items Omit Empty Rows However in the…
-
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
-
how to split a line item in one module into multiple line items in another module
hi Need a help. I am very new (few months) to Anaplan. I got a simple requirement, have to create a new Export module(REP01) from OUT01 module ND Each row in OUT01 will form two rows in REP01. How could I achieve this. Please help. Thanks Module: OUT01 Module: REP01 Regards Balu
-
level 1 exam activity 4
@Misbah Hi, Can you help me on this? I have imported data correctly and formulas also not giving error but I cannot see data in EMP02 module under bonus, car cost, medical costs and phone costs. Hoping to get response at earliest.
-
Import List from List
In all the model building exercises, we are importing list items from module, rather than importing list items directly from the hierarchy lists. Any particular reason for that ?
-
Level 1 - 7.2.3 - Issue in mapping a numbered list
Hi, I am trying to map the E2 Employees# using source of code as it is a numbered list. However, still it is not displaying the employee names.
-
data import
how to import data from one module to another module when dimensions are not match.
-
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.