Smart View Lesson 5: Smart View Functions (HsGetValue)

Smart View Lesson 5: Smart View Functions (HsGetValue) featured illustration

πŸ“Ž This article includes 1 downloadable practice file ↓

⏱ 1 min readUpdated 12 October 2026

πŸ“˜ Smart View & Essbase Basics Course Β· Lesson 5 of 6

In this article
  1. HsGetValue
  2. Reference cells
  3. Function Builder
  4. Practice
  5. Continue learning

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.

Advertisement

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.

πŸ’‘ Functions are slower than ad hoc grids for big reports. For hundreds of cells, an ad hoc grid with formatting preserved may be faster.

More: HsGetValue functions.

Advertisement

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

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.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free Β· AI can be wrong

Leave a Comment