nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What is the best way to use cross join for two hierarchies going to lowest descendants

vatsalasharma8

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

Accepted answers

All comments

There are no accepted answers yet

Quick Links

Can you help?

Unanswered questions

What is the best way to use cross join for two hierarchies going to lowest descendants
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
ETA on ADO - Mulesoft - Boomi API integrations?
Hi! In London it was mentioned, any update on this?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
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…