Monthly Archives: October 2013

My Favourite Blog Posts of the Week

indexOBIEE News is out!

OBIEE News is out! Edition of 21st October.

rssBlogs of the week

1.  Steps to Apply OBIEE 11G Patch

In this blog, Sandeep Venu goes through three simple steps to apply the OBIEE patch:

1. OPEN Command prompt as administrator and set the given variables

2. Unzip the patch folder and keep in the local dirive

3. Navigate to patch folder

Read the blog for the full instructions.

2.  Action links in OBIEE

Kashif explains how Action Links comprises of two methods – dashboards and columns in analysis methods.

He goes through the Dashboard Action Link and the Analysis Action Link then studies in detail the types of Action

  • Navigate
  • Invoke

He then goes through the Steps to Implement Action Links on Dashboard. Read the whole blog here.

3.  How to use RESTful to avoid DB Links with ā’pěks

In this blog, Kris goes through the following steps:

1. Make the RESTful service

2. Install PL/JSON

3. Glue Code

4.Make a page in Application Express

5. It’s alive!!

4.  Are you up to speed on Oracle Application Express 4.2?

In this Oracle Technology Network’s Blog, Laura Ramsay states What’s to know, An Interesting piece of trivia, A Cool Feature of APEX 4.2 and What’s New.  Read it here.

5. SQL Developer Quick Tip: Reordering Columns

Jeff Smith asks – “Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data?”

He tells us not to do that and shows us how!

6.  How to create application roles automatically

Here, Matthias Kietze discusses how to create application roles automatically. He states, “Sometimes it is necessary to create application roles in Enterprise Manager via script. This is not very difficult.” Then he talks us through how to do this.

7. Effective Regression Testing for OBIEE Applications

Mike Jelen says, “If a butterfly flaps its wings in Costa Rica tonight, will the CFO’s Executive Financial Summary dashboard still work?”

He gives three approaches to Regression Testing:

1. Identify commonly executed queries with Usage Tracking (or just identify a specific request’s logical query), then execute the corresponding logical sql using nqcmd.exe.

2. Implement Oracle’s Application Testing Suite

3. Set up a series of webcat (HTTP) requests that can be executed on a scheduled basis by an automated web testing utility.

8. Insert an Image in the Narrative View

Sandeep Venu talks us through the two steps:

1. Place your images in the detailed paths

2. Create your analysis/report by adding the required columns to the criteria tab. Click on Results tab and create “Narrative View” and then paste the given code in the Narrative box.

See the blog post for further details.

9. More Praise for the Siebel Framework

In this blog, Alexander Hansal lays out the benefits of the Siebel framework in a bit more detail in terms of:

  • Technical Architecture
  • Logical Architecture
  • Extensibility
  • Features

10. How to access the DAC server using the command line

In this article, ClearPeaks look at how to set up the command line access to the DAC server and how to use the commands available. Finally, they explore how to create a script that automatically restarts an ETL execution if it has failed.

11. BIApps and BIApps on same machine ?

In this post, Saichand Varanasi asks “Do I need to uninstall existing to run my bi instance smoothly?”

12. Oracle Business Intelligence Enterprise Edition Samples

The Sample Application (SampleApp) for Oracle Business Intelligence Suite Enterprise Edition is a comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices.

Also, includes a link to YouTube BI Tech Demos and a video to show how to download all image files at once.

linkedin logoThis week on LinkedIn

Kris Poria posted Oracle Becomes Second Largest Software Company in the World

Uijal Das shared ERP Strategy Guide: Mitigating ERP Risks

Anand E posted Mastering Calculation Manager with Essbase and Planning

twitter logoThis week on Twitter

Just Analytics tweeted a link to their latest blog post OBIEE 11g – User Folder Path Hashing

Oracle Analytics shared Should Mobile be the New Desktop? (Kevin McGinley’s Blog)

OracleBlogs posted a link to Fusion Middleware (FMW) Proactive patches including SOA Suite

cropped-dreamstime_s_30492048.jpgOracle Team USA News

America’s Cup winner Rome Kirby visits alma mater, Rocky Hill School


Music and the America’s Cup

In a unique approach to integrating sport and music, organizers of the 34th America’s Cup delivered a multi-faceted arts and entertainment program throughout the Summer of Racing.

Blogs of the Week

indexOBIEE News is out!

OBIEE News is out.  Edition of 14th October

rssBlogs of the Week

1. Comparing Performance Using a Union Query

In Kevin McGinley’s blog, he investigates comparing performance using a union query. He states that this is not really new functionality, but a technique he used many years ago. A recent conversation prompted him to post it.  Hopefully, it will come in useful!

2.  New Bigger Model Exalytics T5-8 Introduced

Also, read the full press release here.

3. Oracle BI and EPM Demonstration SampleApp V309 on OTN

The latest new version “SampleApp” V309R2 BI and EPM VM is now available for download by partners from OTN here. This includes a wealth of examples and how-to demonstrations, as well as examples for the new BI Mobile Application Designer, 19 “Apps” and more local data-models.

Also, watch the video – How to download all virtual appliance files at once

linkedin logoThis week on LinkedIn

Kris Poria posted Oracle President Mark Hurd to Keynote on the Role of Big Data in Modern HR at Oracle HCM World

Anshu Monga shared Your Career growth is sure with Oracle SOA second-largest application infrastructure middleware

Ashish Raj posted BI APPS DAC, Informatica) Online Training

Ian Bristow shared OBIEE Problems with Chrome (update 30)  Read the discussion here.

Join the LinkedIn group here.

twitter logoThis week on Twitter

Tim Hall tweeted WebLogic 11g, Forms, ADF, Oracle Linux and VMware

Shiva Molabanti posted a link to OBIEE naming convention changes

Oracle Blogs shared How to use to build a auto stretching table in ADF

Follow me on twitter for daily OBIEE News and Links.

cropped-dreamstime_s_30492048.jpgOracle Team USA

ORACLE TEAM USA, Boeing to Recycle Composites in America’s Cup-Class Yacht

How does Java fuel Oracle Team USA?


Blog posts of the week


OBIEE News is out!

OBIEE News is out! Edition of 7th October

Blogsrss of the week

1. Physical Layer Tips from OBIEE Express

In this blog post, Kishore looks at the physical layer problems of:

  • Circular Joins
  • Nullable Flag
  • Primary Keys
  • Complex Joins
  • Filtering

2. Oracle Open World 2013 – Wrap up

In this blog post, the highlights of Oracle Open World for Danny Byrant are shared. Read his detailed blog to find out more.

3. Configuring Oracle Business Intelligence 11g MDS XML Source Control Management with Git Version Control

In this post, Christian Screen explains how this tutorial was developed so that anyone with a basic understanding of the Oracle Business Intelligence (OBI) development lifecycle can learn how to configure the Oracle Business Intelligence 11g ( metadata repository for development using the new MDS XML source control management functionality. Read the full tutorial here.

4. Top 10 Costly Mistakes for Business Intelligence / OBIEE Implementation Projects

Arun Kumar discusses the Top 10 Costly Mistakes for Business Intelligence / OBIEE Implementation Projects of which two are ‘Not setting the expectations right with users and senior management’ and ‘Going for BI Apps and assuming all out of the box reports will be ready and used by business’. Read all ten mistakes in the post.

Other News

Best Practices for OBIEE 11g Security

Learn about OBIEE 11g security in a step-by-step series as part of the TechTip forum. Simply register your details to access the video.

Oracle Application Express—What’s it All About?

Here, Peter Lorenzen talks about what APEX is, discusses application development, reports, charts, MS Excel Integration, User Interface and so on.  Well worth a read – to both those new to APEX and those more familiar.


The 2013 Winners of the Partner of the Year Awards have been announced.

UKOUG Business Intelligence Partner of the Year

Gold – Rittman Mead Consulting
Silver – IBM
Bronze – Percipient Consulting

Many Congratulations!

This week on linkedin logoLinkedIn

Ian Bristow shared OBIEE problems with Chrome (update 30) and SampleApp V309 is now available for public download from OTN

Uijal Das shared Oracle Special: Oracle Magazine. Click on the link and request your free subscription.

Monica Hasebi shared a link to Essbase Analytic Link Webinar Recording & Presentation

Philippe Lions shared Oracle Business Intelligence Enterprise Edition Samples

Join the LinkedIn group here.

twitter logoThis week on Twitter

Cezar Ovidiu tweeted Oracle Business Intelligence Enterprise Edition Samples

Oracle Blogs posted a link to ‘Partner Webcast – Oracle SOA: Simplifying Cloud, Mobile, and On-premise Integration – 24 Oct 2013.‘ and ‘ADF How-To #12: Deploying Customizations to Standalone WLS.’ shared ‘Practical Uses of Business Scorecards, from Company-Wide to Process Specific.’

Follow me on twitter for daily OBIEE News and Links.


Oracle Racing News

Replay: America’s Cup Final – Race 19

Sir Ben Ainslie: ‘I’m not so stupid as to think I did it alone’

Champagne spray and hugs all around as ORACLE TEAM USA celebrated victory in the 34th America’s Cup.