Continuous Delivery of Analytics and BI: Part 1

Anytime I’m speaking or presenting on either AgileAnalytics or continuous integration/continuous delivery, I usually insert a “Shadow IT Wants Your Soul!” slide complete with an image of Batman lurking in the shadows. For one… I’m a super-hero fan, and there’s always room for Batman. But secondly, and this time seriously: the folks setting the pace for analytics and BI […]

Read More

Oracle BICS DITL Part 02

Welcome to Part 02 in a series of day-in-the-life (DITL) posts about using Oracle BI Cloud Service (BICS) in a real-world setting, with no filters and lots of mistakes! In Part 01, I wrote about loading my wife’s point-of-sale data from Square as the basis for an application I wanted to build. After a few challenges around […]

Read More

Oracle BICS DITL Part 01

Red Pill Analytics recently purchased a license for the Oracle BI Cloud Service (BICS), and with our account being activated, I thought I’d take it for a spin. But rather than write a garden-variety series of how-to articles, I thought I’d give you a first-hand look, or a day-in-the-life (DITL) experience of what it was […]

Read More

The New ODTUG BI Community

At Kscope14, ODTUG announced that they would be rebranding the special interest groups (SIGs) into ODTUG Communities to reflect the growing focus on the people-aspect of ODTUG. Networking, connections, and friendship all make ODTUG the powerful force that it is today and there’s no greater satisfaction than connecting with like-minded individuals on all topics person and professional. This renewed focus […]

Read More

Derived Effective Dating

In my previous post, I discussed the transition from a Type 1 to a Type 2 Dimension structure after initial implementation. Today we’ll maintain our focus on Type 2 Dimensions and highlight derived effective dating and its timestamping implications. Why Effective Date? Within Type 2 Dimensions, it is essential that each record be effective dated […]

Read More

Concurrent RPD Development with OBIEE: The Checkmate Approach

Recently, my former colleague Robin Moffatt authored a blog post about approaches to Concurrent RPD Development, where he discussed some of the technical challenges around trying to use MDS XML as a core OBIEE repository development strategy. As usual, Robin’s attention to detail was spot-on, and he does a really nice job detailing some of the […]

Read More

What’s Your (Dimension) Type?

In the data warehousing world, much attention has been paid to detailing the different dimension types and the design selection criteria for each. A related data warehousing design conundrum has garnered little fanfare, however—a post go-live transition from one dimension type to another. In today’s post, we will focus on the transition from a Type […]

Read More

Direct Database Request -Part 2

In Part 1 of my story on OBIEE’s Direct Database Request (DDR), I walked through the basic process of how to use DDR for directly querying a database mapped ino the RPD without using logical SQL, bypassing the metadata layer and going straight to the connection pool. In Part 2, I’ll be pointing out what works differently […]

Read More

Direct Database Request – Part 1

I will be speaking at Oracle OpenWorld on Self-Service BI for Super Usersand the purpose of the talk is to outline various approaches and tips for leveraging different features across OBIEE, BI Publisher, and Endeca Information Discovery to enable better self-service capabilities for your users. Unfortunately, “self-service” is one of those terms like “big data” — ask 20 […]

Read More
Page 5 of 6« First...23456