Data

Preview Window before creating Revision Tag (Preview of the result in the target environment)
It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in the new UX in page builder mode Thank you Patrick
Fix filter selection for different roles
Hi folks, I have a filter that controls the data category (A or B) shows in dashboards (same model), and this filter could be accessed by Full Access users as well as other roles. However, I don't want the choice made by Full access users to affect others. For example, if a Full Access user change the filter from A to B, I…
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…
Process Ignores one of the Action in it
We have one automated process which has five actions in it which clears the list and reload the new items in the hierarchy. When the automated process runs it ignores the last action which reloads the list. Upon checking we found that the Server has the necessary access to run the action and also the source system(i.e.…
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…
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…

Data

Discussion List