Data Model Class Notes
Data Model Class Notes
August 2013
Explains how to use Oracle Fusion Applications to perform
current state analysis of business applications.
Oracle Fusion Applications Reporting and Analytics Handbook, Release 11.1.6
E41684-01
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.
Contents
Preface ................................................................................................................................................................. v
Audience....................................................................................................................................................... v
Documentation Accessibility ..................................................................................................................... v
Related Documents ..................................................................................................................................... v
Conventions ................................................................................................................................................. vi
iii
5 How Do I Embed a Report in a Sales Dashboard?
How to Embed a Report in a Sales Dashboard..................................................................................... 5-1
iv
Preface
Audience
This document is intended for users of Oracle Fusion Applications who want to
perform current state analysis of their business applications.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle
Accessibility Program website at
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Related Documents
For more information, see the following documents in the Oracle Fusion Applications
documentation set:
■ Oracle Fusion Transactional Business Intelligence User's Guide
■ Oracle Fusion Applications Common User Guide
v
Conventions
The following text conventions are used in this document:
Convention Meaning
boldface Boldface type indicates graphical user interface elements associated
with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for
which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code
in examples, text that appears on the screen, or text that you enter.
vi
Part I
Part I Viewing, Modifying, and Creating Reports
This Part describes how to answer business questions related to viewing, modifying,
and creating reports.
1
How Do I Create a New Report?
1
This tutorial shows you how to create a new Fusion report. A Fusion report is based
on an "analysis" that defines the information you want to see in the report. So to create
a new Fusion report, you first need to create an analysis. The folder in which you save
the analysis controls whether it is only available for your personal use, or whether
other people can use the analysis.
4. Expand the subject area folder (by clicking the arrow next to the folder) and select
the columns to include in the analysis.
For each column that you want to add:
a. Select the column in the Subject Areas list.
b. Click the Add button (the right arrow button to the right of the Subject Areas
list) to move it to the Selected Columns list.
For example, suppose that you want to create an analysis that shows opportunities
by sales stage. Select the following columns from the Subject Areas list and move
them to the Selected Columns list:
From the Employee folder: Employee Name
From the Opportunity Name folder: Opportunity Name, Sales Stage Name, and
Status
From the Facts/Pipeline Facts folder: # of Opportunities
5. Click Next.
6. Specify the views (that is, the ways to visually present the data) to include in the
analysis. You can include a table, a graph, or both a table and a graph.
The Table options include:
■ None — Specifies no table.
■ Table (recommended) — Specifies a table. (This is the recommended table
type for nonhierarchical data).
■ Summary Table — Specifies a table that also includes summaries of the data
(for example, grand totals).
8. Click Next.
9. Save the analysis as follows:
a. In the Analysis Name field, specify a name for the analysis.
b. In the Save In list, select the folder in which to save the analysis.
The folder in which you save the analysis controls whether the analysis is
available only for your personal use or available to other users.
If you save the analysis in My Folders, then it available only for your personal
use. If you save the analysis in Shared Folders/Custom, then it is available to
all users who can access Shared Folders/Custom.
c. Click Submit, then OK in the Confirmation dialog.
For example, select the My Folders/All Opportunities folder, enter Opportunities
by Sales Stage as the name and click Submit:
This Part describes how to answer business questions related to printing reports.
2
How Do I Print a Report?
2
This tutorial shows you how to print a Fusion report. The type of report shown in this
tutorial is an Oracle Business Intelligence analysis.
4. Once the analysis is displayed, click the Print link, and select Printable PDF.
This Part describes how to answer business questions related to exporting reports.
3
How Do I Export a Report to Microsoft Excel?
3
This tutorial shows you how to export the results of a report to Microsoft Excel. The
type of report shown in this tutorial is an Oracle Business Intelligence analysis.
4. Once the analysis is displayed, click the Export link and select Excel. In the dialog
that is displayed, click OK to open the worksheet.
This Part describes how to answer business questions related to scheduling and
sharing reports.
4
How Do I Schedule a Report for Distribution?
4
You can schedule reports to be automatically sent to groups or individual users, so that
you and those you work with receive necessary information in a timely manner. The
type of report that you can schedule is an Oracle Business Intelligence analysis.
During the scheduling of a analysis for distribution, you can specify:
■ How the analysis is generated: does it contain the same data for everyone or data
specific to the recipient
■ When the analysis is generated
■ To whom the analysis is sent
■ How is it sent (such as email, mobile device, or dashboard)
5. Select Schedule.
2. Specify how the analysis should be generated by selecting one of the following
from the Run As option:
■ Recipient: Generates the analysis with data specific to the recipient.
■ Specified User: Generates the analysis with data specific to the specified user.
If you select this option, specify the user in the box to the right of the option by
clicking the Set User button to display the Select User dialog, where you can
select a user.
Create Schedule
1. Click the Schedule tab.
2. Select how often you would like to generate the scheduled analysis from the
Frequency box.
Note that the available scheduling options depend on the frequency.
3. Specify the length of time that you want the scheduled analysis to run using the
End radio buttons:
■ No End Date: Runs the scheduled job perpetually until the agent is disabled
or deleted.
■ Select End Date: Allows you to select a specific end date.
Specify Conditions
1. Click the Condition tab.
2. Specify whether the agent always delivers the analysis, or conditionally delivers
the analysis. This tutorial utilizes the default condition that is created on your
behalf, and it is not necessary to configure any additional conditions for this
example.
Select Recipients
1. Click the Recipients tab.
2. Click the Add Recipient (+) button to add additional users to the automatic
distribution. The Select User dialog is displayed.
3. Select what you want to add to the distribution from the List box:
■ Application Roles
■ Catalog Groups
■ Users
■ All
4. Enter a user name or email or an application role or catalog group name in the
Name field and click the Search button.
5. Select the accounts, roles, or groups that you want to add to the distribution and
click the Move or Move All button.
6. Click OK.
Configure Destination
1. Click the Destinations tab.
2. Specify where the analysis is to be delivered. For most cases, you will use the
defaults so that the analysis is delivered to the recipient's dashboard and to the
devices specified in the recipient's delivery profile.
Complete Configuration
At this point, you have completed configuring a basic agent to automatically generate
and distribute a selected analysis to a specified set of users, groups, or roles.
1. Click the Save button to save the agent.
The agent is now configured and the job is now running and will deliver the
selected analysis to the selected users when the next scheduled interval occurs.
Dashboard?
This tutorial shows you how to embed a report in a sales dashboard. The type of
report shown in this tutorial is an Oracle Business Intelligence analysis.
d. Click the cross in the upper right corner to close the search list.
To add an additional analysis, repeat steps a to d.
e. Click Close to save the changes and exit Edit mode.
The analysis is added to the page.
This Part describes how to answer business questions related to accessing reports on
mobile devices.
6
How Can I View Analytics with a Mobile
6
Device?
This tutorial shows you how to view Oracle Fusion analytics on a mobile device.
Users of Oracle Fusion Applications can access, on their iOS, BlackBerry, and Android
mobile devices, all the same analytics available in the web application. To view Oracle
Fusion reports, you need to view Oracle BI analyses. You can view standard analyses
that come predefined within Oracle Fusion Applications, and you can also view
additional, custom analyses of your choosing.
Oracle Fusion Mobile Sales allows you to view business intelligence in the context of
your other sales data, including your leads, your opportunities, and so on.
Oracle Tap allows you to view business intelligence analyses that have been associated
to a KPI, that in turn you have added to Oracle Tap.
■ For Android devices, install Oracle Fusion Mobile Sales from Google Play.
■ For Blackberry devices, install Oracle Fusion Mobile Sales through a local
server link in a format similar to this example:
https://host:port/sales/faces/MobileInstallerMain
The exact URL is provided to you by your administrator. When opened in a
browser, the link takes you to an installation page.
■ For the iPad, you can also install Oracle Tap from the Apple App Store. Use
Oracle Tap to view key performance indicators (KPIs)—in both CRM analyses
and HCM analyses.
Note: If you do not want to log in right away, you can try Oracle
Mobile Sales and Oracle Tap using the Demo mode.
3. Explore. Both Oracle Fusion Mobile Sales and Oracle Tap offer navigation tours
when you launch the application.
■ In Oracle Fusion Mobile Sales, tap and swipe to access BI analyses in any of
these ways:
– The Analytics icon from the home page.
– The Analytics icon from the main menu. Access the main menu by
swiping left to right from the springboard page.
– The Analytics link from the related objects for a Sales object. For example,
an Opportunity analysis.
■ In Oracle Tap, access BI analyses through the shuttle menu by doing this:
Adding an analysis to Oracle Mobile Sales is explained in detail in the Rollout Guide for
Oracle Fusion Mobile Sales. The Rollout Guide is part of the Rollout Kit for Oracle Fusion
Mobile Sales [Document ID 1540393.1 on https://support.oracle.com/]
On the mobile device, your analysis is rendered in an embedded web view.
Note: Make sure you have the necessary privileges to edit KPI
Watchlists. Users with the Business Intelligence Consumer role, or the
Business Intelligence Author role, can edit KPI Watchlists by default.
If required, the Watchlist editing privilege can be allocated to other
roles by your applications administrator.
Your Oracle Fusion Tap KPI is now available to view under the relevant KPI Watchlist
on users' tablet devices.