Data

Generating Failure Dump Step - on Successful Imports
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
How to convert a date into 2digit format text DD/MM/YYYY
Hi, I'm trying to convert a date into a text line item but Month and Day sometimes have only 1 digit when I need two. Do you know how I can achieve that ?
True ALM for Anaplan Data Orchestrator
Currently ADO only has a single tenant level environment to all store source data, transformations, and links. This can make managing ALM challenging. Being able to have separate (and sync-able) ADO Dev/Test/Prod environment(s) would be more manageable than housing everything in a single tenant wide space. Having true ALM…
Error on importing data onto employee details module
Hi, I am trying to import data onto employee details module. It is a numbered module. I have attached three screen shots, 1. How it should be. 2. How it is and 3. the mapping which I have done. Please can anyone help?
Request for making Anaplan be able to accept various forms of date formats in CSV import.
Excel opens CSVs and changes CSV's date formats depending on users' PC regional setting whereas Anaplan only accepts single date format in importing CSVs. When users import CSV files to Anaplan, they edit source CSVs in Excel. However, in case of apps for multinational users, depending on regions of users date formats vary…
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…
Streamlined Workflow Migration for Environment Transitions
I suggest enhancing the product feature to streamline the migration of workflows from the Dev Model to the UAT and Production environments. Currently, the process requires manually duplicating existing workflows and updating each task—such as the source workspace, source model, import actions, and ADO links—to reflect the…
Need to create a form for users to fill out and the resulting data logged with several requirements
Objective: To create a reusable "data entry form" that allows users to Create a 'Project' The form requirements are as follows: Project Name, text Project Description, text Estimated Funding Cost, number - currency Projected ROI, number - currency Projected ROI (%), number - percentage Funding Required by - Date, date VP…
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
return the light blue color for the input data
Until recently, the input data in applications was blue. Now both the data entered and fixed by the formula are the same black color (or too dark blue??), which is absolutely inconvenient. I hope the color for the input data will be returned to a lighter blue or an alternative will be found, please.
How does the Model Open Analysis Report change without any changes to model?
We've come into performance issues on our model and requested a Model Open Analysis (MOA) report from Anaplan support. This was very helpful in identifying modules and, in particular, line items that were using up a lot of processing power. The metric they used was Total Calculation Time, measured in milliseconds. After we…
Data validation overview
Author: Audrey Neet is a Certified Master Anaplanner and Director at Tru Consulting. Data validation is the process in which business users ensure that the data in Anaplan ties to their source system. It's an important step in preparing a model for go-live as it ensures the data in the model is accurate and the end users…
Anaplan Add-In Grids Upgrade
Being able to pivot/filter the add in grid without references to that grid getting removed. When I create a retrieve using the add-in and link to another excel tab (formatted for distributions to our leaders) and then alter a dimension using the pivot/filter function it will remove the references on the summary page. In…
Data Import Time dimension
Hi, I need a bit of help. I have a file of the following structure, with Time dimension going across as column headers. The system is setup to 13 periods of 4 weeks. When I try to load the data using Custom Fixed position pattern: YYYY_MM, it fails with an error: Invalid period for format YYYY_MM When I try to load the…
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
Dev and PROD desynced following a backup restoration
Hello Everyone, I have taken over the Workspace Administrator responsibilities within the business and I am still learning about the basic model maintenance tasks. We've had a deployed PROD model synced with a DEV model to sync any structural changes and using revision tags. Recently, I have taken a copy of a PROD model…
Leading zeroes in anaplan
I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally we call this left/right padding or leading zeroes.
How I Built It: Data locking and validation within processes
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Hello Anaplan Community! I’m excited to share this ‘How I Built It’ video with you. In this tutorial, I walk you through two types of actions that you can add to your Anaplan processes to improve your data access…
Levels to show only giving two options, not all levels of a hierarchical list
Probably an easy question but I am working through the level 1 course and it shows how you can aggregate based on a hierarchical list. When I try this on my own model it looks different and there are only two options. My view S01 Is a child of S02 which is a child of S03… S05. I'd like to display only the S03 Level. The…
Hierarchy Mapping from flat list
Currently we report our P&L using list Entity L2 which contains all our entities as a flat list. We want to create a new module that reports the same P&L information but not on a flat hierarchy. The dimension of this module is New Hierarchy L6 which rolls up into our highest consolidation level (TopCo) This is the mapping…
How to lookup transactional data without having many-dimensioned calculation module?
I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis. I want to create a module that end users can input into for their department where they're entering details for their next year's budget. For this,…
Facing issue in column separator
Hi everyone, In the source we are using pipe to separate the columns .In anaplan i have created action using .csv file and now changing the column separator from import data source ans using "|" instead of column. For some data element this is working fine but in few in module i dont see any data. also when open the action…
Many to one text merge
Hi, In my FP&A model end-users can add comments(in text format) to a variance module that is dimensioned by the user list(among other dimensions). How can I consolidate the comments so we can see comments from all users combined? I'm thinking we would have a secondary module not dimensioned by end user. The main challenge…
PSA: Deleted Models are no longer inaccessible to Workspace Admins
Anaplan introduced a new feature that allows for models that have been deleted to be restored by any workspace admin. This is wonderful for customers and partners to self serve when a model is deleted accidentally or needs to be restored and the hassle of going through Anaplan support/your BP makes it challenging or not…
Better solution for a nested IF... but I can't think of one
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIAL and LABEL TYPE. Within the material list we have several labels (FRONT, REAR, DECAL + 6 others) In the module i need to…
Data Loss with Inroducing Time Range
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 years now. We realised the span of time for data in that particular module can be reduced. Idea now is to introduce a time…
Clear Filer
Hello Community I have a list of BU's which is selective access enabled For example: If user have access to only 2 BU's Is there any possibility to clear data related all BU's Is Possible How it is done? Thankyou in Advance
What is Data Management System that was talked about during Anaplan Kick-off this year?
Time change in integration
Hi, After daylight saving time, we have to change our integration timings as well by 1 hour, or it will automatically change the time. Thanks, Vicky

Data

Discussion List