Modeling

SUM function based on User-specific filter
Ok, here's the situation: - I have a transaction module - The transactions are children of Cost Centers - The transactions feed into a reporting module using a SUM function - There are certain "special" cost centers that exist across different functions\parents in the Cost Center list - I need to be able to give the users…
Tracking employee\asset moves
I'm looking for a way to track employee movements. I have a transaction table to that includes Employee Number, Cost Center and Month values. Is there a way that I can look up the Cost Center that was assigned to an employee from a previous month? I know there is a PREVIOUS function that can pull numeric values, but wasn't…
Workspace Naming Best Practices
Hi, We have over 1/2 a dozen workspaces. Are there any restrictions to the naming conventions for Workspaces? I know we'll have environments for Development, Test, UAT, Productions, etc. What are the best practices for naming Workspace environments? Are there character limitations? Thanks Daniel
Does anaplan have any plan to expand Pivot max number of dimensions
Are there any plans to allow more than 3 dimensions in a pivot, I have a situation where that would be required. Or are there any work arounds? thanks
Is Anaplan’s New User Experience Right for My Organization?
If you attended Anaplan's CPX conference last year, you've probably already heard about and seen Anaplan's New User Experience (New UX). After seeing a demo or two of what is possible with the New UX, you are likely wondering, “what else do I need to know before implementing the New UX?” To help shed light on this, we've…
New build for Google Chrome
I received this question from my client: Google Chrome is releasing a new build 02/04/2020 that will change how cookies are handling by changing the default SameSite behavior. Will this impact Anaplan? Below is the FAQ from the chromium project: https://www.chromium.org/updates/same-site/faq Please let me know. Thanks.…
Unable to locate Account Flat List (.csv file) in LEVEL 2 MODEL BUILDING: SPRINT 1 Data Hub Model
While creating DAT03 Historic Volumes module for Sprint 1 - User Story 3, Level 2 Model Building Course, in the Dimensions: Account Flat list is included, but I'm unable to find the Accounts (.csv) file in the training module. Please Help.
New UX page access control
Hi, How can i control the access for apps and pages in new UX. For example can i make pages enable and disable in an app based on roles? Else do i need to create seperate app of each role
ALM Sync Error
Hi Everyone, I am facing the below issue while performing sync to the Production Model. Is there any solution for the same...? Regards, Ankur Sonthalia.
Join/Append 2 Lists
Hi team, This is an usual question but I have 2 lists (1 customer & 1 future revenue to be derived off future sales) which I want to append into 1 Phantom/Clone list where I can then Lookup the values from 2 modules & review/analysis the data in 1 module Is there any methodology to create such a list? Thanks Mark
Is there free training available?
I never heard of Anaplan until today, but I have now been tasked with learning it. Do I need to be a paying customer to use the training materials? It seems like I do. Also the Labels required field should be a drop-down picklist if users can't enter new terms.
Anaplan Id Merge
Hi Team, I have a team member who has currently changed the organisation. She is Anaplan certified resource. She was having id with the previous company credentials want to merge it with current company credentials. Can you please help us with the process.
YEARVALUE function
Syntax YEARVALUE(x) where: * x: Source line item or property to be summarized. Format Input Format Output Format x: Number Number As from above we can see input & output format should be number for YEARVALUE function. Can anybody explain how this function is working for boolean format (please find the attachment)
FIRSTNONBLANK FOR ALERT MONITORING
OK, I've already gotten one question answered around this. Just to recap, I'm creating an alert monitoring system that will flag when a stock goes low stock or out of stock. I have a BOOLEAN for when a stock goes below 1 week of inventory and another line item that displays that start date of that week should we go out of…
Logical Functions-IF ELSE statement - Trying to apply condition where line item text contains "DEC"
Hi there I wish to populate the line item "FY TEST" with the future financial year when any "Dec" month is selected in line item "End Period (Last Actual)" For example, return "FY20" in "FY TEST" when "Dec 19" is selected in "End Period (Last Actual)". The formula I have tried to write for line item "FY TEST" is below but…
Time range >= check
Hi, I have a module with time range(quarter) as dimension and also I have time range quarter as a List: I want to populate as true(boolean parameter) for all the fields i.e >= List time range as below: Thanks.. Q1FY19Q2FY19Q3FY19Q4FY19Q1FY19TRUETRUETRUETRUEQ2FY19 TRUETRUETRUEQ3FY19 TRUETRUEQ4FY19 TRUE
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.

Modeling

Discussion List