-
Time mapping for daily data imports
I am importing data into Anaplan from a csv file. I am used to seeing the following screen for time mapping: However, this particular upload is daily data and I am seeing the following: Am I doing something wrong with the module setup or is this how imports usually look for daily data? Any advice on best practice for daily…
-
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
-
Converting Data within module
Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you
-
What is the impact if List subset and List are used in same Module.
For example: If a list subset say Pharmacy? which is subset of larger list Stores are together used in sales planning module. Aware that it cannot be used. However keen on knowing what would be the impact.
-
1.5.8.1 Create Saved View for DAT03 Module
Can someone verify my work. My work is not matching with the guided screenshot; It seems that my Jan column is calculating sums; is my Jan 19 meant to hold a value for this step?
-
Mapping data from module to module
IF we have data at Parent level in a module then how can we bring the data in a module having dimension at child level and Vice versa.
-
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…
-
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?