Modeling

Double Byte - character / data
We have a client that will have users around the globe. As an example, if one user is in China, and is providing local data and local entity descriptions (eg accounts, departments, etc) in local characters (double byte) - is it possible to configure a module in a model that will show descriptions in local language (double…
return code for Anaplan Connect
Hi, I'm using Anaplan Connect to automate my data loading. In order to use my batches in an scheduler I need to output the return codes of Anaplan Connect (ie. file not found, the certificate has expired, connection problem ....) How can I handle this topic? Thanks,
Automatically change the dashboard when adding or deleting a version
Hi everyone, I'm working on a Dashboard. The main goal of this dashboard is to compare differents scénarios (ie Versions). Users are supposed to be able to create and delete scenarios (ie Versions). I face 2 difficulties : 1) When a user delete a version (for example called 'Jim's Forecast'). THe name and the curves…
Changing Line Item Formula to Refer to List Subset Instead of List.Property
Hi all... I'm a modeling newbie hoping an experienced Anaplaner can spot my mistake here pretty quickly. I inherited a model containing Module XYZ that contains a line item with the following formula: 'Module ABC'.Amount[LOOKUP: Account_List.Account_Property_X, LOOKUP: Subsidiary_List.Subsidiary_Property_X] Both list…
Nested IFs or using OR and AND, what gives better performance
Hi, I have a module with a few list-formatted line items. These decide how a nested line item in another module is calculated. I noted that changing some of these list-formatted line items causes the model to freeze for about 30 seconds. Has anyone made any tests to see if the use of AND and OR instead of nesting IFs…
Dynamic Ranking based on Filter selection
I am trying to implement a ranking function which based on user selection of filter on a hierarchy list provides top 5 records i.e if he chooses the lowest level in hierarchy he gets top 5 results on that, but if he chooses the level above he gets top 5 on the Parent item in the list. So is there a way to pass the group to…
Statistical Requirement
Does anybody has experience with linear regression in Anaplan? I also need to create a statistical model for detrending and deseasonalizing time series...any ideas? 🙂
Mapping two dimensions
Is there a way to map one module to another, mapping the intersections of two dimensions? a module with old locations in one dimension and old depts in another dimension mapped to a second module with differtn dimension lists: new locations and new departments. The locations and department do not map one for one, it…
User permissions For Item
Right now I can give permissions for Item in a list only for Specific user . is there a Possibility to give permissions for Item in a list for ROLE and not Specific user?
how to change date format for history?
The date format used in the history is UTC. How can I change this to match our local timezone?
AdHoc Subsets as an alternate to Select function
Hi, From time to time, it may be convenient to create an adhoc subset as an alternative for the SELECT Function. Business case : * Source module : full list * Target Module : need to select only one line item (or more than one) from the source module. Proposals : * Option One:: Formula in the target module will look as…
Compare and Sum ammounts based on text field
Hi, I am fairly new to Anaplan and I have a requirement where there are 2 models with a common text line item . I need to create a 3rd model by comparing these 2 models based on the text line item to sum up the amount for only those rows for which Text field matches. Please suggest hhow to achieve this. Regards, Chaitra
Module adjustments
Hi guys! This is my challenge: I have build a Bakery model. I have 8 products, the products are devided over 2 categories. Of all the products I have the COGS, selling price, turnover, sales, total costs and total profit. I only use a general list atm. Of all the products I have listed the 6 financials in my dashboard, so…
Function to determine if a list item belongs to a subset of the list
I'm trying to build an exception module to check that all items in a particular list with a particular property residing in another module belongs to a subset in the list. Is there any function like ISSUBSETOF(x) to determine if a particular item in a list belongs to a subset of the list? To illustrate, in a List called…
Multiple Conditional Formats for 1 Line Item
I want to show 2 types of conditional formatting for 1 line item, 1 for the children and 1 for the parent. Is this possible? Eg i have 10 questions scoring 1-5 (1 being red – 5 being green), with a total score 10 – 50 (10 being red – 50 being green)
YTD data not pulling from Monthly module to Annual module
I have 2 modules, one having monthly line items, the other having annual line items. When I link the line item in the annual module to the line item in the monthly module, the full year figures come into the annual module but not the YTD figures. Both modules have the same dimensionality
Cell Read-only
Hello! Is there any way to get smth like cell security in TM1? For example, I have a module with 2 dimensions. Clients --------- Client 1 Client 2 Products --------- Prod 1 Prod 2 I need to write in Client1\Prod1 and Client2\Prod2, but read only in Client1\Prod2 and Client2\Prod1. Thank you! Best regards, Alexander
Extending formula bar height
Is it possible to extend the height of the formula bar as you can in Excel? It would be very useful when editing long formulas.
TIMESUM over quarters
Is there an easy way to timsum over a module that has a time scale in quarters? I could do a work around and split it into months in another module but wanted to keep it clean. Quartervalue doesn't work in timesum. H
Syntax for Select Function on Time Periods
What are the time periods that I can use select function for?
Drop Down List With A Way To Insert Another Line Item If Not In List
Hi I just started working with Anaplan! I was hoping to find a way to add a new item to my list that I want to have as a drop down box in my module. Is this possible?
testing for a time period before the first model time period
I want to average quarter values for the last several years. i use (offset(lineitem,-x,0) + offset(lineitem,-x+1,0)) / 2. when the offset runs off the beginning end of my time period, i would like to do something different with the formula. How do i test for this condition when i refer to an invalid time period or date?
Time dimension: have both calendar month and weekly
We are looking to create a model where one can see both weekly and calendar month data for all measures. What is the best way? For instance we could create a week-based (e.g. 4-4-5) model, then insert formulas for time, e.g. January 2015 = (Week1 * 5/7) + Week2 + Week3 + Week4 + (Week5 * 6/7). Thanks upfront for the…
Module Line item is text and want to feed it to a list, formatted as list
Hello, new to Anaplan. I have a line on a module called " Physical Location State". It's an IF Statement looking at field in my file that indicates whether a person worked from home or not (NOT BOOLEAN, but looking at a text value). If the person has work from home in the field, I use the home state, else work state. Since…
Specific Messages/Instructions for Different Planners
I want to publish messages to specific parts of the organisation following a senior management review, for instance the regional manager would ask one of the factory managers to "increase production by 10% in Q4"
Remove Conditional Formating for Zeros
I am using conditional formatting to highlight the scores received in a survey, with scores ranging from 1-5, so I have set a 3 color scale with 0, 2.5 and 5 as the min, mid and max points. However when there has been no response the table shows red, I would like no response to be white
SUMIF function
Greetings, colleagues. I am having problems with summing up value. I have a module with products dimension. It's really huge and each new line item adds much space, so I really want to avoid them. I need to count average based on product list property. For example by color (it's not the product hierarchy). Adding the Color…
Maximum across time
Hello, perhaps I'm stupid, but i can't figure out how to calculate a maximum for a period. I found an aggregation function x[MAX: y], but i couldn't figure out how to put time scale as a dimension in maximization function. The only thread I found on the forum was this:…
Calculating a % of a subset
I have the total active customers by product. I have products organized into schools. I can calculate the percent each product represents of the total of all products regardless of school. I do this in a module with two line items, Active and Active %. The formula is Active / Active[SELECT:’Programs P2’.All Programs]. I…
Formula to convert a Date to the Week number of the year or quarter
I am trying to find a way to take a date and convert the date to a number that would represent the week number in a calender year or the week number in a calendar quarter. The value could either bring back the week based on a the calendar week or the actual number of days divided by 7 (for example January 5, 2015 is a…

Modeling

Discussion List