Accountants, Raise Your Glasses! Smart View Has Landed in Google Workspace!

Nadia Lodroman • 10 April 2025

Listen to Tresora and Ledgeron's chatting about this blog post:

Smart View Goes Google: Liberation for Finance Teams!

As a recovering accountant, I know the comforting embrace of an Excel spreadsheet all too well. It's been the steadfast companion for countless analyses and reports. Even with the shiny new Oracle EPM cloud applications, the allure of Smart View, with its instant data insights, has kept many of us firmly rooted in that familiar grid.

But let's face it, this reliance came at a cost: a seemingly unbreakable chain to Microsoft Office subscriptions. For large corporations striving for enhanced security and seamless collaboration with Google Workspace, this dependency has been a persistent roadblock. For years, finance teams were often the last bastion of the "plasticky PC," clinging to Windows while the rest of the organization embraced the sleek security of Apple Macbooks and the collaborative power of Google Workspace.

And yes, I hear you – Smart View was technically accessible on macOS via the browser. But let's be real, that still meant shelling out for an Office 365 license on top of your Google Workspace subscription, just for that crucial EPM connectivity. It felt like being offered a key to a new, beautiful house, only to find out you still needed a separate, expensive key just to open one essential room.

This reliance on Smart View has come with a significant caveat: a continued dependence on Microsoft Office subscriptions. For large corporations, this has often been a frustrating obstacle, hindering the strategic move towards the more secure and collaborative ecosystem of Google Workspace. The dream of seamlessly integrating powerful EPM data with the flexibility and accessibility of Google's suite has felt just out of reach.

Well, my fellow finance aficionados, the wait is OVER! The barriers have been broken!
Your beloved Oracle Smart View has finally, gloriously, arrived in Google Workspace!

Imagine the possibilities:
  • Need to dissect those budget variances? Open Google Sheets and dive straight into your Oracle EPM data with the familiar power of Smart View, no more clunky exports or platform switching.
  • Crafting your monthly management pack? Picture the collaborative synergy of Google Slides, now seamlessly infused with real-time EPM insights via Smart View. Dynamic presentations, built together, in a secure environment.
  • Tired of the hardware divide? Finally, finance professionals can fully embrace the organization's move to secure and stylish Apple Macbooks, leveraging Smart View directly within their Google Workspace environment.
Supported data source providers:
Oracle Smart View for Google Workspace currently supports Oracle Fusion Cloud Enterprise Performance Management data source providers. The following business processes of Cloud EPM are supported:
  • Enterprise Profitability and Cost Management
  • Financial Consolidation and Close
  • FreeForm
  • Planning
  • Tax Reporting
How to get started:
To use Smart View in Google Sheets, users need to install the Smart View add-on extension from Google Workspace Marketplace.

A few important considerations:
  • Performance may vary due to additional processing on Google's servers.
  • The user interface is currently only available in English.
  • Oracle recommends using Standard mode for the Smart View Ad Hoc Behavior setting.
Liberation Day was March 25th, 2025. We might have missed the initial parade, but the sentiment remains strong. It's time for a belated celebration! Crack open the virtual (or real!) champagne and toast to a future where finance teams can operate with the full power of Oracle EPM within the secure and collaborative embrace of Google Workspace, finally leaving behind the constraints of Microsoft Office and those outdated "plasticky PCs." 

The future is here, it's integrated, and it's gloriously free!

by Nadia Lodroman 9 June 2025
Unlock the power of Oracle FCCS with our deep dive into financial consolidation. This guide demystifies how ownership percentages and consolidation methods (Subsidiary, Proportional, Equity) drive the entire process. Learn the critical roles of Proportion, Elimination, and Contribution, and finally understand the key difference between the Equity Method and the Equity Pickup. Perfect for finance professionals and FCCS users looking to master their financial close.
Effective Tax Rate
by Nadia Lodroman 1 June 2025
Dedicated ETR form within comprehensive tax reporting software, such as Oracle's EPM Cloud, can greatly simplify this process. Utilising an ETR form enhances transparency, auditability, and allows for scenario analysis, making tax calculations more accurate and efficient compared to manual methods.
Moving Beyond MVP to Maximize Your Software Investment
by Nadia Lodroman 28 May 2025
Are you constantly looking for new software? 🛑 Before you start another costly tender, discover the untapped potential in your existing tech. Learn how to move beyond MVP and maximize your current software investment.
Show More