
π This article includes 1 downloadable practice file β
Ad hoc grids are great for exploring, but management reports have a fixed layout with your own formatting and formulas. Smart View functions pull single values from the cube into any cell.
HsGetValue
=HsGetValue("MyConnection","Year#FY27;Period#Apr;Scenario#Actual;Entity#Delhi;Account#Revenue")
Each dimension#member pair fixes one coordinate; any dimension left out uses its default (top) member.
Reference cells
=HsGetValue("MyConnection","Period#"&C$3&";Account#"&$A5&";Scenario#Actual;Entity#"&$B$1)
Put months across the top, accounts down the side and the entity in B1. Copy the formula across the grid; change B1 and refresh for another branch.
Function Builder
Smart View βΊ Build Function creates the formula through dialogs, the easiest way to get the connection name and syntax right.
More: HsGetValue functions.
Examples use a sample Essbase application (Sample.Basic-style dimensions). Connection URLs, applications and member names differ in every company.
Practice
Build a small function report following the checklist.
π Practice files for this article
- πLesson 5 checklistStep-by-step exercises for this lesson.β¬ TXT Β· 288 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.