Data Analytics Blog | Data Blogs

Back to the Future: Time Traveling with Snowflake

In my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE. [pexyoutube pex_attr_src=”https://www.youtube.com/watch?v=fCjsUxbNmIs”][/pexyoutube]Where We’re Going… We Don’t Need […]

Back to the Future: Time Traveling with Snowflake Read More »

OBIEE, Snowflake

Groovy, Web Services and OBIEE 12c

If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more

Groovy, Web Services and OBIEE 12c Read More »

OBIEE, Oracle 12c

Accessing & Analyzing Twitter Posts with R

This is a topic that I was teaching about last night in my Digital Analytics class at the University of Utah and instead of only sharing what I found with my students, I thought I’d share here in the blogosphere. What I’ve found was yes it’s easy to pull Twitter posts into R for analysis!

Accessing & Analyzing Twitter Posts with R Read More »

Code, Data Science, R, Twitter

Forecast: Partly Cloudy (Part 2)

If you’re reading this post, you’ve probably seen my other post on connecting OBIEE to Amazon Web Services’ Redshift database offering. If not, thanks for joining in for this part of the adventure. To summarize the last post, cloud applications are becoming increasingly more common, and because of this fact, more of the data that is produced

Forecast: Partly Cloudy (Part 2) Read More »

OBIEE

Forecast: Partly Cloudy (Part 1)

One thing that is for certain is that the cloud is here to stay. With more and more offerings having a cloud component, managing data and applications that are not on-premises will become commonplace. Some applications are optimized for this brave new world we’re living in (Oracle BICS comes to mind), but the old guard

Forecast: Partly Cloudy (Part 1) Read More »

OBIEE

What You Positively Have to See in the Database Track at Kscope16

This blog post is an entry in the ODTUG Kscope16 Cross-Track Blog Hop, an exercise for Kscope expert regulars to take a walk on the wild side, and talk about must-see sessions in a foreign content track. The other Blog Hop entries are: APEX sessions not to be missed, as recommended by EPM expert Cameron Lackpour: http://camerons-blog-for-essbase-hackers.blogspot.com/2016/05/kscope16-apex-sessions-im-interested-in.html

What You Positively Have to See in the Database Track at Kscope16 Read More »

Events, Red Pill News

UCP Alert— Unidentified Connection Pools

The other day I was playing around with the Direct Database Request (DDR) feature within OBIEE. The reason I did this is I wanted to create a report that utilized columns from the database that were not exposed in OBIEE, yet still utilize the functionality of OBIEE. Why else would you use this and how

UCP Alert— Unidentified Connection Pools Read More »

Direct Database Request, OBIEE, Tips

Help! The WebLogic Dog Ate My Pages!

OBIEE 11.1.1.9.0 is a big step up from the earlier versions, and there are plenty of great things to appreciate about it. However, one thing that I am not that excited about is an error that crops up from time to time in Enterprise Manager. The mystery error looks a little like this: As usual,

Help! The WebLogic Dog Ate My Pages! Read More »

OBIEE, Tips, Weblogic Server

Mind the Gap — Getting the Number on ODI Sequences

At work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table. Unlike other similar IKMs, this module uses

Mind the Gap — Getting the Number on ODI Sequences Read More »

ODI, Tips

ODI 12 LOOKUP Components

In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target

ODI 12 LOOKUP Components Read More »

ODI, Tips

RPA Blog