Hyperion® Reporting and Analysis

Release 11.1.1.4.00

Readme

Purpose.. 2

Accessibility.. 2

New Features in this Release.. 2

EPM Workspace.. 2

New Features in Release 11.1.1.3. 2

Financial Reporting.. 2

EPM Workspace.. 3

General.. 3

Supported Paths to this Release.. 4

Supported Platforms. 4

Supported Languages. 4

Installation Information.. 4

Reporting and Analysis Known Issues. 4

Dashboard Development Services. 4

EPM Workspace.. 5

Financial Reporting.. 10

Installation.. 15

Interactive Reporting.. 16

Migration.. 20

Smart View... 21

SQR Production Reporting.. 22

Web Analysis. 23

Defects Fixed in this Release.. 25

EPM Workspace.. 25

Financial Reporting.. 25

Interactive Reporting.. 31

Migration.. 33

Reporting and Analysis Framework.. 33

Web Analysis. 34

Documentation Updates. 35

Accessing Hyperion Product Documentation.. 35

Accessibility in EPM Workspace, Fusion Edition.. 36

Using Search in Non-Dynamic Help. 36

Include Consolidation Info option for CubeQuery Query Options. 36

Intelligence: Dashboard.. 37

Ghostscript Custom Parameters. 37

Third Party License Appendix.. 42

Accessibility Considerations. 43

 

Purpose

This document includes important, late-breaking information about this release of Oracle’s® Hyperion Reporting and Analysis. Review this information thoroughly before installing Oracle’s® Hyperion Reporting and Analysis.

Release 11.1.1.4.00 is a maintenance release for Release 11.1.1.0, 11.1.1.1, 11.1.1.2, or 11.1.1.3.

For installation and configuration late-breaking information, see the Oracle® Hyperion Enterprise Performance Management System Installation and Configuration Readme.

Top of Document

Accessibility

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. Oracle’s Hyperion Reporting and Analysis supports accessibility features, which are described in Appendix A of the Oracle Enterprise Performance Management Workspace, Fusion Edition User’s Guide. Oracle’s® Hyperion Reporting and Analysis Readme documentation is accessible in this release in HTML format.

Top of Document

New Features in this Release

See the Oracle’s Hyperion Reporting and Analysis Release 11.1.1 New Features Guide for additional information about new features.

Information about system requirements for EPM System products is now available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted at http://www.oracle.com/technology/products/bi/hyperion-supported-platforms.html. System requirements are no longer part of the Oracle Hyperion Enterprise Performance Management System Installation Start Here.

EPM Workspace

EPM Workspace has a new property in the Administer menu called Enabled Products. When selected, you can disable products that are installed but not running. A dialog box is displayed with products that can be deselected. If the checks are cleared, the products are de-integrated. Note that you must restart the Web Application after making changes using Enabled Products for the changes to take effect.

Top of Document

New Features in Release 11.1.1.3

Financial Reporting

Setting Table of Contents Display Text

In the Book Editor, the table of contents column reflects the text display type selected for each entry; name, or description. In addition, you can now display custom text.

Oracle Hyperion Financial Data Quality Management ERP
Integration Adapter for Oracle Applications (ERP Integrator)

Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERP Integrator) is a module of Financial Data Quality Management (FDM) that enables you to:

·        Integrate metadata and data from an ERP Integrator source system into an Oracle Hyperion EPM target application.

·        Drill through from the Enterprise Performance Management (EPM) application (Financial Management or Planning through Web forms, Smart View or Financial Reporting) and view details in the ERP Integrator source system.

ERP Integrator supports general ledger data for:

·        PeopleSoft 9.0

·        Oracle E-Business Suite 11.5.10 CU2

·        Oracle E-Business Suite 12.0.6

·        Oracle E-Business Suite 12.1.1

Financial Reporting Studio New Grid Property – General Tab

A new Grid property, Drill Through, allows you to show drill through to Financial Data Quality Management (FDM) links in the report viewer as Related Content links. The default is when this setting is not selected.

Date Value Format in Financial Reporting Preferences

There is a new preference for Financial Reporting called "Date Value Format". This option supports Essbase data values that return a date value. Financial Reporting allows the user to specify a format for such a value. A cell within a grid can return a date value (which in Essbase internally is stored as a numeric value). When the cell returns that value, Financial Reporting needs to show in date format (for example, mm/dd/yyyy).  The user can specify the preferred date format.

EPM Workspace

Merging Children Permissions (ACL)

A new radio button group has been added, so a user can choose to overwrite or merge permissions.

·        If the user wants to redefine all permissions for child elements, replacing existing, then “Overwrite permissions” is selected.

·        If the user wants to redefine some permissions and add new permissions to the existing ones, then “Merge permissions” is selected. The changes are applied to folder child elements recursively.

Note: In case of a merge, if a user already exists in an ACL of some object being affected, and this user is granted new permissions, the new permissions overwrite the old ones.

General

The term “Drilldown” has changed to “Drill Through”.

Note: This term may not be reflected throughout all guides for this release.

Top of Document

Supported Paths to this Release

Release 11.1.1.4 is a maintenance release for Release 11.1.1.0, 11.1.1.1, 11.1.1.2, or 11.1.1.3. If you are starting from an earlier release, you must first upgrade to an 11.1.1.x release. This may require upgrading to an interim release first, and then upgrading to 11.1.1.x. Once at 11.1.1.x, in EPM System Installer, select the “Apply Maintenance Release” option.

Release 11.1.1.4 also provides a complete installation if you are not already starting from Release 11.1.1.x.

If you are starting from EPM System Release 9.3.3, your recommended upgrade path is to Release 11.1.2.1+.

Security Synchronization between Essbase and Shared Services was removed in Essbase Release 9.3, starting with release 9.3.1.4.1. Essbase and Shared Services Release 11.1.1.3, however, still synchronize security information. For this reason, if you are using Essbase Release 9.3.1.4.1, 9.3.1.5, 9.3.1.6, or 9.3.1.7, you cannot upgrade to release 11.1.1.3. Instead, your recommended upgrade path is to first upgrade all products to Release 9.3.3, and then upgrade all products to release 11.1.2.1+.

Top of Document

Supported Platforms

Applies to all supported platforms.

Top of Document

Supported Languages

This release supports non-English languages. The list of supported languages for all EPM System products is included in the Oracle Hyperion Enterprise Performance Management System Certification Matrix, posted at http://www.oracle.com/technology/products/bi/hyperion-supported-platforms.html.

Top of Document

Installation Information

See the Oracle® Hyperion Enterprise Performance Management System Installation and Configuration Readme.

Top of Document

Reporting and Analysis Known Issues

The following issues are the noteworthy known issues of this release.

Dashboard Development Services

Dashboard Builder

Report Number

Description

6539731

The Dashboard Studio wizard steps are not Unicode enabled.

Architecture

Report Number

Description

6539730

Evaluation toolbar tooltips in Dashboard Architect do not display due to UniToolbox limitations.

 

EPM Workspace

General

Report Number

Description

12890544

The email link option fails in EPM Workspace, and does not return a message.

12848992

When you expand the dimension hierarchy, if you select a member and then scroll through the member list using the scrollbar, the selected member also moves up or down as you scroll. To resolve this issue, use the up and down arrows instead of the scrollbar.

12715908

The Add Content context menu is not displayed in EPM Workspace page portlets.

12390262

Help is not available for BI+ 10.1.3.4.1 when launched from EPM Workspace, Release 11.1.1.4. To resolve this problem, copy:

<BI_INSTALL_HOME>\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\help\en\htmfiles\B25951_01\

to:

<BI_INSTALL_HOME>\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\help\en\htmfiles\E12602_01\

8713212

EPM Workspace stops responding after 50 copy/paste operations are performed.

8667869

Schedules that use Recurring Time Events continue to run even though their End Date is in the past.

8646204

When launching EPM Workspace with Mozilla Firefox 3 or later, the browser's address bar is displayed. The address bar can be hidden by following the instructions at:

 

http://kb.mozillazine.org/Dom.disable_window_open_feature.location

8574449

Parameters of a scheduled job cannot be changed directly from the Modify Schedule screen.

7552741

In the Korean locale, the document’s modified time is displayed as a.m. or p.m. on the search results page.

7483255

When editing an EPM Workspace page by selecting File, and then Save As, users can save the changes to a new EPM Workspace page. However, selecting this menu item saves changes to the existing EPM Workspace page as well as to the new Workspace Page.

To resolve this issue, open the page and select File, and then Save As, then save the page with a new name before making any changes to the page.

7447398

EPM Workspace pages do not correctly render HPS portlets when the browser is Mozilla Firefox and HPS is installed on certain Web application servers. To resolve this issue, use Microsoft Internet Explorer instead.

7434838

Selecting Administer, then General, and then Enable Users to Use Subscription and Notification, has no effect and will be removed in the next release. To disable users to use Subscription, launch Configuration Management Console, and select Web Application Properties, then Workspace, and then User Interface. If you want to disable any email notifications, launch Configuration Utility and clear Mail Server settings in Hyperion Foundation - Common Settings.

7331209

SimpleSearch expressions and AdvancedSearch interface may not be fully synchronized when using date filters in conjunction with an OR operator. Only the AND operator is fully supported.

For example searching for "sales" AND "last modified date between 25th August 2008 and 20th September +sales +LastModifiedDate:[2008-08-25 TO 2008-09-20]” is fully synchronized between both views. But searching for documents containing the keyword "sales" OR “last modified in this same time period: sales LastModifiedDate:[2008-08-25 TO 2008-09-20]” is not displayed accurately in AdvancedSearch.

7211439

When you open a Smartcut with %xx encoded special symbols, you receive an exception. The browser address prompt displays your Smartcut with special symbols already decoded. To resolve this issue:

1.    In %HYPERION_HOME%/common/httpServers/Apache/2.x.xx/
conf/ httpd.conf
, find string: JkOptions +ForwardKeySize +ForwardURICompat –ForwardDirectories.

2.    Replace with: JkOptions +ForwardKeySize +ForwardURICompat -ForwardDirectories +ForwardURICompatUnparsed.

3.    Restart the Apache HTTP server.

7026804

Help is not available for Oracle Hyperion Performance Scorecard, Fusion Edition pre 11.1.1.00 when launched from anywhere inside EPM Workspace 11.1.1.00. To resolve this issue, copy the Help files from the 9.3.1 installation of Scorecard into the workspace_static/docs folder.

6959959

An extra prompt appears for Credentials Opening Office Document using Internet Explorer with Smartcut or from EPM Workspace.

If a security agent with a cookie-based session management mechanism is used, opening Microsoft Office documents from Internet Explorer may cause another prompt for credentials to appear. This is because Microsoft Office issues a HTTP OPTIONS request when attempting to open documents. This OPTIONS request does not contain the same session-related cookies as requests made from the browser, so the security provider issues the prompt for credentials. Please see http://support.microsoft.com/?scid=kb;en-us;838028 for details about how Office and Internet Explorer open documents.

To resolve this issue, reconfigure the security provider by disabling authentication for OPTIONS requests.

6939710

Interactive Reporting portlet session expires after first logon from WebLogic 10 portal.

If the message, "Current Portlet Session Expired, please log on again or create a new session...", is displayed after selecting an Interactive Reporting report in portlet in WebLogic Portal 10, upgrade WebLogic Portal to version 10.2.

6664797

When working with portlets on Oracle WebCenter pages in Mozilla Firefox, portlet content width cannot be changed on the Edit page. Set portlet width and height explicitly in the adfp:portlet tag on the WebCenter page.

6589361

Microsoft Internet Explorer has a new feature that lets users control whether Web applications can open windows that do not display address or status bars. By default, this feature prohibits Web applications from opening windows without displaying address or status bars, making these parts of the browser always visible.

To hide address and status bars:

1.    Select Tools, and then Internet Options. Click the Security tab, select the Web application's zone, and then select Custom Level.

2.    Under the Miscellaneous heading, find the setting Allow Websites to open windows without address or status bars, and select Enable.

3.    Click OK, confirm with Yes, and then click OK again.

6585295

In certain instances a tree with content wider than the visible area displays scrollbars that have no effect. To resolve this issue, move the vertical splitter to the right, which resizes the visible area, allowing for more content.

6581290

When Mozilla Firefox is used with Linux-based operating systems, clicking the mouse to select an object in Microsoft Internet Explorer can select the wrong object.

To resolve this issue, TrueType fonts should be installed and used. The recommended font package is the liberation-fonts package. This package can be installed using the command:

yum install liberation-fonts

The X Windows server must be restarted for the change to take effect. After restarting, the default fonts can be set in Mozilla Firefox to 16pt Microsoft Sans Serif.

6575507

When using Tomcat, all Smartcuts (Get/Run) fail if file or folder names contain the characters “#” (sharp) or “;” (semicolon). To resolve this issue, update the EPM Workspace application web.xml file and change the value for the parameter rebuildPathInf to True (False is the default). After the application server restarts, Smartcuts should work as expected.

6570170

Hyperion Financial Management and Planning users must have a Reporting and Analysis role in order to launch Financial Management or Planning, Release 9.2.0 applications from within EPM Workspace. If not, they cannot access the EPM Workspace repository and view Favorites (including Favorites that are links to 9.2.0 applications).

Note: If Financial Management and Planning are Release 9.3.0 or later, users do not need to be provisioned with Reporting and Analysis roles.

6566264

In Microsoft Internet Explorer, menus sometimes overlap or have unnecessary scroll bars. Microsoft Internet Explorer allows you to control whether Web applications can open windows of any size. By default, this feature prohibits Web applications from opening windows of any size, causing menus to display incorrectly in some circumstances.

To display menus correctly:

1.    Select Tools, then Internet Options.

2.    On the Security tab, select the Web application's zone, and click Custom Level.

3.    Under Miscellaneous, go to Allow script initiated windows without size or position constraints, and click Enable.

4.    Click OK, then Yes, and then click OK.

6564975

Long file and folder names containing multi-byte characters should not exceed 80 characters.

6562984

In Microsoft Internet Explorer, sometimes you cannot open Microsoft Office files in a new window.

To open Microsoft Office files in a new window in Internet Explorer:

  1. Select Tools, and then Internet Options.
  2. On the Security tab, select the Web application's zone, and then click Custom Level.
  3. Under Downloads, find Automatic prompting for file downloads, and then click Enable.

4.    Click OK, then Yes, and then click OK.

6548868

After documents are imported from Shared Services, they are not displayed in the repository. Select View, and then Refresh for the directory containing the imported documents to display documents.

6540172

Group preferences are applied only to current group members, not to users who are added to the group after the group preferences are set.

6539333

The New Document wizard closes unexpectedly when you do not have permission to access Interactive Reporting documents.

When creating Interactive Reporting documents with the New Document wizard, you can select a file to which you do not have access (such as a file imported by another user). If you select such a file, you get an error message that you do not have permission to access the document, and the New Document wizard closes.

6537899

When using Firefox, documents in common spreadsheets and word processing formats open in a separate window; They are not embedded in the browser as when using Microsoft Internet Explorer.

Services

Report Number

Description

8693216

When using UNIX, the agent.sh file has mistakes in the library path definition. To use external library path variables for OCI connections you must fix the library path definition in:

<HYPERION_HOME>/common/workspacert/9.5.0.0/bin/agent.sh file:

The path definition:

LD_LIBRARY_PATH=${ODBC_LIB_PATH}:${LD_LIBRARY_PATH:=/usr/lib:/lib:.}:...

should be updated to:

LD_LIBRARY_PATH=${ODBC_LIB_PATH}:${LD_LIBRARY_PATH}:...

Note: The same is true for SHLIB_PATH and LIBPATH. Perform this workaround together with the workaround in Bug 8693191: For UNIX systems only: set_common_env.sh should not redefine library variables.

8693191

For UNIX systems, set_common_env.sh should not redefine library variables.

To use external library path variables for OCI connections you have to update in: <HYPERION_HOME>/common/workspacert/9.5.0.0/bin/set_common_env.sh library path definition for usage LD_LINRAY_PATH/LIB_PATH/SHLIB_PATH from user environment as below:

AIX      ) LIBPATH="${SAP_NATIVELIB_PATH}:${LIBPATH}"
             export LIBPATH
…………    ;;
 HP-UX ) SHLIB_PATH="${SAP_NATIVELIB_PATH}:${SHLIB_PATH}"
             export SHLIB_PATH
             ;;
 *   ) LD_LIBRARY_PATH="${SAP_NATIVELIB_PATH}:${LD_LIBRARY_PATH}"
        export LD_LIBRARY_PATH
       ;;

Note: Perform this workaround together with Bug 8693216 (UNIX only: agent.sh has mistakes in the library path definition).

8308510

Workspace hangs periodically and users cannot log on.

According to mod_jk documentation, the socket_keepalive property should be used when there is a firewall between the Web Server and the Tomcat engine, so as not to drop inactive connections.

7579450

If you turn on delegated administration in Shared Services, you can no longer assign the WORLD group permissions.

7022335

The Service Broker uses the IP address to register itself to the Global Service Manager (GSM) by default. In order to force the use of the Hostname instead, set the Java Property DUSEHOSTNAME=true.

7001698

If you change a property in the Configuration and Monitoring Console (CMC), you must restart the services for the change to take affect. Also, for Data Access Service DSNs, you must restart the Data Access Service to pick up any modifications made to the DSNs. If you change log configuration values or add custom log configurations, refresh the log configurations (right-click and select Refresh Log Configurations) to apply the changes to the service. You do not need to restart the service for log configuration changes to take affect.

6953800

In certain circumstances, when the Interactive Reporting Job Services are stopped, a scheduled job may try to run continuously in a loop.

6919606

Fully qualified domain names must be shorter than 64 characters. If the name is longer than 64 characters, EPM Workspace configuration fails due to limitations in the database columns.

Financial Reporting

Report Number

Description

13115060

The ESSLANG value in the fr.env file for Financial Reporting is set to English by default. Therefore, the ESSLANG value must be set manually for non-English languages in the fr.env file, which is located in the <HYPERION_HOME>\products\biplus\lib directory.

12908429

If a Financial Reporting report contains a grid name that includes characters other than ASCII characters, the grid point of view cannot be changed in EPM Workspace.

To resolve this issue, launch Financial Reporting Studio, open the report and rename the grid using only ASCII characters.

12907903

Financial Reporting Studio is unresponsive when selecting Help for the following text functions: Annotation, MemberQualifiedName, VariableValue, XbrlUnit.

To resolve this issue, close Financial Reporting Studio and logon again.

12906223

In Financial Reporting Studio, you cannot use characters other than ASCI characters in function parameters.

12877897

If the Financial Reporting Print Server is installed on a Microsoft Windows 2008 server, Complete Book In PDF does not display external content documents. To resolve this issue, do one of the following:

·        If the Financial Reporting Print Server is installed and configured on a Microsoft Windows 2008 x64 server, create the following directory:

C:\Windows\SysWOW64\config\systemprofile\Desktop

·        If the Financial Reporting Print Server is installed and configured on a Microsoft Windows 2008 x86 server, create the following directory:

C:\Windows\System32\config\systemprofile\Desktop

12877205

Annotations Search returns all annotations if the search parameter criteria are not met, instead of displaying the expected message: “No results found".

12730322

In Financial Reporting, the date format set in EPM Workspace Preferences is replaced by the date format of the server locale.

12729427

In the Japanese locale in Advanced Options, the Suppression Setup dialog option is not displayed correctly.

12714694

When using Mozilla Firefox 5.0, you may be unable to select an annotation in the annotation view pane panel in a Financial Reporting report.

12415006

On Financial Reporting Studio client machines where PassLogix software is installed, the Member List Tab in the left pane of the Member Selection dialog is not displayed.

To resolve this issue, make the following changes to the registry of each Financial Reporting Studio client machine:

1.    Add the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Reports\HReports\JVM

2.    Add an additional string value, JVMOption3, and set its value to:
Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl

3.    Increase the JVMOptionCount value from 2 to 3.

9902818

Related content links in MSAS reports fail when reporting against MSAS 2008.

9722803

A Financial Reporting report containing members with more than 250 User Defined Attributes does not preview correctly.

9439221

The GetCell function only supports the Current keyword when used in a grid cell.

9409222

Performance may be slower the first time that a Financial Reporting report is imported as a FunctionGrid into Smart View, because the report must be executed multiple times. Subsequent refreshes of the report only execute the report once.

9092271

When opening a Financial Reporting exported report in an Office 2007 program (Microsoft Excel, Word or PowerPoint), the following warning is displayed:

“The file you are trying to open, <filename>, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”

This warning notifies users that although the file has an Office extension (".xls", ".doc" or ".ppt"), the content of the file is different from the expected (native) Office format, because Financial Reporting reports are generated in an MHTML format when exporting to Microsoft Office.

This is not a security concern. Microsoft Office is alerting users that the file format is different than expected. Select Yes, and the file opens correctly in Microsoft Office.

9070158

When using the Multidimensional Expressions (MDX) query, the function ancestors(inclusive) does not return the specified member.

8440033

Originally, the EPM Workspace User’s Guide referred to the fr_subvars.properties file, which no longer exists. The properties in this file can be added in fr_configcache.properties file, which was changed in the guide for this release.

However, the guide also references the Financial Reporting Studio User’s guide for more information about substitution variables for related content; this information does not exist.

The missing text should read:

Substitution variables can be used to as replacement variables for server information in related content URLs. This can avoid manually changing URLs in case the Web server location is changed.

These variables can be manually added in the fr_configcache.properties file on the report server machine.

The syntax:

$RC_<VariableName>=protocol://server:port

For example:

$RC_LocalServer=http://system9.domain.com:19000

8308152

When a security agent is used to protect EPM Workspace, you may not be able to add or change related content using Financial Reporting Studio.

8298966

In the Arabic locale, spaces between words are not displayed in Print Preview.

8237117

When Financial Reporting reports are exported to Microsoft Word or Microsoft PowerPoint, image objects in the report are truncated. To correct this, change the Tabbed Browsing Settings using Microsoft Internet Explorer Option settings.

7589194

Essbase text and date measures, as well as non-measures text, do not render correctly in a Financial Reporting report.

7572864

The row height is truncated when exporting a fully-formatted Financial Reporting Report to Microsoft Excel.

7571305

When your language preference is set to a multibyte language in Financial Reporting User Preferences, the annotation details field labels such as Title, Author, Description, Date, and Category display as boxes instead of the appropriate multibyte font when printing to Portable Document Format.

To resolve this issue, create and save a text object to EPM Workspace that includes the footnote function, <<Footnote. Then in the Annotations Print Details user preferences, specify the text object to be used for printing.

7539846

The error message about the Financial Reporting Studio repository is displayed in English instead of the appropriate language.

7486419

When reports contain both Russian and Turkish characters, sometimes the reports do not display correctly in print preview.

7482668

In Financial Reporting Studio, when creating a report with Financial Management as the data source and applying conditional suppression, do not use Invalid as the condition value. The correct condition value to use is No Data.

7443066

When using the Mozilla Firefox browser, Smart View must be installed for the Export to Query Ready feature to work correctly.

7434889

When using row and column templates, inherit formatting can only be applied to one axis; either rows or columns.

7434854

Right sided borders in merged cells are overwritten by the left border setting in PDF (Portable Document Format)/Print Preview. To correct this occurrence, change the borders so that the left border of the cell which is to the right of the merged cells has the correct border, and remove the right border of the cell which is being merged.

7409204

When using the annotations Advanced Search window, the user must resize the window in order to display and click the Search button.

7245721

When selecting multiple objects in the annotations view pane, search fails.

7162881

In Annotation Manager, there are limitations to the annotations search Show Reports option. The following scenarios describe known issues with Show Reports/Documents:

Expansion report: Create a report that includes expansion in a particular dimension (for example, year), then create a data source annotation on this report with context year: Qtr1,Product:100,Market:Market,Scenario:Scenario: Qtr1, Product: 100, Market: Market, Scenario: Scenario. The correct report is not retrieved when performing Show Reports/Documents.

Alias and Snapshot: Create a report that contains aliases for member names (for example, 100(Colas)). Then create a data source annotation on this report with Product: Colas and so on. Next, create a snapshot of this report. When performing Show Reports/Documents on that snapshot annotation, the correct result is not retrieved.

Financial Reporting Documents with similar names in same location: Save a snapshot report and a report in the same folder with one report’s name containing a substring of other report’s name, for example, "All Objects" and "All objects Snapshot." When performing Show Reports/Documents on any object level annotation in the report, both the snapshot and the report are displayed in the result. This is true for any type of Financial Reporting document having similar name strings and residing in the same location.

Descendants function, Range functions and so on: There are a number of functions that can be used while selecting members when creating a grid. Apart from simple member selections and children of function, if the report has any other functions like Range or Descendants the Show Reports/Documents will not retrieve results on the data source annotations.

SAP BW and Financial Management Reports: If you create a data source annotation, the Show Report functionality will not work consistently because the user Point of View (POV) members are not available in the report definition. When creating the data source annotation, if you choose any user POV, even with default value, the search will not find a match. Only the annotations created on the dimension’s members contained in row/column/page of the report will find the reports using Show Reports functionality.

7156418

You cannot run a Hyperion Financial Management report after running an SAP BW report as a different user.

In order to run consecutive reports using different data source credentials for data sources such as Oracle Hyperion Financial Management, Oracle Essbase or SAP BW, you should restart EPM Workspace.

7137213

After upgrading, the search services that were not enabled previously must be enabled.

To enable the search services manually using the EPM Workspace Agent User Interface, perform the following:

1.    Start the EPM Workspace Agent User Interface.

2.    Select Start, then Programs, then Oracle EPM System, then Workspace, then Utilities and Administration, then Start Workspace Agent User Interface (or from a command line at <Hyperion_Home>\common\workspacert\9.5.0.0\bin\startUI.bat).

3.    Log on to EPM Workspace Agent User Interface at:
http://workspace_agent_ui_services_machine:55000/cmc.

4.    In the Current View dropdown, select Service Configuration.

5.    Right-click Workspace Service Type, and then select Properties.

6.    Select the Services tab.

7.    Scroll down to view and enable the three Search services: Search Indexing, Search Keyword Provider, and Search Monitor.

8.    Select OK.

9.     Right-click Workspace Service Type, and then select Restart.

7018859

To ensure that long running reports and books complete without timeout errors, the recommended setting in the httpd.conf Web server configuration file is MaxKeepAliveRequests 0.

7000523

When Hyperion portlets are deployed on WebSphere Portal releases prior to Release 6.1.0.9, the Financial Reporting portlet does not work. To resolve this issue, apply patch PK34915 from the following location:

http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg24016004.

For additional details about the WebSphere portlet container issue see:

http://www-1.ibm.com/support/docview.wss?rs=180&uid=swg1PK34915.

6994960

After exporting Financial Reporting reports to Microsoft PowerPoint, if you resize and save report images, the report images are not viewable the next time the Microsoft PowerPoint slide is opened.

6878360

After replying to an annotation, the reply may not be reflected in the annotation manager view pane until refreshed.

6844783

When performing a Print Preview in Financial Reporting Studio, the Print Preview window is not displayed as the active window. You need to select it from the system tray or press Alt+Tab to display it.

6643938

If your browser is Microsoft Internet Explorer 7, you must enable Automatic prompting for file downloads to download files. Some examples of files that can be downloaded include the Smart View installation program and Microsoft Office files being exported from Financial Reporting. To set this Microsoft Internet Explorer 7 option, select Tools, then Internet Options, then Security, then Custom Level, then Downloads, then Automatic prompting for file downloads, and then Set to Enable.

6625979

Before selecting Refresh All for multiple reports in Microsoft Excel, go to the individual report sheets and activate the connection.

6573795

Chart color choices are limited when designing reports on a workstation with the Microsoft Windows Vista operating system. We recommend that report designers create and design reports using a Windows XP workstation.

6565344

Expansions are supported only on rows for reports accessing a SAP BW data source without Calculated / Restricted keys.

6559132

When using SAP BW as a data source, you must search for members using the member name, not the description. When using the description, the members returned are not correct.

6550742

When performing a Change Data Source operation on a report that contains a linked row and column template, there is no warning message when the report contains a row and column template that is linked to a different data source.

6546997

Batch Bursting is not supported for Financial Reporting using SAP BW as a data source.

6546996

Batch Bursting is not supported for Financial Reporting using Microsoft On Line Analytical Processing as a data source.

6540965

In the Web App Server, some Java server pages fail if the path is more than 256 characters when installing under a non-default directory. To resolve this issue, decrease the path length by moving the directory closer to the root.

6540544

Surrounding quotes in Essbase Substitution Variables (SubVars) are not recognized. If there are SubVars with surrounding quotes that are required for Essbase calc scripts, they should be replicated without quotes for Financial Reporting to see them. SubVars can be more easily maintained with Essbase MaxL scripts.

6537555

When using the native Essbase driver with an Essbase data source, using Advanced Member selection with the NOT operator includes members in the NOT condition. This issue does not occur when using the EDS/APS driver.

 

Installation

Report Number

Description

8719571

After you run EPM System Configurator, you cannot log into Financial Reporting Studio using the administrator username and password. To resolve this issue:

  1. Rerun the EPM configuration tool.
  2. Redeploy the Financial Reporting Web application.
  3. Rerun Financial Reporting, and then select the custom configuration.

Interactive Reporting

General

Report Number

Description

12692048

When using Mozilla Firefox, sometimes the prompt dialog is not displayed when opening .mhtml and .xls files from Job Outputs. To resolve this issue, select Microsoft Excel as the default program in Mozilla Firefox to open Microsoft Excel documents. To set this option, in Mozilla Firefox, select Tools, then Options, and then Application.

8509815

The IncludeHeaders parameter is ignored in the Export() and ExportToStream() methods.

8441665

To perform Export on configuration with SiteMinder by selecting File, then Export and then Excel (*.mhtml or *.xls), you must change the security settings for the browser by selecting Downloads, and then enable Automatic prompting for file downloads = enabled.

8439336

Multiple logon dialogs are displayed in export section from EPM Workspace to Microsoft Excel if authentication through SiteMinder is installed.

7479134

Users cannot open an Interactive Reporting document (BQY) in EPM Workspace that contains only a data model section.

7475320

Interactive Reporting Widgets: EPM Workspace error, UNIX Interactive Reporting Service becomes unresponsive after results delete/restore.

Workaround: Do not delete all the columns in the Results section.

7452671

Slider does not draw widgets in certain cases.

When using the Mozilla FireFox2 browser with EPM Workspace, in the following cases, the widgets are temporarily non-responsive to slider input:

·      The first time viewing the widgets when the document is opened.

·      After viewing LiveCharts which are positioned outside a certain footprint.

Workaround: Navigate to another section of the document and return. Widgets should now be responsive to slider input.

7428177

The Section property Last Printed option does not return the last printed time stamp.

If a section was printed from EPM Workspace, the property LastPrinted does not return the proper time stamp.

7139389

Items in the Query Operator dropdown are disabled if an appended query is renamed. To resolve this problem, select another query section or another section, and then return to the problem query section.

7026453

You cannot save an Interactive Reporting BQY document using Save to Repository As if you want to save the Interactive Reporting document with the same name as the open document. If you specify the same name instead of a different name, the following message is displayed:

“Failed to save the BQY document. Check the file name and permission. Also check the user has CONTENT PUBLISHED role. For Interactive Reporting Document Job output only the Save As option is allowed.”

To resolve this problem, use Save instead of Save to Repository As if you want to use the same file name.

6898879

The Launch Out function in the Interactive Reporting portlet opens EPM Workspace in the same browser window when the portlet is configured with Oracle WebCenter 10.1.3.3.

6643904

In EPM Workspace, an Interactive Reporting document (BQY) file job output does not appear through withnav_run+bqtype=ihtml smartcut.

An EPM Workspace Interactive Reporting document (BQY) job output is not displayed if bqtype=iHTML tag is specified in the Smartcut.

Note: This is true only for Firefox 2003 (not Microsoft Internet Explorer 6 or Microsoft Internet Explorer 7) and only for withnav_run (run works correctly).

6614851

Interactive Reporting Service will not start on systems using 64 bit kernel mode on AIX 5.3 ml6.

The issue with AIX 5.3 ML6 affects all current and previously released versions of System 9 (through 9.3.1) and all versions of Hyperion Performance Suite 8. There is an IBM compatibility issue with ML6 in 64-bit kernel mode. IBM may also refer to 5.3 ML6 as 5300-06.

Because versions 8.5 and System 9 supports AIX 5.3, customers could assume that this includes all Technology Level (TL) and Maintenance Level (ML) levels. This notice informs you that 5.3 ML6 is not supported in versions 8.5 and System 9.

Action Required:
If you have already installed AIX 5.3 ML6 you will need to upgrade to AIX 5.3 ML7. IBM may also refer to 5.3 ML7 as 5300-07. Alternatively, you may change the kernel mode to 32-bit if using 5.3 ML6. However, Oracle recommends upgrading to AIX 5.3 ML7.

6588245

When you set a Pivot Cume data function of Function of Percent of Row, the percentage of the grand total is returned.

6583475

An unknown error is displayed when an individual member value is dragged into the data layout from an SAP BW alternate hierarchy. This issue is specific to the OLAP Query section in an SAP BW data source and occurs only with an SAP BW GUI 6.4 OLE DB for OLAP (ODBO) driver.

6540929

Microsoft Excel Export does not check whether the destination file is locked, causing the export to fail.

The Report section Excel (XLS) export to an existing file does not check whether the destination file (which should be overwritten) is locked.  Excel (XLS) export does not occur in this case although the user is asked about the file replacement. This is not an issue for Results or Table sections.

6540605

You are unable to add computed items through a shortcut menu in EPM Workspace.

At least one Results or Table column must be present to enable the right-click (shortcut) menu which contains the option to add or modify a computed item. When no columns are present, select the menu option Actions, and then Add Computed Item... to create a computed item.

6533806

Special characters that are not allowed in naming JavaScript's identifier or functions must not be used in column names and control names. For example, white spaces, ''|'', ''$'', € (euro), or “\” (backslashes) (same as half-width Yen and half-width Won). Using such characters in control names is not supported and can cause document rendering useless in EPM Workspace.

 

Connectivity

Report Number

Description

7042510

Processing INTERVAL data type causes date format error for Teradata 4.0 ODBC driver. To resolve this issue, do one of the following:

·        Set the column’s data type to String in the Item Properties dialog.

·       Use Teradata 3.5 or 12.0 ODBC drivers instead.

7036539

For an ODBC/ODBC MERANT Oracle Wire Protocol driver connection, the timestamp WITH TIME ZONE data type is recognized as a string. To resolve this issue, manually set the data type.

CubeQuery

Report Number

Description

12380390

The context menu is not refreshed correctly when using Microsoft Internet Explorer 9.

12355524

When using Microsoft Internet Explorer 9, sometimes the member list does not display correctly until you move the pointer device.

825453

Case-sensitive members are displayed incorrectly after searching for case-sensitive members using the Both option.

8201413

Download To Results does not behave as expected with case-sensitive outlines.

7376089

The CubeQuery catalog search and Find() method return the stored member instead of the corresponding shared member in the data source with allowed duplicate names.

7335773

Searching a dimension using a pipe ("|") character in the name returns an Invalid argument error if the Catalog Dimensions are displayed in Single dimension mode.

7316302

Sorting in the Results section may be incorrect when CubeQuery contains duplicate names or when aliases are enabled.

7304600

Shared members are included in grand totals in a Pivot section if their parent member was renamed.

6895722

In EPM Workspace, if you select Actions, and then the Drill Through option, the Drill Through menu item is disabled for mapped dimensions. This occurs when there are no mapped dimensions on the other axis. It is enabled for unmapped/disabled dimensions if there are mapped dimensions in both items. To resolve this issue, apply Drill Through using the shortcut menu.

 

Widgets

Report Number

Description

12669135

The Euro character (€) is not displayed for Bullet and Thermometer scales.

12651239

Interactive Reporting Studio stops responding when widgets contain null data.

7317044

Widget transparency is not supported in export output. The widget footprint appears as white regardless of the background color of the dashboard.

7196974

Various widgets may not draw when opening a document for the first time. To resolve this issue, close and reopen the document.

7182583

Some widget-specific Script Editor dynamic help file links are not enabled. Attempting to open them generates a "file not found" alert. To reach these Help topics, open the Help file using another technique, and then search by name.

7160883

The colors in the Live Line Chart ranges may appear lighter than those selected in the color palette.

7148988

A JVM error occurs when opening Interactive Reporting with Dashboard.

The invocation.xml configuration for JVM contains the following setting: <option>-Xmx64m</option>. This Xmx setting may be modified, based on individual system capacity, for performance reasons.

7122540

A slider can be associated with one or multiple gauges or Live Charts. However, only one slider per gauge or Live Chart is supported.

7117551

There is no Object Model functionality for the EventScript on the Slider Widget. You cannot use dynamic creation, reading or writing for this script event.

7117407

Designers should avoid setting Gauge and Widget major and minor tickmark intervals to small values relative to the minimum and maximum scale. The time required to render the tickmarks may be excessive for some users.

7116714

The slider must contain data for a valid association with a gauge or Live Chart.

7116439

For a predefined number format, if the number format is "+#,##0" or "+#,##0%", the negative number is shown as "-+#,##0" or "-+#,##0%" instead of "-#,##0" or "-#,##0%." For a custom number format, the negative format cannot be guaranteed to be correct in this release.

7114220

The Widget Gauge Fact and Target Fact Data function properties must be set through the user interface. You cannot set them using the Object Model.

7111535

The Gradient-Horz (horizontal) and Gradient-Vert (vertical) properties are not applicable for Live Line Charts, even though they are displayed in the Properties dialog.

7039581

A single traffic light gauge is restricted to three color ranges.

7030044

The slider does not appear greyed out when it is disabled.

Interactive Reporting Web Client

Report Number

Description

7452638

In the Mozilla Firefox browser, Live Charts outside a footprint of approximately 8 1/2 inches width or 3 1/2 inches height in the Dashboard workspace are not drawn correctly. If you intend to deploy the dashboard on Mozilla Firefox, design the dashboard within this footprint constraint.

7342404

On Linux/UNIX platforms, sometimes loading ODBC driver for Oracle BI fails, causing query processing to fail. To resolve this issue, run Data Access Service on a Microsoft Windows platform.

7134007

After cancelling the installation of the Web Client, an attempt to open the Web Client shows an unrecognized file type. To correct this, the user must delete the cookie for the EPM Workspace server and complete the Web Client installation.

6982405

Interactive Reporting Web Client retrieves the user name from the Object Model when the:

·        User name is specified by way of the Object Model, or,

·        OCE/Query section setting prompts for the user name

In all other scenarios, the user name/password is read by the server and sent to the database. For security reasons, the user name is never sent to the client.

6534426

You cannot control the Layer or Layering function when one object is an embedded browser.

This is a limitation of Windowed controls and non-Windowed controls where Windowed controls, like an embedded browser, cannot go behind non-Windowed controls like shapes/graphics.

 

Migration

Report Number

Description

12709869

Help for Reporting and Analysis Migration Utility cannot be opened. Use online help instead.

8518387

For DB2-based Hyperion Analyzer 7.0.x migration, desktop Shortcuts are not automatically created for migrated users. Users should manually create shortcuts to the desired presentations on their desktops.

7603465

With Web Analysis 7.0 migration, the data base preference/alias table does not migrate correctly.

In Hyperion Analyzer 7.0.x migration, the Alias Table for data sources is set to Default for migrated users. To resolve this issue, manually update preferences to set desired Alias Table after migration.

7603185

With web Analysis 7.0 migration, some special characters in dimnames and dimaliases do not migrate successfully.

In Hyperion Analyzer 7.0.x migration, the message “Member Not Found” may be displayed when opening some Reports if the corresponding Essbase data source contains certain special European locale characters in Dimension names or Member names. To resolve this issue, rebuild the problem reports.

Services

Report Number

Description

12830681

When using Reporting and Analysis Framework in an NAT or IPv6 environment, you must set a Java property -DuseHostname=true for Reporting and Analysis Framework Services. You must also update all instances of default-domain.cfg by appending the following line to each instance:

policies:iiop:server_address_mode_policy:publish_hostname="true";

See “Administration Tasks” in Hyperion Reporting and Analysis Framework Administration Guide for information about making these changes.

12768902

Sorting does not work in permissions dialogs.

12661269

The Advanced Search feature “Written In (language)” is not active because it is not possible to detect the language used from the metadata of most document types.

Smart View

Report Number

Description

7173634

Microsoft Excel workbooks open in corrupted format when Microsoft Excel is installed.

In the Smart View 11.1.1.1.0 releases, the Simulation and Forecasting workbooks uploaded to the EPM Workspace repository are encoded and can be used only by Smart View.

7145648

Alias Member names appear only in Web/Portable Document Format view. However, when exporting the grid to Microsoft Excel as query ready, it takes the original value from the data base instead of the alias name.

7017277

If Preview contains any controls, the tab focuses on it.

When importing a job which generates output with links and using the Tab key to navigate through Preview page, then those links are selected. Press Enter to follow the link. When this happens, after selecting Finish to import the page, the imported page is different than the page last displayed in the Preview pane.

6940642

Client filters are not updated in the POV toolbar after changing them through BI edit.

If one filter was changed to another one after importing a CubeQuery section through BI Edit, the POV toolbar is not updated with the newly applied filter. Data is changed successfully.

6908330

Reporting and Analysis documents do not display if EPM Workspace is under WebSEAL.

Reporting and Analysis documents are not displayed in the folder tree while importing if EPM Workspace is under WebSeal with the additional context path configured to: http://<server>:<port>/<context path>/workspace.

6871481

If an Interactive Reporting document contains non unique Essbase members in a CubeQuery section, then it cannot be exported to Smart View client using Query Ready data export option or using the Launch Smart View menu command.

6575786

Refresh and Refresh All do not work if two pages of a Web Analysis report are imported sequentially. To resolve this issue, use the All Pages option to import multiple pages of a report.

SQR Production Reporting

Report Number

Description

12790628

Production Reporting job output (.doc, .xls, .ppt) cannot be opened in Mozilla Firefox. To resolve this issue, in Firefox options, select Applications, and then change Action from "Always ask" to "Use Microsoft <product name>" for Microsoft Excel, Microsoft Word, and Microsoft PowerPoint content types.

10270417

".doc" outputs generated by Production Reporting (SQR) cannot be opened in Microsoft Word 2010.

9975710

When running SQR jobs in an AIX environment, you must update the sqr.ini file, adding SQR_USEJVM=FALSE to the [Environment:Common] section:

[Environment:Common] SQR_USEJVM=FALSE

sqr.ini can be found in:
EPM_ORACLE_HOME/products/biplus/bin/SQR/Server/<SQR_TYPE>/bin
folder.

8882198

Production Reporting ODBC does not dependably display Unicode characters from IBM DB2 8.2.

6940273

In a report that includes two master queries from two different DDO data sources, Production Reporting Studio results in an unanticipated application error when attempting to edit the second master query.

6888134

When users edit reports to add a second query from a different data source, based on the first connection that they select, Query Builder displays a warning if the second connection is not of the same type as the first. After this warning is displayed, and the user removes the incompatible data connection, in some cases, this causes the Studio to become unresponsive.

If users get a warning message, they should close the Query Builder dialog and try again.

6565427

Charts are not displayed in a report if placed in a Production Reporting Studio group summary section.

To resolve this issue:

1.    Place the chart in the Query Summary section and process the report.

2.    In the report layout, move the chart from the Query Summary to the Group Summary.

3.    Process the report again.

Now the chart appears correctly for each group break.

6564579

When using Smartcuts to navigate Production Reporting reports, the navigation bar and table of contents become embedded deeper with each report jump. To resolve this issue, when using Smartcuts for Report Surfing, have the target href link point to "_top" so that EPM Workspace Explorer does not keep embedding the link inside itself.

 

Web Analysis

Report Number

Description

13034124

After upgrading from Web Analysis Release 11.1.1.3 to Web Analysis Release 11.1.1.4, opening Web Analysis reports containing a Relational OLAP data source can display the message “Relational Query will exceed the maximum row/column size.” To resolve this issue, you must manually increase the value of the application property MaxJdbcCellCount:

 

1.      Start the Configuration Management Console on the server running Workspace Agent service, using this command:

<HYPERION_HOME>/common/workspacert/9.5.0.0/bin/startUI.bat(sh)

2.      Log in as the admin user to the server where Reporting and Analysis is installed.

3.      Right-click the Web Analysis Web application and then select Properties.

4.      Browse to The Result Set Configuration, then set MaxJdbcCellCount to 100000 or more, and then click OK.

5.    Restart the Web Analysis server.

10269549

Microsoft Windows7 with Microsoft Internet Explorer 8: Web Analysis Studio does not load with default Java 1.5.0_17.

9743859

To open Web Analysis reports exported from Web Analysis Studio to Microsoft PowerPoint 2010, save the file as an HTML file (.html). It is not possible, however to export Web Analysis reports to PowerPoint 2010 from EPM Workspace (Microsoft PowerPoint 2003 and 2007 do not have this problem).

9089964

To correct rounding errors that occur in certain circumstances, the property RoundHalfEven was added to Web Analysis. To enable this property:

1.    Stop the EPM System Configurator application.

2.    Navigate to <HYPERION_HOME>/common/config/9.5.0.0.

3.    Run the following command:

Windows: epmsys_registry.bat addproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@RoundHalfEven true

UNIX: epmsys_registry.sh addproperty SYSTEM9/WEBANALYSIS_PRODUCT/LOGICAL_WEB_APP/@RoundHalfEven true

Start the EPM System Configurator application.

8725988

Web Analysis Secure Socket Layer (SSL) does not work consistently.

8616863

When running Web Analysis on Windows systems with WebLogic and the JRockit JVM, administrators may notice signs of a memory leak. If this becomes an issue, switch to a newer version of JRockit. BEA JRockit R27.6.3-40_o-112056-1.5.0_17-20090318-2104-windows-ia32 fixed apparent memory leaks initially observed during internal testing.

8552664

Internet Explorer process stops responding when closing Web Analysis Studio using the Close(X) or Exit button if the applet was launched using JRE 1.5. To resolve this issue, close the Web Analysis launch page first.

Note: JRE 1.6 is not affected by this issue.

8527806

The Alias Controller, combo box and Dimension Browser button do not work in EPM Workspace. To resolve this issue, make sure to add the last data source that has an alias controller table attached as the one you would like displayed in the combo box.

8527669

ARUutil will not create user preferences when regional settings are Turkish.

8446612

Export of Web Analysis reports to Microsoft Office from EPM Workspace may fail for configurations protected by SiteMinder.

To resolve this issue, in the Internet Explorer browser:

1. Click Tools, and then Internet Options.

2. Select Security tab.

3. Click the Custom Level... button.

4. Scroll to the Downloads section.

5. Enable Automatic prompting for file downloads section.

6. Apply changes and restart the Internet Explorer browser.  

8221086

In Internet Explorer 7, the initial session page receives focus after some dialogs in Web Analysis Studio are accepted. To resolve this issue, keep the browser window minimized.

7716592

Using Microsoft Internet Explorer, the Print via PDF option does not work in EPM Workspace running under Secure Sockets Layer (SSL).

7416537

Drill Down on the Personal variable with member from dimension bottom deletes the dimension selection.

7365176

All ancestors are exported if the XLSeparatecolumns value is set.

Setting the XLSeparateColumns parameter to true state causes dimension member in rows to be exported to Excel together with its ancestors.

7351923

The alias controller applies changes only after Save/Reload.

Changing the label mode with alias controller does not affect subscription controls at once; only after save/reload changes are applied.

7308221

Web Analysis fails to connect to Hyperion Shared Services (HSS) running under Secure Sockets Layer (SSL).

Web Analysis cannot access related content if HSS is running in SSL mode.

Workaround: Specify the particular related content server on Related Content Configuration tab of Web Analysis Web-Application Properties Dialog in Oracle Hyperion Configuration and Monitoring Console.

7225260

If Show LRO Indicators is enabled when working with a cube created through Essbase Studio Server, LRO Indicators will be displayed on all cells.

7146096

Header Descending and Header Generation sorting works incorrectly if the advanced member selection contains a root dimension member.

6915770

The data layout does not work correctly when selecting IDs in the dimension labels.

6784386

You cannot Drill Up on Substitution Variable and member to which Also Select Ancestors, Also Select Siblings, or Also Select Previous Advanced Selection was applied.

6781175

The Subscription control with a personal variable in the selection created for dimension with different descriptions from IDs becomes blank after the label mode is changed for the data source.

 

Top of Document

Defects Fixed in this Release

If you are coming from Release 11.1.1.0, 11.1.1.1, or 11.1.1.2, use the Defects Fixed Finder tool to review the list of defects fixed bbetween those releases and Release 11.1.1.3. This tool is available here:

https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1292603.1

EPM Workspace

Report Number

Description

• 12388264

If you logon using transparent logon, logging out may fail.

11069078

When using Microsoft Windows 77, Microsoft Internet Explorer 8, or Microsoft Office 10, credentials are requested when opening Microsoft Office documents (.doc, .ppt, or .xls). Click Cancel to ignore the request.

Financial Reporting

Report Number

Description

12767763

Unable to select substitution variable for a Planning report in either Financial Reporting Studio or EPM Workspace.

12707666

In a Financial Reporting report the report grid is not displayed, when you click the expansion arrow for a member.

In a Financial Reporting report, when you click on the expansion arrow on a member, the grid disappears from the report.

12640747

Web Preview from Financial Reporting Studio for a new report with a new database connection fails and an error message is displayed.

12404364

A user provisioned with Read Only access for Essbase has insufficient privileges to run a Financial Reporting report that contains a Respond to Prompt function.

12402787

The batch bursting option fails if member names include an ampersand (&).

11930895

The annotation icon is not always displayed at the parent level when an annotation is attached to one of the child or descendant members.

11930848

When a Financial Reporting report or book contains a space in the report or book name is included in a batch, the PDF name that is included in the email replaces the space with a plus sign (+).

11927676

The command line ScheduleBatch.xml file does not work with AIX (Advanced Interactive eXecutive) in Financial Reporting, Release 11.1.1.3.

11927674

MDX format does not render text as expected in a Financial Reporting report.

• 11927669

When running a Financial Reporting report, if a conditional format is applied to merged cells and the condition is true, the merge is reversed, and the cells are displayed as separate values.

• 11927664

In Financial Reporting, the User Point of View does not recognize member names that are enclosed between brackets, <Member Name>, when the member name is manually typed for a dimension.

• 11927661

The User POV members in the source report are passed using related content links to a destination report, and changes the Grid POV fixed dimension members.

• 11927639

When a Line type chart encompasses a data range with #Missing elements, the chart line drops to zero between valid data points instead of displaying a gap in the line where no data exists.

• 11927477

After exporting a Financial Reporting report to Microsoft PowerPoint or Microsoft Excel, you cannot change the member in the page dimension of a Financial Reporting report in EPM Workspace.

• 11927474

A Financial Reporting report using an Essbase datasource that contains a dynamic time series member and a prompt member in one column and a “Same As” member referring to the prompt member in another column may fail to complete.

• 11927472

In a Complete Book In PDF, the Chinese characters are not displayed correctly for the report title in the table of contents.

• 11927469

The EPM Workspace session is unresponsive the first time a user launches a report.

• 11926673

The following batch-scheduling enhancements were made to email functionality:

·        Ability to send email notification without PDF reports attached upon batch completion.

·        Ability to send email notification for both successful and failed batch processes.

·        Ability to add hyperlink to reports in EPM Workspace in the message body of e-mail notification.

• 11926668

Use the new property AnnotationServerPort to change dynamically assigned ports to static ports for annotations service. To change dynamically assigned ports to static ports, add this property to the file:

<HYPERION_HOME>\products\Foundations\workspace\lib\annotation.properties

Setting the value for AnnotationServerPort assigns a static port for the annotation server. An example of the section in the annotation.properties file is displayed below:

# Specify the TCP Ports on which the Annotation Server should run.
# To force the Annotation Server to bind to a specific port, assign value,
# typically between 1024 and 32767, to this parameter.
# The default is to assign no value which will cause the Annotation Server
# to bind to a dynamically assigned port.
#
# Note: The primary RMI port is defined via the Agent Configuration utility

AnnotationSvrPort=
RMIPort=8199
AnnotationServerPort=8555

11926665

In Financial Reporting, a text cell that contains an <<Annotation()>> function and is merged with another cell does not display the annotation text correctly.

11926661

Printing large Financial Reporting reports to PDF files fails, and Financial Reporting sometimes stops responding.

11926660

Data values that contain five zeros after the decimal point are suppressed in a Financial Reporting report with basic or conditional suppression applied.

To resolve this issue, a new property, NumDecimalPlacesForZeroInSuppression, has been added. The property is used to round data values to zero when considering suppression, both basic suppression and conditional suppression, and in conditional formatting based on value “equal to zero.” It also determines when a value is zero and the #ZERO value is displayed.

To use this property, add the NumDecimalPlacesForZeroInSuppression property to the fr_global.properties file. Set the value of this property to a value greater than five (for example, NumDecimalPlacesForZeroInSuppression=7) to allow values with more than five zeroes after the decimal point.

11926658

Custom text colors should be available in addition to the twelve standard colors for grid and chart formatting.

11926655

A Snapshot book fails when run using Complete Book In PDF.

11906104

Surrounding quotes in Essbase Substitution Variables (SubVars) are not recognized. If there are SubVars with surrounding quotes that are required for Essbase calc scripts, they should be replicated without quotes for Financial Reporting to see them. SubVars can be more easily maintained with Essbase MaxL scripts.

11905718

When retrieving members, the number of substitution variables defined for all applications and data sources can affect performance.

11905624, 11905595

If Financial Reporting reports exported to Microsoft Excel include prompts for column dimensions, the column dimension values entered in response to the prompts sometimes revert to the default value.

11903426

Unable to start annotations server when using Oracle 11g R2 database due to change in the file hyjdbc.jar.

11903421

Financial Reporting folders exported from EPM Workspace contain blank files when using the built-in Microsoft Windows XP compression utility.

11903418

If no access filters are enabled in Essbase, when selecting a member to which the user has no access, a long series of numbers will display instead of #MISSING in the data cells of the Financial Reporting report in HTML and PDF preview in Workspace.

11903411

POV dimensions in the Book POV prompts are not displayed for a book imported into Financial Reporting, Release 11.1.1.3 from an earlier version of Financial Reporting.

11903406

User POV members are not passed correctly when a related content link is linked to a folder.

11903397

For some books, viewing those books using Complete Book In PDF does not work when using annotations.

11902096

The following message is displayed when Financial Reporting reports that report against an Essbase datasource contain duplicate, non-unique member names:

“Cannot uniquely identify a member, the <Member Name> is duplicated.”

11901659

In a Financial Reporting report, the GetCell text function retrieves incorrect values when the "Row headings before" property is not set to column A.

11901604

When exporting a Financial Reporting report to Microsoft Excel, sometimes a dash (-) in the report is replaced with zero.

11901547

The Complete Book In PDF option does not complete successfully after upgrading Financial Reporting from a release earlier than 11.1.1.3.

11845866

Printing PDF files of 200 or more pages fails when the printing operation is run as a batch file.

11829540

Small numbers such as 0.000001599 are sometimes treated as zero. Use the property NumDecimalPlacesForZero to control the number of zeros to consider before treating a number as zero. Set this property in the fr_global.properties file.

Note: When considering whether a data value is zero, the value of NumDecimalPlacesForZero is added to the decimal places included in the formatting of the number. For example, if the cell formatting specified two decimal places and NumDecimalPlacesForZero is set to two, then four decimal places of precision are used when checking for zero. In this case, .0001 would not be zero, but .00001 would be zero. If the cell formatting specified zero decimal places, and NumDecimalPlacesForZero is 3, then .001 would not be zero, but .0001 would be zero

• 10415717

The table of contents links in Financial Reporting books sometimes displayed the wrong report.

• 10410838

A Financial Reporting report with auto calculations set up for three or more dimensions fails to complete successfully.

• 10398246

In Financial Reporting reports some functions do not evaluate suppressed missing values as zero when reporting against a Hyperion Financial Management datasource.

• 10394595, 9038160

The annotation view pane buttons are not displayed the first time a report is run.

• 10382320

In Financial Reporting reports, some functions do not evaluate suppressed missing values as zero when reporting against a Hyperion Financial Management datasource.

• 10239833

Text objects containing annotations functions are not updated when adding an annotation to a Financial Reporting report.

• 10177437

When opening a Financial Reporting report in a Microsoft Internet Explorer window that is not maximized, it is not possible to scroll through the window.

• 10177376

Date values in Financial Reporting reports are sometimes incorrect.

• 10173113

It is no longer necessary to rerun a Financial Reporting report to view annotation changes or additions.

• 10166443

Page numbers in Financial Reporting Books sometimes are displayed incorrectly in PDF preview mode.

• 10166043

When the conditional formatting option Replace Format Function is used, charts are not displayed correctly in reports.

• 10157838

After expanding a member in a Financial Reporting report, the annotations are not displayed.

• 10157823

In certain circumstances, annotations text is displayed incorrectly when previewing a Financial Reporting report as a PDF file.

• 10157767

When a Financial Reporting Book is run as a Complete Book In PDF, the annotations text in the reports is truncated.

• 10157756

PDF-formatted rows now expand to accommodate all text for CellText functions or other descriptions.

• 10137774

When using the Respond to Prompts option with Microsoft Internet Explorer 6, you can edit batch options only once without disconnecting and then reconnecting applications.

• 10137757

When a Book is executed from the batch scheduler, annotations are not displayed in the report output.

• 9980689

After exporting a Financial Reporting report to Microsoft Office, if the exported report contains one or more prompts and the default prompt is left blank, you cannot refresh the report in EPM Workspace.

• 9915412

Financial Reporting opens additional random ports instead of using the static ports that are configured in the fr_repserver.properties files.

• 9908293

When Financial Reporting reports are migrated, the database connections for those reports are not updated correctly.

• 9905609

When the Financial Reporting Schedule Server service is restarted, the scheduled report batches are not displayed in the batch schedule list.

• 9852483

If the Not parameter is used as part of the condition when applying conditional suppression for accounts containing a Description, then the entire report is suppressed.

• 9690746

In a report containing a suppressed column followed by a formula column, the value evaluated in the formula column includes the data from the suppressed column.

• 9592301

When using the Hyperion Planning Details driver in Financial Reporting Studio, the drill through check box on the report’s grid property sheet is not displayed after navigating to other areas of the report and then returning to the grid property sheet.

• 9570743

In Batch Scheduler, using the DataSrcName function in the object label under the bursted output label causes the batch to fail.

• 9537245

You cannot view a Financial Reporting Snapshot Book that has been generated from a scheduled batch.

• 9537190

The Freeze Grid Headers option fails to lock column headers when scrolling through a report.

• 9537151

Running a report fails with the error "Database does not exist" when the database connection name contains an ampersand (&).

• 9537140

After exporting a Financial Reporting report to Microsoft Excel, Japanese currency data sometimes is not displayed correctly.

• 9537126

When exporting Financial Reporting reports to Microsoft Excel, a conditionally-formatted 100% is displayed as 100 \%.

• 9537112

In a Financial Reporting report when all data columns are hidden, the text columns are suppressed.

• 9497835

An error occurs when trying to change Point of View for a report displayed in the EPM Workspace report viewer after changing the location of Point of View from In View Pane to Above Report/Book using Financial Reporting Preferences.

• 9488273

Financial Reporting reports containing an invalid Hyperion Financial Management currency function in the report design cause the Financial Reporting Web Application to become unresponsive.

• 9452546

In certain circumstances, member levels are not displayed with the correct indentation in Financial Reporting reports.

• 9438159

If a Financial Reporting report is specified in the General Preferences option Default Startup, the Financial Reporting report does not launch when a user logs into EPM Workspace.

• 9355496

When running a Financial Reporting book using Complete Book In PDF, the table of contents is not generated and included in the book.

• 9105276

Viewing a Complete Book In PDF fails when the book contains Financial Reporting reports or snapshot reports with annotations.

• 9073549

In Financial Reporting reports exported to Microsoft Excel, custom column headings are not displayed correctly.

• 9062306

Report headers sometimes are displayed incorrectly for reports created in Financial Reporting, Release 9.2.0 when they are opened in Financial Reporting, Release 11.1.1.3.

• 9046839

After upgrading to Financial Reporting 11.1.1.3, some complete books do not open as PDF files.

• 9042828

The presence or absence of an asterisk (*) in the search string can affect results when searching for level 1 members.

• 9037910

Member names that include an ampersand (&) are not recognized in POV.

• 9037560

Number formatting rounds values differently in Financial Reporting, Release 11.1.1.3.

• 8985425

For books that contain five or more reports, out of memory errors can occur.

• 8973237

Implemented support for Current Point Of View in member selection for dimensions in a row and column template.

• 8787993

When reports are refreshing using Smart View the tabs are no longer displayed.

• 8787044

When wildcard searches are used with prompts, sometimes Financial Reporting Studio returns incomplete search results.

• 8741914

In a Financial Reporting report that contains both drill through links and expansions, the data in the cells that contain drill through links may not be displayed after expanding a member. If you refresh the report, the cell data is displayed.

• 8464555

Financial Reporting reports that contain formulas that evaluate cells containing #ERROR produce inconsistent results.

• 6587686

Sometimes books are displayed in reports in a different order than specified.

 

Interactive Reporting

Report Number

Description

• 12654797

Column order is incorrect when duplicating a pivot section.

• 12591604

When both Text Wrap and Suppress Duplicates are applied to a table embedded in a report, foreign characters are displayed in cells that should be empty.

• 12557473

You cannot use shell.application methods via jooleobject object instantiation.

• 12417454

Installing the Interactive Reporting Web Client sometimes fails when using Microsoft Internet Explorer.

• 12325499

In a clustered environment, if you export an Interactive Reporting section to Microsoft Excel using the dashboard ExportToStream method, the export fails

• 11938380

For certain data sources, SQL errors occur when running BQY files migrated from EPM System 9 to EPM System 11.1.1.3.

• 11894799

Toolbar is missing Export to Microsoft Excel icon when a BQY file is opened in Smartcut.

• 11877377

When users open BQY jobs in Interactive Reporting, Release 11.1.1.3 that were created in Interactive Reporting, Release 8.3.2, data is not displayed in one or more columns sometimes.

• 11813377

When a column is added more than once as a sort field, the following message is displayed, and the sort fails:

An unknown error has occurred. Please save your document and restart your application.”

• 11807821

When users open Interactive Reporting reports in Interactive Reporting, Release 11.1.1.3 that were created in Interactive Reporting, Release 8.3.2, sometimes footers are not displayed correctly.

• 11794905

When opening a document, the Interactive Reporting Web Client sometimes stops responding after an alert message is displayed.

• 11691263

Bigint values sometimes do not import correctly from the database to text BQY files.

• 10638327

In certain circumstances, values in .csv files are not displayed correctly in Interactive Reporting.

• 10398489

Sometimes if you change between dashboards multiple times, the following message is displayed:

“Error in executing BI_Callback request; Failure: m_messageBundle is undefined.”

• 10350850

Sometimes you cannot export BQY files that contain images (for example logos) from EPM System 9 to EPM System 11.1.2.0.

• 10319964

Delimiters between cells are displayed by default in dashboard pivots.

• 10251038

By default, CSS messages are disabled and a generic message is displayed instead. To enable CSS messages, set the application server java system property ShowGenericAuthenticationFailureMsg to false (-DShowGenericAuthenticationFailureMsg=false).

• 10200987

Sometimes after upgrading BQY files from Interactive Reporting, Release 9.2.1.00 to Release 11.1.1.3.00, pivot table scroll bars are not displayed when Scrollbars Always Shown is selected.

• 10157649

In certain circumstances, the message “Web Client Object Expected” is displayed when opening a BQY file with the Web Client.

• 9902966

Sometimes group values are not displayed correctly in charts embedded in Interactive Reporting.

• 9788321

Users who are not assigned the global administrator role cannot open a BQY job from Interactive Reporting Web Client.

• 9655900

Sometimes the Session.Active property returns True when BQY file connections fail.

• 9611061

If you include the character “<” in a labeled text column of a chart, table columns may not be displayed correctly if that column is dragged to another position in the chart.

• 9437325

When navigating through a BQY file, sometimes Microsoft Internet Explorer exits when the navigation toolbar Back button is used.

• 9374078

Dashboard date-related menu items cannot be displayed in the Japanese locale.

• 9339026

Hyperlinks do not open in a new window.

• 9269473

The Export to Microsoft Excel icon is not displayed on the toolbar when a BQY file is opened using a Smartcut.

• 9197834

Using a JavaScript in a pivot computed item does not produce correct results.

• 9191013

Exporting BQY jobs created with Interactive Reporting, Release 9.3.1 to the FTP directory of an Interactive Reporting, Release 11.1.1.3 system fails sometimes.

• 9188320

Sometimes users assigned the report designer role can open BQY jobs in Interactive Reporting Web Client.

• 8840509

If you move a slider to a category and the category name contains more than 39 characters, Interactive Reporting Studio may stop responding.

• 8438799

Interactive Reporting documents (BQY files) fail to open correctly in legacy mode on German locale.

7462413

When you use Hewlett Packard Unix - HP-UX IA64 platforms, swapping dimensions inside one axis either by dragging items into the Data Layout or using the Swing feature, Interactive Reporting restarts in EPM Workspace.

Migration

Report Number

Description

• 12337981

After migrating from HPSU 8.3 to EPM 11.1.1.3, row level security fails.

12337957

If a connection name contains an ampersand (&), migrated Web Analysis reports that point to that connection do not open.

Reporting and Analysis Framework

Report Number

Description

• 12561625

Users can execute a generic job file with a selected output directory using the following two methods:

execute(String[] params, String username, String password, String @ dbConnectString, String flags, Category outputDir)

executeBackground(String[] params, String username, String password, String dbConnectString, String flags, Category outputDir)

• 12561524

Using the Softward Development Kit, users cannot run a generic job using runtime parameters.

• 12556101

Custom Login does not work properly in Mozilla Firefox after logging off. This happens because Mozilla Firefox shares the session between different windows and tabs. To resolve this problem:

1.    Close all browser windows.

2.    Start a new session, and then navigate to a blank page.

3.    Clear the cache, and then log in again.

Note: If you do not select the option “When Firefox starts: Show my windows and tabs from last time,” clearing the browser cache is not necessary.

• 12531140

The Access Control menu is not displayed unless until users select the Access column.

• 11928875

Sometimes when a Production Reporting job fails, extraneous files remain in the root folder.

• 11874620

The message Processing Error is displayed if a group filter does not match any group name.

• 11870301

Sometimes importing a BQY job fails when using a published BQY report.

• 11846632

Canceling a job cancels other instances of that job that were started by the same event.

• 11841296

Users must click the EPM Workspace Refresh button to display the Production Reporting job output.

• 10397684

Sometimes adding a schedule to a Production Reporting job causes a JavaScript exception when a user adds a recurring time event to that job.

• 10328219

Environment variables defined in Job Service are not carried over to Production Reporting scripts.

• 10103223

When ScheduleOwner is changed using Modify Schedule, the new value is not displayed when Consolidated Job Status is selected

• 9979827

Sometimes after manually importing reports from Web Analysis, Release 9.3.1.00 to a Release 11.1.1.3.00 installation, the imported reports do not open.

 

Web Analysis

Report Number

Description

• 12695440

Saving a Web Analysis report using Save As creates a report that does not have the same description as the original report.

• 12655240

Using the Lifecycle Mangement utility to migrate Web Analysis from 11.1.1.1 to 11.1.1.2 can cause problems.

• 12607615

Some Web Analysis charts display incorrect scale values in EPM Workspace.

• 12567717

When using the Restrict Data analysis tool, the Select Column dialog is not displayed sometimes if the report has cells with missing values.”

• 12566244

Suppress Missing does not display results correctly in report rows when the effected rows contain calculations.

• 12393008

Web Analysis always uses the native ADM driver when interrupting a running Essbase query.

• 12346966

Web Analysis should use the APS ADM Driver as the default when connecting to Essbase.

• 12327659

Some Web Analysis Tools settings revert to previous settings when you open a report that has All Data is Hidden set.

• 12324273

When the opposite member value is zero or #Missing, percent of member function results can vary.

• 11924085

You cannot execute an Essbase Calc script using Web Analysis.

• 11851727

Sometimes copying and pasting Web Analysis files in EPM Workspace results in corrupted files.

• 11682045, 8613351

You cannot save personal variables for Web Analysis database preferences in EPM Workspace.

• 11067519

If you create a calculation for columns that includes the function Percent, the message “Evaluation error” is displayed if the Percent function members include zero.

• 10435226

After reversing two dimensions in Web Analysis Studio, the pop-up menu is not displayed and drill down fails.

• 10396205

When using a filter in a text label, the default alias is displayed instead of the report alias.

• 10376786

In exported Web Analysis reports created in Release 9.3.1, problems with hidden columns can occur.

• 10366124

Web Analysis reports are not updated after changing substitution variable values.

• 10184624

Sometimes users who do not have the required permissions are prompted to save reports.

• 10166517

A Java error is displayed when personal variable members are added to the selected members list.

• 9845194

Sometimes when changing pages in a Web Analysis report, the message "all data is hidden" is displayed if the LoadAllData property value is set to Yes.

• 9758326

Sometimes Web Analysis graphs are not displayed correctly when importing a Reporting and Analysis report to Microsoft PowerPoint.

• 7476590

When exporting Microsoft Excel spreadsheets, the “Show path to MS Excel” dialog is displayed when ShowPatchToExcelDlg is set to False, and ExcelPath is empty.

 

Top of Document

Documentation Updates

Accessing Hyperion Product Documentation

The most recent version of each Hyperion product guide is available for download from the Documentation area of the Oracle Technology Network (OTN) Web site (http://www.oracle.com/technology/index.html). Deployment-related documentation is also available from the Oracle E-Delivery Web site (http://edelivery.oracle.com/EPD/WelcomePage/get_form). Individual product guides are available for download on the Oracle Technology Network (OTN) Web site only.

Note: Not all of the documentation for this product has been updated from Release 11.1.1.1. Similarly, the product UI may not have been updated from Release 11.1.1.1.

Accessibility in EPM Workspace, Fusion Edition

Screen Reader and Magnifier Standards

For EPM Workspace, the following text describes settings that must be made for Job Access With Speech (JAWS) 12 as a screen reader and MAGic 11 for screen magnifier. For additional information, refer to the documentation included with these products.

Note: Oracle does not suggest using JAWS and MAGic simultaneously or using MAGic as a screen reader. Also, screen magnifier programs are preferred over browser based Zoom and Text Size features, as they may produce undesirable results.

JAWS preferences should be set to allow JAWS to read the page properly and react to user interface updates. See section that follows for details.

Setting Preferences for JAWS

·        Virtual PC Cursor should be disabled when using EPM Workspace applications and enabled when reading regular documents. For example, an IFrame with a text file in EPM Workspace. See JAWS documentation for additional details.

Using Search in Non-Dynamic Help

If you are using Internet Explorer and script debugging is enabled, when you execute a search in online help you may get an “invalid character” error message. If this occurs, select No to display search results correctly.

Include Consolidation Info option for CubeQuery Query Options

A new “Include Consolidation Info” option has been added to the CubeQuery Query Options to enhance performance when downloading to results. Enabling this option includes consolidation type/unary operator information of all members from the Data Layout when Download To Results is executed. Disabling the option excludes the consolidation type/unary operator information for each member. By default this option is disabled for newly inserted CubeQuery sections.

Additionally an IncludeConsolidationInfo property has been added to the QueryOptions object in the Object Model as the programmatic equivalent to the Include Consolidation Infor option. This property takes a Boolean argument (true or false).

Launching Smart View from CubeQuery

In the EPM Workspace User’s Guide online help, the “Launching Smart View from CubeQuery" help topic incorrectly states that you can you export CubeQuery content as formatted HTML to Smart View. CubeQuery content can only be exported as query-ready HTML.

Unavailability of Help Topics for Trend Line and Reference Line Property Dialog boxes

Documentation is unavailable for the Trend Line and Reference Line properties dialogs in EPM Workspace. As a workaround, see the Reference Line Properties and Trend Line Properties topics in the Interactive Reporting User’s Guide.

Export and ExportToStream (Methods)

The documentation for the Export and ExporttoStream (Methods) has been changed to include the following note: “The use of the Export (Method) or ExportToStream (Method) does not display a prompt dialog in EPM Workspace or Jobs/Scheduler.”

Gauges and Live Chart

The Gauge “Value” data layout pane has been renamed to “Fact.” As a result, the Interactive Reporting documentation has been modified to reflect the renamed field name.

The Gauge Property “Subtype” field has been renamed to “Style.” As a result, the Interactive Reporting documentation has been modified to reflect the renamed field name.

Intelligence: Dashboard

Object Model Menu Item Changes do not occur until Go To/From another section

When context menu changes made through the Object Model have been associated with embedded section objects of the same dashboard, the entire dashboard should be refreshed for changes to take effect. To refresh an entire dashboard, switch to another section, and then switch back to the same section.

This was designed so that menu changes could be executed from the Startup script or from the user interface and saved with the document. It is not expected to be a frequent operation.

Ghostscript Custom Parameters

The Financial Reporting Print Server uses Ghostscript to convert a report's output from Postscript (PS) file to Portable Document Format (PDF) or to an image format (JPG). Ghostscript provides numerous options (parameters) for the conversion process. Financial Reporting previously passed these parameters directly to Ghostscript; which prevented the users from modifying or specifying custom parameters. However, the ability to provide custom Ghostscript parameters is now available.

Implementation Overview

When it is necessary to convert a postscript output into Portable Document Format or JPG using Ghostscript, the Financial Reporting Print Server queries the Windows registry. If a specific entry is found, it uses the user provided Ghostscript parameters from the registry rather than the default parameters to generate the PDF (Portable Document Format) or JPG. A user only needs to modify the registry entry to obtain the desired output. This can include higher output resolution, the use of custom conversion devices, and changing the default paper size.

Existing Financial Reporting installations are not affected by this change. Users should be familiar with Ghostscript in general and particularly with parameters that are used by Ghostscript. This is an advanced feature that can cause Portable Document Format or JPG output to fail or become corrupted if not implemented correctly.

Ghostscript Documentation

To understand how to use the custom Ghostscript parameters feature in Financial Reporting, it is important to become familiar with the various documented parameters and how they affect the output. The following links provide the most relevant documentation:

·        How to use Ghostscript: http://pages.cs.wisc.edu/~ghost/doc/cvs/Use.htm
This link provides a comprehensive description of the general Ghostscript parameters.

·        PostScript-to-PDF converter: http://pages.cs.wisc.edu/~ghost/doc/cvs/Ps2pdf.htm
This link provides the parameters unique for PostScript to PDF conversion.

·        Ghostscript output devices (JPEG): http://pages.cs.wisc.edu/~ghost/doc/cvs/Devices.htm
This link provides the parameters unique for PostScript to JPG conversion. This link contains details about other image output formats.

·        Ghostscript Overview (main page): http://pages.cs.wisc.edu/~ghost/doc/cvs/Readme.htm

Default Behavior

The new custom Ghostscript parameter feature is not enabled by default. The install and configuration tool does not add the registry entries to enable this feature. It requires administrators to manually add the appropriate registry entries (described below) in order to enable the feature.

This section documents the current default Ghostscript parameters that are currently used to generate PDF and JPG from a report's postscript.

Postscript to PDF Conversion

The routine that uses Ghostscript to convert postscript output into PDF uses the following 12 parameters:

1.    ps2pdf (name of GS instance, always ignored)

2.    -dNOPAUSE

3.    -dBATCH

4.    -dSAFER

5.    -sDEVICE=pdfwrite

6.    -dAutoFilterColorImages=false

7.    -dColorImageFilter=/FlateEncode

8.    -sOutputFile=[postscript file path]

9.    -c

10. .setpdfwrite

11. -f

12. [PDF output file path]

Where:

·        "[postscript file path]" is the path of the postscript file and

·        "[PDF output file path]" is the path of the PDF output file

See the Ghostscript Usage documentation for details on the above parameters.

Postscript to JPEG Conversion

The routine that uses Ghostscript to convert postscript output into JPEG uses the following 7 parameters:

1.    ps2jpg (name of Ghostscript instance, always ignored)

2.    -dNOPAUSE

3.    -r200 (default resolution of 200 pixels per inch)

4.    -dJPEGQ=75 (jpeg quality level)

5.    -sDEVICE=jpeg

6.    -sOutputFile=[postscript file path]

7.    [PDF output file path]

Where:

·        "[postscript file path]" is the path of the postscript file and

·        "[PDF output file path]" is the path of the PDF output file

When the report is set to landscape orientation, the following parameters are also included:

1.    -c

2.    <</Orientation 3>> setpagedevice

3.    -f

See the Ghostscript Usage and JPEG File Format documentation for details on the above parameters.

Specifying Custom Parameters

In order to override the default Ghostscript parameters the administrator must add registry keys with values that represent the custom parameters. The administrator must add the appropriate registry keys and make sure that the parameters produce the desired results.

The following sub-sections describe the process to add the custom parameters.

Custom Parameters for Postscript to PDF Conversion

In order to enable the use of custom parameters for the postscript to PDF conversion routine, the following steps should be taken:

1.    Run the Windows Registry Editor (regedit.exe).

2.    Navigate to the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Reports\HyS9FRPrint.

3.    Add a new Multi-String Value (REG_MULTI_SZ) named GSPDFOptions.

4.    Double click the new value, or select Edit, and then Modify from the menu to display the Edit Multi-String dialog.

5.    Add one parameter per line. Do not enter multiple parameters on the same line.

6.    Click OK.

Note: It is not necessary to restart the Financial Reporting Print Server in order for the custom parameters to be read. The Financial Reporting Print Server reads the most recent information from the registry every time the postscript conversion routine is run.

Custom Parameters for Postscript to JPEG Conversion

In order to enable the use of custom parameters for the postscript to JPEG conversion routine, the following steps should be taken:

1.    Run the Windows Registry Editor (regedit.exe).

2.    Navigate to the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Reports\ HyS9FRPrint.

3.    Add a new Multi-String Value (for example, REG_MULTI_SZ) named GSImageOptions.

4.    Double click the new value, or select Edit, and then Modify from the menu to display the Edit Multi-String dialog.

5.    Add one parameter per line. Do not add multiple parameters on the same line.

6.    Click OK.

Note: It is not necessary to restart the Financial Reporting Print Server in order for the custom parameters to be read. Financial Reporting Print Server reads the most recent information from the registry every time the postscript conversion routine is run.

Mandatory Parameters

Certain parameters are required by the Ghostscript conversion routine. If, after querying the registry they are not found, Financial Reporting will always add them. However, it is advised that the following parameters be indicated when using custom Ghostscript parameters:

·        -dNOPAUSE: This parameter disables the prompt and pause of Ghostscript. Since the Financial Reporting print server is a service there should never be any user interaction.

·        -dBATCH: This parameter is used for the PostScript (PS) to Portable Document Format (PDF) conversion only. It complements the "-dNOPAUSE" parameter.

·        -sDEVICE=: A device must be specified. If this parameter is not found, it defaults to pdfwrite for the PostScript (PS) to Portable Document Format (PDF) conversion and jpeg for the PostScript (PS) to JPEG conversion.

·        -c <</Orientation 3>> setpagedevice -f: These parameters are used for the PostScript to JPEG conversion when a report is set to print in landscape orientation. It is not recommended that these parameters be added to the GSImageOptions registry entry.

General Guidelines

Consider following guidelines when using the custom Ghostscript parameter feature:

·        You should never use the -sOutputFile parameter. This parameter is always added by the Financial Reporting conversion routines. The output file cannot be hard-coded because it is dynamically generated by the Financial Reporting Print Server.

·        Performance vs. Quality: It is important to weigh the benefits of higher quality versus the performance for producing the converted output. There are several Ghostscript parameters that can affect the output quality, however the -r### (resolution) parameter is most commonly used. In general, the higher the resolution, the more time it takes for Ghostscript to produce the output and the bigger the output file becomes. For example, using -r200 on a 180KB PostScript file produces a 204KB jpeg file; using -r400 (same PostScript file) produces a 563KB jpeg file.

·        If the -c parameter is used, it must be closed with the -f parameter. Failing to do this may result in the postscript file name to be interpreted incorrectly.

·        The -c parameter and the subsequent PS commands should be entered at the end of all other parameters (except for -f).

·        It is not necessary to add both JPEG and Portable Document Format (PDF) custom parameters. Users can indicate one or other, both, or none.

Turning Off Custom Parameters

To turn off the custom Ghostscript parameters, rename the registry entries (GSPDFOptions or GSImageOptions). For example, renaming GSPDFOptions to _GSPDFOptions forces the PostScript (PS) to Portable Document Format (PDF) routine to use the default parameters.

Alternately, the registry names can be kept intact, but their values can be empty. Even though the Ghostscript conversion routine finds the registry entry, it still uses the default parameters if the entry is empty.

Examples

The following section provides valid examples of using the custom GS parameters from the registry.

Mimicking the Default Parameters

To mimic the default Ghostscript parameters by using the registry, the following parameters would be entered:

Default entries for GSPDFOptions would be:
-dNOPAUSE
-dBATCH
-dSAFER
-sDEVICE=pdfwrite
-dAutoFilterColorImages=false
-dColorImageFilter=/FlateEncode

-c
.setpdfwrite
-f

Default entries for GSImageOptions would be:
-dNOPAUSE
-r200
-dJPEGQ=75
-sDEVICE=jpeg

Turning off DSC Comments

DSC Comments sometimes cause an error in the rotation of landscape pages. To turn off DSC Comments use the following parameters in the Registry.

GSPDFOptions registry value to turn off DSC Comments:
-dNOPAUSE
-dBATCH
-dSAFER
-sDEVICE=pdfwrite
-dAutoFilterColorImages=false
-dParseDSCComments=false
-dColorImageFilter=/FlateEncode
-c
.setpdfwrite
-f

Changing the Resolution for Image Output

The default image resolution for the "export to Word / PowerPoint" feature is set to 200 pixels per inch. The resolution can be changed using the registry parameters.

Warning: changing the resolution to a large value produces a larger image file and degrades performance of the conversion process.

GSImageOptions registry value to increase the resolution to 400 pixels per inch:
-dNOPAUSE
-r400
-dJPEGQ=75
-sDEVICE=jpeg

Top of Document

 

Third Party License Appendix

Cyrus SASL

Copyright © 1994-2003 Carnegie Mellon University. All rights reserved.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
  2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
  3. The name "Carnegie Mellon University" must not be used to endorse or promote products derived from this software without prior written permission. For permission or any legal details, please contact:

Office of Technology Transfer
Carnegie Mellon University
5000 Forbes Avenue Pittsburgh, PA 15213-3890
(412) 268-4387, fax: (412) 268-7395
tech-transfer@andrew.cmu.edu

4. Redistributions of any form whatsoever must retain the following acknowledgment:

"This product includes software developed by Computing Services at Carnegie Mellon University (http://www.cmu.edu/computing/)."

CARNEGIE MELLON UNIVERSITY DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS, IN NO EVENT SHALL CARNEGIE MELLON UNIVERSITY BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

JPEG

This software is based in part on the work of the Independent JPEG Group.

WSRP Web Part Toolkit for SharePoint Products and Technologies

WSRP (Web Services for Remote Portlets) authors provide no warranty whatsoever for WSRP Web Part Toolkit performance. WSRP authors maintain no liability for WSRP Web Part Toolkit.

Top of Document

Accessibility Considerations

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

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.

Top of Document

 

Copyright © 2011, Oracle and / or its affiliates. All rights reserved.
http://www.oracle.com