July 9, 2015

|

by: Kathryn Watson

|

Categories: ODI, Tips

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

June 9, 2015

|

by: Kathryn Watson

|

Categories: OBIEE, Tips

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

March 25, 2015

|

by: Stewart Bryson

|

Categories: Tips

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

March 13, 2015

|

by: KevinMcGinley

|

Categories: ORACLE BICS, Tips

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

March 11, 2015

|

by: KevinMcGinley

|

Categories: General, ORACLE BICS, Tips

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

March 9, 2015

|

by: KevinMcGinley

|

Categories: Red Pill News, Tips

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

February 6, 2015

|

by: Kathryn Watson

|

Categories: Data Integration, Tips

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

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