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, TipsRed 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, TipsIn 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, TipsRecently, 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, TipsWhile 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 »
TipsIn 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, TipsIn 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
Direct Database Request -Part 2 Read More »
General, TipsI 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
Direct Database Request – Part 1 Read More »
TipsEverywhere I go, the sentiment is the same: the development lifecycle is hard in OBIEE. This sentiment rarely surfaces in the first implementation, but rather creeps-in over time, eventually whacking you upside the head with a baseball bat. You groan, moan, whine, curse, and start throwing things, but it doesn’t change reality. Then you start
Introducing Checkmate Read More »
General, Productivity, Red Pill News, TipsIn Part 1 of this post, I wrote about why you might want to add third-party visualization capabilities for OBIEE and gave a brief explanation how to setup one approach: calling java visualization engines. In Part 2 I walked through a detailed example of how to actually do this using a visualization engine called Flot. In this post I
3rd-Party Visualizations in OBIEE Part 3 Read More »
OBIEE, Tips