-
Migrate from Excel Add-in version 2.6
Migrate the Excel Add-in from version 2.6 to the latest version to benefit from: faster performance; the ability to connect to saved views; the use of context selectors; and the use of pivot and filter to orientate and condense your data to one worksheet. Excel Add-in works in Microsoft windows on your PC only. Before you…
-
One Cloud
Hi, Can someone please tell me where can i see Anaplan Cloud in Anaplan platform ? Regards: Shweta
-
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…
-
Mapping timescale during import and ignoring some columns
Hi I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time. Attaching screen shots for your reference. In the source file attached , the first column simply…
-
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…
-
Calling a Process with HyperConnect
Does anyone have any documentation on calling an Anaplan Process via HyperConnect? Thanks, Dmp
-
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…
-
Workflow Approvals : Integrate Anaplan with Microsoft Power Automate
Hi Community, Have you guys have any experience integrating Anaplan with Microsoft Power Automate for Workflow Approvals. We have a requirement to request single/multilayer Approvals and I see Power Automate as the cost-effective solution until Anaplan builds the new workflow solution Power Automate has its own connector…
-
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.
-
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…
-
Inconsistent response for Anaplan APIs
Hi, While trying with Anaplan API GET method to export data from model, I am getting inconsistent response. i. I was getting 9 columns earlier based on which we designed our database schema, now I am getting 8 columns in response. ii. While trying with another user, I am getting all 9 columns in response. iii. If I run…
-
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…
-
Anaplan Connect Demo
Hi Is there demo/video which shows how to download and setup Anaplan Connect? Thanks, Santosh
-
Anaplan API
Hi Here i'm trying to use Anaplan API to build the integration between the Anaplan and SQL Server database. I could have used ETL tools, but I don't have any ETL tools to do this. Can someone provide me information on how Anaplan API works with some examples? I was reading documentation provided by Anaplan using RESTful…
-
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…