-
Using RIGHT function with a list
Hi, I have a field that is a list format (itemcode), and it has a 3 letter code at the end of each item (e.g product1-abc123-regular-CNC). In another field i want to check this code before carrying out a calculation. IF RIGHT(itemcode,3) = "CNC" THEN 1 ELSE 0 I cannot use RIGHT(itemcode,3) as it is not TEXT, how can i use…
-
How can I use Rank if I have more than 10000 group in a list?
Hi, I have a long list that has around 30000 line. soem of lines are duplicate and I need to deperate them. I wanted to use Rank function and group lines base on a property but I have 17000 actual group and Rank limit for group is 10000. How can I solve this?
-
Disable 'Show All' option
Hi experts, Do you know any way to disable 'Show All' option for List Item with Selective Access? Best regards, Tatsuo Oba
-
Only show year total with time filter module
Hi, I built a time filter module to show only current year and prior year monthly revenue. Also, I want to show CY and PY total. However, when I changed the summary setting to show sum, it shows quarterly total as well. Is there a way to only show annual total, but not quarterly? Thanks a lot!
-
Data Mismatch while fetching the data from one module to another
Hi, I was facing an data incosistency in few of my modules. Here in my model, "Import Rebate Actuals" is the module which drives data into rest of the modules. "Import Rebate Actual" is a module which has proper data init but while fetching this data into other modules then the data in fetched modules gives us inproper…
-
Subtotal visible items
Is there a way to add a subtotal item or function? Currently we have a list with 15 members in it under one parent. Most users have read access to one item, others have access to 2 or more, a small number of users have access to all members and the parent. For users that have access to 2 or more, they can’t see a subtotal…
-
Composite vs general organization hierarchy
Hello, I'd like to hear experiences from others of modelling complex organization hierarchies. Often the decision is to choose between composite hierarchy and general hierarchy in one list. Usually I prefer composite hierarchies but always it is not wise, right? Case that I'm thinking is an organization that has quite a…
-
Comparing the sales line item of a similar kind of product
I have a list of products and few of those products are new to the hierarchy with no history. In this case i need to compare and refer from SALES line item' of a different product from same list. * I have only 1 product hierarchy list to use and it has associated sales, cost, profits,etc with it. * Few Product has similar…
-
Top down allocation
Hi, We have a requirement where we need to capture macro-economic demand % at Region (Parent level) and the same % should be allocated to its children. Eg : We have list Region with UK as parent and UK-MSO and UK-FS as zero level (child) members. We need capture macro-economic demand % at UK (parent) and same should be…
-
Alternative Hierarches
I have a P&L 1 that has being data input into it using a list Organisation 1 as its hierarchy. I require the same data to be pulled into a similar P&L which is using a different list Organisation 2 as its hierarchy. Both Organization lists have the same Codes against each reporting entity, but they are grouped undrer…
-
Time filter for users on Dashboard.
I am trying to set up time filter in such a way a user must be able to select start month and end month OR Every spring has 6 fiscal months or fall has 6 fiscal months What would be best way to do and how ?
-
General Question About Numbered Lists
From what I have read and seen Numbered Lists are used predominantly to reduce sparsity, i.e. when you have a lot of cells in two dimensions that are not ever going to contain data. My question is however, what other uses are there for numbered lists? Are they used to manage a situation where there are duplicate names in a…
-
How to create and use a List with Number of weeks to each Fiscal Month in the module ?
I created a list "Months Flat" (Jan--Dec) with Top Level as 'All Months' and added Property - 'Number of Weeks' and assigned values tothe property -- 445445454445. Then I am in a module, I need to Lookup at the 'Number of Weeks: For example: For every April irrespective of Year like Apr16 or 17 or 18, it should show me…
-
Any Excel equivalent for Match function with Match type 1 or -1?
we have Excel Match formulas which looks thru a lookup_array 1) which finds the largest value that is less than or equal to lookup value (match type 1) and 2) which finds the smallest value that is greater than or equal to the lookup value (match type -1) Eg. of Usage : Supposing we have tank table for liquid A as below.…
-
Copy Module Error & Solution
Hi all - I was having an issue earlier where I couldn't copy a module within one of my models. If you run into this error: “errorReference=“31511bca7bd64524b7108708bbc4a4fe-F26683FC11B149F68977313931A4D29B” userId=“8a819488469c08790146a6bfa7454c75" workspaceId=“8a81b0945db427df015dc7abfba910db”…
-
How to filter modules by custom made user roles?
Contextual explanation: Lot’s of Modules we use in our app are categorized by a List called Workgroup (e.g. modules for Suggestions, Decisions, actions…). Workgroup is a property in those modules. We want to limit what a user gets to see in those modules via user roles. One user role corresponds to with one Workgroup. But…
-
auto fill in User created in a line item
Hi, Situation: I have module with a list in the rows and line items in the columns. One line item of this module is called 'User created', the user who created the list item is supposed to be filled in there. I published the module to a dasboard. Question: Upon creation of a new list item for this module, is it possible to…
-
Anaplan Model Evaluation
Hi All, I have been assigned the responsibility of evaluating an Anaplan Model created by my peers. I need to submit a formal documentation with recommendation on areas of improvement. Do Anaplan have a standard template for such evaluation. If available could you please share or let me know the path. Any other model…
-
Alternative week List - How do i retreive
Hi, We have a customer who have an alternative week description, their year runs from March to March, so their week 1 is ANAPLAN's week 9 for example. I have created a list 'Weeks' and this has the 'Reak week' and also the alternative week (currently in text) Then in my module i want the Alt Week to show... but i do not…
-
Model timing out
I've noticed that in the past few days, I've been getting timed out of my model more often. What's going on with that? Should I speak to my Workspace Admin?
-
Display Native YTD and YTG with a filter
Hello Anaplaners, I have an issue about displaying YTD and YTG in columns. In a dashboard, i display a module with native time in columns. On this module, we set up a boolean dynamic filter linked to a time filter module. This filter displays the current year (2017 in this case). But the client needs YTD and YTG in the…
-
Create a rolling balance using dummy time scales
A common problem with dummy timescales is that you cannot use the Previous() function to create a rolling balance. In this example I have exchange rates which are only provided on week days (on a dummy daily timescale of YYYYMMDD). I need a rolling balance to ensure that all days have an exchange rate. To produce the…
-
Time Dimension - Rolling 18-Months
Hi Everyone, Is there any way to set up a rolling 18-Months in Anaplan, as time dimension? Right now we are able to set up 2 full fiscal years, to get 18-Months for forecasting. But at the 7th month of the current fiscal year, we need to have 1 more fiscal year, which will lead us to have total 3 full fiscal years in…
-
Anaplan Connect error return codes
Hi, I'm using Anaplan Connect to automate my Lists and data loading. I have nearly 30+ Anaplan operations that runs everyday and I wanted to know if there is a way anaplan can output a return code for success vs failure Like The Operation was Successful = 0 The Operation Failed = 1 I have been having these issues where the…
-
Dashboard Toolbar
Is there a way to create a Customized Tool bar on Dashboard for users, consists of all dashboard options like copy across, undo, etc.
-
Searching for Line Items that contain specific formulas
There are times where you may want to search through all of your line items to see if you are using particular formulas. For example, you may want to look for all usages of [SELECT: ...] before setting up ALM, or look for usages of RANK() to check why you are running up against a limitation on the groups parameter.…
-
formula for getting value from another module
hi all, Can we get an item value from one module to another module for a particular item . Ex: Module1 | Sales | Rebate A | 10 | 2 B | 20 | 4 C | 30 | 6 In Module2 for the "C2" attribute for the item "AA" needs to get the value form Module1 of "Rebate" column for the item "B". How can achieve it using the formula ? Module2…
-
Data Copy from One Time Period to Another Time Period
The Bulk Copy feature is great for copying data from one time period to another throughout the entire dataset of a Model. However, what if I just want to copy data from one time period to another in a particular module, and not for the entire Model? In this example, I will show you how to copy data from 2016 to 2017 for a…
-
Dashboard Toolbar
Is there a way to create a Customized Tool bar on Dashboard for users, consists of all dashboard options like copy across, undo, etc.
-
Summary module with multiple calculated measures
Hi All , I am trying to make a summary module which has mutiple calculated measures . Summary module is like an intersection between these calculated measures . Eg below on vertical axis i have measures like revenue $ revenue margin % to cost invoice cost etc on horizontal axis i have measures like original value ,…