Hyperion® Reporting and Analysis

Release 11.1.1.3.00

Readme

Purpose.. 3

Accessibility.. 3

Translation Support.. 3

New Features. 3

Financial Reporting.. 3

Setting Table of Contents Display Text 3

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

Financial Reporting Studio New Grid Property – General Tab. 4

Date Value Format in Financial Reporting Preferences 4

EPM Workspace.. 4

Merging Children Permissions (ACL) 4

General.. 5

Installation Information.. 5

Reporting and Analysis Known Issues. 5

Installation.. 5

Financial Reporting.. 5

Accessibility. 11

Interactive Reporting.. 12

General 12

CubeQuery. 14

Widgets 15

Accessibility. 17

Connectivity. 17

Interactive Reporting Web Client 18

Dashboard Development Services. 19

Dashboard Builder 19

Architecture. 19

SQR Production Reporting.. 19

Accessibility. 20

EPM Workspace.. 20

General 20

User Interface and Servlets 26

Directory Services 27

Services 28

Accessibility. 28

Web Analysis. 29

Migration.. 32

Smart View... 32

Defects Fixed in Release 11.1.1.3. 33

Financial Reporting.. 33

Interactive Reporting.. 35

Web Analysis. 36

Smart View... 37

Dashboard Development Services. 37

EPM Workspace.. 37

Migration.. 39

Defects Fixed in Release 11.1.1.2. 39

Financial Reporting.. 39

EPM Workspace.. 41

Embedded Sections Objects. 42

CubeQuery.. 42

Interactive Reporting.. 42

Web Analysis. 43

Defects Fixed in Release 11.1.1.1. 43

Financial Reporting.. 43

Dashboard Development Services. 45

Dashboard Builder 45

User Provisioning.. 45

Workspace Agent Services. 46

Documentation Updates. 47

Accessing Hyperion Product Documentation.. 47

Accessibility in Oracle Enterprise Performance Management EPM Workspace, Fusion Edition   48

Screen Reader and Magnifier Standards 48

Setting Preferences for JAWS. 48

Using Search in Non-dynamic Help. 48

Include Consolidation Info option for CubeQuery Query Options 48

Launching Smart View from CubeQuery. 48

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

Export and ExportToStream (Methods) 49

Gauges and Live Chart 49

Intelligence: Dashboard.. 49

Ghostscript Custom Parameters. 49

Implementation Overview. 49

Ghostscript Documentation. 50

Default Behavior 50

Postscript to PDF Conversion. 50

Postscript to JPEG Conversion. 51

Specifying Custom Parameters 52

Custom Parameters for Postscript to PDF Conversion. 52

Custom Parameters for Postscript to JPEG Conversion. 52

Mandatory Parameters 53

General Guidelines 53

Turning Off Custom Parameters 54

Examples 54

Mimicking the Default Parameters 54

Third Party License Appendix.. 56

 

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.3.00 is a maintenance release for Release 11.1.1.0, 11.1.1.1, or 11.1.1.2.

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

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.

Translation Support

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

[SP1] New Features

See the Oracle’s Hyperion Reporting and Analysis Release 11.1.1 New Features Guide for additional information on 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.

In addition, new features for this release are listed below.

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

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.

Installation

Report Number

Description

8719571

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

Workaround: Re-deploy the Financial Reporting Web application, rerun Financial Reporting, and select the custom configuration.

 

Financial Reporting

Report Number

Description

9092271

Exporting Financial Reporting to Microsoft office 2007 results in a warning message.

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

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, since Financial Reporting reports are generated in an MHTML format when exporting to MS Office.

This is not a security concern. Microsoft Office is just warns a user of a file format that is different than expected. Select “Yes” in the warning, and the file opens correctly in Microsoft Office.

8741914

The data in the rows with Drill Through links disappear after expanding in the grid.

8661222

If your browser is Firefox 3.0 or later, the Add, Remove, and Remove All icons do not display correctly the first time you add a document in the Select dialog of the Book Editor and the Batch Editor. The icons is displayed once an item is selected in the "Look In" or "Selected Item" pane of the Select dialog.

8633906

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

6537555

Member Selection: Using the Essbase driver and advanced member selection with the NOT operator does not work correctly.

When using the native Essbase driver against 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.

6540544

Member Selection: You cannot see substitution variables if they contain quotes (“ “).

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.

6540965

Web App Server: Some Java server pages fail if the path is more than 256 characters, and when installing under a non-default directory.

Workaround: Decrease the path length by moving the directory closer to the root.

6546996

Scheduler Server: You cannot burst batches against Microsoft Online Analytical Processing (OLAP) data sources.

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

6546997

Scheduler Server: You cannot burst batches against SAP BW data sources.

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

6550742

No error message is displayed when changing the data source on a report that contains a linked row and column template.

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.

6559132

SAP BW: Searching by description does not return the correct members.

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.

6565344

SAP BW: Expansion in SAP BW grid with Calculated / Restricted keys fails.

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

6573795

The number of colors for selection on Windows Vista is less than in Windows XP, 2000 and 2003.

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

6625979

The Refresh All option only refreshes the active report in saved documents.

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

6643938

Enabling automatic downloading in Internet Explorer 7 (IE7) in order for some MS Office files to be opened or Smart View to be downloaded is needed.

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

6844783

The Print Preview window does not display in the foreground as the active window.

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 the Print Preview window.

6878360

Annotation Manager: The view pane does not refresh and show replies to annotations through Annotation Manager.

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

7000523

Financial Reporting portlet does not work.

When Hyperion portlets are deployed on WebSphere Portal version before 6.1.0.9, Financial Reporting portlet does not work. To fix this, apply patch PK34915 from the following location:

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

For additional details on the issue with the WebSphere portlet container see:

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

7018859

Oracle application server: A book in Portable Document Format fails when running a large book.

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.

7038014

Firefox: Selecting related content to Financial Reporting within EPM Workspace returns a blank dialog.

When selecting related content to Financial Reporting using Firefox v2.0.0 browser, the report within EPM Workspace displays a blank dialog. This issue is resolved by upgrading the browser to Firefox 2.0.0.13 or later.

7137213

Search services for annotations must be enabled after upgrading.

After upgrading, the search services which had not been 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 on Workspace Service Type in the list and select Properties.

6.    Select the Services tab.

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

8.    Select OK.

9.    Right-click Workspace Service Type in the list and select Restart.

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.

7162881

Annotation Manager: There are limitations on Show Reports of annotations search.

The following scenarios describe known issues of the 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.

7245721

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

7409204

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

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.

7434889

The column template fails to inherit formats.

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

7443066

If Smart View is not installed, export to Microsoft Excel in Query Ready mode does not work in Firefox 2.

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

7482668

Conditional suppression does not work if the comparison is set to “Invalid.”

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

7539846

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

7571305

Annotation details on Book Preview appear as boxes for multibyte languages.

When your language preference is set to a multi-byte 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 multi-byte font when printing to Portable Document Format.

Workaround: Create and save a text object that includes the footnote function, <<Footnote()>>, to Workspace. Then in the Annotations Print Details user preferences, specify the text object to be used for printing.

8237117

Image objects are truncated in export to Microsoft Word and Microsoft PowerPoint.

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" through Internet Explorer Option settings.

To enable/disable "Browse in same window":

1.    In Windows Explorer, select Tools, and then Folder Options.

2.    Select the File Types tab.

3.    From the list of Extensions and File Types, select the Office product. For example, DOC Microsoft Office Word 97 – 2003.

4.    Click Advanced to display the Edit File Type dialog.

5.    Select Open, then select to enable, or deselect to disable, Browse in same window.

6.    Click OK.

7.    Click Close.

 

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.

8440033

Reference in documentation for more information about substitution variables for related content is missing. 

Originally, the 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

8668920

When server components are installed on the same machine as the Financial Reporting Studio, the Studio logon fails for remote Report Servers that use a different registry database than the local server components. This may affect Studio connectivity from a test environment to a production environment.

Workaround: Connect from a Financial Reporting Studio machine that does not have server components installed.

Accessibility

Report Number

Description

7361320

JAWS (Job Access With Speech) does not read the database connection manager dialog name.

When accessibility mode is enabled, the objects in the database connection manager dialog are not identified correctly.

7376590

JAWS (Job Access With Speech) does not read the Member Selection dialog name.

When accessibility mode is enabled, the objects in the Member Selection dialog are not identified correctly.

 

 

Interactive Reporting

General

Report Number

Description

6533806

 

Some computed item names do not display correctly in EPM Workspace.

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 & half-width Won). Using such characters in control names is not supported and can cause document rendering useless in EPM Workspace.

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.

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.

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.

6588245

Data Function Percent of Row is incorrect on Cume set.

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

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.

Since 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 is to inform 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.

6898879

Portlet: The Launch Out function opens EPM Workspace in the same window.

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

7026453

Inconsistent behaviour of Save To Repository As option occurs.

When opening an Interactive Reporting document (BQY) job in the Web Client, and performing a Save to Repository As with a different file name, the feature works as expected. When performing a Save to Repository As again with the same file name as the Interactive Reporting document job, the following error message is presented: 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.

Workaround: Use “Save” instead of “Save to Repository As” to use the same file name.

7134007

Extension is missing and file type is not recognized when downloading Interactive Reporting.

After cancelling the installation of the WebClient, attempting to open the WebClient will show an unrecognized file type. To correct this, delete the cookie for the Workspace server and conduct the Web Client installation to completion.

7139389

Append query items in query operator dropdown become disabled.

Items in the Query Operator dropdown become disabled after the appended query is renamed.

Workaround: Switch to another query section or to another section.

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.

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.

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.

7479134

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

8432541

SiteMinder: ihtml servlet requests additional authorization on weblogic-iis configuration.

If you are running WebLogic application server with IIS Web Server, and have SiteMinder Web agent configured on IIS, add WLSendHdrSeparately=ON line to the iisproxy.ini file.

8438799

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

8439336

Multiple logon dialogs appear on export section from Workspace to Microsoft Excel if authentication through SiteMinder is installed.

8441665

SiteMinder fails to export to .mhtml and .xls when selecting File, and then Export.

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.

8509815

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

CubeQuery

Report Number

Description

7277986

Some CubeQuery features are not presented in Workspace help.

The following options are not described in help for Workspace:

·     When selecting Navigating CubeQuery, and then Using Swing

·     Label Indentation

6895722

Selecting Actions, and then Drill Through is disabled for mapped dimensions in EPM Workspace.

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.

Workaround: Apply Drill Through using the right-click (shortcut) menu.

7304600

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

7316302

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

7335773

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

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.

7462413

Swapping dimensions inside one axis results in Interactive Reporting service restart.

Hewlett Packard Unix - HP-UX IA64: When you swap dimensions inside one axis by dragging items in Data Layout or use the Swing feature, an Interactive Reporting restart occurs in EMP Workspace.

8201413

“Download To Results” is incorrect on case sensitive outline.

8254533

Case sensitive members are displayed incorrectly after searching for case sensitive members with “Both” option selected.

8615811

Using Firefox2.0, there is no blinking cursor in the Search String edit box of the Catalog pane on a WebSEAL protected configuration.

Widgets

Report Number

Description

7030044

The slider does not appear greyed out when Enable equals false.

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

7039581

A three color range restriction is incorrectly applied to single traffic light.

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

7111535

Remove horizontal and vertical gradient effects from Live Line Chart options.

The Gradient-Horz (horizontal) and Gradient-Vert (vertical) properties are not applicable for Live Line Charts even though the properties dialog displays them.

7114220

You cannot set gauge data function property using the object model.

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

7116439

Negative patterns are needed in XML and API number formats.

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.

7116714

Widget association with slider is lost if slider contains no data.

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

7117407

Slow performance resembling a hang occurs with default interval and no autoscale.

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.

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.

7122540

No support exists for multiple sliders.

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

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.

7160883

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

7182583

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

7196974

Various widgets may not draw when opening a document for the first time.

Workaround: When an individual widget does not appear in EPM Workspace when opening the document, close and reopen the document. The widgets should then appear.

7317044

Export output does not support transparency.

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

Accessibility

Report Number

Description

6853671

No Accessibility or Comments tabs appear in properties for some dashboard controls.

Not all Dashboard controls have both Accessibility and Comments tabs in properties. This influences tooltips for the controls in the EMP Workspace.

6853764

Embedded browser: Some property settings are not saved.

A user is unable to save accessibility text properties for an embedded browser in Interactive Reporting Studio and Web Client. As a result, accessibility text is not displayed in EPM Workspace.

6856503

The presence of embedded browser in dashboard influences keyboard navigation.

6857089

JAWS (Job Access With Speech) does not read advanced information about an element.

Advanced information about a selected element is displayed in Status bar and as a tooltip on selecting the Ctrl+Alt+Enter keys, but it is not read by JAWS.

7046945

You cannot control widgets using keyboard only.

7283262

Smartcut: You are unable to call toolbar items from section.

When an Interactive Reporting document is opened through Smartcut, shortcut keys called from the content area do not work.

7446216

You are unable to open context menu for a table cell.

Pressing Shift+F10 does not open the context menu for elements in a CubeQuery table.

Workaround: Use the Application key.

6770813
7283244

For Interactive Reporting Charts, JAWS (Job Access With Speech) reads all objects with the word “link” in the end (Labels, Legend, Chart elements, and so on).

Connectivity

Report Number

Description

7036539

For an ODBC/ODBC MERANT Oracle Wire Protocol driver connection, the timpestamp WITH TIME ZONE data type is recognized as a string.

Workaround: Manually set the data type.

7042510

Processing INTERVAL data type causes date format error for Teradata 4.0 ODBC driver.

Workaround 1: Set the column’s data type to “String” in the Item Properties dialog.

Workaround 2: Use Teradata 3.5 or 12.0 ODBC drivers.

Interactive Reporting Web Client

Report Number

Description

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.

6982405

Datamodel connection property "username" returns null value.

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.

7134007

The extension is missing and the file type is not recognized when downloading an Interactive Reporting documents file.

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 should delete the cookie for the EPM Workspace server and complete the Web Client installation.

7342404

Data Analysis Systems (DAS) is unable to load OBIEE driver on Linux.

On Linux/UNIX platforms, sometimes loading of ODBC driver for Oracle BI fails, causing query processing to fail.

Workaround: Run Data Access Service on Windows platform.

7452638

In Firefox 2, Live Charts will not draw outside of specific footprint.

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 will not draw correctly. If you intend to deploy the dashboard on Firefox, design the dashboard within this footprint constraint.

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.

 

SQR Production Reporting

Report Number

Description

6565427

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

Workaround:

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.

6888134

Multiple data source: The query builder should prevent users from selecting incompatible data sources when they edit a query.

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.

6940273

After editing the second master query, SQR Production Reporting Studio causes an unanticipated application error.

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

10270417

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

Accessibility

Report Number

Description

6754429

Users cannot navigate through the fields in the report layout the way JAWS (Job Access With Speech) would read out.

 

EPM Workspace

General

Report Number

Description

8713212

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

8574449

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

8693191

UNIX only: set_common_env.sh should not redefine library variables.

In order to use external library path variables for OCI connections you have to update inside <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 8693216: UNIX only: agent.sh has mistakes in library path definition.

8693216

UNIX only: agent.sh has mistakes in library path definition.

In order to use external library path variables for OCI connections you have to fix library path definition inside <HYPERION_HOME>/common/workspacert/9.5.0.0/bin/agent.sh file:

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 one for SHLIB_PATH and LIBPATH. Perform this workaround together with 8693191: UNIX only: set_common_env.sh should not redefine library variables.

6535963

When a text field is selected, the cursor does not display.

When using Firefox, the cursor does not display in some text boxes. For example, the text box in the dialog box which opens when the user renames a file or folder. This issue has been traced to Mozilla.

6537899

UI and Visualization: SQR Production Reporting jobs in Microsoft Excel/Word/PowerPoint output open outside the Firefox framework.

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.

6540172

Group preferences are not enforced for newly added users.

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

6566264

When a menu has a long list of sub-menus, they do not display.

In Internet Explorer 7, menus sometimes overlap or have unnecessary scroll bars. Internet Explorer 7 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, and then Yes, then click OK again.

6581290

The wrong folder can be selected when clicked.

When Firefox is used on Linux based operating systems, clicking the mouse to select an object in Explorer may result in the wrong object selected.

To resolve this, 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 Firefox to 16pt "Microsoft Sans Serif."

6585295

The scrollbar does not work as expected.

In certain instances a tree with content wider than the visible area displays scrollbars which have no effect.

Workaround: Move the vertical splitter to the right, which resizes the visible area, allowing for more content.

6589361

The Address bar always shows on Internet Explorer (IE7).

Microsoft IE7 has a new feature that allows the user to control whether Web applications can open windows without address or status bars. By default, this feature prohibits Web applications from opening windows without address or status bars, making these parts of the browser always visible.

To hide these parts of the browser:

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

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

3.    Close the dialog by pressing OK, confirming with Yes, and pressing OK again.

6664797

The Width parameter is not applied when using Firefox.

When working with portlets on Oracle WebCenter page under Firefox browser, portlet content width cannot be changed on the Edit page.

Workaround: Set portlet width and height explicitly in the adfp:portlet tag on the WebCenter page.

6919621

Duplicate entries display on the toolbar when launched from EPM Workspace 11.1.1.1. and 11.1.1.2.

Users of Performance Scorecard wishing to use EPM Workspace 11.1.1.1 and 11.1.1.2 should upgrade Performance Scorecard to a version later than 9.2.1.

6939710

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

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

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.

7022335

The following Java system property - dusehostname usage documentation is missing:

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.

7026804

URL is not found when selecting the Help icon and menu items.

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.

Workaround: Copy the Help files from the 9.3.1 installation of Scorecard into the workspace_static/docs folder.

7173619

When Microsoft Excel is not installed, right-clicking on a Microsoft Excel-format file in the Workspace repository and selecting Open in New Window produces a browser window which immediately closes.

7331209

Nested search date syntax is removed if there is more than one statement.

SimpleSearch expressions and AdvancedSearch UI 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 redisplayed accurately in AdvancedSearch UI (User Interface).

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. If you want to disable users to use Subscription, launch Configuration Management Console, and select Web Application Properties, then Workspace, then User Interface. If you want to disable any e-mail notifications, launch Configuration Utility and clear Mail Server settings in Hyperion Foundation - Common Settings.

7447398

Firefox: Workspace pages do not render HPS portlet due to wrong content type.

Workspace pages do not correctly render HPS portlets when the browser is Firefox and HPS is installed on certain Web application servers.

Workaround: Use Internet Explorer as the browser.

7477311

Firefox browser becomes unresponsive when trying to resize the portlet.

In some circumstances, Firefox 2 may become unresponsive when resizing a portlet.

Workaround: Use Internet Explorer to edit the portlet's size.

7483255

The Save As option should not change the current version of the Workspace Page.

When editing a Workspace Page by selecting File, and then Save As, allows the user to save the changes to a new Workspace Page. However, selecting this menu item saves changes to the existing Workspace Page as well as to the new Workspace Page.

Workaround: Open the page and select File, and then Save As, then save the page with the new name before making any changes to the page.

7552741

The document’s modified time is displayed as a.m. or p.m. on search request.

7579450

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

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.

8523417

In EPM Workspace Admin help, the Starting RSC topic has the wrong path and batch file name.

Step 1 of Configuring RSC topic has the wrong path and batch file name. Instead of either:

·         Windows: Select Start, then Programs, then Oracle EPM System, then Workspace, then Utilities and Administration, then Service Configurator. Or,

·         From products/foundations/workspace, run servcieconfig.bat.

It should be either:

·         Windows: Select Start , then Programs , then Oracle EPM System, then Workspace, then Utilities and Administration, and then Service Configurator. Or ,

·         From <Hyperion_Home>\products\Foundation\workspace\bin, run ServiceConfig.bat.

8588757

In EPM Workspace User's Guide, change the text,Creating Workspace Pages, step 6:

Optional: To add a URL, Favorites, or Alerts Exceptions in the content area of a Workspace page, select Edit, then Add Content, then URL, Favorites, or Alerts Exceptions.

To:

Optional: To add a URL, Favorites, Alerts Exceptions or Applications in the content area of a Workspace page, select Edit, then Add Content, then URL, Favorites, Alerts Exceptions or Applications. By selecting the Applications menu item, a new layout area is added to the Workspace page that displays the list of provisioned applications.

8616344

An error message is displayed after running a Production Reporting job from the Home page.

8633273

In the Oracle Enterprise Performance Management Workspace User's Guide, Release 11.1.1.3, Accessibility Appendix, the note which follows step 3 in the Enabling Screen Reader Support for EPM Workspace does not apply to this section. It should have replaced the first note in the Accessibility for Interactive Reporting section as follows:

Keyboard navigation has been enabled by default in both the screen reader and non-screen reader modes for Interactive Reporting documents in the EPM Workspace. You can disable keyboard navigation when the screen reader setting is not active. To disable keyboard navigation, add the parameter: DISABLE_KEYBOARD_NAV_IN_NON_508_MODE=true to the Hyperion Interactive Reporting Service (BI) in Dynamic Service properties through the Configuration and Monitoring Console (CMC). For more information, see Oracle Enterprise Performance Management Workspace, Fusion Edition, Administrator’s Guide.

8646204

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

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

8667869

The End Date setting has no effect for recurring events.

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

10270389

Windows 77/Internet Explorer 8/Microsoft Office 10: Credentials are asked when opening Microsoft Office documents (.doc, .ppt or .xls.)

Workaround: Click “Cancel” when asked for credential in the “Windows Security”.

User Interface and Servlets

Report Number

Description

6564579

When using Smartcuts to navigate Hyperion® SQR® Production Reporting reports, the navigation bar and table of contents become embedded deeper with each report jump.

Workaround: 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.

6575507

All Smartcuts (Get/Run) do not work if file or folder names contain the characters “#” (sharp) or “;” (semicolon).

This issue occurs with Tomcat. If encountered, update web.xml of EPM Workspace application and change the value for the parameter rebuildPathInf to True (false is the default). After the application server restarts, Smartcuts should work as expected.

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 does not appear if bqtype=iHTML tag is specified in the Smartcut.

NOTE: This is true only for Firefox 2003 (not Internet Explorer 6 and Internet Explorer 7) and only for withnav_run (run is fine).

6919606

Configuration fails when the host name is around 64 characters.

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

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.

Workaround: Reconfigure the security provider by disabling authentication for OPTIONS requests.

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. In this case, do the following:

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.

Directory Services

Report Number

Description

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.

6548868

Objects imported from Shared Services do not display until after refresh.

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

6562984

You are unable to open Microsoft Office files in a new window in Internet Explorer running on a Windows 2003 server.

To open Microsoft Office files in a new window in Internet Explorer running on Windows 2003:

  1. Add Workspace URL to the trusted zone.
  2. Enable Automatic prompting for the downloads option for trusted sites.
  3. Disable Use Pop-up Blocker.

6564975

An unexpected message appears when creating or renaming folder or file names with over 80 characters.

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

6570170

Users must be provisioned with Reporting and Analysis roles in order to launch 9.2 Financial Management and Planning applications from within EPM Workspace.

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

Note: If Financial Management and Planning are at version 9.3 or higher, the users do not need to be provisioned with Reporting and Analysis roles.

Services

Report Number

Description

6953800

Retry logic for schedules results in an infinite loop when Interactive Reporting Job Service is not available.

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

Accessibility

Report Number

Description

6590179

Items remaining in the status bar of Internet Explorer do not focus.

After the module is opened, JAWS (Job Access With Speech) reads the contents of the focused item.

6680237

In some circumstances, JAWS (Job Access With Speech) may read more information than required, such as the image URLs.

6833345

Foundation: MAGic does not highlight documents in content area.

When the MAGic screen magnifier is used with the speech option enabled, navigating through the content area using the arrow keys produces unexpected results. The screen reader reads listed documents in correct order but does not highlight them, and the focus does not move. This does not occur when the screen reader is used with the speech option disabled.

Workaround: Change the key bindings for moving from the arrow keys to different keys.

6891858

JAWS (Job Access With Speech) reads the "/" in header as “slash” instead of “root”.

In EPM Workspace Explorer, when the user is browsing the repository, screen readers such as JAWS read the path in the repository as "slash" instead of a more friendly term such as "root."

7122544

Buttons and list boxes seen in 508 accessibility scrolling.

List box controls in Internet Explorer 6 may have rendering problems when EPM Workspace is used in accessibility mode and the display is scrolled. Internet Explorer 7 generally does not have these scrolling issues, although in some circumstances older video cards/drivers may display them. In both Internet Explorer 6 and Internet Explorer 7 some list boxes may render as dropdown controls when in accessibility mode.

7140449

In the File Open dialog, JAWS (Job Access With Speech) announces grid view items and name fields twice.

In some circumstances, screen readers such as JAWS may read items in a grid view twice instead of once. This applies to grid listings such as the Open File dialog and Explorer in EPM Workspace.

7274800

JAWS (Job Access With Speech) does not read the focused data in text fields with Virtual PC off.

In some circumstances, when the focus changes to a text field, JAWS does not read the contents of the text field.

Workaround: Enable Virtual PC Cursor, move the focus away from the text field, and return the focus to the text field. JAWS will read the contents of the text field. However, Virtual PC Cursor must be disabled by the user after switching focus from the text field.

7340649

JAWS (Job Access With Speech) reads menu items after opening new EPM Workspace page.

When pressing Esc to exit the main menu, you must press Esc one more time after the menu closes to remove the focus from the menu bar.

Web Analysis

Report Number

Description

8725988

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

8527806

The Alias Controller, combo box and Dimension Browser button do not work in EPM Workspace.

Workaround: make sure to add the last data source that has an alias controller table attached as the one you would like to display in the combo box.

8527669

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

7716592 

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

6781175

Subscriptions do not render personal variables with different label modes.

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.

6784386

The wrong member displays after drill-up on substitution variable/ancestors/siblings.

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.

6915770

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

7146096

The header sorting options work incorrectly in some cases.

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

7225260

Linked Reporting Objects (LRO) Indicators for Essbase Studio cubes are either shown on all cells or no cells.

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

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 are 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.

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.

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.

7416537

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

8221086

The focus is moved from Web Analysis Studio after some dialogs are accepted.

In Internet Explorer 7, the initial session page receives focus after some dialogs in Web Analysis Studio are accepted.

Workaround: Keep the browser window minimized.

8435885

You cannot add related content to a cell on configuration protected by SiteMinder.

You need to configure SiteMinder to work with Related Content. SiteMinder policy server configuration shortage is detected. The unprotected realm for /workspace/browse/listXML context must end with an asterisk (*) symbol (for example, /workspace/browse/listXML*).

8436335

You cannot log on to Web Analysis Htmlviewer client on configuration protected by SiteMinder.

If you are running WebLogic application server with IIS Web server, and have SiteMinder Web agent configured on IIS, add the WLSendHdrSeparately=ON line to the iisproxy.ini file.

8446612

Export of Web Analysis report to Microsoft Office from EPM Workspace may not work on configuration protected by SiteMinder.

To correct this, 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.  

8541530

You are unable to drill through to an URL report working via Essbase Integration Services if Analytic Provider Services (APS) mode is in use.

8552664

The browser launch page hangs after closing Web Analysis applet.

Internet Explorer process hangs when closing Web Analysis Studio using the Close(X) or Exit button if the applet was launched under JRE 1.5.

Workaround: Close Web Analysis launch page first.

Note: JRE 1.6 is not impacted with this defect.

8613351

New database connections may not be added and saved in database preferences dialog in Workspace in some cases.

Workaround: Database connection entries are added using the following steps:

1. In the Database Preferences dialog, specify the database file location.

2. Select Enter User ID and Password.

3. Click Connect.

4. When connected, specify the alias table you want to use as the default, and click OK.

Saved database connection entries can be edited in order to set the "Use User's ID and Password" or "Prompt for User ID and Password" options.

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.

10269549

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

Migration

Report Number

Description

7603185

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

Hyperion Analyzer 7.0.x migration: the “Member Not Found” error message may appear when opening some Reports if corresponding Essbase data source contains some special European characters in Dimension names or Member names.

Workaround: Rebuild the reports with the known issues.

7603465

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

Hyperion Analyzer 7.0.x migration: The Alias Table for data sources is set to Default for migrated users.

Workaround: Manually update preferences to set desired Alias Table after migration.

8518387

Specific to 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.

Smart View

Report Number

Description

6575786

Refresh and Refresh All do not work if two pages of a Web Analysis report are imported sequentially.

Workaround: Use the All Pages option to import multiple pages of a report.

6871481

You are unable to process CubeQuery section with duplicates against Essbase.

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.

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.

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.

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. You can press the Enter key to follow the link. When this happsens, after selecting Finish to import the page, the imported page is different than the page last displayed in the Preview pane.

7145648

Alias names are not exported to Microsoft Excel in query ready mode.

Alias Member name appears 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.

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.

Defects Fixed in Release 11.1.1.3

Financial Reporting

Report Number

Description

8543028 

When exporting query ready reports, the substitution variable name is exported instead of the value.

6567467 

After import, the .des file information is incorrect.

7628883 

Entity currency setup is in fr_global.properties, not fr_repserver.properties.

Financial Reporting documentation has been changed to indicate that the mappings are defined in fr_global.properties in the HFM Entity Currency section.

7719526 

Running reports against migrated Essbase database does not work.

8214791 

When running any report, the Financial Reporting reports server service crashes.

8373072 

A grid POV, when designed not to be hidden, will only show in html view, not pdf view.

Documentation in the Financial Reporting Studio guide was changed as follows:

The grid POV only displays in a HTML view, and not in a PDF view. In HTML view, the report is interactive, so you can change the Grid POV members, whereas a PDF view is a static document, and you cannot change the grid POV.

8447918 

“Indent increases for each generation by” does not work when “Allow Expansion” is true.

8509993 

The alias for any dimensions in Point of View (POV) in Financial Reporting with client outline does not display.

8539973 

Annotations text disappears as you expand a report with expansions in EPM Workspace.

8540090 

Annotation server places annotations at the substitution variable value.

8540578 

Cannot open the report after edit report permission in EPM Workplace.

8554159 

Unable to update xbrl schemas in Financial Reporting.

8560881 

Basic functionality of manageuserpov utility does not work.

8291162

The annotation paperclip does not display on a report for a cell that has a member with Russian characters in Oracle® Hyperion Planning, Fusion Edition

If your database server is MS SQL Server, when using annotations, there is an issue with storage of context with multi-byte characters, which is how the database fields are defined by default.

To enable annotations to work correctly for multi-byte languages, you must make the following changes to the table definitions:

Table: ANNOT_ELEMENT_VALUES

Field: ELEMENT_VALUE
Original Data Type: varchar(256)
New Data Type: nvarchar(256)

Table: ANNOT_ELEMENT_VALUES

Field: ELEMENT_NAME
Original Data Type: varchar(256)
New Data Type: nvarchar(224)

Field: SOURCE
Original Data Type: varchar(256)
New Data Type: nvarchar(224)

Note: Any annotations associated with a context that has multi-byte content prior to the field type changes are not recoverable.

Interactive Reporting

Report Number

Description

7327249

The Help file for the ToMonth function is unclear.

6586331

When using the Japanese Double Byte Character Set (DBCS) character as an Interactive Reporting file name, the file name gets garbled when printing.

8614682 

Chinese characters do not display in Oracle nvarchar with Oracle Call Interface (OCI) connectivity.

8511833 

Irjobservice crashes with signal sigsegv.

8503461 

Biservice fails to send emails for job actions.

8481610 

Running Hyperion Interactive Reporting reports in Internet Explorer Consumes 100% CPU.

8472748 

Brackets should be enabled when building union queries with object model.

8367921 

Interactive Reporting runs in Version 8 but fails as a job in Version 9.

8280140 

When a document is saved without results, and the slider object is moved, an Unknown Error message is returned.  

8272187 

Setting the Zero Administration flag to No still triggers the download of the Interactive Reporting Web client.

7501142 

You cannot display (Double Byte Character Set) DBCS Japanese Katakana and Hiragana characters using Show Values.

7369845 

The page footer in a report section cannot be resized.

7276805 

The Double Byte Character Set (DBCS) Japanese file name get garbled in printer queue.

7240422 

The Interactive Studio User’s Guide (ir_user.pdf), Page 99,  the SQL statement has been corrected.

6797825 

Iteration of control and shape not necessarily identical.

The documentation infers that the Control and Shape would
iterate identically, but that is not the case.

6592011 

The following error appears in the console when exporting:
Script(x): uncaught exception: Cannot export an empty section.

6584693 

The Customsqlwhere command fails when the customsql window closed.

6533573

Incorrect SQL generation using outer join ODBC options in OCE.

This is a known issue with MSSQL and nested outer joins when the Use Outer Join Escape Syntax option is selected. If nested outer joins are needed, deselect the option.

6750307

Locally saved Interactive Reporting document file is not reloaded in new Web Client after upgrading.

When you open a locally saved Interactive Reporting document file from a server, which was recently upgraded to Release 11.1.1.1, it prompts to upgrade itself. If the browser is Firefox, the Web Client does not reload the Interactive Reporting document after the upgrade. In this case, reopen the document.

7444466

When running an Interactive Reporting job, the backslash (\) between the domain name and the user name is removed.

8285790

A critical error occurs when inserting current date that is too long as header/footer.

Web Analysis

Report Number

Description

8235556

8524154

When drilling down on a report, users are prompted to save even though they do not have the right to save.

8412072

Web Analysis Studio client does not work on Weblogic application server and IIS web server with SiteMinder SSO enabled.

8413998

Some Turkish specific characters in Web Analysis reports do not print from EPM Workspace.

8420219

Alias Controller fails to be displayed in Web Analysis report in Workspace when Use Users ID and Password option is set active for given Essbase database connection file.  

8485551

Charts and images are not exported with Web Analysis report to HTML format.

8522762

Using Vista, column names cannot be read when selecting Restrict Data, and then Select Column.

The header of the interior table gets stretched so that scrolling becomes unavailable and you cannot see the column header names.

Smart View

Report Number

Description

7043849

QueryReady export from EPM Workspaces fails if a Web Analysis report contains localized dimensions.

Dashboard Development Services

Report Number

Description

8407873

Online Analytic Processing (OLAP) results do not appear in local filters.

EPM Workspace

Report Number

Description

6546812

Interactive Reporting Studio Japanese online help Index does not show Japanese (Hiragana) characters.

6582185

When using BI+ IR V9.2.0.x iHTML Excel export functionality, the files get exported with EXCEL ''Web Archive'' format.

The following text was added to the Interactive Reporting section of the EPM Workspace documentation:

If you need to export a section to Microsoft Excel in Web Archive format, you much use EXCEL 2002(Office XP) or EXCEL 2003.

6762711

The End Time field is not updated when using Usage Tracking.

6784087

Day of week shifting of schedules in global environment.

The following text was added to Help in order to clarify the behavior:

Note: When scheduling the Day of the Week option, it is calculated based on the server time.

6913915

The variable date limit timestamp is one hour ahead when the timezone is set to Auckland.

8373311

An error occurs on Firefox when setting a filter on a dashboard on ihtml.

8412921

There are issues with Financial Reporting on the Network Address Translation (NAT) server.

8447504

Executebqydocument.java is in the developer pdf documentation even though it is not supported.

8481337

Siteminder: images in Create New workspace Pages dialog do not display.

6861603

Jobs scheduled to run 10th of the month incorrectly show next run date scheduled on the 12th.

6584698 

The option, Select all Displayed Messages, is missing in the job manager.

8572813 

Content publisher documentation needs correct information on Financial Reporting.

Documentation should state that the Content Publisher provisioning has the ability to delete datasource/database connections in Financial Reporting through EPM Workspace.

8528801 

Credentials do not update for a database connection in the JobService of the Remote Service Configurator.

8523118 

Replicated Service Broker configuration does not work.

8523108 

After Service Fix 2 is applied, exceptions occur once a minute in the service broker log.

8339508 

The User Interface for the Show Parameters selection displays incorrectly.

8299504 

The application should display only generic message to users.

7649154 

Regression: The Custom value of Yesterday adds the Greenwich Mean Time (GMT) offset to the timestamp

7490217 

When adding additional permissions to the Apply Permissions to Children option, the previous permissions are removed.

7424453 

You cannot compile *.jsp files when starting Workspace/Tomcat as a Windows service.

7352785 

A Javascript error on page occurs when successful job generates no output.

7173858 

You are unable to run a Production Reporting job with an Input command from bookmark in personal pages.

7044702

When going to the consolidated job status listing filters, the next run date filter does not run properly.

6997087 

You cannot close a tab in EPM Workspace when performaing a specific operation.

6577635

The logon page of the Hyperion Web applications does not prevent auto-completion of username and password. Therefore, browsers can remember username and password and auto-populate the logon form.

6584506

Documentation was added for "Jobs Only Intelligence Service" functionality.

7495938

In the Workspace User’s Guide, the following note has been added after Output Directory Options section:

Note: A user can list all output formats using a delimiter (;) in the Other Formats text field for Schedule Output Properties. This note will follow Table 134.

8412369

You can only filter job notifications on activities that occurred today.

When using a filter (After, Before, Between) in Job Notifications, the following error occurs: "A general error was encountered contacting the server. Detailed Message 1001120. Recommended Action - contact your corporate technical support.

8440240

Smartcut takes too long when more than 250 objects are in the folder.

Migration

Report Number

Description

8363489 

Migrator.sh does not get created under the hpux installation.

7706493

On Demand Server (ODS) folders structure migrates incorrectly if a child was created prior to parent.

 

Top of Document

Defects Fixed in Release 11.1.1.2

Financial Reporting

Report Number

Description

7504755

The Oracle® Enterprise Performance Management Workspace 11.1.1 User’s Guide shows export of books to Microsoft Excel is supported, but it is not.

The guide incorrectly states that export of books to Excel is supported.

6994960

Export to office: Resized exported Financial Reporting report image to PowerPoint gives xml and red cross when saved.

After exporting Financial Reporting report to Microsoft PowerPoint, then resizing and saving the report image in Microsoft PowerPoint, the report image cannot be viewed the next time the Microsoft PowerPoint slide is opened.

7582614

The Arborpath variable is not set correctly for Financial Reporting during the installation and configuration process.

7579335

The Financial Reporting Studio freezes after inserting a combo chart and selecting the Show Point Values option.

7568152

The e-mail notification from a Financial Reporting Batch Burst fails if the e-mail message text contains a carriage return.

7538742

When you export a Financial Reporting Report to Microsoft Excel, the report header prompt values are displayed all the way on the right in the Microsoft Excel worksheet.

7709310

In EPM Workspace, when you select File, then Print, and then PDF, it displays a PDF of the HTML view of the Financial Reporting report, including the frames.

8214871

You are unable to create a Financial Reporting report with related content using Financial Reporting Studio version 11.1.1.1.00. If you select Add Related Content, and then select the Setup button an empty related content dialog is displayed.

7162994

The string "XBRL Footnote, Associate with" is not translated correctly in Turkish, German, Spanish Swedish and Danish.

7384258

On the Format Cells window, the tab “Inherit Formatting“ is missing.

7458041

When using Oracle Application Server 10.1.3.1, the user receives an error message when attempting to change a member through Member Selection in a Financial Reporting Report.

7212386

In EPM Workspace, when selecting User Preferences, then Financial Reporting, then Setup User POV, and then Setup Members, large buttons with text appears, instead of small icon.

7588801

Performing a search in the Prompt dialog box returns a member not defined in choices list.

7371464

In a Financial Reporting report, when you make a change to a member in a prompt, the Russian characters do not display correctly.

7603881

When exporting a Financial Reporting report to an XBRL instance document, it fails on a non-English operating system.

7589194

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

7454796

You cannot access Oracle® Hyperion Financial Management, Fusion Edition servers using the Financial Management ADM driver in 64 bit environment.

To access Financial Management data sources from Financial Reporting components installed on 64-bit Windows environments, the Server/Cluster Registration entries must be manually populated in the Windows Registry.

To do this on 64-bit Windows machines where Financial Reporting components are installed, after registering the Financial Management server using the Financial Management client/config utility, run regedit and export HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Client\Clusters key.

Edit the .reg file and replace HKEY_LOCAL_MACHINE\SOFTWARE\ with HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\, then double-click the .reg file to import it into the Windows Registry.

 

EPM Workspace

Report Number

Description

 

7659960

The pass-through credentials are erased when restarting services.

7659944

A published SQR job results in an empty output collection with errors.

7623407

A replicated service broker configuration does not work.

When you create a second environment, as a means of providing some load balancing and to continue operating when the "primary" environment fails, you cannot create new content in the repository with only the second environment running.

7611321

If a Financial Reporting row and column template contains more then 26 columns, the column names in the formulas are transposed.

7592942

You are unable to copy and paste after logging out.

A native user with Analyst and Content Publisher roles receives "Could not copy: <filename>.bqy" after importing and copying to folder, then logging out and attempting to copy same BQY after logging back in.

 

7565268

Voice commands associated with clickable icons is needed.

There is no way of knowing how to voice the clickable icons at the top of the page. Visual text beneath them is needed to aid the Dragon user on how to voice them.

 

7496248

Scheduled job cannot be executed on the End Date specified in Recurring Time.

 

7496227

The error "Folder does not exist" occurs when using the Smartcut URL for Double Byte Character Set (DBCS) Japanese folder names and pressing Cancel.

 

6956210

Pass-through credentials are erased when restarting services.

 

6587819

You cannot set locale to simplified Chinese from the Job Cycle page.

 

6586678

The System9 user interface is not fully localized in Korean.

 

6583441

In EPM Workspace, when using the Japanese User Interface (UI), the default country setting is wrong when importing an Interactive Reporting file as a job.

 

6577891

The default locale setting is set to US even though it was installed as a different locale.

 

7674213

Port 7540525  Remote Service Configurator deletion of distributed job factories.

 

7709541

You cannot run query in iHTML client or as a job using metadata OCE.

 

7496255

Do not use SUBSTR() function in auditing SQL. Interactive Reporting does the truncation to 4000 characters itself. The Oracle database throws back an error when the string passed to SUBSTR()is too long, which may break Usage Tracking functionality.

 

 

Embedded Sections Objects

Report Number

Description

7114870

Speed menu control methods are missing from CubeQuery and OLAP Query active embedded sections.

The following methods are absent from the Object Model for the CubeQuery and OLAP Query section: EnableMenuItem() and IsMenuEnabled().

Workaround: Select these actions from the Context menu.

 

CubeQuery

Report Number

Description

7482607

In the Web Client, the ZException might occur on attempt to process large query.

Workaround: In order to get large query processed successfully, increase the value of the DAS property "mdd Partial Result Cell Count", then restart DAS.

 

Interactive Reporting

Report Number

Description

8198078

Interactive BQY document consistently crashes Interactive Reporting Service on Linux only.

7447846

Once an Interactive Reporting jobs has its parameters set, the same parameters are used when setting or modifying new parameter values

7421950

When trying to modify limit, the following error displays: Error parsing 'y'. This entry will be ignored.

6940213

A critical error occurs when accessing a table catalog in an Interactive Reporting document created in EPM Workspace.

6667100

From EPM Workspace html, you cannot export data using the ExportToStream() function when using Double Byte Character Set (DBCS) Japanese characters as the file name.

6639473

The wrong Japanese word comes up using Interactive Reporting Studio 9.2.0.0.3 Japanese User Interface.

6584293

A problem occurs when using 9.2.0.3 Interactive Reporting Studio.

The Japanese translations of some system keywords have changed

6582028

The Japanese translation of default query and pivot section names have changed.

6580450

In EPM Workspace, when opening an Interactive Reporting file with HTML format, the chart section, ''Set Legend On'' shortcut menu is not translated into Japanese.

6569492

You cannot send e-mail notification correctly if ''Additional Message'' contains a specific combination of Japanese characters.

7831765

Invalid SQL generation occurs with Oracle outer join syntax.

 

Web Analysis

Report Number

Description

6814743

You are unable to edit calculations in EPM Workspace when using German language in Internet Explorer (IE).

 

Defects Fixed in Release 11.1.1.1

Financial Reporting

Report Number

Description

6792099

Annotation Manager: Performing a search on annotations does not accept leading wildcards.

In Annotations Manager, when performing a search, the asterisk and question mark (*, ?) characters are not supported at the beginning of a search pattern.

6542627

Application and database icons do not appear correctly in the database connection properties.

The images within the icons are not centered. This does not affect the functionality in any way.

6564837

For Member selection user-defined lists, current Point of View (POV) and prompt functions should not be available for selection.

These two functions are not supported when creating user-defined lists in Member Selection.

6955149

During the import process of a report, if you change the data source for the report, the grid-data source annotations are not retained. The context of the grid-data source annotations becomes invalid once the data source is changed.

7134250

If "Suppress Repeats" for column headings is selected, the annotations paper clip icons do not display.

7139445

If a report contains cell text that is longer then 4KB, then in the adm.properties file entry in C:\hyperion\common\adm9.5.0.0\lib, the value for the MAX_PROPERTY_VALUE_LENGTH=4 should be increased to MAX_PROPERTY_VALUE_LENGTH=6 (for 6KB) if you want ADM to return strings longer then 4K.

7166546

Single quote characters cause errors when used in custom categories.

When specifying custom categories in the annotation.properties file, do not use single quote characters.

7169409

When upgrading from prior releases, the Financial Reporting scheduler.xml file may not be copied during the upgrade process. If this occurs, you must copy the scheduler.xml file from its old location in <BIPlus>\lib to <Hyperion_home>\products\biplus\lib, then, restart the Financial Reporting Scheduler server.

7169754

In annotations, a javascript error occurs when trying to view annotation attachment from the bubble through Planning.

When viewing an annotation with an attachment in a Financial Reporting report run from within Oracle® Hyperion Planning, Fusion Edition Web as a Task List, an error occurs on the page.

Workaround: View the annotation and attachment from within the Annotation Pane in the report.

7172832

In Annotation Manager, wildcard annotation search fails when including capital letters.

When performing wildcard searches that include capital letters, no results are retrieved. Using lower case letters in wildcard searches retrieves the correct results.

7173291

The Description line for Replies is missing for Annotations printed in Portable Document Format. This occurs when the Description detail is check marked in the Annotation Printing Preferences. To resolve this issue:

1.    Select File, then Preferences, then Financial Reporting, and then Annotation Print Details.

2.    Deselect Description in the Use Footnote details.

3.    Click OK.

4.    Click Annotation Print Details again.

5.    Select Description in the Use Footnote details.

6.    Click OK.

7184911

When searching from the annotations view pane for a snapshot report, the snapshot report is not retrieved in the search results.

7192214

In annotations, move the view annotations default User Preference to fr_repserver.properties.

1.   To enable viewing of Annotations by default, add this line to <Hyperion_Home>\products\biplus\lib\fr_repserver.properties: com.hyperion.reporting.HRPrefs.annotations_in_report=true

2.   Restart the Financial Reporting processes.

Dashboard Development Services

Dashboard Builder

Report Number

Description

6600196

 

Calendar is not handling new data type.

Interactive Reporting 11.1.1.1 has introduced a new data type for dates; this is bqDataTypeTimestap. As a result, Dashboard Studio documents that have not been updated using the 11.1.1.1 update kit may experience problems with dates. This affects calendar controls and quick-filters that display lists of dates.

 

User Provisioning

Report Number

Description

71928181

When you reboot the machine with EPM Workspace installed, upon logging into EPM Workspace, the menus for other products do not appear.

If a user attempts to log on while EPM Workspace Web application has started but the EPM Workspace Agent services have not started, the user receives an error message, "Could not find a Hyperion Reporting and Analysis server running on HOSTNAME at port VALUE. Please verify your server connect string and confirm that the server is up."

This message should also specify that the EPM Workspace Agent services should be started before the EPM Workspace Web application. If this message is received, start the EPM Workspace Agent services and restart the EPM Workspace Web application. If the EPM Workspace Web application is not restarted, some menu items may not appear.

7176520

Http 400 error when launching Marketing Product from EPM Workspace.

If Oracle Business Intelligence Enterprise Edition is integrated into EPM Workspace, selecting the menu items for launching Marketing and Disconnected Analytics generates an error message. To resolve this problem, request a service fix from your Oracle support representative.

 

Workspace Agent Services

Report Number

Description

7353255

Connecting/processing Sybase ASIQ connections hangs the Interactive Reporting Web Client.

6943296

The ability to view the SQR Production Reporting job output in HyperText Markup Language (HTML) without displaying the table of contents page is requested.

7130184

In EPM Workspace, Bat files do not support "short" name for Hyperion_Home.

Avoid using a folder name with spaces in it.

Workaround: In StartUi.bat replace AGENT_HOME=%cd% with %HYPERION_HOME%\common\workspacert\9.5.0.0\bin.

7154040

You cannot view a job schedule from the e-mail notification link.

7188206

After installation, the HYPERION_HOME/products/Foundation/workspace/
installableApps/portlets/HyperionW ebPart2007.zip
file is corrupted.

Use: HYPERION_HOME/products/Foundation/workspace/installableApps/portlets/unconfigured/HyperionWebPart2007.zip instead.

1.    Using a text editor, open the Web.config file in the HyperionWebPartProxyPage folder and make these changes:

2.     Replace all occurrences of $GET(appServerProps.workspaceHost) with the full host name of the EPM Workspace server.

3.    Replace all occurrences of $GET(httpServerProps.httpServerPort) with the port number of the EPM System Web Server (for example. 19000 for Apache Web Server).

 

7207890

Web Analysis User Preferences objects Life Cycle Management (LCM) import fails if Preferences object contains links to more than one database connection with assigned database Preferences (such as Point of Views (POVs), Personal Variables (PVs) and/or saved username/password). Such preferences should be manually updated by their owners after Life Cycle Management import.

7168819

Product preferences such as Favorites, Personal Pages and/or Subscriptions definitions are not imported for users who are not provisioned with any Shared Services role.

7168799

WebAnalysis service should be stopped when importing Web Analysis objects.

WebAnalysis services should be stopped during the life Cycle Management Import of WebAnalysis content.

7158271

You are unable to import a Web Analysis report which was modified and then copied in EPM Workspace.

Web Analysis reports, which were first updated in EPM Workspace and then copied with the Copy/Paste Workspace function, cannot be imported through Life Cycle Management (LCM).

Workaround: Web Analysis Documents with issues should be updated in EPM Workspace one more time prior to Life Cycle Management export to File System.

7155598

Using Lifecycle Management to migrate System Application and Products (SAP) and SQL Server Analysis Services (SSAS), Web Analysis database connections are not supported in the current release.

Workaround: To migrate these Web Analysis database connections between environments, you must manually export and import the corresponding Web Analysis documents.

6573300

SQR executable runs in background after a job is cancelled.

-DkillSqrTime: New system property that can help to specify how many minutes to wait for SQR to respond to the term signal before terminating it. The default value is 1, which is 1 minute after the terminate signal. If SQR.exe still runs, it will be terminated.

6818935

SQL query strings cannot be logged in usage query using Double Byte Character Set (DBCS) Japanese characters.

If SQL query strings, which has more than 4000 bytes, are expected to be logged in V8_USAGE_ATTRIBUTES.VALUE but instead there is null, try to start services with -Dut_2byte_char=false.

 

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 Oracle Enterprise Performance Management EPM Workspace, Fusion Edition

Screen Reader and Magnifier Standards

For EPM Workspace, the following text describes settings that must be made for JAWS 9 (Job Access With Speech) as a screen reader and MAGic 10.5 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.

Preferences for JAWS 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

·         Forms mode auto off should be disabled. See JAWS documentation for additional details.

·         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.

·         To set preferences for JAWS: In JAWS Verbosity Options, the Control Group Name preference should be disabled. This prevents redundant reading of controls due to user interface layout. 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 compliments 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

 


 

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

Oracle Enterprise Performance System Logo

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

 


 [SP1]Is this still required?