-
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
-
Line Chart Showing Monthly Values for Fiscal Year Lines
I need to create a line chart showing the monthly values for each of several fiscal years as a line chart. The user wants to be able to see lines comparing each month in each fiscal year. For example, on the X-axis would be each month in the fiscal year, January to December, and on the Y-axis would be each fiscal year,…
-
How to pull the annual total from the month forecast module?
Much appreciate if someone can help with this one. Source module: monthly expense list: cost center & expense type Dimension: time (by month, with year total FY23); version (actual & forecast) Line item: expense Target module: Annual summary list: cost center & expense type Line item: expense, budget, variance, % NO TIME…
-
Steps for building a model
Can anyone help me understand why the following order of the steps is wrong? I have tried two attempts but still can't get it right!!! Step 1. Build centralized dimensions in the model (time, version, lists) Step 2. Build Modules in the model Step 3. Build centralized Import data into modules Step 4. Create User Experience…
-
LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks
For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no…
-
HyperModel: five tips to improve your experience
Are you considering HyperModel for your ecosystem, or have you recently deployed it? Fantastic! We've compiled a shortlist of the top five tips to help make kicking off your HyperModel experience as smooth as possible. Check out these top five tips to improve your experience: 1. Recognize that the Hyperblock has not…
-
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
-
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
-
Ability to Comment Code
The ability to put comment blocks and indents within your formulas, so as to allow model builders to better document and format their code within the models for readability and understanding purposes. This will help align Anaplan's language back to the basic features all other development languages used in an enterprise…
-
The Key to Aligning Missions at Academic Medical Centers
Disjointed manual spreadsheets are common pain points expressed by our higher ed clients. You may be able to consolidate all academic departments using the same templates on separate tabs, but what if you have a completely separate operating unit with an entirely different model? Or perhaps you have a legacy system in…
-
Current Date and Time
It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
-
3.3.5.5 Update Inventory Ordering to Allow Override of Shipping Method
Hi All, I need some help here regarding the Final Shipping Time in Weeks and Final Shipping Method Graphics attached. When I run this using the default position of Road and a 2 week delivery time it works fin, irrespective of the week I place the order. However, when I choose to Override Shipping Method, pick, say, Air…
-
Line Item Subset Filter not working in New UX?
Hi All: I am attempting to filter in the NewUX by way of a line item subset. Goal is to hide line items based upon the selection of the user. In the traditional UX I can apply the filter without issue. When I go to apply the filter to my grid in the worksheet (NewUX), it does not allow me to select the line item I wish to…
-
Planning Gross Margin % and other Ratio metrics at levels above the bottom level
Pretty much everyone would agree that Gross Margin % (GM%) is a REALLY important metric when planning your business. It’s a key performance indicator for healthy past performance, and a key driver for future investment decisions and performance management. Employees are frequently bonused on revenue and margin goals – so…
-
Community perspective: How to vary model inputs using optionality
Sandi Duffy is a Certified Master Anaplanner and Senior Finance Manager at Challenger Limited. With Anaplan, it is easy to run multiple scenarios within the same model by using optionality. A common use for this would be during the budget setting process. Say, for example, you have a budget model but would like to see what…
-
Drill to Transaction Functionality in the New UX
Drill to Transaction Functionality is considered critical for some partners/clients as it's functionality that has no alternate solution. I have heard specifically from FP&A implementations regarding allocations, as well as ICM use cases, but would love anyone giving kudos to leave comments with additional examples of it's…
-
Filter not working in UX
I added a time filter for this module expecting the card to populate in the UX. I only want FY23 and 24 as options for selection. It works on the model builder side but the card keeps populating FY22 in the UX despite me saving the view.
-
Ability to Apply Filters before downloading Model History
Currently, If I want to check history to view some activity on a specific module or list, but I am not aware of the dates when that change took place, It takes forever for me to extract the history for downloading 'ALL' change history and locate that change. I face issues especially when the changes are too many and file…
-
what is the difference of classic UX and new UX
-
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 (..)…
-
L1 Model Building - Lesson 7 Data Mapping issue.
Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: * HINT: The E2 Employees# list is a numbered list and each record is assigned a…
-
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