One of the Oracle EPM product features that has been requested for decades - yes, decades - is to bring a report book into Microsoft Excel. With the April 2022 update this can FINALLY be done. Granted, the report book has to be the new Reporting book and not the old Financial Reporting book. But think of it as one more reason to migrate from Financial Reporting to Reporting.
This new feature works for FCC, Planning, Tax Reporting, and Narrative Reporting.
Using the feature requires enabling a new Smart View extension that is being released with the April 2022 update. This blog post will cover how to install the extension. A future blog post will cover how to use it.
To install the extension, go into Microsoft Excel and go to the Smart View ribbon. Click Options and then go to the Extensions panel.
The screen above shows EPM Books already listed but your screen will not. Click the blue "Check for Updates, New Installs, and Uninstalls" link at the bottom. When prompted, select the appropriate environment. Here, I'm using a FCC test environment.
Once the update is done, an item for EPM Books will be shown. Click Install on the right to install the extension. Note that administrator level access to the computer should not be needed for this.
Once the installation is done, quit Microsoft Excel (the installation process will remind you) and restart. Now, use the Smart View panel to connect to the application. Once the application ID is clicked upon, a new link will show for launching EPM Books. Click More>> if the link does not show.
The next blog post will go through how to use the Smart View extension to bring books into Microsoft Excel.
