March 26, 2020

|

by: Renee Miller

|

Categories: dbt, Events, Oracle, Red Pill Analytics' Tips, Red Pill News, Tips

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, [...]

June 19, 2019

|

by: Renee Miller

|

Categories: Analytics, Events, Oracle, Red Pill News

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 [...]

April 18, 2019

|

by: Craig Coulter

|

Categories: Cloud, Code, Oracle, Oracle Cloud, Snowflake, Snowflake Computing

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 [...]

October 25, 2017

|

by: Michelle Kolbe

|

Categories: OBIEE, Oracle

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 […]

January 11, 2017

|

by: Phil Goerdt

|

Categories: Analytics, Data Science, OBIEE, Oracle

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, […]