Modeling

Quarter value of forecast for the Qtr in which switchover occurs
What are the alternative workarounds for this? When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date. (see screenshot)
level 1 exam - model building activity 2
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module When I enter the formula: 'DATA02 SKU Volumes'.Volumes , all my data in the REV02 Volume Inputs module erases and becomes zero. Also in the REV03 Margin Calculation Module. I have set…
Vidéo - Gagner en efficacité avec la "New Modelling Experience" (2min 30)
Bonjour, Notre "New Modelling Experience" existe depuis déjà quelques mois. Et avec les récentes fonctionnalités, je vous propose cette vidéo récapitulant l'ensemble des nouveautés et des astuces pour gagner du temps dans votre modélisation. https://www.youtube.com/watch?v=BBcLmQNeuRk Lien vidéo Bien évidemment cette…
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi everyone, it seems that I have made a mistake and I can't quite pin down where it is. Here is my table:
6.6.4 Activity: Add Formulas to Time Setting Module
I am not sure why the Current Period Start isn't showing?
Compounding Growth In Forecast Model
Afternoon, Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) have nothing to pull from (zero value). LAG(Research Allocation Rate (Original), 1, 0) * (1+Growth Rate). So essentially for…
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
AND and OR logical operators
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example: IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE. In this context, these operators…
Apps or pages don't disappear when the underlying model isn't found
Essentially what the title says
Show / Hide Categories in NUX App based on user role
In my experience most Anaplan implementations focus around a main app where the most users do their work, and most roles are likely only focused on a handful of pages. But as-is they will be faced with the full list of categories of in their dropdown, even if they can't go there or do anything. I think it would be a major…
Rank list items based on multiple ranking levels
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I…
Sync only the clicked members in the insight grid in Worksheet Page NUX
Hi Everyone, I am facing a problem in NUX worksheet page. When I click a member in the worksheet, the insight grids syncs to the immediate parent level hierarchy and shows all the siblings of the clicked member but I only want to see the clicked member only or differentiate it from its sibling after clicking (like…
Hide certain list member in dropdown
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would be little tricky as I need to update everything. Thanks in advance for helping. Tom
Module with Users List
I have a module with two dimensions, Users List and Line Items. Ideally, we would like two Boolean formatted line items (Single Sign-on and Workspace Administrator,). Is there a way to import / write a formula into the module that pulls the information from the users section under model settings? This could apply to model…
1.3.14.2 Create T3 Build Geographic Hierarchies Process
Level 2 training 1.3.14.2 Create T3 Build Geographic Hierarchies Process Create a new Process: * Process Name: T3 Build Geographic Hierarchies * Add Actions: T3.1, T3.2, and T3.3 Could I get some help to complete this task? Thanks in advance!
[First Look] Enhanced Object Search
Feature: Enhanced Object Search Release Date: February 2022 Impact Assessment: Quicker navigation & model building What is changing? The new Search functionality is a new and centralized way to explore model objects and simplify how you navigate throughout your models What are the benefits? A single search will find…
[First Look] New Features in Modeling
Introducing new modeling features If you are looking for a brief overview of the new features available in modeling or the modeling experience, you have come to the right place. In this article, we will add links to new model building features and provide an overview of the essentials of the functionality. When possible,…
1.5.7.2 Add Formula Error
Can anyone point me in the right direction with the following formula? TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 I get the following error
Create an export to CSV option for the Pages Report in the new model experience
Can we create an option to export the pages report as a csv in the new model experience?
Polaris vs Hypermodel
Hello! Exciting new product releases coming from Anaplan announced at Anaplan Live! 2021. One of things a lot of us are curious about and want to know more about is Polaris. What is the difference between Polaris vs a Hypermodel? - Hypermodel gives users the ability to have up to 700GB's of space in a workspace - Polaris…
Restricting Users to their own content
Hello Everyone, I searched the community for this a couple of times and came across this article that actually just confused me more (see below) and I am hoping for clairty. https://help.anaplan.com/56391e35-2831-4642-b6de-2dddb6c68cfa-Default-lists I currenlty have two roles - Admin and Users. If I wanted to restrict…
Ratio of each accounts product sales by country's previous year actual sales by Prod Family
Hello, This question is related to user story 1.3 and 1.4 We want revenue for each account by product. Further we want to take its ratio against country’s previous years actual sales revenue by product family. Are we looking at a module with dimensions of Country, Product Family , Account & Time (Quarter) to calculate the…
3.3.5.3 check your work
Need some help please, as per example, Safety stock target line item is blank In my module have got summary values here, any pointers please?
stuckon level 1 exam question 7
hello can you help me please i don't understand why i have 0
L2 Sprint 3.3.5.3
Good day I am working through sprint 3 at the moment and all is going well. However in activity 3.3.5.3 INV01 Inventory Ordering "Check your work" I have noticed that my amounts are slightly off when compared to the screenshots. (usually by a factor of 2). Can anyone help and explain why this might be and how I may correct…
Average for a Period of Time for Next Period
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters. I am try TIME SUM…
Issue importing Products list into Model - First Course
I have my Product Hierarchy set up, Imported Families under All Products, when I try to import Products.csv I get the following message: Import into ---Product Hierarchy--- list failed: distinct names found for same code - check mapping and/or data I have changed settings, configurations, hierarchy, numbered vs non…
Level 2 Sprint3
Hi, At the end of Sprint 3 there is one lesson which says to Create Product Supply Manager Role so can anyone please help me how to do this lesson and what to do in this.
MR: User to select columns for variance
Hi fellows, New variance feature is a long awaited one. And finally we have it! But this feature is almost a hardcode and it does not allow an end user to select which of the two columns to be compared. Would be great if a user could decide it while presenting something like he can do with page selectors. Or any similar…
stuck on level 1 7 2 3 activity
Hello can you help me please I have a problem with the mapping days not displaying correctly when I select YYYYMMDD. also with the commissions which are displayed at 15 instead of 0.15

Modeling

Discussion List