Modeling

need to do a look up formula
Hi, I need to do a lookup in my line items so that I can import the data into a module. I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers. I've split them so that I can see: Factory 1 inbound Factory 1 Lot Number Factory 2 Inbound Factory 2 Lot Number I'm not sure what formula to use in…
Optimizer Constraints
Hi, In the constraints we specify for optimizer, the last constraint has the format of a - b =0, why is a=b not possible in the constraints. If we change the format , the process will be incomplete. Why is it so.??
Importing forecast numbers with forecast version and time scaled into a module without forecast vers
Hi All, I am trying to import forecast numbers from one module having forecast versions(list) and Anaplan time into a module only with time-scale. The idea is to have a page selector(forecast) in the target module and when users select the respective months ,they should be able to see the numbers forecasted in that…
Concurrent Planning
For a client we're facing issues with user dependency whilst filtering on the dashboards in Anaplan. We're using a Module with 10+ List-formatted line items to let an end-user select different combination of filters. However when multiple users are using the same dashboard which is based on one module/dataset their actions…
Need help with 53rd Week Setup in 5-4-4 Calendar
Hi, I am trying to setup a 53 week year in 5-4-4 Fiscal Calendar. I have setup the calendar as follows According to our client 2020 is a 53rd week and they would like to see the additional week in December 2020 . After the above time settings I am still unable to see a 53rd week in any year. Please let me know if I am…
What-if Analysis in Excel to Anaplan.
Hi, I happened to see a video on Youtube (https://www.youtube.com/watch?v=N924D6tGOG8) where a person introduces the Excel function "What-if analysis - data table" I want to replicate this function in Anaplan where I have similiar variables (values are dependent on both columns and rows). Are there any best practices on…
Ability to add absolute values across months
I have a client who would like to create a new period in Anaplan that sums the absolute values of the months. This will help in identifying account combinations with 0 across all the versions in the model. Is there a way to add formula periods? AbsFY=abs(jan)+abs(feb)...abs(dec) If not, how can they add it to a module? for…
Provision to input code while inserting elements into a list
While inserting a elements into the list, currently the UI only accepts the name, not the code. Can you please make Code and Name available while inserting elements into the list.
create a chart
Hi, I have a question about creating a chart. Is it possible to create a chart like below.(2 line item for 1 bar graph) ? Best regards.
Anaplan Architecture
Today I appeared for an interview, they asked me:- What is an Architecture of Anaplan? I wasn't able to reply. Someone please help me with this question.
Formula to get name of a boolean formated line item .
Hi, I have a module a with several line items. Line item 1 of this module is boolean formated and applies only to VERSIONS. Means, a User has to mark the check box of the VERSION, he wants to use for further steps. In a second module b, there is a line item 2, which shall show the Name of the VERSION, which was marked in…
Unable to see Optmizer option
I am unable to see the optimizer option in New Action. Please help me for the same. Regards, Vikas Jain
Subsidiary Views - Best Practices
Hi, Is there a list of Best Practices for using Subsidiary Views? I cannot find anything in Anapedia or the Community about this besides what they’re used for and that they should be used very sparingly. Also, is there one grand document or manual that lists all Best Practices for all features and situations? Thanks,
Time Dimension Summary
Hi Team, I have noticed that when referencing a module that has Time as a dimension from a module that does not have it as a dimension that the formula will not return the highest node in the Time Dimension E.g. I have a Module with Employees & a Boolean line item and a Module with Employees & Time (with Summary as Sum) &…
NEW UX: Let me hide the "Drag here to add more cards" areas
In Classic there's a "Preview Mode" that you can still build in without having to completely leave a dashboard's edit mode. Even better the "edit mode" in classic basically IS the same view as preview, just with some dotted lines an the sort. In New UX, the edit mode adds a full page wide "Drag here to add more cards" zone…
NEW UX: Ability to adjust the distribution of height in vertically stacked cards
Currently in New UX when I stack multiple cards in a column, they all have exactly the same vertical height, no matter what. I'd like to be able to spread the height distributions of vertically stacked cards to better fit the cards' contents. i.e. give height to cards that need it and less to those that don't. Hopefully…
ALM question
Hi All, I have a Dev model where I made various changes in the hierarchy (production data), re-shuffling lower levels and adding a couple of new ones. The data itself, however, stayed the same as I didn't delete anything. I need to transfer the changes to the Prod model now, and I want the data in Prod to be re-allocated…
Drill to transaction on module with versions – tip
Hi everyone, I thought I'd share a something useful I recently discovered, which I haven't seen documented anywhere. According Anapedia, Drilll to Transaction is only supported for formulas like TransactionModule.Amount[SUM:___, SUM:___] So this means that you can't drill to transaction on a formula like IF…
In NUX , in one of the board or Worksheet, Can we put two views from two different Models
Hi, I want to put two views both from different models on a single board or worksheet. Is it possible, if so how? Thanks, Vamshidhar Reddy
Refer formula across modules with different time range
Hi, I have two modules named A and B. In module A, my time range is FY17 & FY18. And in my module B, the time range is FY18 & FY19. The fiscal year in my model is Jan to Dec. Now I want to refer the data of FY17 from module A to FY18 of module B. I have tried with Lag, lead and offset. But all these have the restriction as…
Put data in Azure or directly to Anaplan
Hi folks, I work as IT manager for a real estate company with 120 employees in 4 countries, within a larger group with 50 thousands of people, but we have our own ERP systems. We in my real estate company is trying to set a strategy for our different kind of onprem data, from project related data, HR data, and finance…
Performance Tuning - Using Subsets
Hi all, Continuing on from an earlier post in the pursuit of model optimisation and performance gains (see here), I was hoping to get some clarification on another set of queries, relating to subsets. I've seen some collateral insinuating that numerous subsets and/or subsets with most of the list flagged as part of the…
Matrix of Conditions
Hi Team, I'm trying create some logic whereby I classify each Customer Account as either Existing, New Business or Churned for each Financial Year based on whether they had revenue in the last month of the previous financial year compared with the current year I have created the Matrix below (the columns are Line Items)…
Spreading amounts using Normal Distribution
I want to add a feature to my model that will include these inputs: Start Date Number of Months Amount Then I want the model to spread the amount across the months using a normal distribution (bell curve). In Excel, I have used the NORMDIST function to calculate the probability be period and then multiply that against the…
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
OEG Best Practice: Model load, save, and rollback
Model load A large and complex model such as 10B cells can take up to 10 minutes to load the first time it is in use after a period of inactivity of 60 minutes. The only way to reduce the load time is by identifying what formula takes most of the time. This requires the Anaplan L3 support (ask for a Model Opening…
How to make column chart
Hi, I'm trying 2 things 1 To make column chart like below photo 1. I want to stack value until year end, and then I want to reset and re-stack 2 After making 1, I want to see how I piled up actual data compared with forecast like below photo 2 at the year level.(or month level) . Are there any plan? Best regards.
Selective Access
Hey! I have given selective access to a person X in my model and he is able to open the dashboard and the module within it when X logs in as himself but there is no data popping up in the line items of the module in the dashboard and the module itself. But when I open as full access, the data is showing in the dashboard…
Create Function for ADDWEEKS
Please could we have ADDWEEKS as a function to work the same as ADDMONTHS and ADDYEARS the current workaround is to convert the weekly time period into a date then add or subtract 7
NEW UX: Don't force single cards on a row to be the entire width of the page
When dropping in a new text box on a board in the New UX, the text box (or any card) is fixed to take up the entire width of the page. Sometimes I want to be able to place a text box underneath something along the right side of the page. But I can't, the only workaround I can come up with is to place some dummy card in…

Modeling

Discussion List