Easter is Sailing Time

Every year my Easter involves a major sailing competition. This year we are at the Olympic venue of Weymouth, and we are staying in one of the Olympic village houses, which are vry nice and up for sale Should I get one?
Keep up with the action here.

You heard it here first. The next Americas Cup will be in AC45′s. Cool.
Mind you not cool if they do go ahead with the Honalulu Plan, but San Diego would be nice.

paperli

Paper.li

OBIEE News is out! Edition of 14th March

Stories from mandsconsulting.com, obibb.wordpress.com and blog.3sixty-analytics.com

Videos such as: Regression Testing: Do your users think OBIEE is unreliable?

Blorssgs of the Week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. Set up https (SSL) for Weblogic and OBIEE

Daan Bakboord blogs (with the help of guest authors Menno Harzing and Rob Chou) about being confronted with the fact that in a new environment, Oracle eBS runs on https while the Oracle BI environment was still http. The steps in this blogs are followed to protect data-transport from/to OBIEE via the internet.
There are two parts described in the blog to accomplish this:

Part One – Configuration under Weblogic Console
Part Two – Configuration under OFMW Enterprise Manager

2. 3rd Party Visualizations in OBIEE – Part 2

Kevin McGinley says, “In Part 1 of this post, I wrote about why you might want to add third-party visualization capabilities for OBIEE and gave a brief explanation how to setup one approach: calling java visualization engines.  In this post, I’ll give a simple and a more advanced example of how to do this specifically in one of the engines: Flot.  In Part 3, I’ll do the same for D3″

3. Endeca – create a new data domain in Linux

Simon Parsons discusses how to do this and refers to a document entitled “Integrator Migration Guide

4. EPM 11.1.2.3.500 Patching Woes, Trials, and Tribulations

Cameron Lackpour warns, “Don’t take infrastructure advice from me.  Ever.  That begs the question, “Why are you reading a blog post on infrastructure by yr. obdnt. srvnt.”?  Simply because tales of suffering, woe, and misadventure are always instructive and sometimes entertaining.  Read below to know that when I write this I state the truth.”

5. OBIEE – Changing the search defaults to contains and no Match Case

Boris Dahav starts this post saying, ”

This post (done on obiee 11.1.1.7.140114) describes how to change the the search default from “Starts” to “Contains” and un-check the Match Case mark (as default).This week 2 different customers requested the same: changing the search default to “Contains” with Match Case not marked.”

 

6. Oracle Text and Oracle Data Miner

Brendan Tierney begins by saying, “This blog post is a follow up to comment on a previous blog post and to some emails. Basically the people are asking about some messages they get when they open the Oracle Data Miner tool, that is part of SQL Developer. If you are just using the SQL and PL/SQL functions in the database then you do not have to worried about Oracle Text. You will receive no warning message. But if you use the Oracle Data Miner tool you will get a warning message.” Read on for further details.

linkedin logoThis week on LinkedIn

Raqsoft OLAP shared Tap Utmost Value of Excel

Mayuri Agrawal shared a link to BI Course YouTube videos including:

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logoThis week on Twitter

Rick Sturm shared How Big Data Is Changing Air Travel

Marcus Borba tweeted Big data, little kids, and the parents in between

OraNA.info shared Twitter Tuesday – Top 10 @ArchBeat Tweets – April 1-7, 2014

Follow Addidici on twitter for daily OBIEE news and updates.

OBIEE and the Big Data

paperliPaper.li

This week’s OBIEE News is out! Edition of 31st March

Stories from kentgraziano.com, obibb.wordpress.com and mkashu.blogspot.com

Videos such as: Crystal Reports to OBIEE conversion

blogBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. Big Data and Analytics Top Ten Trends for 2014

Daan Bakboord posts the Top Ten Trends “Big Data” & “Analytics“ for 2014 posted recently by Oracle. The original paper is here.

2. 3rd-Party Visualizations in OBIEE – Part 1

Kevin McGinley puts together in a blog the presentation he gave at the BIWA Summit. This blog is Part 1 in a 3 part blog series.

3. Oracle Business Intelligence Applications 11g : Getting familiar With Oracle’s Business Intelligence Applications Configuration Manager (BIACM) & Functional Set-Up Manager (FSM)

This blog from KPI Partners says that the following questions arise:

  1. What has to be configured in BIACM?
  2. What is FSM meant for?
  3. Where is DAC?
  4. How do I create an execution plan?
  5. What is an offering?
  6. How to monitor the load?

Read the full and detailed blog post here.

4. OBIEE11g: Creating and Developing Custom Styles, Skins & Messages (Part 2)

In the second part of the series, Andrew Fagence explains how to develop and deploy a custom style and message.  He says, “There are many more combinations to try in terms of colours, fonts, other logo’s… The possibilities of customising OBIEE 11g to your companies needs are endless!”

5. Better Data Modeling: My Top 3 Reasons why you should put Foreign Keys in your Data Warehouse

Kent Graziano says, “This question came up at the recent World Wide Data Vault Consortium. Seems there are still many folks who build a data warehouse (or data mart) that do not include FKs in the database.”

He gives his main three reasons why you should include FK constraints in your Oracle data warehouse database as:

  1. The Oracle optimizer uses the constraints to make better decisions on join paths.
  2. Your Data Modeling and BI tools can read the FKs from the data dictionary to create correct joins in the meta data of the tool (SDDM, Erwin, OBIEE, Cognos, Bus Objects can all do this).
  3. It is a good QA check on your ETL. (Yeah, I know… the ETL code is perfect and checks all that stuff, bla, bla, bla)

6. Getting started with Hybrid Essbase

Cameron Lackpour says, “How do you use Hybrid Essbase? It’s actually very simple.”

  1. Install the 11.1.2.3.500 patches .
  2. Configure the Essbase.cfg file to use the ASODYNAMICAGGINBSO setting
  3. Tag all of the upper level members in your sparse dimensions as dynamic.
  4. Have fun, fun, fun, discovering what Hybrid can and cannot yet do

Read the full blog post for more information.

7. Major Update Releases for Oracle’s R Technologies

“March 2014 turned out to be a banner month for the team working on Oracle R Enterprise, Oracle R Distribution, and Oracle R Advanced Analytics for Hadoop.” See the Oracle R Technologies page here and watch “StubHub Creates a Safe Marketplace with Oracle Advanced Analytics”

StubHub uses Oracle Advanced Analytics to understand its customers in its online marketplace. Analysis times are much shorter, setup was fast and easy, and data scientists like the integration of R with the data warehouse.

 

twitter logoThis week on Twitter

OraNa.info tweeted How To Find Application Data For Use In Customization & Integration

Rachel@NCSLondon posted Oracle Becomes ‘Kinder, Gentler,’ President Hurd Claims

Jeff Smith posted A Few Thoughts Regarding Oracle Open World 2013 from the Archives.

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Daisy Ding  posted esProc Helps Database realize Real-time Big Data Computing

Timothy J. Simkiss shared How Financial Automation Turns CPAs & Controllers Into Financial Close Superheroes

Mark Willems  posted information about the Webinar Leverage the Benefits of a Comprehensive Advanced Analytics Platform

Nithya Regina asked for help: Need Help : Fmap Image Not Shown When Printing to PDF – Fmap Function Showing White Space Instead – Image Can be Seeing in Dashboard but not in pdf —OBIEE analytics

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

A HUGE OBIEE Week

paperli

Paper.li

This week’s OBIEE News is out! Edition of 24th March

Stories from thatjeffsmith.com, sranka.wordpress.com and rittmanmead.com

Videos such as:

The Intelligence Guy – Oracle BI Mobile

blogBlogs of the Week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. EPM patch 11.1.2.3.500 has landed

John Goodwin says, “Finally after a long wait EPM 11.1.2.3.500 has arrived and the patch comes in a bundled 1.8GB download or as Oracle likes to call it a superpatch.”

Read the full details here.

2. OBIEE BI Publisher prompts not visible when added to dashboard page

Arun Kumar writes, “When creating a BI Publisher report from a BIP data model, we can add prompts on the report directly to have interactivity on the report. This is specifically useful if you end up creating a BIP report when all required field are not available in the Subject Area, and the report is more like a one-of report (not requiring any further Ad-Hoc analysis). The report and prompts work well when accessed from a catalog directly. But when you try to add the same BIP report to a dashboard page, it does not show the prompts for some reason.”

He then explores in his post, two workarounds for this problem.

3. OBI Mobile App for Android devices available now

Download it from the Play Store.

Shiva Molabanti gives us some useful screenshots as a taster!

4. OBIEE 11g – Multiple Instances on Computer – Auto Ports Vs Custom Ports

Pravin Khadakkar states, “The standard installation of OBIEE 11g would configure software components to default ports. These ports may be different if it is chosen manually during installation process. The problem arises when company plans to install multiple instances of Oracle Business Intelligence on a single computer; there is a need to decide on a port management strategy. There are two options; the first option is to allow Oracle Business Intelligence 11g Installer to assign the ports for each instance automatically while other option is to assign ports through a custom port configuration file (.ini).”

He then goes through:

  • Auto Port
  • Custom Port Configuration
  • Review Configuration
  • Commands to Find Active Ports

5. Live from the 1st Annual World Wide Data Vault Consortium: Day 1

In the 1st of three posts, Kent Graziano gives us the news from Day 1 of the 1st Annual World Wide Data Vault Consortium.

6. Live from the 1st Annual World Wide Data Vault Consortium: Day 2

Read on for the highlights of Day 2.

7. Live from the 1st Annual World Wide Data Vault Consortium: Day 3

…and finally the news from day 3!

8. Open World 2014 – guidelines for call-for-papers…

Keith Laker provides us with his top 10 list of guidelines for submitting proposals including:

* Make the title and abstract interesting – Your title and abstract must be easy to read and make sure you introduce your main idea as early as possible. Review the titles and abstracts from previous conferences as a guide. Ideally make the issue relevant to the delegates attending OWW, get to the point, and make sure it is easy to read.

* Look at previous presentations – the content catalog for last year’s conference is available online,see here:https://oracleus.activeevents.com/2013/connect/search.ww?eventRef=openworld. You can review all the titles and abstracts that were accepted and use them as guidelines for creating your own title and abstract for this year’s conference.

Read the full article for more fantastic tips.

9. Creating Text Entry in Essbase – SmartList

Steve Yeung explores SmartLists in this blog. He concludes with, “The interesting part is that OBIEE doesn’t seem to support SmartList for some reason. Let me see what I can do to retrieve this list later on next week.”

10. Oracle BigDataLite version 2.5.1 is now available

Brendan Tierney tells us of that a new updated versions of the BigDataLite VM was released on Wednesday.

The following components are included on Oracle Big Data Lite Virtual Machine v 2.5:

Oracle Enterprise Linux 6.4

Oracle Database 12c Release 1 Enterprise Edition (12.1.0.1)

Cloudera’s Distribution including Apache Hadoop (CDH4.6)

Cloudera Manager 4.8.2

Cloudera Enterprise Technology, including:

Cloudera RTQ (Impala 1.2.3)

Cloudera RTS (Search 1.2)

Oracle Big Data Connectors 2.5

Oracle SQL Connector for HDFS 2.3.0

Oracle Loader for Hadoop 2.3.1

Oracle Data Integrator 11g

Oracle R Advanced Analytics for Hadoop 2.3.1

Oracle XQuery for Hadoop 2.4.0

Oracle NoSQL Database Enterprise Edition 12cR1 (2.1.54)

Oracle JDeveloper 11g

Oracle SQL Developer 4.0

Oracle Data Integrator 12cR1/

Oracle R Distribution 3.0.1

It can be downloaded from here.

twitter logo

This week on Twitter

Alexander Hansal tweeted Time to Learn the Languages of the Web (and Good Design) and Oracle announces Java 8

John de Voogd shared Six Challenges of Big Data

Blake Ramsey tweeted The Bold Data Project: Big Data and the Tailored Fit

Oracle Blogs posted OBIEE:Difference between High Availability and Scale Out

OTNArchBeat shared OBIEE Security Examined: WebLogic Security

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

posted “Oracle SOA” online DEMO Session Scheduled on Saturday, 29 March at 8:00 AM IST.

Kent Graziano shared Live from the 1st Annual World Wide Data Vault Consortium: Day 2 and  Live from the 1st Annual World Wide Data Vault Consortium: Day 3

Paul Anderson posted Patch Release: Hyperion Essbase 11.1.2.3.500 PSU

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

Another Awesome OBIEE Week

paperliOBIEE News is out

Read this week’s Paper.li – Edition of 17th March

Stories from mandsconsulting.com, obibb.wordpress.com and siebel-essentials.com

Videos such as: Nurturing Innovation with Oracle Business Analytics

rssBlogs of the week

1. Purging corrupted OBIEE web catalog users

This blog by Christian Berg says, “Sometimes it can happen that user profiles within a web catalog become corrupted for any number of reasons. In order for these user profiles to be correctly re-initialized, there’s more to be done than just drop /users/JohnDoe from the web catalog.

All in all there are three distinct places which need to be cleaned:

  • /users/JohnDoe
  • /system/users/123456
  • /system/acocuntids/987654″

He then goes on to explain how to do this.

He asks us to note that this is a quick & dirty solution and he hasn’t fool-proofed it with any check like “does the folder exist” etc. so use it cautiously and at your own risk!!

2. Global Currencies in Oracle BIA

Daan Bakboord writes, “If you read the Oracle Documentation for Oracle BIA (7.6.9.3), you could find the following; “Currency conversions are required because your business might have transactions involving multiple currencies. To create a meaningful report, you have to use a common currency.”

Oracle BIA stores amounts in the following currencies;

- Document Currency –> Currency of the actual Transaction (Can vary in a multinational organization)
- Local Currency –> Currency defined in the Ledger
- Global Currency –> Defined in the DAC

You can use a Global Currency if you want to report all the different Currencies in one Global Currency (eg. ‘EUR’, or ‘USD’). Oracle BIA for Oracle eBS is able to report in 3 different Global Currencies. If you use Oracle BIA for CRM, you are able to store an additional two Global Currencies. You define the Global Currencies in the DAC.”

Read on for further details.

3. New Features in Oracle Fusion/Cloud Applications Release 8

Alexander Hansal writes, “As announced a few days ago, Oracle has published a new release of its Fusion Applications (ERP, HCM, CRM) product line, namely Release 8.”

Alexander gives his personal list of highlights as:

  • New Skyros Theme
  • Redesigned Global Header
  • User Interface Text Editor
  • Application Composer

4. Finding Calculated View Columns

Jeff Smith says, “Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the column comments. Now imagine someone is asking you for a full accounting of these so they CAN be documented.”

Jeff then goes on to give us a solution to this.

5. OBIEE 11g – How to Add New Fonts in Answers and Dashboards

This blog by Pravin Khadakkar is an attempt to share information he recently came across regarding adding new fonts in Answers and Dashboards.

He goes through processes for ‘Add New Font’ and ‘Add Font in Schema for Validation.’

6. Performance testing of Hive, Impala and esProc Part 2

In the previous article, they tested the grouping computing. In this article, they test their performances and compare their results in associating computing.

Have a look at our blogger database. Not listed? Contact us to be added on.

twitter logoThis week on Twitter

John de Voogd tweeted Big Data Drives The Smart Car – InformationWeek

Cezar Baisanu posted Simple workflow implementation in APEX

Alexander Hansal shared Oracle reverses decline in hardware revenue during Q3

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Raqsoft OLAP posted Performance Comparison Testing of Hive, esProc, and Impala Part 1

Simon Berglund  shared Commonwealth Bank hopes business app will win new customers

Paul Anderson  posted Important! Discoverer Statement of Direction

Divyesh Dave PMP shared What Are The Differences Between SQL Analytical Functions rank, dense_rank and row_number?

Come and join in our group discussions on LinkedIn.  There are over 8,000 members conversing  about OBIEE news and updates.

Better Late Than Never

paperliPaper.li

This week’s OBIEE News.  Edition of 10th March

Stories from thatjeffsmith.com, obibb.wordpress.com and kentgraziano.com

Videos such as: Hackers are Reputation Thieves

and Creating a Studio chart using data from multiple views

blogBlogs of the week

Are you featured in our Blogger Database? If not, please contact us in order to be listed.

1. Important! Discoverer Statement of Direction

Product Management have released the Statement of Direction for Oracle Business Intelligence Discoverer Tools.  This document is available to download from My Oracle Support. It contains vital information about:

  • Oracle’s Product Strategy
  • Oracle’s Support Policy
  • Oracle’s Recommendations to Customers

2. ODM: Changing the bar chart format in Explore Node

This blog by Brendan Tierney says, “In Oracle Data Miner you can use the Explore Node to gather an initial set of statistics for your dataset. As part of this you will also get a bar chart that shows the distributions of the values contained within each attribute.”

He says that the default bar chart is a little basic and he then goes through the steps in order to change the bar chart to 3D.

3. OBIEE FusionCharts Part4 – FusionCharts Configuration

Steve Yeung has previously covered in this series:

Part 1 – Installation

Part 2 – Data Integration

Part 3 – Advanced Integration

In this 4th blog of the series, he goes through setting border, fonts, background and colours.

4. OBIA 7964 – Multiple Calendar Support Configurations In Five Easy Steps

Pravin Khadakkar goes through a scenario where the customer is implementing BI Apps 7964 based on E-Business source system. The source system has been configured for two sets of business lines within a flagship company. One is retail while other one is around oil, which is very valid business scenario in modern businesses. The retail and oil business have different ledgers with different type of calendars.

He says, “this blog is an attempt to showcase the configuration which I have done to achieve multiple calendar implementations within single business analytics warehouse.”

He looks at Calendar Formats, Calendar Categories and Calendar Configuration.

5. OBIEE 11g: Creating and Developing Custom Styles, Skins & Messages (Part 1)

Andrew Fagence says, “Within OBIEE 11g, it is possible to highly customise the appearance and the ‘look and feel’. This is because the UI (User Interface) within OBIEE 11g is compiled and generated from a script which can be edited. There are 3 main components which controls the appearance of the UI which are Styles, Skins and Messages.”

He then explores the difference between the three components. He goes on to explain how to modify and deploy custom skins. In the second part of the article,he says that he will explain how to deploy and configure custom styles and messages.

6. On-Demand: Why Integrate OBIEE, Essbase, and Hyperion?

This recording from KPI Partners covers:

  • Part 1 – What is all this stuff? (OBIEE, Essbase, Hyperion)
  • Part 2 – Differences Between BI & EPM
  • Part 3 – Why Integrate BI & EPM?
  • Part 4 – Integration Success Stories
  • Part 5 – OBIEE/Essbase Integration Demo
  • Part 6 – Q&A Session

7. Does your DBA hate you? 5 Tips for writing efficient SQL queries that get you some DBA love.

This blog by SQLdepbeta  says, “I spoke with my DBA friend today who runs an Oracle data-warehouse that’s about 2 terabytes big, at an international bank. I asked him: “What are some typical problems that users, data analysts, and DB developers have, that make you want to pull your hair out?”

They say that in his friend’s experience, the vast majority of performance problems fall into the following categories:

1) Don’t call a function or use expressions on an indexed column
2) Analyze the tables you create
3) Break down your work into bite-sized SQL steps
4) Use Distinct only when needed
5) Create indexes

They conclude:

“Database Admins, developers, data analysts, and other users are all part of the same team. As with nearly every other situation in life, patience, communication, and education are often the keys to working together smoothly to achieve common goals.”

8. Oracle BIA – Making the Full / Incremental Load work

Daan Bakboord says it is possible to configure either a Full- or an Incremental Load in Oracle BIA. He says that first you start with the Informatica Mapping. He tells us exactly how to do it here.

9. Bridging the Old BI World with Big Data Analytics

This article by Alex Woodie says, “We’re in the middle of a revolution in data analytics, where old beliefs and approaches are being discarded as new technologies emerge.”

Read on…

10. Evaluating BI Tools: Compare OBIEE with Open Source reporting tools

After exploring the comparisons, this post concludes by saying, “There is no perfect tool, it’s up to the individuals, from company visionaries to architects, from engineers and project managers to make things work perfectly. But knowing the limitation of each tools, I hope it can drive future improvement of these technologies, but more importantly, help the decision makers to make the right decision from the beginning.”

11. Learn a lot about Oracle BI

Daan Bakboord encourages us to educate ourselves, network and immerse ourselves in some real problems.  He also recommends viewing the Addidici blogger database for some superb reading material.

twitter logoThis week on Twitter

Bernard Marr tweeted Big Data: The One Strategy Missing In Most Companies

Cezar Baisanu shared Big Data vs. the Data Warehouse

John de Voogd posted A Brief History of Big Data, Analytics and Small Data

OraNA.info tweeted ORA-13504

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Paul Anderson shared RDA Version 8.03 Released

David Booth posted Determining data lineage: SQL scripts vs documentation

shared Download the free webinar on collaborative business intelligence

Alex Anvari asked In your organization, how do you find innovative ways to leverage your Enterprise Data?

Join the LinkedIn group for daily OBIEE discussions, news and updates.

National Jeff Day

blog

This week’s blog is dedicated to Jeff McQuigg, Senior Architect at KPI Partners

A little bit about Jeff:

  • He developed many of Siebel’s early Analytics v7.0 best practices & wrote part of the certification exam.
  • He has personally been involved with over 35+ OBI projects in every capacity (BI Architect, Data Modeling, RPD Metadata, Business Analyst, Report Developer, ETL Architect/Developer, Project Manager, Pre-Sales).
  • He is a BI & OBI Thought Leader:
  • Jeff frequently is an Oracle Open World Speaker.
  • He has developed OBI Deployment Methodology, deliverable templates and all Training programs with Metricsphere.

Some of his best blogs:

1. The Single Most Important Thing to Know About the OBI RPD

This blog from September 2013 states that Dimensional Hierarchies in OBIEE are used for a variety of important features. This post explores the fundamental reason for their existence and some specialized features that require their existence.  But mostly he discusses the single most important thing to know about the RPD!

2. Making Dims & Facts Work Together

Jeff says in this blog from June that this is a very common RPD modeling question on IT Toolbox. The problem is stated something like this:

“I have 2 fact tables and 3 dimension tables.  One of the dimension tables doesn’t work with Fact #2 while the other 2 dimension tables work with both facts.  When I make a report with all 3 dimensions and both facts, Fact #2 is incorrect or missing.”

He then restates the problem using ‘good BI language.’ The blog post also features slides from a recent presentation of his.

3. Bad BI Form

This blog from October 2013 was featured as one of our ‘Blogs of the Weeks‘. In this blog post, Jeff demonstrates visually how circles can not be compared easily but in a vertical bar, comparison is visually better. He says to keep this in mind when dealing with comparisons using area based visuals.

bi-charts-bad

4. Hanging In The OPN Lounge With Norm Dy & Jeff McQuigg

This blog from November 2013 features the following video:

5. HR Analytics at Wells Fargo – Project that won KPI Partners the Specialized Partner of the Year Award for BI and EPM

In this September 2013 blog, Jeff announces that the project he bled and sweated over for nearly a whole year won KPI Partners the coveted Oracle Excellence Award for North American Specialized Partner of the Year in BI & EPM (formerly know as the Titan Award). He has also written a presentation that goes into further detail about the project.

He goes through the following areas of the project:

  • Enterprise BI
  • Prototype-to-Production
  • Technical Solution for making multiple hierarchies end user friendly, all folded in with advanced data security
  • Performance

oracle

6. Keep It Simple Stupid

This blog from December 2012 was another to be referred to in one of our weekly blog posts.

Jeff says, “I’ve been spending a lot of time recently working on performance tuning projects.  Sometimes the BI apps are slow, sometimes it’s custom, sometimes it’s a mix.  I’ve gotten the chance to see what works in both Oracle and SQL Server. My conclusion about both of these databases is that they are like a cat or dog that gets fooled when you play hide the ball; they aren’t very smart sometimes.  The only way you can really truly ensure database engines, even modern advanced ones, do things the right way to is to make it as simple and easy for them to understand as possible.”

He covers this in the following way:

  • Star Schema not Snowflake
  • Map straight to fields
  • Use Good Date Joins
  • Outer Joins Should Be Outta Here

Papers and Presentations

Planning for High Performance OBI

This presentation from September 2010 has the following agenda:

  • Introduction
  • Logical Data Architecture
  • Physical Data Model
  • Physical Database
  • Oracle Focused
  • Physical Database
  • Oracle Focused
  • OBI Server
  • User Interface
Another presentation from September 2010, with the following agenda:
  • Introduction
  • Business Need & Solution
  • Technical Solution
  • Project Implementation
  • Agenda
  • Status & Future Plans
  • Challenges, Lessons Learned & Best Practices
  • Wrap-Up
From June 2011, this was the agenda:
  • Introduction
  • Physical Data Model
  • Physical Database –Oracle Focused
  • OBI Server
  • User Interface

Advanced MetaData Topics

This paper is from the Rittman Mead BI Forum in Atlanta, May, 2011. The agenda is:
  • Combo Tables
  • Make Dims & Facts Reach
  • Non-Conformed Dimensions
  • Canonical Time
  • Selecting a Logical Table Source
  • Controlling Join Paths

HR Analytics at Wells Fargo Bank

This is downloadable from the above link as a pdf.  It discusses the project that won the 2013 Excellence award for KPI Partners.  It covers:
  • Business Need & Solution
  • Project Implementation
  • Status & Future Plans
  • The Solution & Key Aspects
  • Data Model and ETL Efforts
  • Challenges, Best Practices & Keys to Success

Build a Performance Layer for Oracle Business Intelligence Applications 11g

This is described as:

“All the best work on your Oracle Business Intelligence Enterprise Edition–based system will be wasted if users are frustrated with long response times for dashboards and reports. Learn from an Oracle ACE with more than 10 years of implementation experience what contributes to poor performance and what the best solutions are to improve the end user experience and user adoption. This session discusses the creation of a performance layer to make dashboards and reports run at high speed. Samples scripts and the necessary mapping into the Oracle Business Intelligence Enterprise Edition Repository are also reviewed, plus architect and project manager considerations. The context is Oracle Business Intelligence Applications 11g, but the concepts are equally valid for custom-built solutions.”

Download the pdf from the above link.

Videos

Webinar: A Mix of Art & Science: How to Achieve High Performance Business Intelligence

Performance Tuning Oracle’s BI Applications

Contact details:

Contact Jeff via his LinkedIn profile or his blog

jeff

 

 

 

 

Super Busy in OBIEE World

Business Intelligence as we know it may be changing, and that very good news, because it means much more work.
Upgrades, installing new tech, new Fusion, New OTBI, new hardware, new ETL, new Bigger Data – All very good news for the eager to learn OBIEE consultant.

Keep Moving. Keep learning. Keep reading these blogs….

paperliOBIEE News is out! Edition of 24th February

Stories from M & S consulting, Rittman Mead and 3sixty Analytics

Videos such as Real Time BI with Kevin & Stewart: Ep 017

blogBlogs of the week

1. Data Guard

This post says, ” Learn how Active Data Guard will make your investment in a standby environment worthwhile via real time queries while applying the archived logs, converting the physical standby database to snapshot standby, and a host of new improvements in infrastructure.”

It focuses on:

  • Easier Creation of Standby Database
  • Active Data Guard
  • Snapshot Standby
  • Conversion from Physical to Logical Standby
  • Rolling Upgrade

and other Improvements.

2. Oracle Database 11g: The Top Features for DBAs and Developers

Arup Nanda says, “In this multipart series, learn how important new features such as Database Replay, Flashback Data Archive, Edition-based Redefinition, and SecureFiles work via simple, actionable how-to’s and sample code.”

The series focuses on:

and so much more.

3. OBIEE FusionCharts Part1 – Installation

In Part 1 of a 4 part series, Steve Yeung focuses on Installation. The post covers:

  • What does FusionCharts provide?
  • Installation
  • Test if it works

Continue to Part 2 here.

4. Collaborative BI ZigZag – BIWisdom Response

Christian Screen explores Collaborative BI, which he defines as ‘the means to communicate persisting knowledge and provide feedback within Business Intelligence systems in order to collectively make better business decisions.’

He apologises for the length of the post, as he didn’t have time to make it shorter! Well worth taking the time to read.

5. DateTime field conversion to a Date field in OBIEE

Arun Kumar says. “If you have a field in physical table which is of type DateTime, but you want to display it as only date in the report, then you this can be converted.” He then goes on to explore the two ways of doing this.

6. Hat Trick Tuesday – 3 new releases

Kris Rice blogs about the three new releases that took place on Tuesday 25th February.

7. Installing Oracle Database 11g XE and Unlocking the HR Sample Schema – A Tutorial with Screenshots

M & S Consulting advise, “When learning to develop Oracle Fusion applications, one of your first steps, if not already completed, should be to install a database for your applications to connect to.”

They go through Installing Oracle Database 11g XE and Unlocking the HR Schema.

They conclude by writing, “After completing this tutorial, you should now have a fully functional Oracle XE database with the example HR schema unlocked.”

Are you featured in our blogger database? Have a look. Contact us if you are missing.

linkedin logoThis week on LinkedIn

Ian Bristow shared OBIEE Version 11.1.1.7.140225 Now Released

 posted a video:

Kris Poria shared Oracle Planning and Budgeting Cloud Service Helps Organizations Adopt World-Class Planning with the Simplicity of the Cloud

Steve Yeung shared OBIEE FusionCharts Part1 – Installation

Join the LinkedIn group for Oracle Business Intelligence News, discussions and updates.

twitterThis week on Twitter

Oracle Blogs tweeted SOA Community Newsletter February 2014 and Fusion Concepts: Unique ID Generation

Kenny Mayne shared Media Report | Big (Bad) Data

KPI Partners posted Improving Revenue & Satisfaction With Social Media Analytics

Rene Kuipers shared OBIEE Version 11.1.1.7.140225 Now Released

Follow Addidici on Twitter for daily updates and news.