Data Analytics Blog | Data Blogs

Having ODI 12c Studio Performance & Memory Issues?

ODI 12c Studio slow to respond? Receiving low or out of memory warnings? ODI 12c Studio crashing? With an out-of-the-box ODI 12c installation, the memory allocated to ODI Studio is generally too low to handle complex tasks — multiple modifications on a complex mapping, regenerating multiple scenarios, prolonged development sessions, etc. When completing such complex tasks over […]

Having ODI 12c Studio Performance & Memory Issues? Read More »

ODI, Tips

OBIEE Warning: Unused Physical Tables

If you’ve ever developed an OBIEE Repository (RPD) in which you’ve configured a multi-table Logical Table Source (LTS), you’ve likely been plagued by the following warning: There are physical tables mapped in Logical Table Source “Logical Table Source Name” that are not used in any column mappings or expressions. If you’re a Type-A OBIEE Developer

OBIEE Warning: Unused Physical Tables Read More »

OBIEE, Tips

Oracle BICS DITL Part 03

If you’ve been following this series, you’ll know that in Part 01 of my day-in-the-life (DITL) I worked on getting my first data set loaded and in Part 02 I learned the ins-and-outs of loading additional data into the same table. In both articles, my data comes from Square, which is my wife’s POS system for her store. In

Oracle BICS DITL Part 03 Read More »

Oracle BICS

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

Continuous Delivery of Analytics and BI: Part 1 Read More »

Tips

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

Oracle BICS DITL Part 02 Read More »

Oracle BICS, Tips

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

Oracle BICS DITL Part 01 Read More »

General, Oracle BICS, Tips

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

Derived Effective Dating Read More »

Data Integration, Tips

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

Concurrent RPD Development with OBIEE: The Checkmate Approach Read More »

Red Pill News, Tips

Weird Results When Calculating Percentages or Ratios…

While I was looking into a calculation issue today for a calculated percentage, let’s say the formula is ((b-a)/c)*100, the numbers just were not coming out correctly. Actually they were all coming out to 0! I know this was not right, so I investigated. I looked at my physical query and noticed OBI was creating that

Weird Results When Calculating Percentages or Ratios… Read More »

Tips

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

What’s Your (Dimension) Type? Read More »

Data Integration, Data Modeling, Tips

RPA Blog