BI

Oracle Data Integrator 11.1.1.7 available

ODI 11.1.1.7 is now also available for download.  New installs of ODI 11.1.1.7 support Java 1.7 for server components, which I thought was interesting.

New features in this release:

ODI WebSphere Support (Hot-Pluggability)
This ODI release introduces the support of IBM WebSphere Application Server (WAS). ODI Agents and datasources can now be deployed on Oracle WebLogic Server (WLS) and IBM WebSphere Application Server (WAS).

XML Driver Enhancements
Full support for XML Schema constructs by using standard Oracle parser:

  • New JDBC driver parameter compat_mode to indicate the compatibility with mapping modes such as the XDK XSD parser.
  • New JDBC driver command WRITEMAPPINGFILE to help understand the relational structure that has been created for the XSD/DTD file. The mapping file contains the element/attribute name to table/table.column name mapping for each element/attribute.
  • The JDBC command CREATE SCHEMA includes now the compat_mode parameter.

SSL Support for Standalone Agent
The Standalone Agent now supports the SSL protocol for secure connectivity. New parameters added to specify the Standalone Agent server side transport protocol and to configure the SSL truststore and keystore:

  • New environment variables in agent.sh/agent.bat scripts
  • New configuration variables in odiparams.sh/odiparams.bat scripts
  • Java system properties in odiparam.sh/odiparams.bat scripts

Include EDQ Open Tool in ODI Core
The EDQ Open Tool introduced in ODI 11gR1 PS2 ( 11.1.1.6) to invoke an Oracle Enterprise Data Quality (Datanomic) Job is now available as a standard ODI tool. The OdiEnterpriseDataQuality tool includes a new, optional parameter to connect MBean domains.

 

From an EPM perspective, we just scratch the surface of what ODI can do.  Most of my clients are operating under the limited use license that comes with Planning and/or HFM.   ODI is a great tool that allows some great automation to be built for EPM administrators, though.  Most of my experience with ODI has been replacing old HAL routines during Planning application upgrades, so these features don’t really change the game very much for me.

If you want it, here it is; come and get it:  Oracle Data Integrator Downloads.

Advertisements

OBIEE 11.1.1.7 is now available

OBIEE 11.1.1.7 is now available for download from Oracle.  Please visit the links below for the downloads.

New Features:

Recommended Visualizations Feature for Creating Views

In this release, when you create a view, you can choose a recommended view type based on the data in your analysis and, optionally, what you want to use it for (for example, to analyze trends).

You can choose a suggested “Best Visualization” as well as a “Recommended Subtype”. Or you can instead choose the “Recommended Visualization” option, for which you specify your intent for the new view. For example, will the view compare values, compare percentages, visualize trends, or something else? From a list of suggested view types that is ordered with the best option at the top, you can then choose your preferred view type. See “What Is the Recommended Visualizations Feature?” for more information.

Breadcrumbs

Breadcrumbs have been added to help users understand their current location within Oracle BI content and the path that they have used to navigate Oracle BI content. Breadcrumbs display at the bottom of the page, and users can click a breadcrumb or the breadcrumb overflow button to navigate to a specific location on their breadcrumb trail. See “Navigating With Breadcrumbs” for more information.

Enhancement to Dashboards

This release provides the following enhancements to dashboards:

  • The ability to create custom print layouts for high-fidelity printing of dashboard pages. See “About Creating Custom Print Layouts for High-Fidelity Printing of Dashboard Pages”.

  • The new default style is FusionFX. See the “Dashboard Properties dialog”.

  • The addition of the Freeze Column option to the Column Properties menu. This option allows you to freeze a column at an edge (top or left) of a dashboard layout. See “Properties Buttons for Objects”.

  • The addition of the following options that allow you to control the position and size of columns and sections:

    The ability to export an entire dashboard or a single dashboard page to Microsoft Excel 2007+. See “Exporting Dashboards and Dashboard Pages”.

  • The addition of options to replace an analysis on a dashboard and to return to a dashboard from the Analysis editor:

    • The Replace analysis in <dashboard name> option was added to the Save As dialog. This option displays when the user is viewing a dashboard, clicks an embedded analysis’ Analyze or Edit link, edits the analysis, and selects Save As to rename and save the analysis. The Replace analysis in <dashboard name> option allows the designer to choose to include the modified analysis on the dashboard. See “Save As dialog” for additional information.

    • The Return to <dashboard name> option was added to the Analysis editor. This option displays in the Analysis editor when the user is viewing a dashboard and clicks an embedded analysis’ Analyze or Edit link. The designer can click this option to easily move from the Analysis editor to the dashboard. See “Analysis editor” for additional information.

Enhancements to Graphs

In this release graphs have been enhanced in various ways.

  • New graph types include:

    Zoom to data range. This option lets the system evaluate the range of values on an axis, and choose appropriate minimum and maximum values for the scale. This is useful when graphing a set of large values that are all within a small percentage of each other. See “Graph Properties dialog: Scale tab” for additional information.

    • Waterfall graph. A waterfall graph lets you visualize how a value increases or decreases sequentially and cumulatively. An initial value is summed with subsequent values (both negative and positive changes or deltas) to arrive at an end value, focusing your attention on h ow each measure contributes to the whole.

    • Stacked graph as a new subtype to the area graph. A stacked graph is useful for comparing the proportional contributions within a category. A stacked graph displays the relative value that each part contributes to the whole.

    • 100% stacked graph as subtypes to the bar graph and the area graph. A 100% stacked graph, like the stacked graph subtype, lets you compare the parts to the whole. But while the stacked graph shows cumulative total in the units of the measure, the 100% stacked graph always shows units as percentages of the total, and the axis scale is always zero to 100 percent.

    See “What Types of Graphs Are Available?” for additional information about the new graphs in this release.

  • Hide sliders in graph views that listen to master-detail events. For graphs in master-detail relationships, if you want to simplify the appearance of an analysis or dashboard, you can hide the slider that is created to accommodate detail columns. See “Defining the Detail View” for more information.

Enhancements to Views

This release includes enhancements to various view types, including those in the following list:

  • A new view type named performance tile. This view type displays a single aggregate measure value in a manner that is both visually simple and prominent. See “Editing Performance Tile Views” for additional information.

  • Action links in trellis views. In simple trellis views, action links can now be used on inner graphs per unit, including the context of the outer edges. Action links can also be used in legends and in axis labels. In advanced trellis views, action links can be used in microcharts, where the microchart functions as a single unit (such as an aggregate number), including the context of the outer edges. For more information, see “What Are Action Links and Action Link Menus?”

  • For map views:

    Null suppression at view and analysis levels. You can set null suppression options at the view level (which overrides the analysis level) for data views including: table, pivot table, trellis (both simple and advanced), graph, gauge, and funnel views when the entire row or column contains nulls. See “Understanding Null Suppression” for additional information.

    • Vary the width of a line by measure to accentuate a feature. See “Line (Layer) dialog” for additional information.

    • Link a map view as a detail in a master-detail relationship. See “Defining the Detail View” for additional information.

    • Auto Correct option. A map view error can occur for various reasons. If the issue appears to be related to missing layers, maps, or styles, then it might be possible to correct the map by replacing the missing map view components with similar items that exist in the spatial metadata. See “Editing Map Views” for additional information.

    • Legend and formatting highlighting. See “What Are the Components of Map Views?” for additional information.

  • Ability to include or exclude calculated items and groups at the view level for columns and column headers. Specifically, two new options have been added:Include Custom Member and Exclude Custom Member. These interactions are available for tables, pivot tables, and trellises. See “Creating Groups and Calculated Items” for additional information.

  • For tables, pivot tables, and advanced trellises, the ability to:

    Row count. If your table or pivot table view contains a grand total or subtotal on the row edge, the display totals, that is the grand total and subtotals, are now included in the Rows per Page count for content paging. In prior releases, if you had the Rows per Page count set to 10 for example, the table or pivot table would display more than 10 records if display totals were shown in the view results. See “Editing Views” for additional information.

  • For right-click interactions, the ability to specify whether the Hide Columns interaction is available at runtime. See “Right-Click Interactions in Views” for additional information.

Enhancements to Prompts

This release includes enhancements to prompts, including those in the following list:

  • This release includes an enhancement to the SQL Results prompt option. If you are working with double columns, you can now write the SQL statement so that filtering is done on code values rather than display values. For more information, see “New Prompt dialog”.

  • This release includes an enhancement to the prompt constraint option. The prompts designer can now limit a column prompt value list by more than one column. For more information, see the Limit values by component in the “New Prompt dialog”.

  • This release includes enhancements to the parameters for prompted links. For more information, see “What Are Prompted Links?”.

New Menu Options for Exporting Views and Results

This release adds the Excel 2007+ and Powerpoint 2007+ options for exporting views and results.

See “Export Menu Options for Views and Results”.

Total Member Placement for Hierarchical Columns

This release includes an enhancement that allows placement of total members on a hierarchy. See “Analysis Properties dialog: Data tab” for additional information.

Browse Catalog Search Results by Object Attributes

This release provides the capability to use full-text search to find catalog objects and then filter the search results by attributes. This search is available when the administrator integrates Oracle BI Enterprise Edition with Oracle Endeca Server. After the full-text search results are returned, the Catalog area displays a list of matching items, and the Search pane displays the search results grouped by attribute (that is, Type, Name, Path, and Created By). See “What Results are Returned from a Full-Text Catalog Search?” for additional information.

Navigate from the Total or Grand Total in a Table or Pivot Table

If an analysis contains a total or grand total and the associated attribute or hierarchical column contains an action link or a conditional action link, the action link (or conditional action link) is applied to both the column and the total or grand total. See “What Are Actions?” for additional information.

New BI Desktop Tools Available for Download

This release adds the following tools to the list of BI desktop tools that are available for download:

  • Oracle Hyperion Smart View for Office

  • Oracle Hyperion Financial Reporting Studio (if Essbase is installed)

  • Oracle Essbase Studio Console (if Essbase is installed)

  • Oracle Essbase Administrative Services Console (if Essbase is installed)

See “Downloading BI Desktop Tools” for additional information.

Enhancement to Favorites

This release provides the capability to organize your favorites from the Category Tree area and the Selected Category area in the Manage Favorites dialog. In previous releases, you could organize favorites from the Category Tree area, only. See “Organizing Favorites” for additional information.

Integration of Oracle BI EE with Oracle Enterprise Performance Management System

With this release, Oracle BI EE is integrated with Enterprise Performance Management Workspace. See “Integration of Oracle BI EE with Oracle Enterprise Performance Management System”.

So, Smart View 11.1.2.2.310 functionality with OBIEE can now be used.  I would expect the hits to keep coming from Oracle, EPM 11.1.2.3 should probably be released soon as well so check back for more information on that as well.

Download now: Oracle Business Intelligence (11.1.1.x) Downloads.

Documentation link – http://docs.oracle.com/cd/E28280_01/bi.htm

Oracle Knowledge Base article 1488475.1

I have a colleague that has become quite the OBIEE expert over the last few months.  She loves OBIEE sometimes more than others, especially given the amount of patches that have come out.

A couple of months ago I upgraded her OBIEE implementation at a client to 11.1.1.6.7, but I noticed today that a new round of OBIEE patches were available.  So, how do you find out what patches are available?  Log into Oracle Support (https://support.oracle.com) and search the Knowledge Base for article 1488475.1.  This article lists the patches available for various releases of OBIEE 11g.

OBIEE 11.1.1.6.8 consists of the following:

  • Patch 16094198
  • Patch 16094192
  • Patch 16080520
  • Patch 16094205
  • Patch 16094211
  • Patch 16067995
  • Patch 16097082

This patch set was released on February 5, 2013

This is a cumulative bundle patch to go on top of current 11.1.1.6.X releases  (excluding FA 11.1.1.6.3.X).

Patch 16094198 (1 of 7) Oracle Business Intelligence Installer. (generic)

Patch 16094192 (2 of 7) Oracle Real Time Decisions. (generic)

Patch 16080520 (3 of 7) Oracle Business Intelligence Publisher. (generic)

Patch 16094205 (4 of 7) Oracle Business Intelligence ADF Components. (generic)

Patch 16094211 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port-specific)

Patch 16067995 (6 of 7) Oracle Business Intelligence. (port-specific)

Patch 16097082 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer  (generic)

Note:

The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch.

This patch is cumulative, and therefore contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6 and 11.1.1.6.7 patch sets.

However, lists of fixes from included patch sets need to be looked up in the respective patches’ readme files, and are not included in the above patches’ readme files.

The instructions to apply the above patches are identical, and are contained in the readme file for patch 16094198.

Please bear in mind, that the readme states to apply patch 13952743 for JDeveloper, too.

Oracle Hyperion Smart View Release 11.1.2.2.310

On February 18, 2013, a new patch for Smart View was released: 11.1.2.2.310.  This release holds some pretty interesting new features that foreshadow the release of OBIEE 11.1.1.7.

New Features:

  • Support for OBIEE through Smart View (if you are on OBIEE 11.1.1.7)
  • New VBA functions to interact with OBIEE
  • Shared Connections can be stored in an XML file (used to provide access to OBIEE through Shared Connections).  Could be pushed with a software install to new users for example.
  • New document contents pane.  Think of this as a table of contents for Smart View information located in your Office document.
  • HsGetValue functions can be copied and pasted between files or Office applications (Why are you using HsGetValue? Hyperion Enterprise is dead, people.).
  • Support for Shared Connections in functions.  This is a nice feature for people building reports using Smart View.
  • New reporting object called an Office Table.  These are for Word only and look like a part of the Word document, but are refreshed using a Smart View connection.  Allows users to format the table using Word formats, but members and data come from Smart View.  That could be interesting for management or tax reporting that is done using Word.
  • POV will now support 5000 members.

Basically download the patch #16238382 and install using the SmartView.exe, or by auto deploy, or from Workspace, or now from OBIEE apparently.

One little gotcha that I found was that the Windows 64-bit version of 16238382 does not include both the 32 and 64 bit installers as previous Smart View patches have.  Keep that in mind if you are used to just grabbing one of the Smart View patches like me.

Here’s a link to Oracle’s Documentation Library for the 11.1.2.2.310 release of Smart View:

Oracle Hyperion Smart View for Office Documentation Release 11.1.2.2.310.

 

UPDATE – March 7, 2013:

Oracle has been contacting anyone that has downloaded this patch to inform them that the patch now includes the version.xml file that was originally missing in the patch.  The version.xml is needed to do automatic updates to Smart View through Workspace.  Setting up automatic updating is something that I normally don’t do because many users don’t have administrator rights on their computers.