Subsidiary is the composite list here as an example, i want to filter my grids based on the selection at any levels.
For E.g If i select RoW then i should be able to see all the data of Germany, Brazil, Australia etc.
@araj - Turn on the native hierarchy filter & you should be able to select that in the context selector & filter the grids. If not, creating a parallel flat list with all members & creating the filters would be the way to go.
@devrathahuja My grid has flat list as a dimension. Subsidiary details are in line items. So we cannot keep it in the context selector.
Also, we don't want to create a separate list; we want to achieve this using the composite list.
@araj - If you do not want to create a separate list, you'd have to publish the list (shown in the screenshot) as 2 separate filter fields. 1 with the parents, 1 with the children, either as 2 field cards or just 2 grids with boolean to filter the below grid.
@devrathahuja Thanks for your time and effort. My current setup is in a similar way by having different fields of levels, but I wanted to check if we could achieve this using a single field.
@araj , Hi if you could create separate line item, with the same or a lower list formatted, you could turn on dependent hierarchy from the format option by default & you can see the child items in second item based on the first line item
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…
