hi!
I want to view the properties of an item in the parent hierarchy from the child hierarchy.
How can I do this?
@KubotaNatsuki
We do not have any anaplan built-in functionality to view parent hierarchy properties in child list.
You have to derive the parent hierarchy level properties in child hierarchy dimension using lookup based on parent list formatted property/line item.
for example:
Parent List: List L1
Child List: List L2
Then the lookup line item or property (LKP) should be with the format of List L1 in List L2 dimension/list.
List L2. Property 1 = List L1.Property[lookup:LKP]
Hello there, we are using AnaplanXL to pull data from 3 different sources into one Excel file. Two of them are Azure SQL data bases and the third is Anaplan itself. Whenever the Excel is opened 3 pop up windows to log in to each data base appear. Until they appear and everything is entered or clicked already 2 minutes are…
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…