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.

Leave a Reply