Running Financial Reports in Oracle EPM 11.1.2.4

There are two ways in which Financial Reports can be run in Oracle EPM 11.1.2.4: Workspace and SmartView. Workspace only allows users to view the Financial Reports. SmartView also allows users to view the report. However, in SmartView, users can use Ad Hoc Anaylsis along with the report. This allows users to enter/change data directly on the Financial Report. Users can also manipulate the Point-of-View on the report when using the Ad Hoc analysis feature in SmartView.

First, I will show how to run a report in Workspace. Once the user has logged into Workspace, they will see an ‘Explore’ button under ‘View’ at the top-left of the screen. Click ‘Explore’.

FR Reports001

‘Explore’ is the Report Repository. Here users can view all of the Financial Reports from every application that exists. Double-click the application folder to open it. For the example, I will open the ‘Vision’ folder.

FR Reports002

Now, I have a list of all of the reports in the ‘Vision’ application. I want to run/open the ‘Vision Account Summary Report’. So, there are two ways to run this report:

1) The user can right-click on the desired report. Then select ‘Open in’ and they can choose from HTML or PDF previews. The HTML preview will open the report in the web browser, while the PDF preview will give the user a downloaded file that they can open or save as a PDF file.

2) Double-click on the report, and it will open in the HTML preview format.

FR Reports003

Here is the report in the HTML Preview.

FR Reports004

Now I will demonstrate how to run a Financial Report in Hyperion SmartView. Open Excel, go to the SmartView tab at the top of the Excel toolbar, and select ‘Panel’ on the very left side of the SmartView toolbar.

FR Reports005

The Panel will open on the right side of the Excel Screen. Connect to a Shared Connection for SmartView and log in.

FR Reports006

Once successfully logged in, in the drop-down bar, select ‘Reporting and Analysis Framework’. This connection will allow the user to directly open the Financial Reports in SmartView, giving them full Ad Hoc capabilities with the report.

FR Reports008

Next, the connection to the server will show up. Expand the server and notice that the same Report folders are displayed as the ones shown above in the ‘Explore’ menu in Workspace. Expand the application and double-click on the Financial Report in order to open it in SmartView.

FR Reports009

WEBINAR

Building to the ‘Top’ with OneStream: HFM Replacement Story

An ‘Import Workspace Document’ screen will appear with a preview of the selected report.

FR Reports010

Make sure that all three check boxes have been checked before selecting ‘Finish’.

FR Reports011

Once the user has finished importing the report, it will open in SmartView.

FR Reports013

It is displayed exactly how it was in the HTML preview in Workspace, but now the user has full Ad Hoc capabilities.

FR Reports014

To demonstrate the Ad Hoc functionality, I deleted the data in B23 cell for ‘Sales’ in Q3.

FR Reports015

I clicked ‘Refresh’ in the SmartView toolbar. A message will appear saying how many pages of the report have been updated.

FR Reports017

As soon as the Refresh has completed, the value in B23 was restored.

FR Reports013

To further demonstrate the Ad Hoc Analysis, I deleted all of the data in the Report.

FR Reports018

I clicked ‘Refresh’ and all of the data comes back.

FR Reports019

In conclusion, both Workspace and SmartView allow Oracle EPM users to view Financial Reports. The added benefit of running a report in SmartView is the use of the Ad Hoc Analysis feature. This allows users to work with the data and change the Report’s Point-of-View.

Share this

About the author

Philip Parker

The Pre-Transformation Checklist for Finance

An 11-Step Risk Reduction Tool for CFOs and CAOs Who Aren’t Sure Where to Start

By following this checklist, organizations can systematically approach their finance technology transformation, ensuring that all critical aspects are addressed and that the transition is smooth and successful.

Related posts you might like

Building to the ‘Top’ with OneStream: An HFM Replacement Story

View Post
CPM

An introduction to Corporate Performance Management Software (CPM)

View Post

HollandParker Named 2022 Power of the Platform Winner by OneStream

View Post

Privacy Policy

Introduction

Welcome to Holland Parker. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about our policy or our practices with regard to your personal information, please contact us at [email protected].

Information We Collect

We collect personal information that you provide to us when expressing an interest in obtaining information about us or our products and services, when participating in activities on the website, or otherwise contacting us.

The personal information that we collect depends on the context of your interactions with us and the website, the choices you make, and the products and features you use. The personal information we collect can include the following:

  • Name and Contact Data: We collect your first and last name, email address, postal address, phone number, and other similar contact data.
  • Payment Data: We collect data necessary to process your payment if you make purchases, such as your payment instrument number (e.g., a credit card number), and the security code associated with your payment instrument.
  • Login Credentials: We collect passwords, password hints, and similar security information used for authentication and account access.
  • Other Information: We collect any other information you directly provide to us through our website.

How We Use Your Information

We use personal information collected via our website for a variety of business purposes described below. We process your personal information for these purposes in reliance on our legitimate business interests, in order to enter into or perform a contract with you, with your consent, and/or for compliance with our legal obligations.

We use the information we collect or receive:

  • To send administrative information to you.
  • To fulfill and manage your orders.
  • To post testimonials.
  • To request feedback.
  • To send you marketing and promotional communications.
  • To deliver targeted advertising to you.
  • For other business purposes.

Sharing Your Information

We may process or share your data that we hold based on the following legal basis:

  • Consent: We may process your data if you have given us specific consent to use your personal information for a specific purpose.
  • Legitimate Interests: We may process your data when it is reasonably necessary to achieve our legitimate business interests.
  • Performance of a Contract: Where we have entered into a contract with you, we may process your personal information to fulfill the terms of our contract.
  • Legal Obligations: We may disclose your information where we are legally required to do so in order to comply with applicable law, governmental requests, a judicial proceeding, court order, or legal process.
  • Vital Interests: We may disclose your information where we believe it is necessary to investigate, prevent, or take action regarding potential violations of our policies, suspected fraud, situations involving potential threats to the safety of any person, and illegal activities.

Cookies and Other Tracking Technologies

We may use cookies and similar tracking technologies to access or store information. Specific information about how we use such technologies and how you can refuse certain cookies is set out in our Cookie Policy.

Data Security

We aim to protect your personal information through a system of organizational and technical security measures. We have implemented appropriate technical and organizational security measures designed to protect the security of any personal information we process.

Retention of Data

We will only keep your personal information for as long as it is necessary for the purposes set out in this privacy policy unless a longer retention period is required or permitted by law.

Your Privacy Rights

In some regions, such as the European Economic Area (EEA), you have certain rights under applicable data protection laws. These may include the right to (i) request access and obtain a copy of your personal information, (ii) request rectification or erasure; (iii) restrict the processing of your personal information; and (iv) if applicable, to data portability.

Updates to This Policy

We may update this privacy policy from time to time in order to reflect changes to our practices or for other operational, legal, or regulatory reasons.

Contact Us

If you have questions or comments about this policy, you may contact us by email at [email protected].

The Pre-Transformation Checklist for Finance

Tap into wisdom gained through 300+ finance transformations to uncover answers to questions you have and those you should.

This field is for validation purposes and should be left unchanged.