
π This article includes 1 downloadable practice file β
The fastest way into a cube is an ad hoc grid: Smart View places the top member of each dimension on the sheet and you drill from there.
Connect
- Excel βΊ Smart View tab βΊ Panel.
- Shared connections (set up by your admin) or Private connections with the URL provided.
- Log in, expand to your application and cube, choose Ad hoc analysis.
The default grid
Rows and columns show one dimension each; the remaining dimensions sit in the POV (point of view) at the top. Click Refresh to fetch data.
Options worth setting
- Data options βΊ Suppress rows: No data/Missing and Zero, to hide empty lines.
- Member options βΊ Member name display: Alias for readable names.
- Formatting βΊ Use Excel formatting if you want your own number formats to stay after refresh.
More: ad hoc analysis for beginners.
Examples use a sample Essbase application (Sample.Basic-style dimensions). Connection URLs, applications and member names differ in every company.
Practice
Connect and refresh your first grid following the checklist.
π Practice files for this article
- πLesson 2 checklistStep-by-step exercises for this lesson.β¬ TXT Β· 315 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.