I have a list call lease ID that has a top level called All Lease ID. I do not want the top level to be seen in my selection. What can i do ?
@Kireshma1234 You can create a flat list without a top level and use that list in a selector. Below that, create a second line item called “Selected Lease ID”, where you can apply the FINDITEM logic. Then use this line item in a boolean filter.
FINDITEM
You cannot hide items directly in a dropdown, but the above approach works as a workaround.
~ Bhumit
Thanks for the solution! Creating a second line item with the FINDITEM logic is a clever workaround. @fnf
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
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…