Oracle Smart View questions, answered clearly.

Oracle Smart View for Office is the add-in that connects Microsoft Excel, Word, PowerPoint and Outlook to Oracle’s EPM and analytics products: Essbase, Planning, HFM and Financial Reporting on-premises, and Planning Cloud, FCCS, Narrative Reporting and the other EPM Cloud services. From Excel a user can retrieve live data, drill and pivot across dimensions, open Planning forms, submit budget numbers, run business rules and refresh reporting packs, all against the server’s data and security. For most South African finance teams it is the main way they use the EPM applications day to day.

Three things above all. Ad hoc analysis: retrieving a grid of live data from Essbase, HFM or Planning and zooming, pivoting and filtering it to answer a question. Data entry: opening Planning forms in Excel, entering budgets and forecasts, and submitting them back with the same validation the web form applies. Reporting: building month-end packs, board reports and reconciliations with Smart View functions and formulas that refresh from the server each period. It is also the drill-through path from a consolidated number back to FDMEE and the source ledger.

Finance works in Excel, and Smart View lets it stay there without losing control of the numbers. Data is retrieved live from the server rather than pasted from an export, so a refreshed workbook reflects the current consolidation or forecast. Server security applies in Excel, so users see only what they are entitled to. Reports built once refresh every period. Planners enter budgets in the tool they know, and the entries land in the application with its validation and audit trail. The cost of getting it wrong is spreadsheets full of stale pasted values, which is exactly what EPM is meant to replace.

Oracle releases Smart View updates several times a year, aligned with EPM Cloud’s monthly updates, and each version has a compatibility matrix against the server products and Microsoft Office builds. For Oracle EPM Cloud, staying within a few releases of current is expected, because cloud updates can require a newer add-in. For EPM System 11.2 the certified version is published with each patch set. Microsoft 365 click-to-run updates and 32-bit versus 64-bit Office are the usual sources of trouble. Namandla’s advice is to standardise one version per estate, deploy it centrally through Group Policy, SCCM or Intune, and re-test it before each Office or EPM update rather than let each user install their own.

By making the server’s data as easy to reach as a cell reference. Ad hoc grids support zoom in and out, keep only and remove only, pivoting, member selection and free-form layouts, so analysis moves at the speed of the question. Smart View functions such as HsGetValue and HsSetValue turn any Excel layout into a live report. Cascading generates a workbook per entity or cost centre from one template. Query Designer builds repeatable queries, and Office reports place the same grids in Word and PowerPoint for board packs. Financial Reporting and Narrative Reporting output can be opened and refreshed in Excel as well.

Not directly; Smart View connects to the EPM applications, and those connect to the ERP through FDMEE or Data Integration. What Smart View adds is the drill-through: from a consolidated or planned figure in Excel, a user can drill to the FDMEE or Data Integration landing page and see the source ledger lines that make it up, and where an ERP adapter is configured, drill again into the ERP. That path only exists for data loaded through those tools, which is one reason Namandla insists on them for financial loads.

Smart View is the common client for all of them. Shared connections through EPM Workspace or the cloud service URL give a user one panel with Essbase, Planning, HFM, Financial Reporting and, in the cloud, Planning Cloud, FCCS, Narrative Reporting and Enterprise Data Management. The same workbook can hold a Planning form, an Essbase ad hoc grid and an HFM retrieval on different sheets, which is how many groups build their month-end packs. Extensions add Planning admin functions, Narrative Reporting doclets and Enterprise Data Management views inside Office.

Ad hoc analysis is free exploration: start from a grid, zoom and pivot, and change the layout as you go; it is the analyst’s tool. Forms are the structured data-entry layouts defined in Planning or FCCS, opened in Excel with their validation, formatting and business rules intact; they are the planner’s tool. Smart View functions are formulas placed in individual cells that retrieve or submit a single value, so a report can have any layout and still refresh from the server; they are the report builder’s tool. Most users need one or two of these, and a good deal of support effort goes into using the right one: functions in a grid that should be ad hoc, or ad hoc retrievals where a form was intended.

Yes, at the desktop. Report packs built on Smart View functions refresh with one click instead of being rebuilt from exports. Cascading produces the entity-level versions automatically. VBA functions let a macro refresh a workbook, submit data and run a business rule in sequence, so a month-end pack can be produced by a scheduled job. Planners submit forecasts from Excel without re-keying into a web form. What remains manual is commentary and judgement, which is where Namandla applies AI assistance rather than more macros.

Smart View uses the server’s security: a user signs in with the same credentials, including single sign-on, and sees only the members and data their role and filters allow, exactly as in the web interface. Data is retrieved over HTTPS from the server and not stored on the desktop unless the user saves the workbook, which is the practical exposure: a saved workbook contains whatever was retrieved into it. Groups that care about this control it with document policies, sensitivity labels and disconnected workbooks for distribution. Keeping the add-in current also matters, because older versions lose support for newer authentication methods.

Every organisation running Oracle EPM, because it is how finance uses the applications; the question is how well it is deployed. Groups get the most from it when reporting packs are built on refreshable templates rather than exports, planners enter data through Excel forms, analysts use ad hoc against Essbase and HFM, and the add-in is centrally managed. In South Africa that describes listed groups with monthly board packs, planning-heavy retailers and miners, and any finance team that has said “we live in Excel” while running Hyperion behind it.

Usually one of five things. Retrievals that pull far more members than needed, with suppress missing rows and columns switched off. Workbooks with thousands of individual functions instead of one grid. Excel set to automatic calculation while functions refresh. Network latency between the desktop and the server, which is common with remote users reaching an on-premises environment. And on-premises, an Analytic Provider Services or Essbase server that has never been tuned for the number of concurrent users. Each is diagnosable in an hour and the fixes are template design, options settings and server tuning, in that order, before anyone buys bandwidth.

Smart View is the Office client for the whole EPM family: on-premises Essbase, Planning, HFM and Financial Reporting, and Oracle EPM Cloud’s Planning, FCCS, Narrative Reporting, Account Reconciliation views and Enterprise Data Management. It sits beside the web interface and the reporting tools as the third way of using the applications, and because it spans both on-premises and cloud, it is often the constant for users during a migration: the servers change, the Excel workbook does not.

Yes. The data that Smart View retrieves into Excel is exactly the data finance wants commentary on, so AI assistance sits naturally beside it: drafting variance explanations from a refreshed pack, flagging cells that moved unexpectedly against prior periods, and answering questions about a grid in plain language. Namandla’s approach is to apply AI to the workbooks and EPM data you already have, with defined boundaries on what leaves the organisation and a person reviewing anything that goes into a board pack, rather than to replace the reporting process. Microsoft 365 Copilot alongside Smart View is a practical starting point for many groups.

Namandla is a South African consultancy whose senior team has deployed and supported Smart View across Essbase, Planning, HFM and Oracle EPM Cloud for about two decades, and the person who reviews your reporting templates is the person who fixes them. We work on the whole chain, from the server settings to the workbook design to the desktop rollout, and we are independent on which EPM platform sits behind Excel. Where AI can help with commentary and review, we apply it to the data already in your packs. Contact info@namandla.com or 087 188 3388.