Rob - thank you very much . this is helpful!
@JohnnyW
It depends on the number of list members in each list as well as which engine you are using (Classic vs. Polaris).
What are you attempting to do and maybe we can help you out.
We are helping a home improvement client build Gross to Net Forecasting model. What is the general guideline on maximum number of dimensions (aka lists) per Anaplan Module under Classic and Polaris?
There is really no limit to the number of dimensions for the model, you just have to be careful with the number of dimensions in a module.
"you just have to be careful with the number of dimensions in a module" Can you expand on this? Is it a fixed number of dimensions or is there another variable? I have a case where I try to add an 8th dimension and it is rejected. I tried adding the new list first then the other dimensions, one by one. This worked but not for one Subset. I then removed another dimension and tried the rejected one. This didn't work. HELP!
@FlynnWil
It is not a fixed number of dimensions, it is the number of cells in a line item which can't get bigger than 2^31 -1 cells (roughly 2,147,483,647 cells)
It also depends on the amount of free space you have in your workspace. The number above is a hard number, but if your line items are less than that number and you are still getting errors, it could be that your workspace is running out of room.
If we go down lowest descendants for 2 hierarchies something like this {Descendants([Planning Org].[Planning Org].[ALL].[AllMember],255,LEAVES)} then the queries timeout what is the best way to use lowest decendants so it doesnt scan the whole hierarchy
Hi! In London it was mentioned, any update on this?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
