Tag Archives: Obiee

Oracle Business Intelligence Enterprise Edition (OBIEE) 12c Bundle Patch 12.2.1.0.160419

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.0.

This bundle patch download is available from the My Oracle Support | Patches & Updates section.

  Oracle Business Intelligence Bundle Patch 12.2.1.0.160419
Patch 22734181

OBIEE Suite Bundle Patches are cumulative. Oracle BI Bundle Patch 12.2.1.0.160419 includes all the bug fixes released in Oracle BI 12.2.1.0.0.

To install the Oracle BI Bundle Patch 12.2.1.0.160419 patch, Oracle BI 12.2.1.0.0 must be installed in the Oracle BI Home directory. Subsequent Oracle BI patches can be installed on Oracle BI 12.2.1.0.0 or any Oracle BI bundle patch with a lower fifth numeral version than the one being installed. For example, you can install 12.2.1.0.160419 on 12.2.1.0.0.


Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file.

The Readme file is available from the Patches & Updates download screen.

For an introduction to OBIEE Suite Bundle Patches, which includes information on the bundle patch lifecycle, availability, and version names, refer to Knowledge Article:

OBIEE Suite Bundle Patches
Doc ID 1591422.1

To locate the latest available Patch information visit the Knowledge Article:

OBIEE 12c: Required and Recommended Bundle Patches and Patch Sets
Doc ID 2070465.1

To share your experience about installing this patch ...

In the MOS | Patches & Updates screen for OBIEE Patch 22734181, click the "Start a Discussion" and submit your review.

Have a question for OBIEE specifically ....

The My Oracle Support Community " OBIEE (MOSC) " is the ideal first stop to seek & find product specific answers:

OBIEE (MOSC)



Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Bundle Patch 11.1.1.9.160419

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.

This bundle patch download is available from the My Oracle Support | Patches & Updates section.

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g
Bundle Patch 11.1.1.9.160419

Patch 22951634

OBIEE Suite Bundle Patches are cumulative, and include the contents of previous 11.1.1.9.x bundle patches. Oracle BI EE Suite Bundle Patch 11.1.1.9.160419 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.9.160119 and new bug fixes.

Patch 22951634 is the top-level patch and it contains all of the cumulative component patches. This provides a single patch to download from My Oracle Support, although there are several component patches that must be installed in the Oracle BI Home directory.

The Oracle BI EE Suite Bundle Patch 11.1.1.9.160419 under the top-level patch 22951634 consists of the following component patches:

  • Patch 22859999 - Oracle BI Mobile App Designer (BIMAD)
  • Patch 22977810 - Oracle BI Server (BISERVER)
  • Patch 22967335 - Oracle BI Presentation Services (BIPS)
  • Patch 22603478 - Oracle EPM Components Installed from Oracle BI Installer 11.1.1.9.0 (BIFNDNEPM)
  • Patch 22974747 - Oracle BI Publisher (BIP)
  • Patch 22951536 - Oracle BI Platform Client Installers and MapViewer
  • Patch 21350584 - Oracle BI ADF Components (BIADFCOMPS)
  • Patch 21517672 - Oracle BI Third Party

NOTE: Refer to the readme for FULL list of instructions on how to install this bundle patch.

Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads refer to the Readme file for important information. It is important to verify that the requirements and support paths for this patch are met as outlined within the Readme file. Details for moving from 11.1.1.7.x to 11.1.1.9.5 are also outlined as well as Important Notes to Read Before Installing the Bundle Patch.

The Readme file is available from the Patches & Updates download screen.

For an introduction to OBIEE Suite Bundle Patches, which includes information on the bundle patch lifecycle, availability, and version names, refer to Knowledge Article:

OBIEE Suite Bundle Patches
Doc ID 1591422.1

To locate the latest available Patch information visit the Knowledge Article:

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


To share your experience about installing this patch ...

In the MOS | Patches & Updates screen for OBIEE Patch 22951634, click the "Start a Discussion" and submit your review.

Have a question for OBIEE specifically ....

The My Oracle Support Community " OBIEE (MOSC) " is the ideal first stop to seek & find product specific answers:

OBIEE (MOSC)



Installing & Setting JDK for OBIEE 12C (12.2.1.0.0) on AIX

First off, you should always check the certification matrix Oracle provides prior to installing anything… 12.2.1.0.0 Certification Matrix … Once you verify the correct JDK needed for your install, use the url from the certification matrix to download it, IBM JDK 1.8 SR1 FP10 from matrix Downloading the JDK For the AIX Power System 7 […]

The post Installing & Setting JDK for OBIEE 12C (12.2.1.0.0) on AIX appeared first on artofbi Blog.

ChitChat: The Importance of BI Integrations

A user’s workflow shouldn’t change to accommodate a new tool. A new tool should fill a gap in the current workflow and help streamline the user’s process. An application without a clearly defined scope eventually overlaps with existing solutions, creating confusion and distress among users. It takes both time and effort to clarify the appropriate situations to use the application, reconcile different use cases and approaches, and resolve incorrect uses. We designed ChitChat with appropriate scopes in mind, implementing key integrations, to fit seamlessly into existing workflows.

What exactly do we mean by “scope?”

Let’s look at an example with JIRA. JIRA owns the complete ticketing process, meaning tickets are stored and maintained by the tool. Using a competing ticket solution, such as Trello, for the same purpose within the organization will cause havoc among users. However, JIRA tickets are still extremely useful outside of the JIRA application. They can be linked to and displayed inside other applications, but they are still maintained by JIRA itself.

If you can recognize that the ticketing management should be handled solely by JIRA, but exposure of those tickets outside of the tool is also important, then you understand the correct scope of the application. The scope of the application does not determine where the context of an application is useful. It only describes what section of a workflow the application has absolute control over. The question isn’t “Where should we be able to view the information?” The question is “Where should the content be maintained?”

ChitChat respects the appropriate scopes of neighboring applications and allows the flexibility to continue maintaining the scopes of these applications. With integrations to Atlassian JIRA and Confluence and Salesforce Chatter, the information you need is available where you need it, without infringing on your existing workflow.

Examples of Integrations

Let’s look at some examples. As we use a BI dashboard, we stumble upon an issue. Using ChitChat, the issue can be identified and a conversation can be made about temporarily working around the problem. However, the IT team uses JIRA to accept issues and resolves them as appropriate. We obviously want the IT team to know of this issue, so we must create a ticket in JIRA as well. Rather than going to JIRA and creating a ticket manually, we can simply export the initial annotation to JIRA. The workflow remains generally identical, but now requires less time and effort. And this comes with the added benefit of the ticket pointing directly to the location of the issue on the dashboard.

In another instance, let’s say our dashboard has some confusing calculations on it, some of which are not immediately recognizable. The formulas used, and the reasons to use such formulas, are available in Atlassian Confluence for us to view. However, not all users have a Confluence account, and even fewer have access to the document. We could copy and paste the calculations as a document using ChitChat, but now we have two separate instances of the same information. If the calculations are changed, we must ensure both locations are accurate. Alternatively, ChitChat can sync directly with Confluence and pull a page into the application. The page guarantees accuracy by consistently pulling new updates from Confluence, as well as pushing updates to Confluence if the content is changed in ChitChat.

These approaches allow the JIRA ticket and Confluence document to be maintained in the appropriate location, while also being available in a useful context. Chitchat does not impede on the purposes of other applications. ChitChat offers integrations that seamlessly enhance your workflow without making it convoluted. Our tool is designed specifically to fill the missing pieces in your BI workflow, allowing for a seamless transition between analysis and communication.

To learn more about ChitChat’s many commentary features, or to request a demo, click here.

The post ChitChat: The Importance of BI Integrations appeared first on Rittman Mead Consulting.

New OTN Article – OBIEE Performance Analytics : Analysing the Impact of Suboptimal Design

I’m pleased to have recently had my first article published on the Oracle Technology Network (OTN). You can read it in its full splendour and glory (!) over there, but I thought I’d give a bit of background to it here and the tools demonstrated within.

OBIEE Performance Analytics Dashboards

One of the things that we frequently help our clients with is reviewing and optimising the performance of their OBIEE systems. As part of this we’ve built up a wealth of experience in the kind of suboptimal design patterns that can cause performance issues, as well as how to go about identifying them empirically. Getting a full stack view on OBIEE performance behaviour is key to demonstrating where an issue lies, prior to being able to resolve it and proving it fixed, and for this we use the Rittman Mead OBIEE Performance Analytics Dashboards.

OBIEE Performance Analytics

A common performance issue that we see is analyses and/or RPDs built in such a way that the BI Server inadvertently returns many gigabytes of data from the database and in doing so often has to dump out to disk whilst processing it. This can create large NQS_tmp files, impacting the disk space available (sometimes critically), and the disk I/O subsystem. This is the basis of the OTN article that I wrote, and you can read the full article on OTN to find out more about how this can be a problem and how to go about resolving it.

OBIEE implementations that cause heavy use of temporary files on disk by the BI Server can result in performance problems. Until recently in OBIEE it was really difficult to track because of the transitory nature of the files. By the time the problem had been observed (for example, disk full messages), the query responsible had moved on and so the temporarily files deleted. At Rittman Mead we have developed lightweight diagnostic tools that collect, amongst other things, the amount of temporary disk space used by each of the OBIEE components.

pad_tmp_disk

This can then be displayed as part of our Performance Analytics Dashboards, and analysed alongside other performance data on the system such as which queries were running, disk I/O rates, and more:

OBIEE Temp Disk Usage

Because the Performance Analytics Dashboards are built in a modular fashion it is easy to customise them to suit specific analysis requirements. In this next example you can see performance data from Oracle being analysed by OBIEE dashboard page in order to identify the cause of poorly-performing reports:

OBIEE Database Performance Analysis

We’ve put online a set of videos here demonstrating the Performance Analytics Dashboards, and explaining in each case how they can help you quickly and accurately diagnose OBIEE performance problems.

You can read more about our Performance Analytics offering here, or get in touch to find out more!

The post New OTN Article – OBIEE Performance Analytics : Analysing the Impact of Suboptimal Design appeared first on Rittman Mead Consulting.