-
Workspace size
Monitoring the size of the workspace is crucial in Anaplan, since you must not exceed the allocated size. In general, what advice do you have? Thank you Julien
-
Waterfall chart
Hi, I'm working on some data that I'd like to present as a cascade chart, but I have no idea how to do it. Unless I'm mistaken, this type of chart isn't available by default. Do you have any tips or advice? Any examples? Thanks in advance, Julien
-
How to get subtotals for a filtered view instead of Grand totals
Facing challange to get the exact totals for Q1 Q2 line items(it should be 21250), Can somebody please suggest a way to get subtotals intead of grand totals. My Summary should be dynamic.
-
Issue with double counting bed types
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
-
Anaplan Export (Tabular Multiple Column): Saved View Line Items
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
-
Anaplan Polaris - ITEMLEVEL Question
Hello, I am trying to understand how the ITEMLEVEL function works. I am reviewing the example shown in Anapedia (https://help.anaplan.com/itemlevel-756d1428-5f1d-4d79-8274-d075a1bd312f) but I do not understand how Result 1 is calculated. For example, why does California returns 0 but Texas 4? Also, Spain returns 3 but UK…
-
Mapping LOOKUP
I have a Combined String list and a Combined String Properties module. I also have a Mapped Flat List and a Mapping module. I want to bring the mapping from the Mapping module to the Combined String Properties. How do I do that? I know I should use a lookup, but I need help with the setup?
-
On Polaris' Sparsity and Memory Efficiency
According to the Polaris website, it states that the higher the sparsity of the data, the better the memory efficiency. What exactly does this “memory efficiency” refer to? Does it simply refer to the model size?
-
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…