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 →Category Archives: Oracle Smart View
Ad hoc analysis, forms and reports from Excel.
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 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 →