Well. This is it, the end of another great OBIEE year, and what a year of blogging it was.
I tried to find a top 10 blogs for 2014 but when I got to 22 blogs to choose from I decided to cover them all!
Happy New Year.
What will 2015 bring?
Christian Berg says that one of the questions that frequently comes up is ‘How do I change a part of the GUI of OBIEE?’
He says the point isn’t simply to say “do X in Y”, but rather “how do you get to know that you need to change X in Y?
He then talks us through the process.
Daan Bakboord summarises the RittmanMead BI Forum. He says that the program is varied with Oracle BI EE, Oracle Endeca, Aggregation Persistence, Big Data, Oracle Exalytics, Oracle BI Cloud, Oracle Information Management Reference Architecture etc. It was also a place to network and exchange ideas.
He also praised Robin Moffat for his presentation, ‘No Silver Bullets – OBIEE Performance in the Real World’.
Jeff McQuigg says, “When it comes to OBI report design, minimalist is the only way to go when it comes to the Criteria Tab. Whereas architecture and design are subjective, when it comes to keeping the criteria tab minimalist there is a strong, demonstrable benefit to this philosophy. It’s so important that this is the very first thing I look for when I am called in for a performance healthcheck review.”
This post takes a quick look into why.
Kevin McGinley writes:
“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 Part 2 I walked through a detailed example of how to actually do this using a visualization engine called Flot. In this post I will do the same thing for a visualization engine called D3.”
Myles Gilsenan writes of how he attended Oracle OpenWorld (OOW) 2014 recently with a focus on BI, Big Data and ERP.
He then summarises:
Business Intelligence (BI)
- BI Cloud Services
- BI Apps 18.104.22.168.8 (ODI version)
- Golden Gate and Real Time Reporting
- OBIEE/Essbase Integration
Enterprise Performance Management (EPM)
- Budgeting and Planning Cloud Service
- Big Data - Big Data Discovery, SQL for Big Data, Big Data Appliance
- Enterprise Resource Planning
- Oracle Fusion Apps
- Fusion Financials & Oracle Transactional BI
- Oracle Functional Set-Up Manager (FSM)
Peak Indicators discuss Version 2 with the new features:
- Map Visualisation
- Custom Maps
- Set of new functions with redesigned calculated fields
and improved functionality on:
- Redesigned authoring UI
- Exploration template
- Application level calculated fields
They then go through in detail:
- User Interface
- Calculated Field
- Multiple Filters
- Exploration Page
- New Map Visualisation
- New Custom Map
- Other Features
Dimitri Gielis says that at Oracle Open World, he gave a presentation about the integration of Microsoft Sharepoint and Oracle Application Express (APEX).
View his slideshow:
Tim Hall shares more thoughts on the Oracle ACE Program including the ‘Access to Information’ and ‘Access to Support’. Take a read.
Dimitri Gielis lists the the keyboard shortcuts in Oracle Application Express (APEX)
- R Project
- ES Series
Debra Lilley gives us her OOW14 overview including linking to her video
“2 Minute Tech Tip: Communication Between Technical and Business Stakeholders”
Christian Screen writes, “When I speak to people about the idea of collaboration in Business Intelligence, it usually begins by me explaining that in its simplest form Collaborative BI is the ability to comment or annotate a report or a dashboard in a BI System.”
He then goes on to explain ‘Collaborative BI’ further.
Christian Berg says, “NOTE: This is a quick & dirty solution!”
Daan Bakboord writes, “If you read the Oracle Documentation for Oracle BIA (22.214.171.124), 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.”
Andrew Fagence writes, “In my previous article (found here: http://blog.3sixty-analytics.com/?p=971) I explained how to develop and deploy a custom skin within OBIEE. In this part of the article I will explain how to develop and deploy a custom style and message.”
Justin Townsend writes about commentary and collaboration problems being a thing of the past…
Leigh Wilson says, “This post is a long overdue upgrade from my 10g Dynamic Banner post.
Most of my stakeholders don’t like the visual noise that dominates a typical Oracle BI project.
I usually take control of the look and feel by hiding away the banner and “branding” my Oracle BI projects using a logo.
This post will help you take control of the look & feel. It also forms the basis for other advanced dashboarding posts in my blog.”
Steve Yeung summarises:
- Define the Vision and Core Values of the Company
- State Your Primary Mission
- Set Corporate and Departmental Goals
- Do a Situation Analysis
- Set Out Your Business Plan
- Set up Key Performance Indicators
Kevin McGinley says,
In his opinion, every development environment should have the following:
- A working area for each developer
- Source control for everyone developing
- Branch-based development, with automatic merging of selected features into a fully-functional release
- Automatic regression testing of each and every new feature as part of the development process, before migration to QA
- Environment-specific build processes that automatically generate and deploy artifacts to each environment
Christian Screen writes, “We all like new shiny-spoon features and it looks like the Oracle BI public cloud edition will be brandishing at least one new visual on which we can feast our eyes. Treemap visualizations have long been a staple in analytical visual renderings and many a business user will be happy to explore this new functionality.”
John Booth writes a homage to ‘Who moved my cheese’!
Jeff McQuigg covers:
- There Are Multiple Hierarchies to be Aware of
- A Closer Look at a Level
- Optional Columns
- Column Naming
- Putting the Table Design Together
- OBI Configuration
- Building Calendar Data
- Other Notes
And wraps up by saying, “A good time hierarchy should be very robust and flexible for users. We really shouldn’t ever need to build special RPD or report logic to concatenate or do funky things with the calendar dimension – build them into the table. Hopefully you’ve seen how easy it actually is, and adding a new column isn’t that daunting.”
This week I have updated the Blogger database, adding more members and putting links in place to the ACE Directory and oracle community.
Also this week I heard from ODTUG that my submission to talk at next years conference in Miami was not successful, but I think I will go anyway. I need to figure why they didn’t want to hear about advanced OBIEE techniques. I am hoping its because my submission was not eye catching enough, and not that OBIEE is not a popular subject any more? Lets wait see what come out on the agenda at KSCOPE 16
Blogs of the week
Is your blog listed on our blogger database?
Daan Bakboord shares two presentations that he made to help him study for these exams.
Jeremiah Johnson defines data scientists as ‘master communicators’. He looks at:
- The Core Skills
- What they bring to the table
- What they do
- Bottom Line
Carlos Chang helps us to catch up on Oracle Mobile Application Framework (MAF)
- There’s a new version of Oracle MAF
- Oracle Enterprise Pack for Eclipse (OEPE)
- The Mobile Application Framework Challenge
- Mobile Design Patterns
Dan Power’s tips include
- Keep in mind what’s interesting to your audience.
- Come up with your ending before you figure out your middle.
- “Putting it on paper lets you start fixing it. If it stays in your head, a perfect idea, you’ll never share it with anyone.”
Tim Tow writes, “We had a couple of issues reported with the output of the Next Generation Outline Extractor where the exported file did not work properly as a load file.” Read the blog to find out the solution
Vishal Pathak talks us through a quick way of producing BIP reports on top of OBIEE dashboards.
Join the LinkedIn group for discussions, news and the latest blog posts.
Trajano Leme asks How to embed a Google Docs spreadsheet with OBIEE? Read the answers and join in the discussion.
Follow Addidici on Twitter
KPI Partners tweeted OBIEE Mobile Application Designer: Features, Issues, Limitations
Robin Moffatt shared No Silver Bullets – OBIEE Performance in the Real World
Boris Dahav posted Simple OMM4OBI use cases with OBIEE
Videos such as
OVUM talks about making the business case for Oracle Enterprise Performance Management
Excluding and Including Columns Without Editing a Fusion OTBI Report
This weeks blog is brought to you from up a mountain in Italy, at a cafe overlooking Lake Garda.
We come here for fantastic sailing competitions and pizza!
Nothing to do with OBIEE except I sometimes get to wear my OracleNerd OBIEE T-Shirt
Blogs of the week
Daan Bakboord says that the message from Oracle to customers is clear – “Move away from OBIA 7.9.6.x and move to OBIA 11g, either in the Cloud or On Premise.”
Myles Gilsenan of KPI Partners shares his post OOW14 thoughts.
Debra asks, is Oracle Cloud ready for these Applications?
Gurcan Orhan shares a “2 Minute Tech Tip” video. He says, don’t forget that it was 8am in the morning and birds were still sleeping.
3 Sixty Analytics blogs about the new patch. There are no new features in this patch – it’s just a bug fix patch. The full list of bugs fixed are detailed in the readme for this patch set.
Kent Graziano shares the following picture:
Boris Dahav blogs, “A customer asked me to create an analysis on top of a Name – Value table. A table where instead of having one row for each key, there are multiple rows with the structure of Key_Value / Attribute_Name/ Attribute_Value. This structure is very nice for developers. They can add any attribute they want, but it’s a nightmare for reporting.” Read the full blog forthe solution.
OracleAnalytics posted Views from IDC’s Craig Stires on the Cloud and Big Data
Videos such as Webinar : Best Practices with Oracle BI Financial Analytics
and Fiat Chrysler on the Benefits of Oracle Exalytics
How many emails do I get each week where it says,
“hi (insert name here) I just wanted to catch up with your current situation, I have an opportunity you may blah blah blah.”
IT enables mass communication at the expensive of the personal touch.
And when it comes to recruiting, I know I prefer the personal touch.
Blogs of the week
In this blog, Scott Spendolini writes that APEX 5.0 is still going to be a few months off. The good news, however, is there will be an EA3. Read the full blog for more information.
Daniel J Power says, “A data warehouse is a central, integrated repository for historical, enterprise data from multiple business systems. An expanded definition for data warehousing includes business intelligence tools for analyzing the data and OLAP is part of the broader category of business intelligence tools.”
As the title says. Dig deep please for this cause.
Boris Dahav says, “OBIEE had always the ability to run GO URL links and pass parameters. It is documented in many blogs.” Also see Oracle documentation.
Jonathan Lewis writes, “In this instalment we’re going to look at an example where some of the numbers are generated by guesswork, and some by estimates that aren’t visible in the plan.”
Srinivas Malyala blogs, “ I guess many people might be knowing about this but thought of re-sharing as it may help at least someone.”
Debra Lilley puts together her thoughts on OOW14
Shiva Molabanti blogs, “Oracle BI Cloud Service, a part of PaaS, offers a highly scalable, multi-tenant Oracle BI environment that is integrated with Oracle Cloud store. Oracle BI Cloud Service features Presentation Services to create analyses and dashboards, Oracle Database Cloud Service integration, self-service web-client Data Loader and Data Modeler, simple administration, and integrated Identity Management for Security (Authentication & Authorization) Services.”
Boris Dahav tells us that OBIEE 126.96.36.199 new general bundle patch (number 9?), 188.8.131.52.141014 is available!
Brendan Tierney goes through the 13 steps then tells us we can now sit back, relax and watch the installation of 184.108.40.206c (with the in-memory option) complete. Then he says, we are not yet finished and gives us step 14!
Ian Bristow posted Bundle Patch OBIEE 11g 220.127.116.11.141014 is available
Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist
OracleBlogs tweeted Automating the OBIEE patching process from EM Cloud Control 12c
Shiva Molabanti posted Reporting Capabilities in Oracle BICS with respect to OBIEE 11g
Videos such as
TransRe attended Oracle OpenWorld 2014 and spoke about Oracle Hyperion Tax Provision
2 Minute Tech Tip: Integrate Oracle Essbase with Oracle Business Intelligence Enterprise Edition
In case you didn’t notice, last week was OOW week.
I personally stayed at work and delivered some great dashboards (I thank you), but some people (um hum, Christian) had a whale of a time in sunny/foggy San Francisco (that place where they used to host the Americas Cup!)
Luckily, there are those who went, and who blogged (how did we manage in the pre-Internet era?)
Blogs of the week
1. OOW14 day 0
Christian Berg talks breakfasts, sessions and scheduling issues!
Alex Hansal says, “Having to watch Oracle OpenWorld with several time zones between me and San Francisco has the benefit of getting enough sleep and waking up to interesting news.”
Arun Kumar shares lots of photos!
Jeff Smith says, “I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer.”
So he shares this video:
Cameron Lackpour shares his OOW14 experiences in a series of blogs.
Dan Vlamis asks:
For those that attended:
- What did you find interesting?
- Any funny stories to share?
- What was different from what you expected?
For those that didn’t attend:
- What would you want to know?
- Are you more interested in the “behind the scenes” or the “major announcements”?
Daan Bakboord tweeted Oracle OpenWorld 2014 Presentations are available to download from here.
Christian Berg shared his blog ‘OOW14 Days 1 through 4 and wrap-up’.
Debra Lilley shared the video ‘The Oracle ACE Program – An Overview’
Gokhan Atil posted a presentation on OOW14: Database Patching Best Practices
Daisy Ding shared Methods of Grouping and Summarizing in R Language
Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist
Videos such as Mark Hurd: Companies With Billions of Revenue Rely On Oracle
and Connecting to an Oracle Database Cloud Instance
Don’t forget that KScope 15 is going to be soo cool (especially for us Nerks ( nerdy geeks )). I will be buying a new T-Shirt just for the event
Christian Screen writes, “ Although not a very common integration but every now and then an organization will install OBIEE with SSL configured between the components.”
He lets us know of common errors and how to fix them!
John Goodwin says, “If you are running 18.104.22.168 and a Provider Services version before patch 502 then if you run a diagnostics report you should hopefully see a pass for the Essbase web services. If you decide to apply patch 502 or later then there are some changes that have been made to the web services.” Read on for more details.
Debra Lilley explains the many hats she will be wearing this year at OOW!
- Oracle ACE Director*
- Oracle Applications UX Advocate
- Usergroup Leader
- Partner - My new job
- With Analysts
- Just for fun
- As a mum
This blog goes through interview questions regarding Agregate Tables such as:
- What is granularity?
- What is content logical level ?
- If Two fact tables, due to some reason has same granularity then how to decide the priority?
Lyndsay Wise writes, “BI implementations are becoming more commonplace as organizations realize they cannot overlook the management of and access to their data in order to facilitate better decision-making. What this means for many is the re-evaluation of resources, skill sets, and project planning to ensure that the proper resources exist to support BI and analytics development.”
Gurcan Orcan lists his sessions:
Here are my sessions to speak for this year’s Oracle Open World.
- UGF8949 – 12 Looks at Oracle Database 12c: EOUC Short Talks
- Sunday, Sep 28, 2:30 PM – 3:15 PM - Moscone South – 304
- CON7921 – Insight into Action: Business Intelligence Applications and Oracle Data Integrator
- Thursday, Oct 2, 2:30 PM – 3:15 PM - Moscone South – 270
- Podcast with Bob Rhubart (@OTNArchBeat)
- Monday, Sep 29, 3:00 PM – 4:00 PM
and then goes on to list the sessions he himself would like to attend.
Pravin Khadakkar says, “Oracle Endeca Information Discovery (OEID) is one the most significant product to enter into the Big Data space, this blog is an attempt to give a brief overview of the OEID and list down links for resources for the same.”
Boris Dahav says, “At the last ILOUG we presented the “KPIs creation in OBIEE” and “Using KPIs in OBIEE”.
Download them here.
Last but certainly not least, Christian Screen blogs, “We all like new shiny-spoon features and it looks like the Oracle BI public cloud edition will be brandishing at least one new visual on which we can feast our eyes. Treemap visualizations have long been a staple in analytical visual renderings and many a business user will be happy to explore this new functionality.”
He links to the following video:
Oracle Business Intelligence Cloud Service: Convert Data into Insight
Marije Nelis asks How are technologies like #Cloud & #BigData transforming business?
ANAND EKBOTE shared OBIEE Smartview Integration
KPI Partners tweeted one from the archives - Complex Row Level Security in Oracle BI (OBIEE)
Edition of 22nd September
Videos such as
No Silver Bullets – OBIEE Performance in the Real World
and Deploying an Application to an Oracle Java Cloud Service Instance