-
How will sync option work in dashboards
I would like to understand how will the sync option help to activate all the Grids with one selector
-
Level 2 Model Building: Conclusion DATA02 SKU Volumes
Hey folks, I'm on Level 2 Model Building: Conclusion, and it says: "Import Final Demand Forecast into DAT02 Module In the Financial Planning & Analysis model: Import the Demand data into the DATA02 SKU Volumes module. * The results should have none ignored and 0 errors. Update Actions and Processes: * Rename the import:…
-
Error Message: Mapping have a common LIST format
Hi all, I am trying to assign the territory to the accounts that matches the attributes. However, because I am using the same list for my Product L2 and Product L3, I am getting the error below. I understand that this is due to my line item format be: build a product list hierarchy is not an option because I want the…
-
Export ignoring show/hide
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…
-
how to check of the month of a month formatted line item
Hi I have a month formatted line item in one module, how can I get a boolean line item to check off in that month in another module? In my SYS65, I have a month formatted line item "MOB to time" For example the value is Mar 24. How can I get Mar 24 to checkoff in my C86 module? (both are dimensioned by credit and turn)…
-
Bulk Copy Action
I am aware that I can add Bulk Copy as an action via Action in Model Settings Bar however to set this up I have to select the target and source version/list member. Is there any way to set this up so that I can select the target and/or source when the action is being run?
-
Selective Access and picklists
Hi, I have set up selective access on a list and limited the user to one list item. This works as from the context selector at the top of the page, they can only see the one list item I gave them write access to. But when they access a user based picklist for that list item, they can see all the list items. They are able…
-
Production capacity calculation
Hi, Good Day All. Does anyone know how to build the calculation modules that calculate a Factory’s production capacity. This is the formula I am using: Production capacity = number of machines*number of working hours*number of working days*number of shifts*line efficiency. Usually, they work five days a week (From Monday…
-
Commission calculation
Hi, Can anyone tell me whether the below calculation is correct or not? If yes, then can someone please clarify why the quarterly balances are different Thanks AB
-
Is a live model to model connection still happening?
A few years ago, there was a "live" model to model connection on the Anaplan roadmap. Has there been any update on whether models would speak to each other continuously versus through an import?
-
How to sync manual data to from one module to another
Hello All, I am trying to bring the data from an existing module A to another module B ( have created the same column in the module B with correct dimension), but I am seeing no data in that module Going forward i want this column to be up to date with the live data in Module A Is creating an action my only way? Approach…
-
Need to set a particular list item as default in Dashboard, other than ALL
Hello Everyone, I have Flat List by name: ABC, This list i have selected in a Module:1. This Module1 i have published on classic DB. The list contains list items 1,2,3 and ALL. Requirement: I want to set 1 as default list item on DB, whenever any user opens this DB they should see the default as 1 as the list item. But in…
-
UX User-Filter & Context Selector Issue
Hi, I have a user filter that was working correctly before (and still working in some old UX pages) but it seems that after the last Anaplan update a bug had happened and I am not able to apply the filter anymore. In my UX page shown below, the user-dimensioned selector (Blue box) filters the context on the page (green…
-
Summing values for a year
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks
-
How to vary the calculation used for each version for a single line item?
I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs then compared to previous versions. However, sometimes the calculations themselves need to change to reflect our evolving…
-
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
-
Formula to calculate based certain items in a dimension
I am having trouble to create a formula to calculate something on selective items in a dimension. Simplified example is as follow. 1. Products A, B, C and D defined in a list 2. Clients 1, 2, 3 and 4 in another list 3. Production costs calculated at the client level based on the products (any and all) they have Now I need…
-
Sum based on Boolean
Hello, Hopefully a simple one. Our P&L has 50 cost centres, each of which have staff costs assigned. In a separate module I want to bring in the staff costs from 15 of these - is there a simple way to do this, for instance by having a separate module with the cost centres included and a boolean line item to determine which…
-
Rank Formula Work Around
Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date. The problem is, with the "RANK" formula, the…
-
Clear Override value when the Override boolean is unchecked
Hello All, I would like to clear the override line item based on whether the boolean value enabled or disabled. Please see screenshot attached for current & expected behavior I have perused through the existing questions on this topic but couldnt really get the same problem statement. Apologies if I missed it somewhere, if…
-
A line item format as "No Data" can be used in an import action?
Hi Guys, I have an action to clear data in target module. The format of line item in source module is "No Data" and formula is blank. And the format of line item in target module is Boolean. I want to make the value of target line item as FALSE. Does it work when I run the import action? As my experience source and target…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
L3 model building sprint1- 4.6 Model Build Specifications
Hi Everyone, I'm working on L3 training and feeling stuck. in section 4.6.5 we are asked to build the module that references PY FY19 sales. I was able to do it, but on the confirmation page from anaplan dimensions look different, but the numbers are correct in total and by product. I used A1 accounts, P2 Products lists. do…
-
Boolean to Boolean / Date to Date import
Friends, I am experiencing a very strange case where am importing a boolean lineitem (1 cell) to another boolean lineitem within the same module (1 cell), which has derives DCAs on other lineitems, but the boolean is not copied over (through import) in target line item; although the import process shows 1 updated. Source…
-
How to bring a territory down to account level?
Hi all, I am having trouble assign territory down to the account level. Here are my modules: Module 1: This is the territory definition module containing the attributes for my territories. In this case, I have create an territory "USA_Banking_SPC_Tier 1_Rule 1" to cover all "ABS Lender" products. Module 2: This is the…
-
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
-
Use Time dimension in a formula
I have a module with Day as the time dimension. I would like to refer to the module time dimension in a formula. For example, WEEKDAY(time dimension). So that on January 1, 2023, the line item would return 7 (for Sunday). Is this a thing?
-
Comparing values against the same dimension
Use case: Prod A was sold for 100$ as part of Plan A, 120$ as part of Plan B and 150$ as part of Plan C, I need to determine the increase/decrease in price for each plan. How can this be achieved in Anaplan?
-
Filter - Current User Selection Not available in NUX pages
Hello all, We are currently facing an issue with the filter on page selectors in NUX. Earlier we had this option but now it got disabled. We have version list as a selector in a NUX board page. As it is has lot of members in it, we have given the user the flexibility to reduce the no of drop down items by selecting Version…
-
NUX, Subsets, and Context Filters
Hello! I've got another unusual NUX issue I need some help with. I've tried to include relevant snips below, but as always happy to answer any questions and provide more info as needed! It has not been an issue until now, so we suspect recent Anaplan updates are the cause but have no way to verify beyond it being a new…