-
Alert Monitoring
Hello Everyone, I've setup a weekly scenario tool that shows your starting and ending weekly inventory with the line items being the key factors like Forecast, Sales Orders, Purchase Orders, Planned Orders, etc... I export this data from SAP. I'm basically trying to recreate the planning book because our company doesn't…
-
Reducing (or declining) balance depreciation
Hi We currently have an asset forecast module set up that calculates the NBV of assets over time which currently only uses straight line depreciation so it's reducing by the same value per month...simple. However we have just changed our depreciaition policy to use reducing/declining balance depreciation and I am not sure…
-
Cumulate Performance
Hi all, I would be really interested to hear your thoughts on the Cumulate function and how you have best utilised this without affecting performance? I understand on longer time ranges it is usually, but not always, beneficial to use Previous instead of Cumulate however would you also break the function out in several…
-
Anaplan Substitute for Excel What-If Two-Variable Data Table
If anyone has an interest, I have a recipe that allows to replicate Excel What-If Two-Variable Data Table functionality in Anaplan aka sensitivity/incremental change analysis of drivers.
-
Import from a Staging Module to a numbered list
I am struggling with the following: I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then…
-
find a module name by line item
Hi Team, Is there any way we could identify the module name by line items? As we are rebuilding/cleaning one of our modules we need to identify the modules name by line item. suppose, say I need to delete/update the formulas for all the line items start with the name "reporting 1 ". When I search for line items in the…
-
Nested IFs (early exits) vs. OR/AND?
I'm curious what others' thoughts are, or if there's been any testing done regarding the performance difference between nested IFs vs. OR/AND. I found a very old thread on this topic from 2014, but I expect the thinking & research has progressed a lot since then. Let's say I have multiple criteria I need to check in order…
-
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
-
Linking two modules with two different dimension
Hi All, I have an issue that I may need some help with. Below is the sample table: Gencon Module (Source) - GenCon List Inventory Module (Target) - Inventory List Gencon Module is the transactional data of the client. In the Gencon Module it is normal to see multiple transaction code with different Start Date, End date and…
-
Delete from list all levels
Hi all, I have 4 levels of accounts, I want to delete accounts not used in my modules. I have created a module to identify accounts not used and set a boolean format. I created an action for Delete from Selection that references the module boolean line. It only seems to delete the base list level. How do I adjust so it…
-
ALM Distrubed
Hi Experts, In our PROD model, mistakenly ALM Structure was disturbed. Is there any option to revert back the ALM Process Structure and we cant restore the model because the user has inputted a huge volume of changes. Please help me for this Regards, Uma
-
Tagging Duplicate Items
Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows: item 1: Product A item 2: Product B item 3:…
-
Move multiple actions in a process at one time
When you add actions to a process they are added to the bottom on the list of the already existing actions. Whilst you can move a single action I would like to be able to select multiple actions and move them in a single action.
-
Line Item Format move Style format dialogue
When you click on the line item format I would like to be able to choose my style at this stage rather than having to scroll to the right to then change the style that is applicable to the line item.
-
Master Data based on Scenarios
Hi Can I know how to change master data based on scenarios ? Example I have Regions List consisting of 3 regions and Scenarios list having 3 scenarios (Base Scenario , Scenario1 , Scenario2 ). The data related to these 3 regions should be base Scenario and in future if I add another region the data related to these 4…
-
Allow un-balanced hierarchies on composite hierarchies for child hierarchies
As a model builder, I would like to be able to add "parent" elements into the child hierarchies (Level 2, 3, etc.). As for now, in a child hierarchy is allowed only to add leaves elements (elements without children) because as "parent" are allowed to be set only elements from the parent hierarchy. As for now, the unbalance…
-
What is the Longest Model Time Range You've Used?
If you feel comfortable, try include: * Model time range (actuals + forecast periods) * Industry * Usage Mine is: - Model time range: 2 years actuals + 10 years forecast - REIT - PB&F
-
Creating an As-Of Version
Hi, I was wondering if users can create an as-of version in Anaplan. Thanks in Advance, Daniel
-
How to model annual inflation in Anaplan?
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period. In this example, I am trying to model the annual inflation rates. In Excel, it is quite easy, just type…
-
List Formatted Line Item Selective Access
I am requesting the ability to control if a user can copy/paste into a list formatted line item cell with selective access enabled. Currently, model builders can restrict a list formatted line item drop-down to only show list members for which a user has selective access. However, this restriction is easily violated by…
-
Notes Availability in the New UX
When you build an Anaplan model you can add notes to Modules, Lists and Line Items amongst other things. I would like to have the option in the New UX to be able to pull these notes forward and display them as informational messages in the Pages in the same way that you can currently add information to an object.
-
Roll up blank children into parent list?
Hi all, I'm working on an incarnation of a the Anaplan Agile app, where we track user stories in a list and those roll up into epics in a parent list. In my user story module, the user stories can be tagged with a status (not started / in progress / complete / removed), or that cell can be left blank by the end user. In my…
-
Option to pick a separator, when using TEXTLIST as "Result = Source[TEXTLIST: Mapping]"
Good to give user the ability to pick or type a separator instead of default comma, as there might be commas in the orginal text strings already.
-
Import data to a module, best practice?
Hello, I have the following data: Name/Formula/Format/Notes Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format) Cost…
-
Meeting Invite Through Anaplan
Hi Can we schedule a Meeting invite into our mail calendar through Anaplan? Thanks Tejaswini
-
Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
-
Platform for new users
Hi All, Recently, have started exploring the Anaplan, can someone please let me know how I get a platform to test and explore options. I want a platform to work on my ideas.
-
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
-
ALM and History changes
I accidentally make an error and realize it instantly. So alter it back to the previous one. My history gets saved. Now I archive the model and later change it to standard one. Will Tenant Admin still be able to pull the history?
-
Allow for users to breakback on time and not other hierarchies
I have a customer who wants to use breakback for time but not the other hierarchies in the module. They are planning for cost centers and require users to enter data at the lowest level. However, they want to enter data for annual periods and break back to the months. If we can separate the other hierarchies from time,…