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 BICSWelcome 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, TipsIt’s a bear. There, I said it. A bear. Wrestle with OBIEE RPD Development and you’ll feel like you’re wrestling with a big ‘ol grizzly bear. It’s not that the OBIEE metadata layer is bad, or that it doesn’t work, or it should be removed. Far from it. But work in the RPD long enough
Top 3 Challenging Things About OBIEE RPD Development Read More »
OBIEEIn 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 »
TipsStewart and I have both conducted training frequently in our past lives, so one of the things we wanted to include within Red Pill Analytics’ offerings is Oracle training. We’ve found over the years that boutiques tend to deliver a better training experience than Oracle because the trainers tend to be people with real world
Partnering with Peak Indicators Read More »
General, Red Pill NewsEverywhere 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, 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 this post, I’ll give a simple and a more advanced example of how to do this specifically in one of the engines:
3rd-Party Visualizations in OBIEE Part 2 Read More »
OBIEE, Tips