Rittman Mead Blog - Technical Insights

Tagged

Technical

A collection of 878 posts

New OTN Article: Installing and Configuring Oracle BI Apps 11.1.1.7.1

A few months ago I posted a series of articles [https://www.rittmanmead.com/blog/2013/05/introduction-to-the-bi-apps-11-1-1-7-1-release-overview/] on our blog about the new 11.1.1.7.1 release of the BI Applications [http://www.rittmanmead.com/biapps11g/], focusing on the new ODI 11g-based architecture and its supporting utilities.

Oracle BI Suite EE

Three Ways to Improve Efficiency With Better Documentation

I was at a client site recently, and as part of a front-end development effort we had added some documentation within the web catalog. They had never seen anything like it and started referring to it as “smart” documentation. Quite frankly, I was more than a bit taken aback by

Oracle BI Suite EE

OBIEE 11.1.1.7 + Essbase : Essbase Filters within Fusion Middleware 11g Security

Data and metadata filters are used with Essbase to limit access to data in a cube. When you use data filters to restrict access to a certain set of dimension members in the cube, the end-user can see that the member exists, but can't see any data associated

Oracle BI Suite EE

Conclusions on Storing Detail-Level Data in Oracle Exalytics

Last week I wrote a blog post on the topic of storing lots of detail-level data in Oracle Exalytics [http://www.rittmanmead.com/blog/2013/07/storing-detail-level-data-in-oracle-exalytics/] , not the primary use-case for the product but something we're increasingly asked about. Most implementations of Exalytics use OBIEE's

Oracle BI Suite EE

Optimizing TimesTen for Exalytics Queries using TimesTen's Index Advisor

Late last week I posted an article on our blog on loading detail-level data into Exalytics [http://www.rittmanmead.com/blog/2013/07/storing-detail-level-data-in-oracle-exalytics/] ; whilst the article was intended really as an introduction to Essbase Aggregate Storage Option, and how it could offer an alternative to TimesTen when storing large

Oracle BI Suite EE

Storing Detail-Level Data in Oracle Exalytics

Although the primary use-case for TimesTen within Oracle Exalytics is to store relatively-small aggregate tables created using the Summary Advisor [http://www.oracle.com/technetwork/issue-archive/2012/12-may/o32bi-1578015.html] , many customers have asked us whether it's possible to store their entire reporting dataset in TimesTen. With 1TB

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 3: Real-time ETL Challenges

I've finally had the chance to sit down and properly closeout this series on GoldenGate and Oracle Data Integrator. Since the last post, I’ve actually presented this topic on three different occasions. Once at each of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/2013/

Oracle BI Suite EE

Rittman Mead BI Masterclass Tour: India, October 2013- Register Now!

I'm very pleased to announce a one-off Rittman Mead BI Masterclass Tour [http://www.rittmanmead.com/indiabimasterclass2013/] that we're organising, in partnership with ODTUG, to take place in India in October 2013. Along with the US and UK, India has the largest amount of readers of

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

Exalytics X3-4 Now Available, 2TB RAM + SSD and Supports OBIEE 11.1.1.7

It's been on the Oracle Tech Price list for a while now, but Oracle Exalytics In-Memory Machine X3-4 was officially launched this week, with headline new features of 2TB of RAM (up from 1TB in the earlier, X2-4 version), and 2.4TB of SSD flash disk. This new

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

Oracle BI Suite EE

MDS XML versus MUDE Part 4: Simple Multi-Branch Development

After getting our MDS XML repository ready for development in the last post [https://www.rittmanmead.com/blog/2013/07/mds-xml3/], I am ready to demonstrate what multi-user development without MUDE would look like using Git as our version control system (VCS). Let me apologize for the slightly different username

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

Accelerating Hadoop/Hive OBIEE Queries Using Exalytics and the Summary Advisor

A few weeks ago I blogged about the new Hadoop/Hive support in OBIEE 11.1.1.7 [https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-2-connecting-obiee-11-1-1-7-to-hadoop-data-sources/] , and how it enables users to query "big data" sources with no need to know Hadoop or MapReduce. As this feature is

Using Oracle TimesTen With Oracle BI Applications (Part 3)

In part 2 [https://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-2/] I introduced TimesTen Columnar Compression and explained that it creates-column value look up tables so a longer data value can be replaced with a short token. If we take a traditional Fact table we have a set of (usually)

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 Database 12cR1 - New Features for BI & DW

Oracle Database 12c Release 1 [http://www.oracle.com/us/corporate/press/1967380] came out last week, initially available for 64-bit Linux and Solaris (SPARC and x86_64), with the Windows and other versions presumably due over the next few months. So what's in this new release for

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

Using the Exalytics Summary Advisor and Oracle BI Apps 7.9.6.4

Peter Scott is currently mid-way through a series of posts on our blog on replicating parts of the BI Apps data warehouse into TimesTen [http://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-1/] , as a potential way for running all or part of the BI Apps "in-memory". We'

Using Oracle TimesTen With Oracle BI Applications (Part 2)

Last time I posted an introductory blog to this series of posts on using Oracle TimesTen with Oracle BI Applications (OBIA). Today, I am going to look at some of the OBIA structures and then start to explore the ways we can use TimesTen with OIBA. As TimesTen may be

Using Oracle TimesTen With Oracle BI Applications (Part 1)

Oracle BI Applications (OBIA) is a product for delivering industry best-practice dashboards and analysis over enterprise sources such as ERP, HR, SCM and CRM systems. OBIA includes the necessary functionality to extract data from the source systems, transform and load it to the target database's standardised data model

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

Using OBIEE SampleApp 305 in VM Fusion

Oracle distribute the new OBIEE SampleApp [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] as a VirtualBox image, but it is dead easy to run it on VM Fusion instead. Here’s how: 1. Unzip the SampleApp archive files [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] , and

Oracle BI Suite EE

New With OBIEE 11.1.1.7 and SampleApp v305 - Essbase Cube Spin-Off

Now that the new v305 OBIEE SampleApp that we previewed in May [http://www.rittmanmead.com/blog/2013/04/previewing-the-new-obiee-11-1-1-7-sampleapp/] is out, I thought it'd be a good time to take a look at an experimental feature added into OBIEE 11.1.1.7's logical SQL

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