Setting epm workspace server settings and preferences

Oracle® Hyperion Reporting and Analysis

Addendum
Release 11.1.2.3
Updated: August 2013

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

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.

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 fail-safe, 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.

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.

Chapter 4. Production Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Configuring SAP Data Source Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Chapter 5. Reporting and Analysis Framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Tracking File and Folder Deletions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Canceling Running Jobs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Opening Versions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Extended Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22

Contents	iii

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at .

Access to Oracle Support

This document includes important, updated information about Oracle Hyperion Reporting and Analysis products and Oracle Hyperion Enterprise Performance Management Workspace. Review this document thoroughly before using these products.

Note: If information is not displayed when you select Help for any of these products, use Search to find the information you need.

This chapter contains updates for EPM Workspace guides and Help.

Additional General EPM Workspace Properties

Table 1


Remember User Name at Logon	If set to Yes, the user's name is remembered after a successful logon. The default value is Yes.
	sso_username=admin&sso_password=mypassword

EPM Workspace Parameter Descriptions

		Additional General EPM Workspace Properties	9
	Navigate Menu
l

Table 2

	Menu Command	Description

Table 3

Navigate Menu

Management Applications)

m Planning (Oracle Hyperion Planning Applications)

m Oracle Business Intelligence Answers

m Oracle Business Intelligence Interactive Dashboards

selecting Applications from the Navigate menu displays “No

Applications.” “No Applications” is also displayed when

Opens the selected application. The list of available applications is determined by which applications are installed and by user rights and roles.

10


	Use Explore to: l List and navigate the repository As a result, some documents are displayed in the content area and others can also be opened in their own studios. For example, you can set Oracle Hyperion Interactive Reporting to always open documents in Oracle Hyperion Interactive Reporting Web Client.
l Workspace Pages	Shared Workspace pages are stored in a system folder that authorized users can access from Explore. For details about using Workspace Pages, see the Oracle Hyperion Reporting and Analysis Framework User's Guide.

EPM Workspace Parameter Descriptions	11


m Workspace Server Settings m Reporting and Analysis o Production Reporting Engines o Production Reporting Database Servers o Notifications o Change Ownership m Dimension Library m Application Library m Configure Interface Data Source m Consolidation Administration	l Oracle Hyperion Reporting and Analysis Framework User's Guide l Oracle Hyperion Reporting and Analysis Framework Administrator's
m Batch Scheduler	Use Schedule to manage jobs and to schedule batches and events for automated processing. Batch Scheduler enables users to create and edit schedules for Oracle Hyperion Financial Reporting batches.

	Description
l Impact Manager m Manage Task List m Show Task Status

Tools Menu

Table 4	Tools Menu

l Install

m Oracle Hyperion Smart View for Office

m Offline Planning

m Smart View Admin Extension

Links to other tools, if available.

Smart View Admin Extension
Note that the Install menu includes a new option: Smart View Admin Extension. Using this

		EPM Workspace Parameter Descriptions	13
l
l



	Create and refresh Oracle Hyperion Planning databases

For more information, see the Oracle Hyperion Smart View for Office User's Guide.

available when users select Workspace Settings.

ä To set or change EPM Workspace server settings and preferences:

Customizing the Logon Page

An incorrect filename is used in the procedure in the section “Customizing the Logon Page” in

2 Backup file <EPM_ORACLE_HOME>/common/bpmui-common/11.1.2.0/bpmui.jar.

3 Using an unarchiving utility, extract the contents of <EPM_ORACLE_HOME>/common/bpmui-

7 Save your changes.

8 Repeat Step 4 through Step 7 for all other Resources_xx.properties files for all other locales.

14	EPM Workspace

In ab
in

is chapter contains updates for Interactive Reportin

Email Address Separators

the Oracle Hyperion Interactive Reporting User's Gui
lowing “The behavior of Download to Results varies
should include a reference to “Ragged Hierarchies.” The revised list:

Separate Columns

document that contains data in Results xisting Results data is not displayed. In eractive Reporting, Release 11.1.1.xx t when run with Interactive Reporting,

de in “Downloading to Results,” the list for different CubeQuery components,”e revised list:

l Shared Members

l Including Totals

Table 5

Operator	Description
Equal (=)	Retrieves records where the filtered item exactly matches the specified values. For example, if you use the equal operator to filter through inventory items, and specify the value “ball”, the filter returns only the item “ball”. It does not, for example, return“volleyball” or “ball pump”.
Contains

publishBqy Method Corrections

The publishBqy method is listed incorrectly in the Interactive Reporting guides as publishBqyFile.

Changed Examples

var uuid = objRep.publishBqy(objF, strN, strD, uuiF, blnD, strH, oceP)
repLocal.publishBqy(filSrc, strTrg, strDesc, uuiFolder, blnD , strH, oceMapNew); repLocal.publishBqy(filSrc, strTrg, strDesc, uuiFolder, blnD, strH, oceMapNew);

Versioned BQYDocument Methods

The following methods are added to the list of available methods in:

getParentIdentity ()

Returns the parent category identity. If the parent category is root, the method returns null.

Swing Feature	17

setADREnabled()
Sets ADR Enabled option value.

Upgrading Interactive Reporting Studio Files
After upgrading to Oracle Hyperion Interactive Reporting Studio, Release 11.1.2.3.000, you must update your files.

	Interactive Reporting

In This Chapter

ä To configure Production Reporting to use SAP as a data source:

1 Get the SAP JCo files from your SAP distribution, or download it from the SAP Web site as a registered

lib.

c. Expand the .jar file, using the convenience utility, in EPM_ORACLE_HOME/common/

4 Optional: To configure Production Reporting to use SAP as an authentication provider:

a. Download these files from the SAP Enterprise Portal EP60 SP2 or later into

l iaik_jce.jar

l iaik_jce_export.jar (if using the export version of the IAIK-JCE libraries)

	Production Reporting