-
Excel Add-In: Improve performance populating model/module lists in Excel Add-in
Description: Performance needs to be improved or the user needs to be kept informed of what is happening. Impact: When creating a new view the list of modules to choose from can, potentially, take minutes to populate.
-
Overlapping text on /model-building/
Each time users change a page (via Select Pages) Anaplan’s excel plug-in creates a new tab. Use case: When a new month comes along, they would rather just select a new month via Select Pages and update the current sheet. Similarly to switch Versions a new sheet shouldn't be created. This is so that they don't lose their…
-
Excel Add in 3.2 name range format
In Excel Addin 3.2, the name ranges have changed names compared to 3.0, adding a connection guid to the end. There should be an option to keep the old format This will allow users to upgrade from 3.0 to 3.2 where they have formulas referencing name ranges
-
Excel Add-in Copy Excel Tab to Duplicate Query
Allow for the capability to copy an Excel tab containing the Anaplan Excel Add-In defined in that tab and duplicate in a new Excel tab. This will reduce having to completely setup a new view if exactly the same as the existing tab.
-
Anaplan Excel Add-in : Combination of versions 2.6, 3.0 and 3.1 in one future version
We are using Anaplan EXCEL Add-in version 2.6 because of its two-way data transfer concept. Unfortunately the later versions 3.0 and 3.1 are one-way Add-ins (no refresh-function). Our idea: Later EXCEL Add-ins should include at least the features of former add-ins in order to not be forced to run all Anaplan EXCEL Add-in…
-
Calling a Process with HyperConnect
Does anyone have any documentation on calling an Anaplan Process via HyperConnect? Thanks, Dmp
-
API: GET the data in a chunk in JSON format
Description: Enhancement request for Export API: Download file (sample URL below) to output data in JSON format Example of enhancement: GET https://api.anaplan.com/major/minor/workspaces/workspaceID/models/modelID/files/fileID/chunks/chunkID Benefit/impact: Anaplan Connect does not have the Export (direct) into Oracle…
-
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.
-
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…
-
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
-
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…
-
On an import have the ability to Ignore All
Currently when manually mapping fields in an import there is the option to Match, Ignore and Clear All. It is often the case that it would be easier to set the import to Ignore All and then to match only specific fields on an exception basis. The current requirement of clicking each field in the import you wish to Ignore…
-
Creating Imports: Search for Saved View, Module, or List
When creating import actions that connect to lists, modules, or saved views within Anaplan models, it would be useful to have a “Search” button to assist in locating the list/module/saved view the model builder needs to select. This search feature is incorporated into other parts of Anaplan and, should it be added to the…
-
Access to source views on saved exports
When an export is created and saved, from a saved view, it does not indicate the source of that export (only the source module). It will be very useful, when an export is created from a saved view, to have it recorded in Anaplan, in the same way as the Imports are recorded their source view.
-
Recognise zeroes and blanks as different data inputs when using number formatting
Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as a number. For example - the default calculation for sales volume generates 50 for January 2018, there is an "override" line…
-
Default Import Setting
It would be great if the 'Default File' setting when you import a csv into a module could be automatically set to 'Admins Only' or 'Everyone' instead of 'No (keep private)'. Our company uses an ETL tool to load data into models and if that setting is not changed then it causes errors and we end up with data that is not…
-
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?
-
An action to export Dashboard as PDF
I exported a dashboard in PDF format using the Export option. It will be really helpful if this an action that can be published to the dashboard. So that business users will not have to go through all settings and all.
-
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.