January 16, 2015

|

by: Stewart Bryson

|

Categories: Red Pill News, Tips

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 […]

December 17, 2014

|

by: FrankDavis

|

Categories: Tips

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 […]

December 16, 2014

|

by: Kathryn Watson

|

Categories: Data Integration, Data Modeling, Tips

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 […]

November 3, 2014

|

by: KevinMcGinley

|

Categories: OBIEE

It’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 […]

October 23, 2014

|

by: Stewart Bryson

|

Categories: General, Red Pill News

I’m the Best Choice for the ODTUG Board If you know me well, then the title of this story shouldn’t surprise you. I’m not short on confidence (okay… pun intended). But let’s face it, everyone running for the board believes they are the best choice for ODTUG, or they wouldn’t waste the time and effort. […]

September 8, 2014

|

by: KevinMcGinley

|

Categories: General, Tips

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 […]

August 28, 2014

|

by: KevinMcGinley

|

Categories: Tips

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 […]

August 7, 2014

|

by: KevinMcGinley

|

Categories: General, Red Pill News

Stewart 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 […]

July 1, 2014

|

by: KevinMcGinley

|

Categories: General, Productivity, Red Pill News, Tips

Everywhere 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 […]

June 20, 2014

|

by: KevinMcGinley

|

Categories: Events, Red Pill News

Kscope is my favorite conference all year. ODTUG is such a fantastic organization with great people, great followers, and always great content. Seriously, if you haven’t become a member yet, you should. The great thing about Kscope is that it’s more like going to a bootcamp training event than a conference. I find that many conferences are often littered with […]