Better Late Than Never

Paper.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

Blogs 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 SQLdep^beta 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.

This week on Twitter