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.

    On Wearables, IoT, and How They Fit into Oracle’s UX Strategy
    Submitted by Kathy Miedema, Oracle Apps UX
    Check out the latest from the Oracle Apps UX Team. This group stays on the edge of everything UX, and the latest "thing" is wearables: glasses, watches, headsets, and more. Plus, the Apps UX Team is sponsoring the ODTUG Scavenger Hunt at Kscope15. 

    Marur.png Configuring SSL in OBIEE 11g
    Krishna Marur, Brother International
    This white paper covers configuring SSL for OBIEE 11g in a scenario where the SSL certificate is not in a format that WebLogic Server (WLS) readily accepts: Java KeyStore (JKS) file. First, a certificate request (.csr) should have been generated on the server where SSL will be configured and a signed certificate obtained from a Certificate Authority (CA). Consider that IIS web server was used to generate the certificate request. The signed certificate from the CA will have to be installed on IIS because the request originated from IIS where the private key for the certificate is stored. Once the signed certificate is installed, you can export it along with the private key.




    Unleashing Hyperion Planning Security Using ODI
    Ricardo Giampaoli, TeraCorp
    Rodrigo Radtke, Dell
    In some Hyperion Planning projects, security becomes so complex that it takes more than just granting access to some security groups on the high-level members of the dimensions. Global companies often have the necessity to create multiple Planning applications to meet the diverse regions of the globe. However, what happens when the business requires a single application with a single plan type that contains cost centers from different regions around the entity hierarchy? Moreover, is that data restricted according to the region’s security group using only one attribute dimension? Furthermore, does each user need to see aggregated values correctly for your region only? This paper demonstrates how to generate and maintain leaf-level member security settings based on attribute dimension on a global Hyperion Planning application using only ODI and Hyperion Planning application metadata repository information.

    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.

    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 © 2015