Paper.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
https://www.youtube.com/watch?v=ByQ9t4Yt03o
Blogs 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.
This blog from KPI Partners says that the following questions arise:
- What has to be configured in BIACM?
- What is FSM meant for?
- Where is DAC?
- How do I create an execution plan?
- What is an offering?
- 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:
- The Oracle optimizer uses the constraints to make better decisions on join paths.
- 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).
- 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.”
-
Install the 11.1.2.3.500 patches .
-
Configure the Essbase.cfg file to use the ASODYNAMICAGGINBSO setting
-
Tag all of the upper level members in your sparse dimensions as dynamic.
-
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.
This 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.
This 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.