Technical Improvements to Essbase Integration in OBIEE 11.1.1.6.2 BP1 : ASO Aggregate Persistence, Combined Install & Systems Management The recent 11.1.1.6.2 BP1 patchset for OBIEE 11g provided a bunch of new features including trellis charts, Oracle BI Mobile and the repository Model Checker [https://www.rittmanmead.com/blog/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/] , but it also sneaked in another set of new features that will be
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 Integrating Oracle WebCenter and Oracle BI EE Part 3 : Adding BI Content to Custom Portal Applications In the previous two postings in this series I looked at Oracle's WebCenter Portal application at a high-level [http://www.rittmanmead.com/blog/2012/09/integrating-oracle-webcenter-and-oracle-bi-ee-part-1-introducing-oracle-webcenter-portal-11g/] , and then explained how analyses and other BI content from OBIEE 11g could be added to WebCenter Portal : Spaces applications [http://www.
UKOUG Oracle BI Partner of the Year - Vote for Rittman Mead Rittman Mead has been nominated for the UKOUG Partner of the Year Awards for another year, in the Business Intelligence category. We take awards like these very seriously as we feel they reflect the effort and service we provide directly to our clients and indirectly to the wider Oracle BI
Integrating Oracle WebCenter and Oracle BI EE Part 2 : Adding OBIEE Content to Oracle Portal : Spaces Earlier in the week I looked at Oracle WebCenter Portal : Spaces [https://www.rittmanmead.com/blog/2012/09/integrating-oracle-webcenter-and-oracle-bi-ee-part-1-introducing-oracle-webcenter-portal-11g/] and how it was the spiritual successor to Oracle's older Oracle Portal product. I mentioned at the time that it was possible to add OBIEE content into Oracle Portal
Integrating Oracle WebCenter and Oracle BI EE Part 1 : Introducing Oracle WebCenter Portal 11g Many years ago I wrote an article for OTN on integrating Oracle Discoverer content into Oracle Portal [http://www.oracle.com/technetwork/articles/rittman-dash-089241.html], where Discoverer (for those of you new to Oracle BI) was the predecessor to OBIEE and Oracle Portal was Oracle's enterprise portal product.
Technical The PIVOT Clause is Only for Aggregates We briefly interrupt the transactional schemas [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] series for this important message: the PIVOT clause of SELECT is only for aggregates! When Oracle added the PIVOT and UNPIVOT operators in Database 11g, at first, I was hopeful. It certainly scratched an itch that
Technical Integrating OBIEE11g with Hyperion Shared Services Security - An Example Workaround using the HSS Security API and BISQLGroupProvider One of our customers in the UK recently asked us to help them upgrade an existing OBIEE 10g system to the 11g release, to take advantage of the enhanced visualisations, scorecards and KPIs, iPhone and iPad clients and so on. What made this upgrade interesting is that their OBIEE 10g
Technical Introducing Oracle Enterprise Data Quality Visually, BI dashboards and analyses can be impressive and appear to meet the user’s needs, but if the data displayed on the dashboards isn't reliable or correct then those same users can quickly lose faith in what they contain. Therefore, it’s important that assessing and managing
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 Using OBIEE against Transactional Schemas Part 2: Aliases It seems like a different life when I posted the introduction to reporting against transactional schemas [https://www.rittmanmead.com/blog/2012/06/using-obiee-against-transactional-schemas-part-1-introduction/] . Since that time, we've had some exciting new customers come aboard, which has required a lot of my time (and which I have been
Technical Advanced Presentation Services settings for OBIEE testing & development As John Minkjan pointed out [http://obiee101.blogspot.co.uk/2011/10/obiee-obipsconfigbasexsd.html] a while ago, the XSD (XML Schema) for the OBIEE configuration files can yield some interesting things. I've been looking at obips_config_base.xsd and found the following bits of information which I
Technical OBIEE / FMW and networking on DHCP hosts FMW can be a bit of a sensitive soul when it comes to networking. Something that always seems to antagonise it is running within a VM (both VMWare Fusion and VirtualBox, since you ask). Being on-site at clients I'll often find my laptop's network details change,
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 RTD Hardware Requirements and Components In my last post I promised some details on RTD hardware requirements and components, so let's take a look at the components that live in the RTD black box shown in my previous posts. Realistically, the minimum RTD setup in production is likely to be as below: [http:
Navigating to BI Content in OBIEE11g and Passing Multiple Parameters Hello everyone, I'm Francesco Tisiot a new Rittman Mead consultant, in this post I'll explain how to achieve custom navigations to BI content passing multiple parameters on Oracle BI 11g and a way to include that functionality in the Action Framework. First of all, what does
Looking Towards the BI Apps 11g Part 3 : Preparing for BI Apps 11g In the previous two postings in this three-part series, we've looked at the Oracle BI Applications product roadmap, and what new features and components the 11g release is likely to use. In this final posting, we'll try and answer a question that we often get asked
Looking Towards the BI Apps 11g Part 2 : Oracle BI Apps 11g Technology Innovations In our previous posting in this series on the Oracle BI Applications 11g, we looked at the overall product roadmap for Oracle BI Applications 11g, and how in the next twelve months the 7.9.6.x branch that currently covers Applications Unlimited customers will eventually merge with the 11.
Technical OBIEE 11.1.1.6.2 BP1 - Logical SQL Diagnostic view New in 11.1.1.6.2 BP1 is the Logical SQL Diagnostic view for a report. There's nothing in the release notes about it, nor the documentation, so it's possible that it's a debug option that ought to have been disabled by the
Looking Towards the BI Apps 11g Part 1 : BI Apps 11g Product Roadmap Whilst this blog is most well known for articles on OBIEE, ODI, Essbase and data warehousing, many of the projects we work on are actually Oracle BI Applications implementations, out of our offices in the UK, India, USA and Australia. Recently we're getting asked more and more about
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"
Last Week to Complete the BI Survey 11! [Re-posted as there's just one week left to get your responses in...!] Every year we're pleased to help publicise the BI Survey [http://www.bi-survey.com/], an annual independent survey of BI tools customers organized by BARC. What's good about the BI Survey is
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
