Data

Bulk API Integration
Hi All, If I upload a file to Anaplan server using Bulk API, can a user manually run the import action from actions page in Anaplan to import the uploaded file into the Anaplan Model, are there any limitations or pre-requisite? For example I understand if I am uploading the file using basic authentication with a user ID…
Can Data Hub hold formula related data? or just the spoke model is supposed to that?
Upload Image for NUX
Anaplan don't allow to upload images but there is the possibility to show them only with the use of links. This can indeed streamline the App but it can generate some problems where some clients have restrict web access in regards to websites that are visitable. It would be great to have the chance to upload image and -why…
How I Built It: Data validation
Author: Matt Liffmann, Certified Master Anaplanner and Senior Solution Architect at Deloitte Consulting. Hi Anaplanners! My name is Matt Liffmann, and I’m a Senior Solution Architect at Deloitte Consulting. Today I’m excited to share a ‘How I Built It’ tutorial on data validation. Data validation in an upfront Data Hub is…
What is the process for viewing a workspace map like a model map in Anaplan?
Hello, I'm attempting to figure out how to examine workspace maps, similar to Model maps. It will be useful for us to keep track of the dataflow between models. Is there anything we have for Anaplan? TIA
Displaying an Incorrect Version of Data
Hi All, I just would like to check if anyone experienced the issue wherein affected users are viewing an incorrect data (ie. Actual was selected as version on context selector however, the report in Apps shows Budget data). I tried to replicate the issue by giving the same role permission on my account as affected users…
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
Data Alignment on Columns in UX Grids
Hi, it would be very useful and nice to have the possibility onto the UX Tools for Format Settings to aligh the Data inside the cells on the right, centre or left. In this momenti this functionality is possibile only for Column Headers and Row Headers, but not for Data. Thank you.
How can I restrict users selection of months
How can I restrict month selection drom a dropdown? For example I would like to set a dashboard where end users can only select pre-defined months i.e. Jan 23 to Mar 23. Is there a way I can easily change this by adding (locking/unlocking option) additional months if needed. Thanks!
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
Model Builders and Solution Architects: We want to connect with you!
Are you a Model Builder or a Solution Architect who works to create a set of rules and validations for data in Anaplan? If so, we want to speak with you! We invite you to join us for a 60-minute remote research interview, during which you'll be asked to weigh in on a new way of creating rules and validations in Anaplan.…
Does file ID change if I update the import source for an action?
Hi all, We are testing bulk API's data import, on which I had 2 queries. Suppose I create an action in Anaplan for a file and then data in loaded using bulk API's, but later I went to manage import data sources and updated the import source of that action with a new file. Will this change the file ID of the file which is…
How to convert Month Line item in text format to Month Format
Hi All I have two month line items in text format as shown in picture and want to convert to Month formatted line item. What steps should I take so that I convert it into Month formatted line item. Thanks in advance
Working with FP&A data in Anaplan: share your experiences!
The Anaplan UX Research team is looking to speak with solution architects, model builders and integrations specialists to understand your experiences of working with FP&A data in Anaplan. We invite you to join us for a 60-minute, remote research interview during which you will be asked to weigh in on this key topic and…
Share your experiences: Preparing Data for Anaplan
The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…
Fortnightly time scale in Anaplan
Could you please share any custom day level time scale hierarchy Fortnightly time scale For January (Jan 1 to Jan 15, Jan 16 to Jan 31 ). For Feburary (Feb 1 to Feb 15, Feb 16 to Feb 28 ) @Misbah, @Manjunath
Increase the Cell count limit on line item blocks for Anaplan
As a model builder, I would like to see Anaplan increase the upper limit of cell count on a single line item block (currently it is set as 2,147,483,647 = 2^31-1 cells), so that I don't have to model certain filtering modules/logics outside Anaplan. I know this is successful when the limit is increased to 4,294,967,295 =…
Share your Experiences of Data Preparation Processes in Anaplan
The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…
Data Entry Shortcuts for data input in UX
It would be useful to have more shortcuts when entering data in the UX. At the moment we can enter e. g. 1e3 to input 1000 in a cell which is great and makes it easier to enter high values. In addition, I would find it useful to have at least these shortcuts as well: Shortcut ‘+’: By entering a value using '+' the value…
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
Data Related Training Classes
* Anaplan Connect (301) * Anaplan Data Integration Basics (303) * Creating a JAVA keystore for use with Anaplan Connect Overview This set of classes address how data is used and managed within an Anaplan model: Anaplan Connect (301) Anaplan Connect enables the Anaplan administrator to automate Anaplan imports of data and…
How to know a parent is selected
Greetings, We have a model where a Employee have territories assigned, each territory have accounts assigned. At the moment if we edit the end date of a territory the end date of the accounts stay the same. So i want to make a formula where if we mark the territory for edition , a boolean on the accounts gets active as…
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…
Input time range
Hi All, Is there a way to restrict users inputs of a number (formatted) line item to values between -1 and 1. I cant use a list for this as users are free to add any decimals. Thank you in advance for any suggestions.
How to prevent edits to a version
I have set the edit from/to fields to 'None' However, for data inputs where there the time scale is set to Not Applicable, users are still able to edit the data inputs. Is there any way to prevent this?
Insights and inspiration! Two "5 mins reads" for those interested in data and application challenges
In the last couple of months I have really enjoyed working with @PeteD on a couple of different articles on topics that we think resonate across all industries, lines of business, and basically anyone trying to navigate the modern data and application landscape. In case you missed them see below for the links to check them…
Are you using Anaplan's UX? Find out more today!
Our engaging user experience brings in people to the right place and at the right time, across devices, across solutions, leveraging the speed and scale of a purpose-built planning platform - enabling better, faster, decisions. With Anaplan's UX you can: * Personalise your experience * Visualise Plans and Data * Plan…
Join us – Everything you need to know about Anaplan’s Management Reporting functionality!
What is it: An event showcasing Anaplan’s Management Reporting functionality that allows users to create formatted, customizable reports that highlight key insights that empower business leaders to make more informed decisions, fast. When is it: Thursday 21st October 2pm BST How do I register? Clink the link here to…
The 3 Pillars of Connected Planning: Part 1⁠—People
Chief Planning Officer Simon Tucker speaking at CPX 2019. As you’ve surely heard by now, Anaplan is the pioneer of Connected Planning⁠—an approach that uses next-generation technology to connect people, data, and plans across the enterprise to combine strategic insight with business foresight. Ultimately, this allows…
Implementing Anaplan to Transform Commercial Planning
During CPX 2019, Supply Chain Lead Jordan Hardy and Principal Solutions Architect John Dorma from Twelve Consulting Group, sat down with Ryan Meehan, Director of Finance & Strategy at Prestige Beverage Group, to discuss how Anaplan has transformed the way the beverage company does commercial planning. Today, we're…

Data

Discussion List