Tuesday Aug 05, 2014

OBIEE 11g: Configuration Management for OBIEE in Enterprise Manager Cloud Control 12c

(in via Senthil)

The Oracle Business Intelligence Enterprise Edition (OBIEE) support team have provided a new knowledge article for OBIEE configuration management:

OBIEE 11g: Configuration Management for OBIEE in
Enterprise Manager Cloud Control 12c
Doc ID 1912834.1

This article will assist in understanding how to use Enterprise Manager Cloud Control to manage OBIEE configurations and includes:

  • Compare configuration data to detect changes
  • Compare patches applied across different systems
  • Create custom Comparison Templates
  • Use Configuration Extensions to collect additional files/data

The article also assists in identifying changes in configuration that maybe resulting in differences in the behavior of similar systems.

The content by itself will not fix "performance" but its use is beneficial to identify differences in configuration between slow and fast performing systems that would be expected to behave the same.

An article of interest relating to slow performing Dashboards ... visit:

OBIEE 11g: How To Diagnose Slowly Performing Dashboards
using Enterprise Manager Cloud Control
Doc ID 1668236.1

Wednesday Jul 16, 2014

OBIEE 11.1.1.7.140715 Bugs Fixed List

Following on from the OBIEE Version 11.1.1.7.140715 release information ...

... a Knowledge article has been made available providing a Bugs Fixed listing. The following "Doc ID" link will access the Knowledge article directly from "My Oracle Support":

OBIEE 11g: Bugs Fixed in 11.1.1.7.140715
Doc ID 1907639.1

This article provides a list of the bugs fixed in each of the components contained within the OBIEE 11.1.1.7.140715 Patch Bundle download.  It is divided into eight sections for each of the patch components.

Ensure to review the Patch Bundle Readme document for important information. The Readme file is available via the MOS | Patches & Updates screen when downloading the OBIEE Patch Bundle.

Tuesday Jul 15, 2014

OBIEE Version 11.1.1.7.140715

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11g 11.1.1.7.140715 Bundle Patch is now available to download via My Oracle Support | Patches & Updates.

This is provided as single Bundle Patch  Patch  18818588 and is comprised of the following:

  • 1 of 8 Oracle BI Installer (BIINST) - Patch 16913445
  • 2 of 8 Oracle BI Publisher (BIP) - Patch 18841070
  • 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM) - Patch 18657616
  • 4 of 8 Oracle BI Server (BIS) - Patch 18841084
  • 5 of 6 Oracle BI Presentation Services (BIPS) - Patch 18841078
  • 6 of 8 Oracle Real-Time Decisions (RTD) - Patch 17300045
  • 7 of 8 Oracle BI ADF Components (BIADFCOMPS) - Patch 16997936
  • 8 of 8 Oracle BI Platform Client Installers and MapViewer - Patch 18841089

NOTE: Also required to be downloaded:

Patch 16569379 - Dynamic Monitoring Service patch

For compatibility of Enterprise Manager pages with Internet Explorer 11:

Patch 18277370 - Merge Request On Top Of 11.1.1.7.0 For Bugs 18071063 18176711

This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition

  • 11.1.1.7.0,
  • 11.1.1.7.1,
  • 11.1.1.7.131017,
  • 11.1.1.7.140114,
  • 11.1.1.7.140225,
  • 11.1.1.7.140415 and
  • 11.1.1.7.140527


NOTE: It is also available for Exalytics customers who have applied the Exalytics PS3 patch.


For more information refer to:

OBIEE 11g 11.1.1.7.140715 Bundle Patch is Available for OBIEE and Exalytics [Doc ID 1907571.1]


The OBIEE Suite Bundle Patches are cumulative - the content of the previous 11.1.1.7.x bundle patches are included in this latest bundle patch.

Ensure to review the Readme documentation for further important patch information. 
This is available via the My Oracle Support | Patches & Updates screen when downloading.

Keep up to-date with the latest OBIEE Patches and Patch Set Updates by visiting:

OBIEE 11g: Required and Recommended Patches and Patch Sets [Doc ID 1488475.1]


Monday Jul 14, 2014

OBIEE Sample App V406 - Learn More

The OBIEE Sample App v406 was recently released as outlined in Blog posts:

OBIEE Sample App V406 is available via OTN
OBIEE Sample App V406 - Try It Live

The Oracle BI TechDemo team have made available videos to further assist with OBIEE Sample App v406.

These short sessions are available via:

YouTube "Oracle BI TechDemo" channel


OBIEE Sample App v406 Videos Link

Sample App Explained
- An overview of what SampleApp is, why you need it and what you can do with it. [4:35]

Whats New in SampleApp v406
- Discusses what is new in the latest release of SampleApp v406 that is available via Oracle Technology Network (OTN). [5:05]

SampleAppv406 Adding Disk Capacity
- Details the process for adding additional disk storage to the SampleAppv406 virtual box deployment. [4:44]

ODM Workflows in Sample App
- Shows examples of the Oracle Data Miner Workflows that are included in the OBIEE SampleApp v406. [5:24]

BIApps Plug-in for SampleApp 406
-Discusses the BI Apps Plug & Play option for SampleApp v403. This video is compatiable for v406 release as well. [3:21]

Disclaimer:
The SampleApp contents and its code are distributed free for demonstrative purposes only. It is neither maintained nor supported by Oracle as a licensed product.

Thursday Jul 03, 2014

OBIEE Sample App V406 - Try It Live

(in via Ian & Martin)

The OBIEE Tech Demo Team have released the Oracle Business Analytics Enterprise Edition (OBIEE) URL for:

OBIEE SampleApp V406 - "TRY IT LIVE"

Further to the previous Blog post "OBIEE Sample App V406 is available via OTN" that provides information for downloading the Sample App, access is now available to this new release via the "TRY IT LIVE" option.

The "TRY IT LIVE" option provides access to a Sample App V406 "Demo" Virtual Image. This allows quick access without the need to download and install.

SAMPLEAPP V406 - TRY IT LIVE

To access the OBIEE Sample App V406 URL:

  • visit Oracle Technology Network (OTN) OBIEE Samples
  • select the "Try It Live" icon
  • enter the User ID and Password as detailed on the Log-In screen

Disclaimer:
The SampleApp contents and its code are distributed free for demonstrative purposes only. It is neither maintained nor supported by Oracle as a licensed product.


Friday Jun 20, 2014

Oracle BI Mobile App Designer v2 is Now Available

( in via Paul R. )

The News:
Oracle BI Mobile App Designer (BIMAD) v2 is a major release that incorporates significant new capabilities, including:

  • New map visualization
  • Better navigation and contextual awareness
  • App level filters and calculated field support
  • Completely re-designed calculated field editor UI
  • An improved property pane, plug-in SDK, and playground
  • New app theme that matches the modern iOS 8 look and feel

What’s New

  • Exploration Template
    Including, drag & drop for drop down list and range filter, breadcrumbs for currently selected values, filter with dropdown and range slider, single and multi-value select support.
  • Sidebar
    New way to quickly drill down to show detail data of your interest. Including drag & drop for creating vertical table, 'Group By' support, standard filter, sorting and calculated field support.
  • New Map Visualization
    It is designed from the ground up for business users to easily visualize their data with Map and to interact on mobile devices to zoom, filter, and drill down.
  • New Custom Map
    On top of the pre-seeded map types for US states, US counties, etc, it allows customers to add their own regions and maps by simply uploading their own geoJSON files for polygon boundaries. Flexible custom keyword matching is also included as well as support for native interaction and filtering.
  • Completely Redesigned Authoring UI
    Redesigned, modern and easy to use property pane, simplified toolbar, consistency across various components and support for multiple component selection to set and update configuration all at once.
  • New Set of Functions with Redesigned Calculated Field
    Calculated Field Editor (previously,'Formula Editor') has been re-designed from the ground up to make the creation of custom calculated fields a lot more intuitive and simple yet flexible with a set of newly introduced functions.
  • Application Level Calculated Fields and Filters
    Filters and Calculated Fields can now be created and managed centrally at App level. Users can drag and drop to assign Calculated Fields to any component and assign Filers from the newly re-designed Property.
  • Plugin SDK and Gallery
    Download SDK with sample data, enjoy offline development, a plugin 'playground' with dynamic refresh, remote publish and a standard set of APIs to leverage BIMAD interactive filtering. A new plugin gallery is also included to make existing plugins easy to browse, find and download/upload.
  • And much more, including
    o    Type search in BI Mobile Apps Library
    o    Upload with drag and drop to refresh Excel data files and upload / replace images
    o    Share via QR code, link to copy and embed within web pages, blog posts and applications

Where can I find more information?

(layout and post: Torben, authorized: Lia)

Friday Jun 13, 2014

OBIEE Sample App V406 is available via OTN

(in via Ian )

OBIEE SampleApp V406 virtual box appliance
is now available for public download from  OTN.

( VirtualBox Image (includes OEL6.5, Mobile App Designer v2 & Oracle Database 12c and more) )

OBIEE Sample Application V406 combines a

  • BI-platform
  • ad-hoc queries
  • Dashboards
  • Enterprise Reporting
  • Mobile Analytics
  • Scorecards
  • Multidimensional OLAP
  • and more

in a standalone virtual box image, creating a comprehensive OOB collection of examples and integrations designed to demonstrate Oracle BI capabilities, product integrations, and design best practices.

The OTN Public V406 image appliance is a collection of OBIEE examples demonstrating capabilities of 11.1.1.7.1 OBIEE stack, as well as some design best practices.

V406 image is an enhanced version of the earlier Internal V403 version. V406 includes latest code patches, several bug fixes, new ODM content examples, new workshops and new datasets.

It does ">not include Cloudera installation.

SAMPLEAPP V406 HIGHLIGHTS

  • Latest GA Software & Patches
    Oracle Db 12c PDB, OBIEE 11.1.1.7.1 (two instances), EID 3.1, BI MAD V2, TT 11.2.2.6, Oracle Loader for Hadoop, Oracle SQL Connector for HDFS
  • Mapviewer html5 JS integration, Integrated ADF visualizations
  • New BIMAD V2 examples and BIMAD plugins
  • Enhanced OAA integration : ODM Workflows, new ORE scripts
  • EPM and BIApps Companion plug-ins to V406, EID Demos, Domain Demos, Workshops, MVDemo
  • Custom Interactions & Configurations Examples

Find the release documentation (zipped) here.

Instructions:

Download all zip files into a single directory (approx 28.5 GB).
Optionally verify integrity of zip files using checksums.
Open a zip file manager such as 7zip and select the first zip file (001) and extract.
This will extract a compressed VMDK file, and .ovf file into Sampleappv406appliance folder.
Open VBox Manager, select Import, navigate to the directory, select the .ovf file and click import.
After import the initial image size is about 67 GB.

Disclaimer:
The SampleApp contents and its code are distributed free for demonstrative purposes only.
It is neither maintained nor supported by Oracle as a licensed product
.

The last previous release was also blogged here:
https://blogs.oracle.com/proactivesupportEPM/entry/obiee_11_1_1_73

We recommend to use the videos on the Youtube Channel "Oracle BI Techdemo" to get started with the OBIEE Sample Apps.

Update: 23 September 2014: Sample App FAQ:


    (layout and post: Torben, authorized: Lia)

    Use Enterprise Manager Cloud Control to monitor OBIEE 11.1.1.7.x Dashboards

    (in via Senthil

    If your OBIEE 11.1.1.7.x is set up in the following way:

    1. The OBIEE repository is an Oracle Database and is set up as a data warehouse
    2. Usage tracking is enabled in OBIEE.
      ( For information on how to enable usage tracking in OBIEE, refer to the following link: Setting Up Usage Tracking in Oracle BI 11g )
    3. The OBIEE instance is discovered in EM Cloud Control.
      ( For information on how to discover an OBIEE instance in Cloud Control, refer to the following link: Discovering Oracle Business Intelligence Instance and Oracle Essbase Targets )
    4. The OBIEE repository is discovered in EM Cloud Control.
      ( For information on how to discover an Oracle database, refer to the following link: Discovering, Promoting, and Adding Database Targets )

    then we've got news for you:

    KM Article:  OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

    takes you step by step through monitoring the SQL query performance behind your OBIEE dashboard.

    This Diagnostic approach ...

    • .. will help you piece together information on BI dashboard performance, e.g. processing time from the different layers of the BI system including the repository.
    • .. should enable you to get to the bottom of slow dashboards by using the wealth of information available in EM Cloud Control on OBIEE and Oracle DB.
    • .. will NOT fix any performance issues on its own, but will help identify bottlenecks while processing dashboard requests.

    (layout and post: Torben, authorized: Lia)

    Thursday Jun 05, 2014

    OBIEE 11.1.1.7.140527 bugs fixed list

    For anyone interested the bugs fixed list for OBIEE 11.1.1.7.140527 is now available

    OBIEE 11g: Bugs Fixed in 11.1.1.7.140527 (Doc ID 1678846.1)

    Wednesday May 28, 2014

    OBIEE Version 11.1.1.7.140527 Now Released

    (in via Martin)

    The Oracle Business Intelligence Enterprise Edition (OBIEE) 11g 11.1.1.7.140527 Bundle Patch is now available to download via My Oracle Support | Patches & Updates.

    This is provided as single Bundle Patch  Patch  18507268 and is comprised of the following:

    Patch 16913445 - 1 of 8 Oracle BI Installer (BIINST)
    Patch 18507640 - 2 of 8 Oracle BI Publisher (BIP)
    Patch 18657616 - 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
    Patch 18507802 - 4 of 8 Oracle BI Server (BIS)
    Patch 18507778 - 5 of 6 Oracle BI Presentation Services (BIPS)
    Patch 17300045 - 6 of 8 Oracle Real-Time Decisions (RTD)
    Patch 16997936 - 7 of 8 Oracle BI ADF Components (BIADFCOMPS)
    Patch 18507823 - 8 of 8 Oracle BI Platform Client Installers and MapViewer


    NOTE:
    Also required to be downloaded:
    Patch 16569379 - Dynamic Monitoring Service patch

    This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition

    • 11.1.1.7.0,
    • 11.1.1.7.1,
    • 11.1.1.7.131017,
    • 11.1.1.7.140114,
    • 11.1.1.7.140225 and
    • 11.1.1.7.140415

    NOTE:
    It is also available for Exalytics customers who have applied the Exalytics PS3 patch.


    For more information refer to:

    OBIEE 11g 11.1.1.7.140527 Bundle Patch is Available for OBIEE ( Doc ID 1676798.1 )


    The OBIEE Suite Bundle Patches are cumulative - the content of the previous 11.1.1.7.x bundle patches are included in this latest bundle patch.
    Ensure to review the Readme documentation for further important patch information. 
    This is available via the My Oracle Support | Patches & Updates screen when downloading.

    Keep up to-date with the latest OBIEE Patches and Patch Set Updates by visiting

    OBIEE 11g: Required and Recommended Patches and Patch Sets (Doc ID 1488475.1 )


    Monday May 12, 2014

    OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide

    (in via Steve)

    We want to take this opportunity to highlight a document that has been written by one of our OBIEE Advanced Resolution Engineers (thanks Steve).


    OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide
    Doc ID 1625533.1


    This document is intended to assist with the test-to-production (T2P) process for an Oracle Business Intelligence Enterprise Edition (OBIEE) installation i.e. cloning. 

    The documentation has steps that are posted in various sections of the Fusion Middleware Administration Guide; therefore, the intent of this document is to link all the steps together in a "cookbook" format to make the process easier to follow and help one to avoid common pitfalls or mistakes. 

    The intended audience are OBIEE and Fusion Middleware Administrators who have access to the environment and are able to run scripts providing the appropriate variables.

    For questions or an issue that you can not identify - visit the OBIEE Community as a first step on your way to a solution:

    • My Oracle Support Community (MOSC) OBIEE


    Wednesday Apr 23, 2014

    Oracle BI Mobile For Android Now Available

    The Oracle Business Intelligence Mobile app for Andriod is now available via the Google Play Store.

    The Oracle Business Intelligence (BI) Mobile app provides a full range of BI functionally, from interactive dashboards to location intelligence, and allows business processes to be initiated directly from the mobile device.

    Oracle BI Mobile for Android is a mobile analytic app that allows you to view, analyze and act on Oracle Business Intelligence 11g content.

    • Using Oracle BI Mobile, you can view, analyze and act on all your analyses, dashboards, scorecards, and reports all on the go.

    • Oracle BI Mobile allows you to drill down on reports, apply prompts to filter your data, view interactive formats on geo-spatial visualizations, view and interact with Dashboards, KPIs and Scorecards.

    • Advanced features include Android Beam (NFC) report and connection sharing, voice commands and voice search, and search suggestions.

    This app is compatible with Oracle Business Intelligence 11g, version 11.1.1.6.2BP1 and above.

    The documentation is available from the Oracle Documentation Library - direct link:

    Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Mobile for Google Android 11g Release 1 (11.1.1)

    https://play.google.com/store/apps/details?id=com.oracle.obi Available for download on an Andriod Device via the Google Play Store:
    https://play.google.com/store/apps/details?id=com.oracle.obi

    Interested in more information on BI Mobile?

    Visit the BI & Analytics Pulse Wiki page for a discussion by Product Development:

    BI Mobile: What’s the Deal with Android?


    Version: 11.1.1.7.0.76
    Date: Apr 18, 2014
    Size: 1.3M

    My Oracle Support Knowledge Article reference:
    OBIEE 11g: Is There An Android Application? [Doc ID 1167499.1]

    Oracle BI Mobile HD 11.1.1.7.0.2397 Now Available

    The Oracle Business Intelligence Mobile HD app has been updated, with Version 11.1.1.7.0.2397 now available from the Apple iTunes store.

    The Oracle Business Intelligence Mobile is designed for Apple iPhone and iPad. It is a mobile analytics app that allows you to view, analyze and act on Oracle Business Intelligence 11g content.

    • Using Oracle Business Intelligence Mobile, you can view, analyze and act on all your analyses, dashboards, scorecards, reports, alerts and notifications on the go.

    • Oracle Business Intelligence Mobile allows you to drill down reports, apply prompts to filter your data, view interactive formats on geo-spatial visualizations, view and interact with Dashboards, KPIs and Scorecards.

    • You can save your analyses and Dashboards for offline viewing, and refresh them when online again; thus providing always-available access to the data you need.

    • This app is compatible with Oracle Business Intelligence 11g, version 11.1.1.6.2BP1 and above.


    What's New in Version 11.1.1.7.0.2397

    - Bug fixes including prompts, stability and much more
    - iPhone UI update and general clean-up
    - MAD external links open in Safari


    Now available for download via Apple store [ Link]



    Version: 11.1.1.7.0.2397
    Updated: Apr 18, 2014
    Size: 17.2 MB

    Wednesday Apr 16, 2014

    OBIEE Version 11.1.1.7.140415 Now Released

    The Oracle Business Intelligence Enterprise Edition (OBIEE) 11g 11.1.1.7.140415 Bundle Patch is now available to download via My Oracle Support | Patches & Updates. 

    This is provided as single Bundle Patch  Patch 18283508 and is comprised of the following:

    • Patch 16913445 - 1 of 8 Oracle BI Installer (BIINST)
    • Patch 18290942 - 2 of 8 Oracle BI Publisher (BIP)
    • Patch 17891247 - 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
    • Patch 18291001 - 4 of 8 Oracle BI Server (BIS)
    • Patch 18290979 - 5 of 6 Oracle BI Presentation Services (BIPS)
    • Patch 17300045 - 6 of 8 Oracle Real-Time Decisions (RTD)
    • Patch 16997936 - 7 of 8 Oracle BI ADF Components (BIADFCOMPS)
    • Patch 18291015 - 8 of 8 Oracle BI Platform Client Installers and MapViewer

    NOTE: Also required to be downloaded:

    Patch 16569379 - Dynamic Monitoring Service patch

    This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0, 11.1.1.7.1, 11.1.1.7.131017, 11.1.1.7.140114 and 11.1.1.7.140225. 

    NOTE: It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

    For more information refer to:

    OBIEE 11g 11.1.1.7.140415 Bundle Patch is Available for OBIEE and Exalytics
    Doc ID 1663101.1

     The OBIEE Suite Bundle Patches are cumulative - the content of the previous 11.1.1.7.x bundle patches are included in this latest bundle patch.

    Ensure to review the Readme documentation for further important patch information.  This is available via the My Oracle Support | Patches & Updates screen when downloading.


    Keep up to-date with the latest OBIEE Patches and Patch Set Updates by visiting

    OBIEE 11g: Required and Recommended Patches and Patch Sets
    [Doc ID 1488475.1]

    Friday Apr 11, 2014

    OBIEE 11.1.1.6.x - End of Error Correction Support

    Following on from a previous Blog post ...

    A reminder that the "Error Correction Support" for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.x. ended on 2nd April 2014.


    For more information refer to:

    OBIEE 11.1.1.6.x: End of Error Correction Support
    Doc ID 1642219.1



    Every version within a product's life cycle has an "End of Error Correction Support" after a defined Grace Period" date. 

    OBIEE 11.1.1.6.12 was the Final Regular Bundle Patch and Error Correction Support in Product Life Cycle for OBIEE 11.1.1.6.x. It will continue to be supported under the Lifetime Support Policy.

    For assistance on upgrading to OBIEE 11.1.1.7 refer to the following documents on My Oracle Support (https://support.oracle.com):

    Doc ID 1517518.1 - OBIEE Upgrade Advisor 11.1.1.x to 11.1.1.7.0
    Doc ID 1488475.1 - OBIEE 11g: Required and Recommended Patches and Patch Sets

    For further details on the Oracle Lifetime Support Policy refer to:

    • Oracle Lifetime Support Policy Oracle Fusion Middleware [ PDF]



    Have a question or an issue that you can not identify - why not speak to the OBIEE Community as a first step on your way to a solution?

    My Oracle Support Community (MOSC)
    Oracle Business Intelligence Enterprise Edition


    About


    This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

    Authors:

    italia.nowodworska(€)oracle.com
    torben.hein(€)oracle.com
    paul.anderson(€)oracle.com
    julie.foster(€)oracle.com





    Search

    Archives
    « July 2015
    SunMonTueWedThuFriSat
       
    1
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
     
           
    Today