-
Import from Subsidiary View
Does anyone know a workaround to import from a subsidiary view?
-
Summing based on another modules field
Hi team, Hopefully a straight forward one. I have 2 lists. Campaign and Show ID Multiple campaigns can have the same show however they are not within the same hierarchy. I have a module INP01:Campaign Details that has the Show ID as a line item - not all campaigns have show IDs. I have another module INP02:Episodes where…
-
Problem with replacing SELECT with LOOKUP
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list…
-
Converting data
Hello everyone, Is there any possibility of converting line item formatted as period (Month) into the TEXT? Thank you
-
DIMENSION INDEXING in POLARIS
If you had already attended an event on 4th Aug 22 by "Modelers Forum India" you would be knowing by now that there is a concept called "Dimension Indexing" in Polaris Engine. In this article we will try to explain what do we mean by Dimension Indexing If you remember, that in Hyperblock any dimension (apart from Anaplan…
-
Converting "Month 1" to a date
Hi everyone, I am currently building a project planning scenario analysis UX and have designs that use the line items "Month 1-18" to decide hours available by team. There is a button where we can "create a project" and the "start date" is entered. Is there a way to convert from months 1-18 to actual dates using the start…
-
Use of default and mandatory "Organization" list in models
Has anyone used the "Organization" list models? Anaplan automatically creates it in every model which can't be deleted. I've never seen it used. I also don't recall any of the Anaplan courses use it. 1. Has anyone used it? If yes, how did you use it? 2. How is it theoretically supposed to be used? I guess theoretically,…
-
Number to boolean format help
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters which will give me projects having valuation more than 1,00,000 i created a boolean filter and tried to change the format for…
-
Issue When Using List Subset Picklist with a LISS
Hello, I've come across a scenario that appears to be a bug when combining Line Item Subsets and List Subsets. The scenario is that I have a report module that I created a LISS of. I then created an input module dimensioned by that LISS with a Line Item formatted by a list subset. The list subset is to only allow users to…
-
Need to breakback the value
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E). with common percentage. Any idea how can i do it? Example here: A B C D E Before X 100 10 10 10 10 After X 0 35 35 35 35…
-
Update a filter based on picklist
I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1
-
Identify Duplicates
Hi friends, Hoping to get some help with a method to help me finish up a labor calculation module. I'm tasked with allocating costs to contractors differently dependent on if there are multiple contractors from the same "Vendor" and "Area". IF multiple contractors from same Vendor in an Area THEN divide Area cost evenly by…
-
Suppress 0 or missing where there is no YearTotal aggregation
Hi I have a situation where I need to suppress 0 or missing for Headcount, Note that the Months do not aggregate to Year. The months are in columns. How do I achieve this, so that it look at Jan, feb, mar etc.. Thanks
-
Median Calculation on Multiple Dimensions
Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by certain attributes of those customers. For example, I have 10 customers all who belong to different countries, and…
-
Summary in UX Page
Hi everyone, I have a module which is dimensioned by 'L3' List. It hold amount data. I want to filter l3 list by Region. So, I have added a region filter and published as a 2nd grid in the same Page. But, in the Summary for the 2nd grid, is there any chance that I will get only sum of the list items that are filtered out.…
-
Parent to Child Mapping
Hi, Is there a way to map a selection made at the parent level to all the children of the parent? Product Hierarchy: L1 Program, L2 SKU My final output report is at the L2 SKU level. The users take multiple snapshots of this report during planning cycle. At the end of the cycle they want to select a final snapshot for that…
-
Last Workday of the month
How would I create a Boolean line item that would select the last work day of the month? Thanks
-
Advise on building methodology
Hi, Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month. Thank you
-
How to prevent misentry by end-users when importing.
Hi Anaplanners, On my current model, there is an export module providing a CSV template for end-users. When end-users get this CSV, I’d like them to be submitting the date format correctly (ie Q1F Y23 rather than Q1FY23). Does anyone know if there is a way to put a drop-down list on the date column of a CSV file to prevent…
-
LAG() Rent Increases without Time Scale
Hello, New Model Builder here! I'm working to enhance an older model that uses a hierarchical list as a Custom Time Scale (CTS Months). The list is used in lieu of a time scale for most modules, however one of the enhancements involves applying market rent increases to the next 'time period'. i.e. a 5% market rent increase…