-
New Style for Line Items
We have had a client request for a line item style with one line above and two lines below a specific line item. This style is very common in financial statements and SEC filings and would be beneficial if it could be reflected in Anaplan. I have also seen requests for the style to be reflected in the dropdown in blueprint…
-
Word wrap on rows
It would be great if model builders could enable word wrap on rows as well as columns. It would be even better if Anaplan could dynamically check each row, see which rows required wrapping, and only increase the row heights of rows where wrapping is required.
-
Adjust row heights for list or line items
It would be great if model builders could define row heights for list items or line items when pivoted to rows. This could even be controlled within another module. For instance, a model has one list Countries. One module would control the row heights of Countries, contained within a line item Row Height. Another module,…
-
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
-
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
-
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
-
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…
-
The filter dialog for percent formatted line items should display a % after the filter value
When you're entering values in percent formatted cells, unless there is a % in the cell, the value entered should be a decimal to show the correct value, e.g. 0.5 should be entered to display 50%. When setting up a filter on a percent formatted line item the value to filter on does not have a % therefore I would assume I…
-
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
-
Fixed Export Destination
Hi Team, Is there a way that I can set a fixed Directory destination for an Export Action? I want to always extract to the same directory so the data can be referenced by an Excel Macro Thanks Mark
-
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.
-
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