-
Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
-
Introducing Anaplan API Python SDK
Author: Vinzenz Klass is a Senior Data Engineer at valantic. Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support…
-
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.…
-
Export Hierarchy even we don't have child's assigned to parent
Hello @community members, I am encountering an issue while attempting to export hierarchical data to downstream systems and would appreciate any assistance. Current Scenario: I have a hierarchy consisting of 6 levels(A0, A1, A2, A3, A4, A5, A6). Upto the A3 level hierarchy is well defined. However for A3 level I have 100…
-
Lookup error : invalid lookup list X is unused
Hi guys, I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it For some context I have : LI1 reference dimensionned by "Dimension A" format number LI2 target dimensionned by "Dimension B" format number LI3 dimensionned by "Dimension A" format "dimension B" (a basic…
-
Data Related Training Classes
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 lists, exports. and other actions from the client. Find out more about this valuable tool in this course. The Anaplan…
-
Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
-
How do I create a dynamic picklist upon Boolean selection?
I want to create a dynamic picklist, where I will check boolean from a line item, only true values will allow me to select list items else on default it wont show anything. For example: Assume a scenario where I want to assign at least 1 employee who is present in my office to become the pantry inspector & review the…
-
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…
-
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…
-
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…
-
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…