-
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.
-
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…