Volunteer SpotLight Featured Articles

    ODTUG Volunteer Spotlight: Opal Alapat
    Read the article

    The latest ODTUG Volunteer Spotlight shines upon Opal Alapat (al-uh-pat). You probably know Opal as the Kscope15 Content Chair for EPM/BI or maybe as a great speaker in the Hyperion/EPM world. You might not know that Opal is also one of ODTUG’s most prolific tweeters (@Opal_EPM) and a blogger, too.

    Opal is Services Engineering Manager at TopDown Consulting and spends her days finding ways to allow TopDown to provide better services to its customers and a great working environment for its consultants. In a nutshell, Opal’s focus is to help TopDown and its consultants succeed. Opal is one of TopDown’s premier consultants, working her way up through the organization to a management role once she got tired of traveling for work. Her position now allows her to work from home (most of the time) and be more creative with her career. That’s lucky for us at ODTUG because it provides her with more time for ODTUG and the user community.

    Born in South Korea (Opal is half-Korean), Opal’s family moved to Houston, Texas, when she was a toddler, and she is a loyal Texan to this day. She moved to Dallas 10 years ago and has no plans to move out of Texas anytime soon. One of my first experiences with Opal was when a conference committee meeting was scheduled in Dallas and she put together Texas welcome bags for all of the participants (much obliged, ma’am)!

    Read more about Opal here.

    JohnKing.png John King, King Training Resources
    Oracle PL/SQL Performance Tuning Tips & Techniques” by Michael Rosenblum and Dr. Paul Dorsey is a book you should read soon. A quote from Oracle’s Bryn Llwellyn in the book’s forward says it all “Every professional PL/SQL programmer should study this book and act upon its teachings.”

    Misha and Paul take the scientific route to performance, providing readers the how and why of effective performance. The first chapter sets the tone, showing how performance is an aggregate typically of nine steps from execution of code on the client side, through middleware, to server, and back again to the client. Learn how PL/SQL works from two of the best, whose shared stories of actual issues underline the importance of performance planning and thinking.

    Read more here.


    You must be a member of ODTUG to access the featured articles. Log in or click here to become a member of ODTUG.

    KevinM.png Part 3: Making the Case for Leveraging Agile and Continuous Integration in Oracle BI Development
    Kevin McGinley, Red Pill Analytics
    In part 1 of my article, I made the argument that the waterfall methodology is a methodology that we, as BI/DW professionals, blindly follow for BI/DW projects, even though they don’t make sense considering today’s technology and business demands. In part 2, I introduced Continuous Integration as a development practice that should be used in the Oracle BI world to develop in the OBIEE RPD. In this last part, the conclusion, I want to talk about how using an Agile development methodology in conjunction with Continuous Integration is the best way to develop and deliver content in OBIEE.

    dana.png Development Tools at Oracle OpenWorld 2014: A Recap
    Dana Singleterry, Oracle Corporation
    Oracle OpenWorld 2014 is now behind us, and it was filled with information and plans for the present and future presented by Oracle Product Management, developers, and evangelists the world over. This year’s event announced the release of our new design patterns, including the new Oracle Alta UI system, for building modern applications for multichannel delivery. Mobile was also front and center with a key announcement around in-depth integration between Oracle Mobile Application Framework (Oracle MAF) and Oracle Mobile Security Suite. Let’s not forget the cloud, with a focus on developer tooling in the cloud and the empowerment of non-technical users with Oracle Mobile Accelerator.

    Where Is My Input Data? How to Find and Convert Input Data into Level 0 Data
    Philip Hulsebosch, Trexco
    Bodo Abenhardt, Vodafone Germany
    If you want to convert an existing Block Storage (BSO) database into Aggregate Storage (ASO), you may find out some of the data in this BSO database has not been loaded at leaf level for all dimensions. You must load data at leaf level in ASO, so you need to have this data. Finding this upper-level entry data in a fully aggregated cube is difficult. This data is aggregated in the dimensions and likely cannot be found manually by drilldown. It will require a technical approach. This article will present you the method to find upper-level input data in a large BSO database and export it to be loaded at Level 0 in an ASO database. It will describe the steps required and the calculation logic applied to BSO.

    KevinM.png Part 2: Making the Case for Leveraging Agile and Continuous Integration in Oracle BI Development
    Kevin McGinley, Red Pill Analytics
    In part 1 of my article, I made the argument that the waterfall methodology is a methodology that we, as BI/DW professionals, blindly follow for BI/DW projects, even though it doesn’t make sense considering today’s technology and business demands. I introduced Continuous Integration and Agile as approaches we should be adopting instead and promised to explore both in parts 2 and 3 of this series. Given a more general lack of familiarity with Continuous Integration (CI) in the BI/DW space, it makes sense to tackle it first.

    WilliamHodges.png Keeping a 'Road from ODTUG' Conversion Experience from Becoming a 'Bumpy Road to Groovy Existence
    William Hodges, The Hackett Group 
    “Wouldn't it be nice if I could find ‘the one’?” Haven't we all said this at one time or another? Having been struck off his PowerShell horse on the way back from ODTUG by an Aultman bolt of lightning, a certain Essbase developer went into seclusion. There, he reflected on what had just happened, saw the light, rejected his automating ways, and set out on a new mission. Against all kinds of opposition and logistical roadblocks, he championed the conversion of a large collection of automation scripts from a Windows platform to a Linux platform, from CMD, esscmd, MaxL, VBScript, and PowerShell to Groovy. This is his story.

    Submit an Article
    Author Guidelines
    Search Archives


    Letter from Editor
    Karen Cannell, TH Technology
    As ODTUG opens a new chapter, commencing next quarter, our Journal will be entirely online and released in a distributed format. We will deliver one feature article and one or more of our regular columns right to odtug.com’s Tech Corner on a monthly basis. You will have the opportunity to give online feedback and comment on each article – and you know how we ODTUGgers like to exchange opinions!

    No worries, some things will stay the same—we will keep our same columns, so you can look forward to your favorites each quarter. We will also have greater opportunity and flexibility to bring you more varied content, to keep pace with the ever-growing family of Oracle development tools.
    Karen Cannell

    Our aim is to bring delivery of the ODTUG Technical Journal in line with today’s social media options. These days our members are consuming more information online, and in shorter formats, such as blogs, podcasts, newsfeeds, and tweets, as opposed to formal whitepapers and other printed media. The times, they are a changin’, and ODTUG is keeping up. Join us!

    2601 Iron Gate Drive, Suite 101 | Wilmington, NC 28412 | Phone (855) 853-0491 | odtug@odtug.com | Copyright © 2014