Tagged

obiee

A collection of 131 posts

Oracle BI Suite EE

Automated Regression Testing for OBIEE

In the first article of this series [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction] I explored what regression testing is, why it matters, and by breaking down the OBIEE stack into its constituent parts where it is possible to do it for OBIEE. In this posting, I explore some

Oracle BI Suite EE

OBIEE Regression Testing - An Introduction

In this article I’m going to look at ways to test changes that you make to OBIEE to ensure that they don’t break existing functionality. In all but the simplest IT systems it’s common for one (planned) action to inadvertently cause another (unplanned). What IS Regression Testing?

Oracle BI Suite EE

Monitoring OBIEE Performance for the End User with JMeter from EM12c

This is the third article in my two-article set of posts (h/t [https://en.wikipedia.org/wiki/Trilogy_in_five_parts]) on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions [https://www.rittmanmead.com/blog/2013/11/collecting-usage-tracking-data-with-metric-extensions-in-em12c/] as an alternative

Oracle BI Suite EE

Collecting Usage Tracking Data with Metric Extensions in EM12c

In my previous post [https://www.rittmanmead.com/blog/2013/11/building-alerts-in-em12c-with-obiee-usage-tracking-data/] I demonstrated how OBIEE’s Usage Tracking data could be monitored by EM12c through a Service Test. It was pointed out to me that an alternative for collecting the same data would be the use of EM12c’s

Oracle BI Suite EE

OBIEE "Act As" (ActAs) vs "Impersonate"

There will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside (it's

Oracle BI Suite EE

Tips and Tricks for the OBIEE linux sysadmin

As well as industry-leading solution architecture, consultancy and training on Oracle BI, here at Rittman Mead we also provide expert services in implementation and support of such systems. In this blog I want to share some of the things I find useful when working with OBIEE on a Linux system.

Technical

TimesTen and OBIEE port conflicts on Exalytics

Introduction Whilst helping a customer set up their Exalytics server the other day I hit an interesting problem. Not interesting as in hey-this-will-cure-cancer, or oooh-big-data-buzzword interesting, or even interesting as in someone-has-had-a-baby [https://twitter.com/andybolton/status/359568006545809408/photo/1], but nonetheless, interesting if you like learning about the internals

Oracle BI Suite EE

The Rittman Mead scripts github repository

Here at RittmanMead we’re big fans of working smarter, not harder. One of the ways we do this is not re-inventing the wheel. There’s only so many ways that products such as OBI and ODI can be implemented, and we’ve probably seen most of them. The corollary

Technical

Learn OBIEE 11.1.1.7 from the experts!

Here at RittmanMead we write and deliver our own courses on Oracle's products including OBIEE, ODI, OWB and EPM. Our trainers also consult and deliver projects, meaning that our training is based on real-world usage of the products. We offer public courses in UK, US, India and Australia,

Oracle BI Suite EE

Patch OBIEE the quicker way - with OPatch napply

Since 2012, Oracle's patching strategy for OBIEE has been Bundle Patches released approximately once a month. These bundle patches are usually cumulative ones, applied on top of the .0 version of the product. Patching is done through Oracle’s standard OPatch tool, which manages the application of patches

Oracle BI Suite EE

MDS XML versus MUDE Part 3: Configuring MDS XML with Git

In the previous installment of this series [https://www.rittmanmead.com/blog/2013/06/mds-xml2/], I gave an overview of MUDE (multi-user development environment), and described it's strengths and weaknesses, hopefully presenting a fair assessment on both sides. For a recap, here are three properties that I think

Oracle BI Suite EE

Embedding a D3 Visualisation in OBIEE

In this blog entry, my first since joining the company as a consultant a little over a month ago, I will be taking you through the process of embedding a D3 visualisation into OBIEE. In my first few weeks in this new role I've had the pleasure or

Oracle BI Suite EE

MDS XML versus MUDE Part 2: What is MUDE?

Mark Rittman once joked during a presentation on OBIEE and SCM that "MUDE" (multiuser development environment) was the closest thing to a dirty word in the OBIEE documentation. I know many people who feel that way... some justified, some perhaps not, as MUDE has certainly gotten better in

Oracle BI Suite EE

Testing aggregate navigation on OBIEE and Exalytics

One of OBIEE’s many great strengths is aggregate navigation; the ability to choose from a list of possible tables the one which will probably give the optimal performance for a given user query. Users are blissfully unaware of which particular table their query is being satisfied from, since aggregate

Technical

Incremental refresh of Exalytics aggregates using native BI Server capabilities

One of the key design features of the Exalytics In-Memory Machine [http://www.oracle.com/uk/solutions/ent-performance-bi/business-intelligence/exalytics-bi-machine/overview/index.html] is the use of aggregates (pre-calculated summary data), held in the TimesTen In-Memory database. Out of the box (“OotB”) these aggregates are built through the OBIEE tool,

Technical

Advanced monitoring of OBIEE with Nagios

Introduction In the previous articles in this series, I described an overview of monitoring OBIEE [https://www.rittmanmead.com/blog/2012/09/automated-monitoring-of-obiee-in-the-enterprise-an-overview] , and then a hands-on tutorial for setting up Nagios to monitor OBIEE [https://www.rittmanmead.com/blog/2012/09/an-introduction-to-monitoring-obiee-with-nagios]. Nagios is an Enterprise Systems Management tool

Technical

An introduction to monitoring OBIEE with Nagios

Introduction This is the second post in a mini-series on monitoring OBIEE. The previous post, Automated Monitoring of OBIEE in the Enterprise – an overview [https://www.rittmanmead.com/blog/2012/09/automated-monitoring-of-obiee-in-the-enterprise-an-overview] , looked at the overview and theory to why and what we should be monitoring. In this post I

Technical

Automated Monitoring of OBIEE in the Enterprise - an overview

A lot of time is given to the planning, development and testing of OBIEE solutions. Well, hopefully it is. Yet sometimes, the resulting deployment is marked Job Done and chucked over the wall to the Operations team, with little thought given to how it is looked after once it is

Technical

OBIEE / AD integration - [OBI-SEC-00022] Identity found ... but could not be authenticated

A quick blog post to record for future Googlers a problem I encountered today. I was configuring OBIEE 11.1.1.6 to use Microsoft Active Directory (MSAD) as an Authentication Provider, following the instruction's in Mark's blog post [http://www.rittmanmead.com/blog/2012/03/

Technical

Exalytics - TimesTen and OBIEE connectivity

Two of the key components in Exalytics are OBIEE and the TimesTen in-memory database. Configuring them to work together, particularly in non-standard configurations, can be fiddly, so here is a guide on how to make sure you get it right. The aim To recap, the aim of this configuration is

Technical

Applying patches to OBIEE : 11.1.1.6.2 BP1

The recent release of OBIEE 11.1.1.6.2 BP1 [https://www.rittmanmead.com/blog/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/] weighs in with a hefty eight individual patches to apply. They use the standard Oracle opatch mechanism. Here we see how to apply the patches, and note any "gotchas"

Technical

Downloading OBIEE patches from Oracle with wget

Last week saw the release of OBI 11.1.1.6.2 BP1 [https://www.rittmanmead.com/blog/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/] , and with it, some eight patches to download (seven OBIEE, plus one JDeveloper). A very useful option when downloading the patches, particularly if you are working on Linux servers

Technical

OBIEE Administration Tool - Import Metadata shows no schemas

Importing Metadata with the Administration Tool The client-only install of the OBIEE 11g Administration Tool is installed with a set of OCI libraries. This means that it can support basic Oracle Database interaction, without the need for a full Oracle Client installation on the machine. For example, you can update

Technical

OBIEE performance tuning myth : BI Server logging

One of the frequent recommendations around performance in OBIEE that one hears is a blanket insistence on disabling the BI Server log. It is a line that is repeated by Oracle support, propogated in "Best Practice" guides, and repeated throughout blog posts on the subject. Antony Heljula did

Technical

Public training schedule for 2012-H2 announced

Rittman Mead offer training courses at centres in Brighton UK, Atlanta GA, Bengaluru India, and Melbourne Australia. These courses are our standard, "bootcamp" courses, five days in length, and is typically taught by consultants such as Mark Rittman, Robin Moffatt, Stewart Bryson, Ashley Beauman and Venkatakrishnan J. If