Smart View Lesson 2: Connecting and Your First Ad Hoc Grid
Connect Smart View to Essbase or EPM Cloud with a private or shared connection, open an ad hoc grid, refresh, and set the most…
Read article →Oracle Smart View
Ad hoc analysis, forms and reports from Excel.
📊
← ERP
Oracle Smart View
Ad hoc analysis, forms and reports from Excel.
📄 9 articles⬇️ 9 with practice files🕒 Updated 12 Oct 2026
🎓 Start here: Smart View Course → 🎓 Start here: Tally & Busy Course → 🎓 Start here: SAP Basics Course →Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
Read article →Smart View Lesson 5: Smart View Functions (HsGetValue)
Smart View Lesson 5: Smart View Functions (HsGetValue)
Build free-form reports with Smart View functions: HsGetValue syntax, referencing cells for members, the Function Builder, refreshing functions, and when to use functions vs…
Read article →Smart View Lesson 6: Building a Refreshable Report Template
Smart View Lesson 6: Building a Refreshable Report Template
Combine everything into a monthly report: parameter cells for period and entity, ad hoc or function grids, preserved formatting, multiple sheets refresh, and VBA…
Read article →Smart View Functions: Build Cell-Based Reports with HsGetValue
Smart View Functions: Build Cell-Based Reports with HsGetValue
Use Oracle Smart View functions such as HsGetValue to pull single numbers from Essbase or EPM into any Excel layout — syntax, POV defaults,…
Read article →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Smart View Lesson 1: What Essbase and Smart View Are
Smart View Lesson 1: What Essbase and Smart View Are
Understand Essbase cubes, dimensions, members and hierarchies, how Smart View connects Excel to them, and where it fits with Planning and EPM Cloud.
Read article →Smart View Lesson 4: Member Selection and Aliases
Smart View Lesson 4: Member Selection and Aliases
Choose exactly the members you need with the Member Selection dialog: hierarchy browsing, search, filters by level and generation, aliases vs member names, and…
Read article →Smart View Lesson 3: Zoom, Pivot, Keep Only and POV
Smart View Lesson 3: Zoom, Pivot, Keep Only and POV
Navigate cube data with the core ad hoc actions: zoom in and out, pivot dimensions between rows and columns, keep only and remove only,…
Read article →