Simplify cube views with the Bench in Planning Analytics
💡 Improve cube view clarity by hiding dimensions
Move rarely used dimensions to the Bench and show them again when required.
🎯 What you will learn in this short
In this video, I show you how to move dimensions from a cube view to the Bench to make your cube views easier to read.
How dimensions are moved from the cube view to the Bench.
Why the measure dimension often does not have to be permanently visible.
How hidden dimensions are displayed again via the eye symbol.
✍️ Practical example
Scenario:
The cube view contains many dimensions and seems confusing.
Result:
Rarely used dimensions are hidden, the view is structured more clearly.
What was covered: Identified a rarely used dimension + moved it to the Bench + displayed it again using the eye icon
Original transcript (German)
So kannst du deine Cubeview übersichtlicher gestalten. Dimensionen, die du nur selten veränderst, kannst du in die sogenannte Bench verschieben. In der Regel hat jeder Cube eine Measure-Dimension und in 99 % der Fälle stehen alle Daten auf der Measure „Number“. Du kannst also die Measure-Dimension oder andere selten genutzte Dimensionen einfach mithilfe der Bench ausblenden. Klicke dafür auf die drei Punkte neben der Dimension und wähle „Zur Workbench verschieben“.
Die Dimension verschwindet anschließend aus deiner Cubeview. Wenn du sie wieder einblenden möchtest, findest du sie über das Augen-Symbol. Gerade bei Cubes mit vielen Dimensionen ist das ein super Trick, um deine Views deutlich übersichtlicher zu halten. Hast du diesen Trick bereits verwendet? Schreib es mir gerne in die Kommentare.
English transcript
Here is how to make a cube view easier to read. You can move dimensions that you rarely change to the Bench. Most cubes have a Measures dimension, and in many cases all data uses the Number measure. You can therefore hide the Measures dimension or other rarely used dimensions with the Bench. Click the three-dot menu next to the dimension and select Move to bench.
The dimension disappears from the cube view. To display it again, use the eye icon. This is particularly useful for keeping views with many dimensions clear. Have you used this technique before? Let me know in the comments.
