OBIEE Archives - Red Pill Analytics

An abstract image of hexagonal purple and blue gradient

Using Oracle’s Baseline Validation Tool with OBIEE — Part 4

This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are: Post 1: An intro to BVT Post 2: Setting up BVT Post 3: Running the Tests Interpreting the BVT Results As described in my third post in this series, here’s how to […]

Using Oracle’s Baseline Validation Tool with OBIEE — Part 4 Read More »

Business Intelligence, Code, Data, OBIEE, Software Testing, Technical Tutorials

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3

This post is part 3 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Post 2 about setting up BVT to run, can be found here. Running the Test Against Both Environments We need to execute BVT twice with the same

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3 Read More »

Business Intelligence, Code, Coding, Data Analytics, Data Integration, Java, JavaScript, OBIEE, Technical Tutorials

TimestampAdd Error in OBIEE Migration from 11g to 12c

I have a report that works fine in OBIEE 11g but when upgraded to 12.2.1.2, it gives an error stating: [nQSError: 22025] Function TimestampAdd is called with an incompatible type. This report has a SQL Expression in a filter that states: TimestampAdd(SQL_TSI_HOUR, 4.5, CURRENT_DATE) The problem is that we are trying to add hours onto

TimestampAdd Error in OBIEE Migration from 11g to 12c Read More »

OBIEE, Oracle

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1

This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Overview of BVT With the 12c release of OBIEE, Oracle released a new tool called the Baseline Validation Tool or BVT. This tool allows you to run specific tests against your OBIEE reports, dashboards, and BI Publisher

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1 Read More »

Coding, OBIEE, Oracle, Oracle 12c

Checkmate for OBI is Now Free

For those of you in the Oracle Business Intelligence space, you have likely heard us or some one else talk about Checkmate in the past. We have several posts on our blog about Checkmate, as well as a YouTube playlist dedicated to it, so I won’t spend too much time in this article evangelizing it.

Checkmate for OBI is Now Free Read More »

Checkmate, OBIEE, Red Pill Analytics Tips, Red Pill News

Installing OBIEE 12c on Exalytics

Red Pill Analytics recently performed the installation of OBIEE 12c on an Exalytics machine for one of our customers. There is no option to use the Domain Management Utility for installing OBIEE 12c… that’s still only capable of installing OBIEE 11g. Therefore OBIEE 12c is a manual install on Exalytics, but it’s very similar to installing OBIEE

Installing OBIEE 12c on Exalytics Read More »

Exalytics, OBIEE, Oracle 12c, Tips

Finding an Open Slip

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the

Finding an Open Slip Read More »

OBIEE, Red Pill Analytics Tips, Tips

A Funny Thing Happened on the Way to the Cloud…

Oracle Analytics Cloud (OAC) is generally available (GA) today, and I’m excited to be included in this OAC blog hop welcome wagon. So I’m slumming it with a bunch of Essbase professionals, as you can see from the list of contributing authors below. It’s fascinating to see just how stoked the Essbase community is for

A Funny Thing Happened on the Way to the Cloud… Read More »

Analytics, BICS, Business Intelligence, Cloud, OBIEE, Oracle BICS, Oracle DV

Which Version Was It Again?

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using

Which Version Was It Again? Read More »

OBIEE, Oracle 12c, Tips

Bring the Noise

As I’ve been discussing in my last few blogs, it’s possible to start using OBIEE for analytics, rather than the standard operational reporting and BI that is commonplace. Data science has been quite the buzz the last few years, and no doubt about it, data scientists can bring great value and understanding to an organization,

Bring the Noise Read More »

Analytics, Data Science, OBIEE, Oracle