-
Export button on the Imports tab under Settings > Actions
I frequently export the Imports table under Settings > Actions when troubleshooting or working through a model. Connections between models or modules/lists through actions are not displayed in the model map so I highlight the Imports table and copy/paste into excel to diagnose/troubleshoot actions and discover…
-
DCA Import Access For Combination List
Hi All, I am working on a model where I have a module with dimension including a combination list, version lists & stages created with respect to P&L. The combination list has been created with the combination of states (rate area), product (Sku) etc. Now to restrict the access of each Regional Finance Manager so as to…
-
API 1.3 changes
Hi, I had some issues this week with the API 1.3 interfaces https://anaplan.docs.apiary.io/#reference if you also have problems please try this: * PUT method to upload file: In the Header the Content-type should be application/octet-stream * GET method to download a file: In the Header delete the…
-
Import Action Into List from Saved View is not importing all values (no failures/ignores/duplicates)
Hi, I've setup an import action from a saved view to a list in a different model & workspace. It imports without any failures or ignores, but it does not import all of the items. Why is it not importing all items & how do I change the view and/or import action to fix it? Source (Data Anonymized): * 3 dimensions pivoted to…
-
Default File - See & Use
Hi team, When discussing the Default file in L2MB the training states setting the Default File sets you can see and use the file. I'm not 100% sure what this is referring to because my understanding is: - You select between No, Admins Only & Everyone for 'Set Default File' - You are only able to view the Actions/Imports…
-
Ability to export in .xml format
Description of Enhancement: Customer would like to have an option to export data to XML format. To provide more clarification, could you please explain how you hope the enhancement would assist in your business process(es)?: We have a need to be able to export data to this format so it can be imported to Workday for the…
-
Specification of importing a file changed?
Hi experts, I think specification of Anaplan importing a file has changed. Is my understanding correct? When we try to upload a file, which includes both key record that exists and doesn't exist in master list, <Before> Displays only "Success!" message window, and number of failed records can be confirmed in "View Details"…
-
Delete List Item no longer found in source
I am working to remove Gross shipment data that is no longer found in the source DWH feed. Shipment actuals can be removed from the source data and I need to remove those not found in the source from the Data Hub and from the spoke planning model. When the shipment actuals are removed from the source them remain in…
-
Data Import
Hi, I need a clarity on data import through integration. For the first time load the load was set and configured in the Integration process, but what if next time the data load comes in with a different delimiter or separators. Will the Integration load auto detects the load and adjust the import or will it give a error.…
-
Have imports run base on the display name rather than a unique ID
This can be an issue when running a Module to Module Import, if both the target and the source module are dimensioned by numbered Lists, if the target Module's numbered list(s) the import will coordinate the import based on the numbered list(s)' Unique IDs. This means that some values will fail to import and other values…
-
Import Error - Source Model Archived
Hi team, I'm receiving a 'Source Model Archived' error when creating an Import from another model. This source model is not archived as I can access it and I have checked whether it is archived, it is not Any idea why this error would be presenting? Thanks Mark
-
Allow export to XLSX
I want Anaplan to allow me to export to the XLSX file-type rather than just XLS or CSV. XLS can't stand up to the amount of data I want to export. CSV is not sufficient for what I need it for
-
How to create a script of your model
Hi Team, Can someone help me to understand, how we can create a script of module which we prepared from our internal Anaplan environment, so that we can use it in any other Anaplan environment? for example: I am using two different environment for Anaplan, one is normal environment & other is partners environment, know i…
-
During Import - Choosing between Fixed Values & Column Headers
Populating line items with values. Would both give the result? When to choose what?
-
How to hide admin-like result of running a Process
Hi Experts, Please help hiding admin-like view of process running result. Is there any setting for this? Our client doesn't want to see each action succeeded or not. <As-Is> <What my client wants to be>
-
Pushing excel formula results into Anaplan using the excel plugin
What I want to accomplish is to pull down data from a module in Anaplan using the excel plugin, overwrite the Anaplan value with an excel formula, and push the result of that formula back into Anaplan. On the initial refresh it will send the calculated value into Anaplan, but on refresh, it wipes out the formula that I…
-
User Enabled Import Action
Hi, I have a User Dimensioned module. I want to import data from one line item to another in the same module but it has to be for each specific user. Only the Action is published to the dashboard. When I run the action alone, the data is getting imported for all the users irrespective of who is doing that. Is there any…
-
Uploading file Via REST API and Triggering Imports
Hi All - I am working on a small POC to do the following: * Create a simple list in anaplan * Import data into the list via file upload. * Permission on import/upload file will be sent to "Admin Only". * Import/upload will be done initially with my user account (ie damian.shameer@xcompany.com) * Create a systematic/batched…
-
Copy data from one scenario to another
Hi, I have an assumptions module with country, time and scenario dimensions. The scenario list has the following members. Upside Base Downside The user wants the ability to input assumptions for the base scenario and have the system copy the assumptions to the upside and downside to start as a baseline. When I try to…
-
Basic Authentication Talend Workflow Example
There is a small, but growing, user base interesting in integrating with Anaplan using Talend. Previously, we shared (upon request) a sample workflow, with the launch of our latest API version, I've been working to update this demo. Today, I'm sharing a very simple workflow, which fetches a list of imports from your…
-
Short data for import
Hi Anaplanner, I'm import data like this, but i want to sort data based on color before im import to another after import the data will be like this can anaplan provide like that? Thanks, Panji
-
Import into a List Formatted Line Item
Hi, I am trying to import value(top Hierarchy) from a list A formatted line item to another List A formatted line item. But the import is getting failed. Is it possible to have this kind of reset action to make the selector to ALL(top Hierarchy) by default when nothing in the list is selected by the user. Example: Select…
-
Export from a Saved View
Hi, I am trying to create a process for export on a dashboard, facing few challenges in the data. 1. I created a saved view in a module where time is a dimension (time in Months) 2. Build an export action to run the export where Time is a selector and saved that export action and created a process from that and published…
-
Importing is not updating correctly
Hi Friends, I am trying to import this .csv file into my module. But I can't do so. I think I need to create a Col ID. My ques: will the newly created Col ID able to match data in another module with different ID? I will brief my problem elaborately, in case you find any difficulty in understanding.
-
Import Help requested
Dear Friends, I receive this file every month from the vendor. I want to automate the process of adding the file. I want to follow the process of certification. Please tell me, how is it done.
-
Who's interested? Office Hours with Rob Marshall - presented by the Anaplan Community
Alright Anaplanners, we’re giving you direct access to Anaplan experts to answer those tough questions. Is there a formula you are struggling with? What about a list or line item? Getting stumped working with a specific dimension? We’ve got the expert and the answers! How does this work? Well, if we’re honest, this is our…
-
Import Action - Not Importing All Data
Hi, I want to upload a .csv file with 8,008 items with 7,999 unique values (codes in the file are unique for 7999 items). After uploading the file into a numbered list, only 2,777 items are getting into the list and in the import summary, it shows 9 items are ignored which makes sense as these are repetitions. However, the…
-
Import Issues with date and time format in CSV
Hi everyone, I am trying to import data from CSV file. However, whenever I try to modify the data and save the file with CSV format the Date and time format in CSV automatically changed to its original format. Our Anaplan models cannot recognize the original CSV format, so I have to re-input it. Can anyone help me to solve…
-
Audit during bulk uploads
The User would like: A more detailed view of auditing functionality during the ‘bulk upload’ process at the cell level and create an ‘action’ during import. The action would be created upon export of the audit history. During the Sales planning process the User takes the 1st pass of Territory assignments and has the field…
-
Able to use the row id number as unique identifier when import a file
It would be really useful if the row id number ("Line #") would be available as additional column when import a csv file or from any other external source. When import files in Anaplan, usually the first step is to import the file into a numbered list where the file columns are transformed in numbered list properties. To…