
π This article includes 1 downloadable practice file β
In this article
Five actions do most of the work in an ad hoc grid. Once they’re second nature, you can answer most questions in seconds.
| Action | Does | Shortcut |
|---|---|---|
| Zoom In | Shows children of a member (Q1 β Apr, May, Jun) | Double-click the member |
| Zoom Out | Back to the parent | Right-click double / ribbon |
| Keep Only | Keeps selected members, removes the rest | Ribbon |
| Remove Only | Removes selected members | Ribbon |
| Pivot | Moves a dimension between rows, columns and POV | Ribbon or drag in POV |
Point of view
The POV bar holds the dimensions not on the grid. Change Scenario to Budget, Entity to a branch, and refresh: the whole grid recalculates for that slice.
Zoom options
Options βΊ Member options βΊ Zoom in level: next level (default), all levels, or bottom level (leaf members only, e.g. all months).
Examples use a sample Essbase application (Sample.Basic-style dimensions). Connection URLs, applications and member names differ in every company.
Practice
Practise each action from the checklist on your grid.
π Practice files for this article
- πLesson 3 checklistStep-by-step exercises for this lesson.β¬ TXT Β· 333 B
Free to use for learning. Files with macros (.bas) are plain text β import them with Alt+F11 β File β Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.