Symmetric vs asymmetric drill
💡 Control drill behaviour
The drill mode determines whether you expand selected members or all corresponding consolidated members at once.
🎯 What you will learn in this short
In this video, I explain the difference between symmetric and asymmetric drill in Planning Analytics.
You will see how each drill mode affects the view.
You will also learn when to use each mode.
You will learn how to open detailed information only for a selected item.
You see all elements of a level unfolding simultaneously.
You learn how to switch between the two modes and avoid large views.
✍️ Practical example
Scenario:
Product categories and months are displayed together in a view.
Result:
Details are displayed specifically or for all categories at the same time – depending on the drill mode.
What was covered: Changed the drill mode + expanded members + controlled the view
Original transcript (German)
Was ist der Unterschied zwischen einem symmetrischen und einem asymmetrischen Drill in Planning Analytics? In meinem Beispiel siehst du die Produktkategorien aus der Produktdimension und die Monate aus der Monatsdimension. Beim asymmetrischen Drill kannst du die Monate nur für eine ausgewählte Produktkategorie aufklappen. Beim symmetrischen Drill dagegen werden die Monate für alle Produktkategorien gleichzeitig geöffnet. Umschalten kannst du ganz einfach über dieses Symbol.
Mein Tipp: Lass die Einstellung standardmäßig auf asymmetrisch und wechsle nur bei Bedarf auf symmetrisch. So verhinderst du, dass du versehentlich extrem große Views erstellst.
English transcript
What is the difference between symmetric and asymmetric drill in Planning Analytics? In my example, the view contains product categories from the Product dimension and months from the Month dimension. With asymmetric drill, you can expand the months for one selected product category. With symmetric drill, the months are expanded for all product categories simultaneously. Use this icon to switch modes.
My recommendation is to keep asymmetric drill as the default and switch to symmetric drill only when required. This prevents you from accidentally creating extremely large views.
