-
How to Lookup in different dimensions
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image is as follows. I would appreciate your advice. Best regards.
-
Filters
Hi, I’ve built a filter (boolean) consisting of 3 levels with dependencies. If I choose an item in level 1, I will only be able to select items in level 2 that are dependent on the selection done in level 1. Same relationship between 2 and 3 as well. This works well downwards but not upwards. When I delete (leave it blank)…
-
Simple seasonalization question
I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have the following simple example with three modules: Annual sales by product group and employee Seasonal percentages by product…
-
Excel '^' Operator in anaplan
Hi Team, I need an help in using '^' operator(in excel) into anaplan, while looking through all available operators and constants I could not find this operator. Is there any alternate function for this? Thanks & Regards Madhu
-
How to plan annual values -- a beginner's question
Is it possible to directly plan annual values only using calendar type Calendar month/quarter/years? I have completed the Level 1 modeling course and all the examples there plan on the basis of individual months (Time being placed in the columns of the module definition) so I am very much feeling my way on this. Here's the…
-
Formula Summary type on LOOKUP or OFFSET
Hi, We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution. I cant use formula…
-
Level 1 Model Building not a recognized line item or list member
Hello, I am trying to add the below formula and I am getting this error.
-
KPI's calculation in NUX
Hi Team, Can you please help me understand how are KPI's are calculated for a line item. It is not giving me the first data in the grid, neither the average or the Sum. I wanted to understand how is it calculated. Thanks, Veena
-
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
-
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.…
-
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
-
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.
-
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…
-
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