Modeling

Community perspective: Anaplan user license management
What is an Anaplan user license? Users get access to Anaplan based on the model role provided to that user. From an Anaplan commercial perspective, each Anaplan user is consuming one active Anaplan user license. On a high level, Anaplan has the following three types of user licenses: * Model builder * Contributor * Viewer…
Application link check from Model
Hi Anaplan, It would be great if we can get a functionality to check from the model as to which all New UX applications the Model is linked to. As if we are working on a MSP model, it gets really difficult to track as the model is linked to which all New UX Apps. Thanks, Shivankur
Summing on Period (Quarter)
Hi, I need some help in summing on the maturity period (quarters). Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities. Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates. Module 3 is dimensioned by time (quarters) and I…
How to prepare for the change to the default Modeling Experience - FAQs
What is happening? The New Modeling Experience will become the default experience in February 2023. It is replacing the Classic Modeling Interface but not eliminating Classic Dashboards or forcing you to use the UX Apps and Pages. What does that mean? Simply, the modeling interface is getting an update to the look and feel…
Calculating the average of a balance sheet item for quarterly / annual totals
I have a number of balance sheet accounts (e.g. Closing Receivables*) for which I need to calculate the average value. This should be calculated as follows: - Monthly: average between the current month and prior month value - Quarterly Total: average of the last 4 data points - Annual Total: average of the last 13 data…
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
NUX - Pushing Changes from TEST App pages to PROD App Pages
BACKGROUND: We utilize ALM and have everything built out in Apps for End Users. We have Duplicate Apps for TEST and PROD. PROBLEM: This becomes a pain and time consuming maintaining the changes you make in both TEST and PROD. Currently we have to make a duplicate of each page edited, move it to the new app, then repoint…
Quickly duplicate cards on page without having to save them as template
Currently we only have a option to save card as template which is great. But there are many instances where I just need to duplicate a card/grid/etc and not need it saved as a template. Its cumbersome to have to either resetup the grid with specification or to create a template then use and delete it. Thanks!
3.3.5.3 Check Your Work - issue with beginning inventory numbers - can anyone please help!
Hi, my numbers on beginning inventory aren't changing from 13,000 below - Sharing the relevant screenshot incl SYS01 Time Settings By Week - any help would appreciated as why the numbers from beginning inventory are getting referenced prroperly… Also, to add, when I'm changing the formula to IF (…) from IF NOT (..)…
Formula - limiting values returned
Looking to limit the values returned within a module, which I've made a start on the module showing in the right hand side , where limiting by currency. However, if I then also wanted to limit by say GL Category or GL code, how would I go about this? Any help would be welcomed on this
Managing expenses as positive, reporting as negative
we have a client that manages expenses at GL account level as positive numbers. they rollup the GL accounts to reporting lines (they have multiple GL accounts for salary and report salary on a P&L). the reporting lines are hierarchical (total income and total expenses aggregate to profit before tax). they would like to use…
Increase Note Character Count (in Blueprint Mode)
250 characters or how ever many is too small for saving off larger formulas when modeling or if saving detailed descriptions/insctructions. Please increase to a few thousand. Thanks.
Some kind of Bug in model of Anaplan Essential Course for Customer
Hi Community, One of my client users is taking Essential course and notified an issue he got while importing date into transactional data module. See the screenshot below When he clicked to open dropdown to select "Language for month names" (his laptop language setting is Chinese), the mapping window here will collapse and…
Remove the blank space to the left of list items in a Grid View
Hello Fellow Anaplanners, Hope you are all doing great :) While building a dashboard I got struck on something, I am thinking is there a way to remove the blank space which is caused by the parent hierarchy and show the child items at the left. I though you might have tackled this before and help me on this. Thank you!…
Ability to display negative numbers as positives
Detail description of the enhancement that is being requested: We have numerous requests to have costs displayed as positive numbers but aggregate as negative. The current workarounds are very difficult To provide more clarification, could you please explain how you hope the enhancement would assist in your business…
How to get the average of a previous month in the current month ?
Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ? PFA screenshots Need help urgently Thank you
model search
Is this search feature buggy? I don’t think it is working as is. For example see below: I search for ‘calc’ I only want results with calc in it Below also gives results with references that contain c AND a AND l AND c This is not correct. The search is limited here. The Boolean logic behind the search does not seem…
Create Shipping Export Module and Create a Saved View
Hi, I am unable to compile the data at month level. As soon as I change the timescale formula to monthly it shows the subsidiary view icon against line items, yet does not change it to monthly view in grid. Please suggest what's going incorrect here..
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
Forward Cover Functionality
Summary Statement In the supply chain horizontal, you may be asked to calculate a forward cover in Anaplan. In this article, we modified a best practice suggestion from @nathan_rudman based on a question posed by @mikhivin about accounts receivable coverage which looks backward. See this post on count back for turnover.…
Level 2 - 1.7.3.2 Import into SYS08 SKU Details module
Hi, In activity 1.7.3.2Import into SYS08 SKU Details module it says Use the saved view from the Data Hub model to import into the Supply Chain model SYS08 SKU Details module. In this which saved view we have to import there are 2 saved view. 1. Build SKU 2. Import SKU Details In Supply Chain model SYS08 SKU Details module…
1.4.3.2 Import Data & Add Formula
I'm getting an error for Sku and Product Code after importing Sku csv Does anyone understand why this is based on my screenshots? Thanks!
Is it better to use CODE(ITEM( SKU List)) or to use SYS SKUDetails.code?
Hello, I need to concatenate two codes because I am generating a combined list. My first instinct was to utilize the function (CODE(ITEM()), but the example I saw in ANAPEDIA used the the systems module Line item [SYS SKUDetails.code]. Given that I don't even have a system module, I'm unsure if doing it this way is a bad…
Passed your L2 exam? Now what?!
Author: Hillary Sich is a Certified Master Anaplanner and Consultant Manager at Allitix. P.L.A.N.S. is the underlying guide to building a good model — and following these model building best practices will insure you're building the best model! If you've passed your L2 test and are diving into work, here are some…
Selective access: Sum/Total does not work!
Dear all, My company is at the end of the project and we've just found out the Selective access cannot show the total budget amount! Particularly, we have many expense category and for example Labor expense include personnel costs (owner is HR department) and non-personnel costs (owner is general affair department) and…
Confirmed PO Delivery - offset function
Hi i am trying to determine the formula of this line item - confirmed PO Delivery for INV01 inventory ordering module in Sprint 3 was working on the hints given to use offset function and if PO request if 1 came up with this but couldn't quite figure out how to use the offset function if PO submitted = 1 then offset ( ?,…
Visualize new list items after import
Hello, We have a list of Skus that is the child of a Packaging list. Each packaging has multiple Skus. Some Skus are old and are no longer active on our production lines. We have a module made of boolean line items to select which skus are "used" currently. When we update the sku list with new skus, by default that "used"…
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi. requesting assistance in this part. I am not sure what I am doing wrong. I have transfer the file as directed but the number for forecast do not match. The data should be like this. Thank you
Level 3 calculate the Quaterly Initial Sales Target
Hi community, I am investigating for a long time to find the formula to calculate the Quarterly Initial Sales Target. According the user story , I checked all my data and according your screenshot for Nutzo bar I must find 670.8 Using my values I cannot obtain this figure for US, Nutzo Bar/Candyate (family Chocolate) and…
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi. requesting assistance in this part. I am not sure what I am doing wrong. I have transfer the file as directed but the number for forecast do not match. The data should be like this. Thank you

Modeling

Discussion List