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 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
“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.”
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
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.
This week on LinkedIn
Paul Anderson shared RDA Version 8.03 Released
David Booth posted Determining data lineage: SQL scripts vs documentation
Monica Hasebi 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.