Modeling

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.
Bring Your Own Key (BYOK) - Guide de l'utilisateur
L'application Bring Your Own Key (BYOK) vous permet maintenant de vous approprier les clés de chiffrement de vos données de modèle. Si vous avez accès à l'outil Anaplan Administration, vous pouvez chiffrer et déchiffrer des espaces de travail sélectionnés à l'aide de vos propres clés AES-256. À la différence des clés…
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 ,…
Job Aid: Copy Current Plan to Original Plan Using Actions
How to copy your current plan to an original plan Please note: I took Peter Mcanena's idea in one of his posts and modified it to create this job aid. Step 1. Create a saved view of your current plan that exactly looks like the original plan module. Default View of Current Plan Saved View of the Current Plan called “OP…
Create budget line item description
Looking to create line item description for budgeting spend of a particular spend category. E.g. Spend Category "Consulting" has 5 lines with different names on the contractors, Spend Category "Marketing" has 10 lines with different names of the events. Also, want to have free lines where the business partners can enter…
How to rank by text line item
Hi, I have a request to include a text line item as part of the ranking criteria. But as i know, ranking not apply to text, may i know any good ideal how to do it?
Any equivalent to the Excel TODAY() function in Anaplan??
Need to establish the number of days between a given future date and today's date. It's currently a pre-requisite for a set of business rules to kick in. Haven't had any luck in finding a DATE function that I can use.
How to create a Model with >130gb size?
Dear Experts, Are there options to create a model with more than 130gb size?
Formula getting "Current" Fiscal Year as NUMBER
Hi, Anplan friends, May I have pointers how to get current fiscal year as NUMBER ? For example, In case where "Fiscal Year Start Month" is April and "Current Period" is March 2019, I would like to have "2018" in a line item. Do you know of any such a formula ? Initially I thought "YEAR(CURRENTPERIODSTART())" would work,…
Ranking on a date prior to switchover
Hi All, I have a number of versions in my model with different switchover date. I also have ranking function on the last date prior to Switchover. For instance, I set the swithcover to Aug 17 then I need ranking to be ran in July; If swithover = Sep17 then ranking on Aug17 etc. For specific period it is easily done by…
Waterfall chart missing items
Hi All, I'm new to develop charts in Anaplan. I'm building the waterfall chart in anaplan with attached sample .csv data file. After building the waterfall chart it is missing few items i.e; TOTAL UTILITIES, TOTAL TELECOMS, TOTAL while plotting the chart, why it happens ? Please find the attached sample data and waterfall…
Formula for cell value
In attached image i'm trying to get the highlighted GREEN of second column cell value into highlighted BLUE of first column cell. What formula needs to write to achieve this ? Thanks, Satish.
To Get value of previous fiscal year where fiscal year is not time dimension
Hi, Anaplan Friends, I have been faced with a difficulty in getting a value from previous FY where FY is not time dimention, but a list member. Please refer to the attached file for reference. Here I have Fiscal Year FY50, FY51 etc as list members, and estimated sales is expected to be calculated based on the previous…
Time Scale Name Change
Hi, Anaplan friends Is it possible to change time scale display ? Precisely, I would like to display FY55, FY56 etc. instead of FY2017, FY2018 etc. Thank you. John

Modeling

Discussion List