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.

    Case Study: How to Maximize User Adoption as Part of Successful Project Management 
    Christine Hubley, US-Analytics
    Every year, billions of dollars are wasted in failed technology projects. In Business Intelligence (BI) alone, over half of the projects undertaken are considered to be failures. Last year, this resulted in about $7 billion wasted. While projects fail for a number of reasons, many of those reasons are guarded against with good project management. Project management is a key ingredient in delivering successful projects. As a project manager, you manage time, money, resources, client expectations, and your team. But in my experience, the most important part of a successful project is often an afterthought. Are you managing the change the users are experiencing?

    SUNIL.png Use Smart View Smart Slice to Take Your Analysis/Reporting Capabilities to the Next Level
    Sunil Kumar, Infosys Limited
    The purpose of this article is to demonstrate how a little-known feature of Smart View called Smart Slice can be used to build intuitive and interactive ad-hoc reports in an integrated manner. Typically, the Smart View is used for row-column, format-based, ad-hoc analysis and reporting. It is up to the users to use additional MS Office features such as graphs, charts, or tables if they want to view their analysis or report output differently. This may, however, be time-consuming to build and inconvenient to use due to disconnect between the data retrieval and the representation, and moreover it depends on the user’s expertise with MS Office. This is where Smart Slice offers excellent features to build such reports within the single framework.

    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.

    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