-
Issue with Scenario Mapping – Line Item Not Appearing as Mappable Dimension in Import Action
Hi everyone, I’m trying to replicate a UX setup where a user selects a Source Scenario and Target Scenario in the UX, and an action transfers data from the source scenario to the target scenario. I reviewed how consultants implemented this in one of our existing modules: They created two line items: Source Scenario and…
-
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
-
Result from ISNOTBLANK() is not aligned to LENGTH()
Hi Anaplanners, I have encountered this super weird situation where I am using ISNOTBLANK() formula to identify if there's any characters in my Parent Reporting Sub-Segment (PRSS) column, but some rows (see ss below) is showing ISNOTBLANK() = TRUE even when there's no inputs. When I tried to troubleshoot this with LENGTH()…
-
400 error when using From Action
hi, I'm receiving this error when trying to create item in numbered list item. My list has a display name property (used only to display name, never in modules) In form Action I ask user to give display name and other informations about the item (informations are line items in associated modules). It seems that when I ask…
-
Change the model source for all pages in an application in one go
Hello every year I use to copy a PROD model of a given period (Bud 2026 for example) and keep it open but "Locked" for users, in order for them to still be able to access it if they want to remind what has been done during the previous process. All the pages in the app are sourced on this model (the PROD one not the copy),…
-
Update Anaplan IRR Function to calculate running IRR
We have a business requirement of calculating running IRR to calculate the performance fee. Currently, Anaplan IRR function gives 1 final output basis entire cashflow We need running IRR to start calculating the performance fee from the period if the IRR exceeds Hurdle rate This is a highest priority item and needs to get…
-
Single Thread and Cumulate
Hi, I'm reviewing a model MAPS report. the model includes 5 instances of 'Single Thread' cases all involving the Cumulate function. I can't figure how to resolve these. Does anyone have any pointers or ideas?
-
Quick sum bar not supported in Saved View
I wanted to check if others are facing this specification difference between Grid Card in Additional Insight. When created using a Saved View, the Quick Sum bar feature does not work, but when created using the module directly, the Quick Sum bar works.
-
How to use a different 'Current period' for different versions
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…
-
How to Implement Selective Access with Flat Lists
Hi Anaplanners I need assistance on achieving this. I have: Flat Region list (e.g., Region A, Region B…) Flat Retailer list (e.g., Retailer 1, Retailer 2…) In the spoke model, these become a composite hierarchy (Region → Retailer), which makes selective access easy. But in the Data Hub, the lists are flat, and I want users…
-
Level 1 model building - Numbered emp
Required import My import Can someone help with this? How to get the name of the employees in above e.g. instead of #1039 get Shala Engle.. Thank you,
-
Subset Update on Selective Access Enabled list - Workaround Suggestions?
Hi All, I'm Currently Optimising some of our Cell-Count Intensive Reporting Modules, I've an almost working solution except for this limitation I'm facing. We've around 5-6 Reporting modules in our model which is Dimensioned by Levels of Promo Hierarchy X Users, promo Customer Hierarchy X users. Since the promo customer…
-
Different Aggregations for Different Dimensions
I have a REP01 module with Account 2 (R1, R2, L1, L2, E1, E2) and City(City 1, City 2, …) dimensions and an Amount line item. City rolls up to Region (Region 1, Region 2) Account 2 rolls up to Account 1 (Revenue, Labor, Expense). In REP01 module's Amount line item, I want to sum in City dimension but use a formula of…
-
CUMULATE optimum use
Hi All, I'm trying to replace the use of CUMULATE to produce a running total in a module Dimensioned by 'fake time' - so I can't use PREVIOS, for example. I am trying to establish if this is a worthwhile exercise - the relevant MAPS report shows 00.00% calculation effort against the CUMULATE formula and a relatively low…
-
Import Final Demand Forecast into DATA02 Module - Would like to have your suggestions on this.
Not sure the way i handled this scenario right or wrong, would like to have your thoughts on this .. Since the Supply chain model, dem03 final demand forecast dimensioned by Accounts, Product SKU's. However, my assumption is FP&A, No way related to accounts(we didn't added any lists for account during the FP&A model…
-
Limit the resulting value to a specific File Type
I have data organised by File Type, so has values such as: Month End Flash 1 Flash 2 Flash 3 Flash 4 Flash 5 For Cohort 202602 (Feb 26), the module holds data for Flash 1, Flash 2 and Flash 3. I only want to bring in the data for the latest Flash version - this is shown in the Module in the line item called File Type…
-
Trying to use a formula to choose a value to use in a calc
I am trying to choose between 2 values to use based on a value in another module and lookup to a Cohort from a month value. So, either the Extrapolated Blank Tariff CoS if the Cohort has Flash ticked in Month End Attributes, or Blank Tariff CoS if the Cohort does not have Flash ticked in Month End Attributes. This formula…
-
Formula not resulting in the correct value
I have the following line item and formula, but it appears to not result in the correct value, the correct value according to the formula and the excel version of this is: 302,590 and not 315 as in Anaplan. All of the correct values are pulling through into the calculation so this is probably a syntax error that I cannot…
-
Mapping Cohorts in the format YYYYMM to Time value Month
I have a module that has 4 line items, 2 of which work on Month which results in the correct values, however 2 work on something called Cohort - so for example 202204 is Apr 22. See module below, the top 2 result in blanks/zeros and the bottom 2 result in correct values. So I want somehow to map the Cohorts to the time…
-
Collect then Cumulate or Cumulate then Collect?
We are thinking of an addition to a key model in the business process. Unfortunately, we do not have access to BPI numbers for either of these Cases. Am I correct in thinking Cse B, below, is the better option. If not why not? Both cases A and B are described below. All Line Items (‘Refs) are constant across both Cases…