It’s that time of the year again. Kscope19, one of the best Oracle User Group conferences of the year, is merely weeks away. If you’re only going to one conference this year, definitely take this one into consideration. Why Kscope? If you are heading to Kscope, you're probably already an Oracle aficionado. This is where [...]
In this series, we are showcasing a fictitious midsize brokerage company moving their technical environment to the cloud. We have established previously, the company is experiencing contention issues, at both the user and hardware level. We will talk about the Oracle BI migration in a future blog; but first, we have to get the data [...]
The sun is shining, and the data-driven community is coming out of hibernation to gather across the country. Check out where Red Pill Analytics will be in the coming months, and let us know if you will be attending. We’d love to connect in person! Kafka Summit 2019: April 2, 2019 New York, NY The [...]
October 27, 2017 was our second annual U Girls Code event at University of Utah. The idea for this event came from Tyra Crockett, from Oracle Academy, and I. We convinced University of Utah’s TEK Club to host the event as it is good exposure for their program to have the girls in a university [...]
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 […]
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 […]
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, […]
Clustering. Whether we’re talking about headaches, compute nodes, or uh, well, I’ll let you fill in the blank… isn’t anything worth doing, worth doing together? Clustering can be a powerful tool for understanding the relationships between data, and in this post I’ll walk through how to use the OBIEE 12c Advanced Analytics Cluster Function. As […]
Recently I had a couple of interesting situations pop up in OBIEE 11g regarding dates. No not the edible kind, but the calendar kind. Specifically where it involves fact measures that are valid for a period of time beyond what the date id(s) on the rows in the table allow. The first scenario I will […]
In this series I have been exploring various cloud Buisness Intelligence product offerings from companies like Domo and Tableau. Now it is time to review Oracle’s newish offering Business Intelligence Cloud Service (BICS). First of all, if you are going to combine data sources for your analysis, versus having, say, a single spreadsheet to load, the easiest [...]