
π This article includes 1 downloadable practice file β
Zooming is quick, but for a report you want specific members in a specific order. Member Selection is the precise tool.
Open it
Click a cell holding a member (or the POV) βΊ Member Selection. The hierarchy appears on the left; chosen members on the right.
Ways to select
- Browse the tree and tick members; use the arrows to order them.
- Search by name or alias.
- Filters: Children, Descendants, Level (0 = bottom members), Generation, attributes, UDAs.
Names and aliases
Members often have a technical name (e.g. 410000) and aliases (e.g. “Sales Revenue”). Choose the alias table in Options. Reports read better with aliases; formulas and uploads often need member names.
Examples use a sample Essbase application (Sample.Basic-style dimensions). Connection URLs, applications and member names differ in every company.
Practice
Build the 6-account grid described in the checklist.
π Practice files for this article
- πLesson 4 checklistStep-by-step exercises for this lesson.β¬ TXT Β· 273 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.