Monthly Archives: December 2013

News of the week plus some of the best bits of 2013

paperliOBIEE News is out!

Read the last edition of 2013!

Featuring posts and blogs from KPI Partners, Siebel Essentials and Art of BI

Also videos such as:

blogBlogs of the Week

1. Advanced Filtering in OBIEE 11g

This post is an extension of M and S Consulting’s last blog post about filters and selection steps. In this one, they focus their attention on writing logical SQL statements to help write more flexible ways to limit data writing case statements.

2. Data computing and integration, database parallel processing, alternative to R and Hadoop

This post focuses on:

– external memory computation

– data exchange

– memory sharing

– memory computation

3. Oracle SQL Developer: Potpourri and Random Thoughts

In this post, Jeff Smith answers the Million dollar question “When are you going to start charging for SQL Developer?” and looks back a little on 2013.

4. Types of Cloud Computing

The types of Cloud Computing are explored in more detail by Datawarehouse concepts.

  1. Hybrid Cloud Computing Deployment Model
  2. Community Cloud Computing Deployment Model
  3. Private Cloud Computing Deployment Model
  4. Public Cloud Computing Deployment Model

5.  OBIEE – Local minima and maxima in graph

Local minima and maxima (extrema) in graphs emphasis the points where the graphs change the trend. This post explores how to acieve it in OBIEE.

6. Is Data Quality The Biggest Threat To Obamacare?

“With the political problems hovering around the launch of The Affordable Care Act (“Obamacare”) now seemingly left behind, the biggest threat to the Affordable Care Act is now a technical one.” This post by KPI Partners explores this in more detail.

7. Cost-Effective Business Intelligence for Mid-Market Companies

Another post by KPI Partners where Jeremiah Johnson says “Business intelligence (BI) provides great insight into how a business is being run, as well as which aspects of the business are succeeding and which are failing.  A properly implemented BI system can provide a comprehensive breakdown of sales, and allows managers to react to an ever-shifting market.  However, smaller and mid-sized businesses tend to get the short end of the stick when it comes to business intelligence, as most of the hardware and software for effective business intelligence was too expensive for smaller organizations.”

Read the full blog post for more.

8. Adventures in OBIEE Upgrade Land: Quirks and Workarounds — Episode I

This is Blog 1 in a series of 3, where Jeremy Harris jots down any lessons learnt during upgrading!

See our blogger database here.

rssSome of the best blog posts of 2013 (in no particular order!)

1. How to Add Comments in Oracle BI (OBIEE) by The Art of Business Intelligence

“By adding comments in OBIEE users are able to provide their feedback on the decision making system of the enterprise.  Commenting on a dashboard or annotating a cell with feedback or other descriptive details can provide a great way to corroborate information or provide persisting perspectives. This commentary can then be viewed by other users who have access to the BI system.  Ultimately the goal of adding commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the BI System’s most prolific users. This is the basic concept of collective intelligence in Business Intelligence referred to as Collaborative BI.”

This post comprises of:

– Custom Build a Solution for Adding Comments in OBIEE

– What to know and What to ask for in a custom commenting solution

– Oracle APEX as a Solution for Adding Comments in OBIEE

– OBIEE Action Framework as a Solution for Adding Comments in OBIEE

– OBIEE BITeamwork Collaborative BI Solution for Adding Comments in OBIEE

2. My 3 Favorite Features of OBIEE

This blog by Corporate Technologies states that Waterfall Graphs, Table Scrollbars and Recommended Visualisation Views are their favourite three features of OBIEE!

3. Custom style and skin in OBIEE

Christian Berg tells us how to apply a custom detail in this step by step blog.

4. OBIEE Creating a Performance Tile View

In Ravi’s Business Intelligence Blog, he goes through the steps to take in order to create a performance tile view: He provides detailed instructions and screenshots of the steps.

5. Insert an Image in the Narrative View

In this short, yet informative post, Sandeep details step by step how to add images in the narrative view. See the steps plus screenshots here.

6. Steps to Apply OBIEE 11G Patch (Simplyfied)

Another blog from Sandeep, where he tells us how to simply apply the OBIEE 11g patch.  It’s as easy as 1-2-3!

7. Action Links in OBIEE 11g

In this blog by ‘All about DataWarehousing and Business Intelligence’, Kashif explores dashboard and columns in analysis methods. He goes through:

1. Dashboard Action Link

2. Analysis Action Link

3. Types of Actions

4. Navigate Action

5. Invoke Action Type

6. Steps to Implement Action Links on Dashboard and

7. Action Links in Analysis

Read his blog post here.

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

In Oracle Business Intelligence 911, The Top 10 Costly Mistakes for Business Intelligence / OBIEE Implementation Projects are listed as:

1. Not setting the expectations right with users and senior management.

2. Going for BI Apps and assuming all out of the box reports will be ready and used by business.

3. Not spending enough time on designing repository to enable intuitive ad-hoc reporting.

4. Lack of user involvement during development project.

5. Not testing subject areas for Ad-hoc reporting.

6. Not having BI standards for requirement gathering, development, testing and migrations.

7. Hiring a great data modeller experienced with relational source systems, and letting him lead dimensional model design.

8. Using relational models instead of dimensional model.

9. Not having application level backups or other faster ways for disaster recovery.

10. Having developers or power users write access to non ad-hoc reports in Test, or Production environment.

(He then adds an 11th – Having multiple installations of software within the same organization) Read the full blog for more details.

OpenWorldOracle OpenWorld 2013

Watch the videos, for example, Mark Hurd “Transforming Businesses with Big Data and Analytics” and download session pdfs

Read about the highlights from Server and Cloud Blog, Arik Hesseldahl, Danny Bryant and Oracle Fusion Middleware Team USA – Winners of the 34th cup!

Named as one of the biggest Sporting Comebacks of 2013!!

ORACLE TEAM USA stages massive comeback to win 34th America’s Cup

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

linkedin logoThis week on LinkedIn

We run a group on LinkedIn for Oracle Business Intelligence consultants, from large consultancies to independents. It is aimed at users and developers of OBI, including Siebel Analytics.  Over 7,000 members so far (and growing!), each one vetted to ensure they have a genuine interest in OBI.  Sorry no agencies and no general networkers.
The group is used for sharing information on Oracle BI, including events, news and social gatherings.

This week’s highlights:

Rob Burton shared If You Want Innovation, You Have to Invest in People

Ujjal Das posted a link to Free White Paper: Enterprise Backup and Recovery Methodologies for Oracle

twitter logoThis week on Twitter

Andrejus Baranovskis tweeted ADF Dynamic ADF BC – Surviving Passivation/Activation Events

Abhinav Agarwal shared Spark and Shark: High-speed In-memory Analytics over Hadoop Data

Follow me on Twitter for daily OBIEE news, links and updates.

Real Time Understanding OBIEE Deployments and Scheduling

paperliOBIEE News is out!

OBIEE News is out.  Edition of 9th December

Featuring blogs from KPI Partners, The Art of Business Intelligence and Siebel Essentials.

blogBlogs of the week

1. Scripted RPD deployments using UDML and WLST

In Ben Mackin’s blog, ‘Adventures in OBIEE’, it states that “with OBIEE 11g, RPD deployments are now handled through Weblogic, so we need to take some additional steps. Luckily these can be easily scripted thanks to WLST.”

He then goes through the steps.  Read the whole blog for more details.

2. Oracle SQL Developer v4 is Live & Top 10 Reasons to Upgrade Today!

Jeff Smith goes through the 10 reasons why we should upgrade.  These are:

1. Get a leg up on the competition

2. Lots and lots of dead bugs

3. Better connection management

4. Java 7

5. Finding stuff in the database is easier

6. New Command line interface

7. Reports are brand new

8. GIT

9. New Framework and updated look and feel

10. Version 3.2 is more than a year old.

Read in more detail here.

3. OBIEE 11g Selection Steps and Filters: Their Differences and How to Use the Two

This blog by M & S Consulting, explores the OBIEE 11g Selection steps and filters and how to use the two of them. Read the full blog for detailed instructions.

4. Scheduling OBIEE Reports with CRON

In this post by Shwetank Sheel, he says “I recently got a request from a colleague to help them with scheduling some reports for delivery, with the destination being a unix machine folder. I am aware that iBots can call a Java Program to write to a disk, and that BI Publisher’s scheduling engine can directly write to the disk, but I did not want to delve into any large lines of code nor even use the OBIEE scheduling. I wanted to see how I can make it a purely pull job from the unix machine side. To this end, I wrote a shell script to accomplish this.”

See the blog for this script.

5. Basic Understanding of OBIEE Report vs BI Publisher report.

In this blog, Bojie says that BI Publisher was originally a different application, which is now part of OBIEE. The best way to put it is, BI Publisher is another technology that has been integrated with OBIEE, so now the two are both parts of Oracle Business Intelligence. He then goes on to explain the difference between the two of them.

linkedin logoThis week on LinkedIn

Kris Poria posted Oracle Sponsors OpenStack Foundation; Offers Customers Ability to Use OpenStack to Manage Oracle Cloud Products and Services

Kashinathan K shared How to do Sorting in UNIX???

Kent Graziano posted Tech Tip: Connect to SQL Server Using Oracle SQL Developer (updated)

Arun Sadagopan shared Installing OBIEE services as Windows services

Join the LinkedIn group to see more posts and discussions.

twitterThis week on Twitter

Robin Moffat shared Getting Started with Oracle Endeca Information Discovery v3.1, Part 1: General Introduction

Oracle Analytics tweeted Big Data Episode 3: Acquiring Big Data

Oracle Blogs shared OBIEE Web services with javascript

Jeff Smith tweeted Oracle SQL Developer 4.0 Enhances Support for Oracle Database 12c

Follow me on Twitter for daily OBIEE news and updates.

youtubeYouTube Uploads

Agents, Passwords and the Oracle Data Warrior

indexOBIEE News is out!

OBIEE News is out.  Edition of 2nd December.

rssBlogs and News of the Week

1. Configuring Agents with OBIA and EBS Cookie Integration

This blog contains an explanation of what Ben Mackin did to get Agents up and running when using EBS and OBIEE in a setup with EBS Cookie Authentication.

2. Configure Change Password for Users in OBIEE 11g

This blog links to another article ‘Configure Change Password for Weblogic users in OBIEE 11g’ for guidance with this issue.

3. Oracle: Big Data at Work: Analytics to Run and Change the Business

Paul Sonderegger (Big Data Specialist) presents ‘Big Data at Work’.

4. UL and the Big Data Challenge

5. Customer Videos: Real-World Successes with Oracle Business Analytics Solutions

At Oracle OpenWorld 2013, a host of customers went on camera to discuss Oracle Business Analytics solutions and how they are using them to strategize and plan, optimize business operations, and capture new market opportunities. This page summarises five of the best and links to the YouTube channel which lists the rest.

6. New Release of Oracle Big Data Appliance Delivers 33 Percent More Storage per Rack

In November 2013, Oracle launched Oracle Big Data Appliance X4-2, which delivers the entire Cloudera Enterprise technology stack and 33 percent more storage capacity for a total of 864 terabytes per rack—plus comprehensive security capabilities including authentication, authorization, and auditing.

Oracle Big Data Appliance X4-2 is a comprehensive and secure engineered system optimized to run Cloudera’s entire platform for big data, Cloudera Enterprise, at a low overall total cost of ownership. To meet diverse computing requirements, it includes:

  • Cloudera Distribution for Apache Hadoop
  • Oracle NoSQL Database
  • Cloudera Impala
  • Cloudera Search

Read more here

7. The Business of Growing

Marta Bright, in this feature article, “Land O’Lakes invests in Oracle engineered systems to plant the seeds of change,”looks at Land O’Lakes as a case study.

8. Security and the Mobile Workforce

Now that many organisations are moving to the BYOD philosophy (bring your own devices), security for phones and tablets accessing company sensitive information is of paramount importance. In this article, he interviews Brian MacDonald, Principal Product Manager for Oracle Business Intelligence (BI) Mobile Products, about this subject, and he shares some wonderful insights about how the Oracle Mobile Security Tool Kit is addressing mobile security.

Tlinkedin logohis week on LinkedIn

Santhosh Reddy posted ‘deployment tab missing.’ Help him out with his query in the group.

Kent Graziano posted Better Data Modeling: The best FREE data modeling tool just got better!

Ujjal Das shared Free White Paper: Private Clouds for Oracle Databases

Saandeep Raghunath shared Prevent the FETCH FIRST XXX ROWS ONLY from Applying

Stephen Bowden shared his latest webinar on Data Visualization Techniques and the latest capabilities of OBIEE

Join the LinkedIn Oracle Business Intelligence group here.

twitter logoThis week on Twitter

KPI Partners tweeted What’s New In Oracle Manufacturing Analytics? [Examining OBIA 11g: The Series]

Paul Mitchell shared Why Oracle Purchased BitzerMobile and The Impact to Fusion Middleware

Search Oracle posted Oracle and big data architecture: Floyd Teter weighs in

Oracle Analytics shared Endeca Information Discovery 3.1 Expands Self-Service for Business Users

Rory Capon shared a video entitled “Installing OBIEE 11 G on Windows 8 – 64 Bit”

Follow me on Twitter for daily OBIEE News and updates.