Smart View Lesson 5: Smart View Functions (HsGetValue)

📎 This article includes 1 downloadable practice file ↓

⏱ 1 min read

📘 Smart View & Essbase Basics Course · Lesson 5 of 6

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

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

“`text
=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

“`text
=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.

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.

Keep reading

Oracle Smart ViewSmart View Lesson 3: Zoom, Pivot, Keep Only and POVOracle Smart ViewOracle Smart View for Beginners: Ad Hoc Analysis in ExcelOracle Smart ViewSmart View Lesson 1: What Essbase and Smart View Are
✨ Ask AI about this article

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

Free · AI can be wrong