OAC has a nice button for a person to unsubscribe within an Agent itself. But this required a person to navigate to the catalog to find the agent and look inside the details of the agent. Seems like a lot of steps to me. But what if you want to enable this capability for an [...]
COVID-19 has created an anxiety-ridden week. With the chaos of preparing to quarantine over (hopefully), what’s next? If you’re looking for a way to be productive at home, we have an answer - we’ve taken our canceled and postponed live events and converted them to online educational opportunities. With a worldwide pandemic at our heels, [...]
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 […]
