-
Import Process
Hi All, I have an import process in my model from module to module. The process is taking about 20 mins to get executed so are there any possible ways which can be used so that the import process time can be reduced. Thanks in advance!
-
Does Anaplan platform provide capability to pull data directy from a SQL Server database?
Hi, The company I am working for has a datawarehouse in the cloud to which the files needed in Anaplan are loaded on a daily basis. This SQL Server database lives on Amazon AWS. Is it possible to connect to this database and load directly into the Data Hub? Is this possible through Anaplan Connect and where can I find…
-
Anaplan Excel Add-in version 3.4
Is there a way to retrieve two or three Anaplan reports to one excel add-in tab? I tried but it jumped to a new tab. Thanks.
-
Formula
Hi, I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module with extra dimensions(i.e. brand and channel) thereby…
-
Posting it for Wider Audience
These are my latest three articles that got published as Best Practice in this month. Please read if you haven't already done so, for they say Sharing is Caring 1. Anaplan Time Import Mappings Untangling Anaplan Time Mapping in Imports - Anaplan Community 2. New UX and Analogies Understanding Anaplan's UX with Analogies,…
-
Fetching anaplan export defenition failing with HTTP 500 Error
Hi Experts , I'm new to Anaplan and working with anaplan REST API's . I'm trying to fetch the export defenition from anaplan using postman . I have 4 export ID's for which I need to fetch the metadata . One of the export ID gives me the right metadata structure as output when i use a GET method and call the below…
-
Need suggestions for API call of export process for integration
Hi All, I have provided the Export Process Names and the file names to the integration team for API call for integration with SAP but the team is getting some error and unable to fetch the metadata. Kindly suggest how to to that. Below is a sample export process name and file name with the error File NameFile IDProcess…
-
How to upload data into week time when my format is week number
HI Anyone please guide on how to upload data into week time when my format is week number. I tried and got error of mapping and week headers. Thank You
-
Creative usage of Office add-Ins
General Information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If you would like to contribute or comment, please contribute…
-
Excel Addins synchronize page selector
Hi, I have multiple sheets in my Excel where each tabs represent modules in Anaplan. Is it possible that when I change the time in one tab all the other tabs with time dimension will be updated based on my selection? I tried the Sync Sheet in Anapedia but with no luck. It creates thousand of tabs that I need to cancel.…
-
Retrieve user details when Importing to list
Hi, I have a module where the user populate a few line items with information, which is then imported into a list and used further on in the model. However, now the client wants to include a column (line item) where they can see who made the new "transaction", that is, the user that is logged into Anaplan. So my question…
-
5.06-02 Delete unwanted sources
For one off imports, or when import sources are no longer required, delete the sources to keep the source list tidy
-
5.06-01 Naming Convention
Rename the import sources as soon as possible. For a saved view include the module name (e.g. module.saved view). For model imports, include a shorted version of the model name (e.g. model_module.saved view) Best Practice article: Naming Convention
-
Data Export in Individual Tabs in Excel
Hi, I was trying to take export in form of .xls where each item in my page selector should get copied to an individual tab in Excel and the tab name should get renamed as that of the page selector. I was able to get individual copies from each page selector in separate tabs by Exporting in Grid view and selecting All Pages…
-
Ability to include a timestamp on exported XLS files
Description of the enhancement required: Date Time Stamp as data field in the exported file (accurate to DDMMYYYY HHMMSS) An example of the enhancement: Formula which captures the current system time at time of export would be highly appreciated. How would it help the business process: The customer server would be able to…
-
Anaplan API Python Library
NOTE: The content below is out of date. Please find the updated library at Anaplan API 2.0 Python Library - [Updated March 2022]. Note: While all of these scripts have been tested and found to be fully functional, due to the vast amount of potential use cases, Anaplan does not explicitly support custom scripts built by our…
-
Data export
Hi Friends, Other than Tableau, what are the external systems where data gets exported?
-
Can someone please explain, what these mean in Anaplan Informatica Connector?
-
Import Action Categories and Separators
The import action management section often becomes messy because ALL import actions are saved. Would love the ability to create sections and separators, to better organize the import actions I intend to repeat. The following example was created from dummy imports, but it would be great if this feature were built in. I…
-
Release note details for August 22 maintenance
Hello, Is it possible to learn the details for the August 22 maintenance? I see details related to the August 8 maintenance but nothing afterwards. Does that mean that the maintenance being performed tomorrow is not significant? Any information would be welcome.
-
Unable to Import to the Same Module Using Saved View
Hello, I am having this difficulty since last night, I can't figure out how to address this issue. If anyone has encountered this issue before, what did you do to solve this? Situation: 1. I have created saved views inside the same module. I'm using saved views to import to the very same module. 2. The module has a custom…
-
Level1 Training 8.5.3 Activity: Import Data into Volume Inputs Module
How can I set Mapping tab? Is it correct below? Souce column header →Time Location Code →G3 Location Product Code →Products Fixed Items →Volume inputs line items
-
Excel Add-in Authentication method settings (applicable to PPT as well?)
Hi, As an add-in user I would like to be able to change the authentication settings anytime after the first installation attempt. This is because while a number of users might be able to install an Add-In on their machine with non admin rights they would not be able to uninstall it. This means that if a user is providing…
-
Add-Ins - Quickly Edit/Amend connections
As a model builder/user I would like to be able to quickly amend my connections so that they can easily be re-pointed to different Workspaces and Models. I will know that this is successful when I will be able to quickly change my connections and re-point to different workspace and models, perhaps with a functionality…
-
Excel Add-in: Allow for the ability to connect spreadsheet interface to more than one connection
If a model is archived, then retrieved , its model ID changes. The model ID change disables the spreadsheet's data connection. Suggestion: Allow a spreadsheet connection which was created under Model ID "Example_1" to be redirected to Model ID "Example_2". Otherwise users are at risk to lose work created under Model ID…
-
Ability to change switch models in the excel add in
moment when you set up an spreadsheet reports pack via the excel add in you select a model to work from and are not able to change this. I would like to be able to change the model you look up to without having to rebuild the reports pack. We have a medium sized reports pack that works in the excel add in taking a lot of…
-
time mapping while importing the exported module
Hi all, I am trying to import data using the export file of the module which has weekly time scale. Every other dimension mapping is ok instead of the time mapping as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy. I am attaching the screenshot of the exported file and the…
-
Integration of Data hub & spoke model
Hi all In an implementation if I have loaded all the master data(assume product list) in the first month and in the next month we have few more products added will we load all the data again in the next month or only load additional items? If we are are only loading additional items how can we update the attributes of old…
-
Local settings for .csv imports - Booleans
Hello, I faced a problem when importing boolean values to anaplan as part of csv file. Our company uses localized version of MS Excel, which when saving a file containing boolean values to text/csv, keeps them not as TRUE or FALSE, but as local equivalents ИСТИНА and ЛОЖЬ. I can try to change my own excel settings, so I…
-
maximum number when creating numbered list
HI, Is there a limit as to the number of items you can import using numbered list? Is there a maximum number you can import in the numbered list? Thanks, Ana