-
Date Stamping the last time a Process was ran
Hello, I am aware that Anaplan does not have a Date Stamp ability and I have solutioned that; however, I am not sure how to apply a date stamp to the last time I ran a Process from the dashboard (e.g. If I run an Import today it should be stamped as 09/30/2022, or the last time it ran successfully). To do this, I was…
-
ETL - Summary for hierarchy
Hello! I am trying to build an ETL that will upload into a client's ERP system. They have some nuanced requirements, and I'm struggling to build one of those into our module. In the image below, I need to have the parent values displayed for the highlighted columns: This module uses L2 for account numbers, and the parent…
-
New to the Forum
Hi Community, I am new to this Forum. I started e-learning Model Building Journey last year and I am happy to be now Certified Model Builder (achieved last week). I am working as Project Owner Support and I am looking forward to increase my Anaplan knowledge and enhance my building skills.
-
Hello All. New to this forum, go easy on me...
Hi all. New here but not new to Anaplan. I've been here nearly 9 years. I'm joining this forum to help out and spread knowledge. Will help create some content and articles - any suggestions, what do you need here as model contributors? Let me know what you need and what you want to see... Post your questions, there are no…
-
Convert list item to time period
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Period "Week" The data is copied in a module with this list and the product list on the lowest level as dimensions : How can I…
-
RANK on Total & Sort Nested Dimension
Hey builders, I'm trying to match a mockup, but having trouble building it in Anaplan. User Story: I need to rank all projects by their total cost (highest to lowest) while showing the breakdown of Project Total Cost by each Cost Pool (if there is a value in a cost pool). Rows: Projects and Cost Pool Columns: Cost My…
-
Job Aid: How to use the new Model Search
@VickiA posted all the New Modeling UX features in this post. Just wanted to show you where the "Model Search" magnifying glass is located. Took me a while to find it. It's terrific! Already used it to clean up one of my models - used it to search for line items used for filters that I want to change, particularly the time…
-
Is there a way to view Months then Quarters then Years in a Module Applies to Time
Hi All, I have a Module which Applies to Time. Attached Screenshots. =>The possible view for the Timescale is Jan Feb Mar Q1 Apr May Jun Q2 Jul Aug Sep Q3 Oct Nov Dec Q4 FY =>But is it possible to have a view like this Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Q1 Q2 Q3 Q4 FY Regards, Sreeroop
-
Optimizing Models, blueprint Analysis
Hi all, I am beginning my journey as a model builder in a company where one of the first task is to try to optimize the current Anaplan Models, I've followed the instructions given here to try to reduce the cell count in a specific module: Context: * Formula repeated several times in different line items and modules. And…
-
Get Min Date
Hi, I want to get min Date. I set Min as Summary. If any source item is blank, Summary shows blank. Is there any way to get min Date?
-
CURRENTPERIODEND() does not work
Hi everyone, I was having trouble when I start learning working on a module with switchover. I set the switchover on and set the month. It started okay, until I want to get the data from the beginning until the end of the period. I used CURRENTPERIODEND() function. But when I check out the output it turns out empty. I…
-
Calculation logic for different hierarchies
Hi In source module I am having Hierarchy list with 6 levels(L1,L2,L3,L4,L5,A) where A is lower level of hierarchy which is having some count line item. In target module I am having L5 as dimension with litem as Total Count. Scenario 1: Now we are moving A1, A2 from it's L5-1 to L5-2, where L4-1 is parent of L5-1 and L4-2…
-
Compare two lists, one of it being numbered list
Can someone advise me how to compare two lists, one of it being number list ?
-
How to create a boolean with Radio Button like properties?
Hi Everyone, I want to create a boolean line item in a module dimensioned by a list, which can only be true for one list item only at a time. Let's say, the list has 10 members and initially that boolean is false for every list item. User checks the boolean for list item 2 and then User checks the boolean for list item 5…
-
Summing Values across dimensions
Hello - I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS. Now I want to sum my values into an L4; which is just "L3" and "Account "strung together; but my formula of Sum - Lookup: the "L3" and "Account" attributes (Mapped to the L4) does…
-
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)
-
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…
-
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…
-
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…
-
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…
-
Publish List and there Subset in the NUX
Hi Anaplanners, I have came across problem in which we are migrating from Dashboard to NUX and as of now in NUX there is no facility of publishing list directly, workaround for it would be adding modules and publishing it directly for the list and their properties but what I want to know that in the list we have provided…
-
Users Names
Hello, Can we get the User name in a lineitem if the module is not dimensioned by Users? Thanks Devika
-
Translating % correct into a RANK()
Hello, Question - I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place. Advice on how to do that? I tried using the RANK() with the module calculating the percentage correct and could not get a solid translation. Thanks in advance!
-
GL's available by Property, Owner, & Expense Category
Hello Everyone! I'm working on a budgeting model and need some help. Happy to provide any necessary details I may have omitted. We have a handful of properties (ownership specific) that need to budget in a specific GL account, while the remaining 90% of properties shouldn't have access to the GL in question. Currently,…
-
Cannot add Revision tag
Hello, I am trying to add a revision tag to the test model so I can compare and sync it to the production model. However, the button to add the revision tag is disabled. Please note that the model is in 'Deployed Mode'.