Category Archives: Obiee 11g

What are you doing here?

All the action is now at

The new home of OBIEE Information. Blogs, News, Tweets, links, Videos, etc

Please change your bookmark to the new BLOG

Thank You

The Best of 2014

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?

1. How-To: File hunt for OBIEE GUI changes

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.

2. RittmanMead BI Forum 2014 – Wrap – up

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

[slideshare id=34476471&doc=rittmanmeadbiforum2014nosilverbullets-obieeperformanceintherealworld-140509053752-phpapp01]

3. Minimalist Design for the Criteria Tab

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.

4. 3rd-Party Visualizations in OBIEE

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

5. Cloud Services Are Reaching Maturity – Thoughts from OOW 2014

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 (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)

6. Oracle BI Mobile App Designer – Version 2

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
  • Filters

They then go through in detail:

  • User Interface
  • Calculated Field
  • Multiple Filters
  • Exploration Page
  • Sidebar
  • New Map Visualisation
  • New Custom Map
  • Plugins
  • Other Features

7. MS Sharepoint and Oracle APEX integration

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:

[slideshare id=40350847&doc=dgielis-141016082317-conversion-gate01]

8. Oracle ACE Program: Follow Up

Tim Hall shares more thoughts on the Oracle ACE Program including the ‘Access to Information’ and  ‘Access to Support’.  Take a read.

9. APEX 5.0 – Keyboard shortcuts

Dimitri Gielis lists the the keyboard shortcuts in Oracle Application Express (APEX)

10. 6 Desktop BI Tools

  1. Excel
  2. R Project
  3. ES Series
  4. SPSS
  5. STATA

11. My OOW14 Overview

Debra Lilley gives us her OOW14 overview including linking to her video

“2 Minute Tech Tip: Communication Between Technical and Business Stakeholders”

12. Collaborative BI ZigZag – BIWisdom Response

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.

13. Purging corrupted OBIEE web catalog users

Christian Berg says, “NOTE: This is a quick & dirty solution!”

14. Global Currencies in Oracle BIA

Daan Bakboord writes, “If you read the Oracle Documentation for Oracle BIA (, 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.”

15. OBIEE11g: Creating and Developing Custom Styles, Skins & Messages (Part 2)

Andrew Fagence writes, “In my previous article (found here: 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.”

16. Your OBIEE Commentary and Collaboration Issues are a Thing of the Past…

Justin Townsend writes about commentary and collaboration problems being a thing of the past…

17. Oracle BI 11g – Adding a dynamic logo and title to your dashboard page

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

18. How to Use Strategic Planning and KPIs to Achieve Business Success

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
  • Conclusion

19.  Introducing Checkmate – True Development Lifecycle For OBIEE

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

20. Treemap Visual Now Available on Oracle BI Cloud Edition

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

21. Who moved my data?

John Booth writes a homage to ‘Who moved my cheese’!

22. Build Your Own Time Hierarchy

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
  • Testing
  • 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.”



OBIEE Weekly Roundup

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?

1. Preparing for TOGAF 9 and ArchiMate 2 Exams

Daan Bakboord shares two presentations that he made to help him study for these exams.

2. What is a data scientist?

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

3. Catching Up on Mobile

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

4.  How do you tell a ‘good’ story based upon data?

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

5. File Encoding in the Next Generation Outline Extractor

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

6. Easy method to create BIP 11g reports on top of OBIEE dashboards.

Vishal Pathak talks us through a quick way of producing BIP reports on top of OBIEE dashboards.

linkedin logoThis week on LinkedIn

Join the LinkedIn group for discussions, news and the latest blog posts.

Gerd Aiglstorfer posted Criteria for OBIEE project success

Uday Singh shared What is relational algebra?

 asks How to embed a Google Docs spreadsheet with OBIEE? Read the answers and join in the discussion.


twitterThis week on Twitter

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



Stories from and

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

OBIEE Up a Mountain

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

1. Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

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

2. Cloud Services Are Reaching Maturity – Thoughts from OOW 2014

Myles Gilsenan of KPI Partners shares his post OOW14 thoughts.

3. Are Cloud Applications Ready?

Debra asks, is Oracle Cloud ready for these Applications?

4. #2MTT by @OTNArchBeat

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.

5. OBIEE Patch now available

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.

6. Say “Big Data” One More Time (I dare you!)

Kent Graziano shares the following picture:

big data

7. OBIEE with Key / Name / Value table, the Union solution

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.

linkedin logoThis week on LinkedIn

Piyush Dutta shared Capture Adhoc Report/analysis in Usage Tracking

Italia Nowodworska posted Statement of Direction: Oracle Business Intelligence Analytics (OBIA)

Duncan Mercer shared Five Smart Reasons Why You Need a Business Intelligence Tool

twitter logoThis week on Twitter

OracleAnalytics  posted Views from IDC’s Craig Stires on the Cloud and Big Data

Daan Bakboord shared Facts and Dimensions – a perfect couple

BI Futurecom tweeted Correct order by Month date in OBIEE

Stories from and

Videos such as Webinar : Best Practices with Oracle BI Financial Analytics

and Fiat Chrysler on the Benefits of Oracle Exalytics





Insert OBIEE name here

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.

2. What do I need to know about Data Warehousing/OLAP?

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

3. Help the Riley Family Beat Cancer

As the title says.  Dig deep please for this cause.

4. OBIEE – GO URL, the old (Px) and the new (COLx) way

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.

5. Execution Plans Part 10: Guesswork

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

6. Power of/Capabilities of Oracle BI Administration – Tool Query Repository Tool

Srinivas Malyala blogs, ” I guess many people might be knowing about this but thought of re-sharing as it may help at least someone.”

7. My OOW14 Overview

Debra Lilley puts together her thoughts on OOW14

8. Oracle BICS and Identity Management – A New Security Architecture

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

9. OBIEE BUNDLE PATCH AKA (?) is available

Boris Dahav tells us that OBIEE new general bundle patch (number 9?), is available!

10. Installing Oracle on Windows 64bit

Brendan Tierney goes through the 13 steps then tells us we can now sit back, relax and watch the installation of (with the in-memory option) complete. Then he says, we are not yet finished and gives us step 14!

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Monitoring – Rating

Ian Bristow posted Bundle Patch OBIEE 11g is available

Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist

twitter logoThis week on Twitter

OracleBlogs tweeted Automating the OBIEE patching process from EM Cloud Control 12c

Boris Dahav shared OBIEE: NonEmpty MDX for Essbase (and Microsoft) – the secret life of PERF_PREFER_SUPPRESS_EMPTY_TUPLES

Shiva Molabanti posted Reporting Capabilities in Oracle BICS with respect to OBIEE 11g


Stories from and

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

OOW Special


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!

2. Oracle OpenWorld 2014 – Back to the Future

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

3. Oracle Openworld 2014

Arun Kumar shares lots of photos!

4. Real Time SQL Monitoring Support in Oracle SQL Developer [Video]

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:

5. Oracle OpenWorld, Day 5

Oracle OpenWorld 2014, day 4

Oracle OpenWorld, Day 3

Oracle OpenWorld, day 2

Oracle OpenWorld, day 1

Cameron Lackpour shares his OOW14 experiences in a series of blogs.

6. Your Ideas on OOW BI and Analytics Scoop Session

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”?

twitterThis week on Twitter

 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

linkedin logoThis week on LinkedIn

Stewart Bryson posted a link to the Georgia Oracle Users Group

Daisy Ding shared Methods of Grouping and Summarizing in R Language

Anshu Monga shared OBIEE11g Implementing KPIs, KPI Watchlist

Stories from and

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 🙂


blogBlogs of the week

1. Installing BITeamwork on SSL Configured WebLogic Admin Server

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!

2. APS diagnostic report failure

John Goodwin says, “If you are running 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.

3. My Oracle Open World Objectives

Debra Lilley explains the many hats she will be wearing this year at OOW!

  • Oracle ACE Director*
  • Oracle Applications UX Advocate
  • Usergroup Leader
  • Speaker
  • 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?

5. The importance of BI specific skill sets

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

6. #OOW14 Sessions & Interests & Social

Gurcan Orcan lists his sessions:

Here are my sessions to speak for this year’s Oracle Open World.

and then goes on to list the sessions he himself would like to attend.

7. Oracle Endeca Information Discovery Resources

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

8. Building KPIs And Using KPIs Presentations

Boris Dahav says, “At the last ILOUG we presented the “KPIs creation in OBIEE”  and “Using KPIs in OBIEE”.

Download them here.

9. Treemap Visual Now Available on Oracle BI Cloud Edition

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

linkedin logoThis week on LinkedIn

Marije Nelis asks How are technologies like #Cloud & #BigData transforming business?

Monwabisa C. Sibiya asks the question “Is there anyway of reporting using Google maps in OBIEE other than Oracle Spatial reporting?” Answer him here.

ANAND EKBOTE shared OBIEE Smartview Integration

twitter logoThis week on Twitter

KPI Partners tweeted one from the archives – Complex Row Level Security in Oracle BI (OBIEE)

Gerd Aiglstorfer shared his blog post Oracle BI Mobile HD App

Daan Bakboord posted Update to the FAQ-section of the OBIEE – Sample Application (V406)


Edition of 22nd September

Stories from and

Videos such as

No Silver Bullets – OBIEE Performance in the Real World

and Deploying an Application to an Oracle Java Cloud Service Instance

Summer Loving – And OBIEE Greases the wheels of Industry


You may have noticed that Sailing features strongly on this blog, so today was a great day for us as we joined thousands of sailors around the World who raced against each in Barts Bash –

The only downside is that a certain large competitor of Oracle is presenting the results – We need to get the full Oracle based results analysis system out there to show that Oracle Database and OBIEE are better than a certain TLA.

I hope it didn’t pass you by – The Major news of the week is the launch of the Cloud BI solution from Oracle.  I don’t know how this will change IT departments, but look out for reviews on this as we find them.

Anyway, on with the show…

Blogs of the week

1. Your indispensable guide to DW at OpenWorld in iBook and PDF formats

Keith Laker has put together a comprehensive downloadable guide of all the data warehousing and big data activities at OracleOpenWorld 2014. Download it here.

2. Analytics Hands on Labs at OOW 14

Brendan Tierney says, “After trawling through the list of Hands-on-Labs it was disappointing to see that there was no Oracle Data Mining or Oracle R Enterprise hands-on-labs this year.

But there is a hands on lab that looks are how to use the new SQL for Big Data feature (announced over the summer).”

3. Who moved my data?

John Booth pays homage to ‘Who moved my cheese?’ in this blog about data.

4. OBIEE common Pre-defined System Session Variables

Praveen shares the common Pre-defined System Session Variables in this blog post.

5. It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Kent Graziano writes, “There will be much to see, do, and learn at what is arguably the largest (60k+ people) gathering of Oracle users and experts in the world. Expect big news from Oracle Corp, great sessions from Oracle ACEs and ACE Directors, and of course the annual customer appreciation event.

So here is my short list of what to check out this year:”

Read the full blog for what he expects to be highlights!

6. Minimalist Design for the Criteria Tab

Jeff McQuigg says, “When it comes to OBI report design, minimalist is the only way to go when it comes to the Criteria Tab.” Read his full blog post to find out why.

linkedin logo

This week on LinkedIn

Anshu Monga shared ETL Part 1

Kent Graziano posted It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Gerd Aiglstorfer shared Top 4 BI Articles

Mohamed Abdelaziz posted MERGE Two Repository in OBIEE 11G

twitterThis week on Twitter

David Haimes posted Focus on Oracle Social Network at OpenWorld

Danny Byrant shared Direct Database Request

Stories from and

Videos such as The Oracle ACE Program – An Overview

and 35th America’s Cup Press Conference – Full Replay

and Mark Hurd Previews Oracle OpenWorld Theme – the Social, Mobile Customer




This is post 100.

Doesn’t time fly when you are having fun.

And boy, OBIEE is just too much fun  🙂


Yes, there maybe new technologies turning your head, but stay faithful to OBIEE, it just gets better and better.



Blogs of the week

1. Execution Plans Part 9: Multiplication

Jonathan Lewis writes: “In part 8 we looked at a very simple execution plan involving a hash join; but that example was too simple to give us the full flavour of the arithmetic involved in Oracle’s predictions because every operation executed just once. We need to see some plans where each execution of a parent operation could requires multiple executions of its child operations; and that’s what we’re going to do in parts 9 and 10.”

2. Oracle OpenWorld Agenda Released

Eric Helmer lets us know that the Agenda is released – catch him (VP of Global IT Services at ADI Strategies and an Oracle ACE Director)  presenting CON4996, Session Title: “SaaS? Cloud? Oracle Exalytics? On-Premise? Exploring Oracle EPM Deployment Options” on Monday September 29, from 2:45 – 3:30 PM at Moscone West – 3010.

3. 30 SQL Developer Tips in 30 Days, Day 3: Syntax Highlighting

Jeff Smith gives us 30 SQL Developer Tips in 30 Days.  This one is day 3! Lots more tips to come.

4. 2 Options For Data Security in Tableau

Kumar Krishnaswamy goes though the Manual and Automatic options.

5. Build Your Own Time Hierarchy

Jeff McQuigg says, “Every single BI system has a time/date/period/calendar hierarchy in it. If you use the BI Apps, it actually comes with 2 different tables for this purpose alone, along with a ton of OOB capability. However, when you are faced with a pure custom system from scratch, how do you build one? What does it look like? What sort of data should it have in it?”

He 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
  • Testing
  • Other Notes

He wraps up by saying that a good time hierarchy should be very robust and flexible for users.

twitter logoThis week on Twitter

Danny Byrant linked to Direct Database Request

Cameron Lackpour tweeted Oracle OpenWorld 2014 EPM/BI meetup

KPI Partners shared What Is Cache?… 5 Steps to Automatically Purge Cache in Oracle BI

linkedin logo

This week on LinkedIn

Gerd Aiglstorfer added OBIEE Mobile App Designer Release 2

Monica Hasebi shared The Answer to the Analytic Needs of a Business

Daisy Ding posted How to join related tables in database construction and analysis?


Stories from and

Videos such as Kevin McGinley’s ice bucket challenge

and Real Time BI with Kevin & Stewart: Man on the Street

Sweet Summer Lovin OBIEE

rssBlogs of the week

Have a look at our blogger database.  Contact us if you would like to be added on.

1. OBIEE 11g: Unable to Add condition to run Agent during the Agent Creation or Insufficient Privileges.Access Condition Evaluation Service Service

Venkata Nagarjuna says that the scenario is as follows: 
“I would like to create a new agent. The Agent has to run as per another report. I would like to pass the other report as a condition for this Agent.”

2. Oracle SQL Developer: Code on Demand

Jeff Smith writes that he has recently spent a few hours debugging some user defined reports.

He said if the code that he detailed did not work then upgrade! He found that a few of his wouldn’t work, and he found a bug. It’s been fixed in v4. Another reason to go upgrade, like…today.

3. SAML – A go-to tool for Enterprise – Cloud Applications Security

Shiva writes, “SAML is the XML-based Security Assertion Markup Language being standardized at OASIS. It enables Single Sign-On and other security scenarios, and provide details about the authentication, attribute, and authorization information between security domains.

He then blogs about :

  • Terminology
  • How does SAML work?
  • Why is SAML Used? And how it is related to Cloud?
  • What are the benefits of SAML?
  • SAML usecase

4. OpenWorld on your iPad and iPhone

Keith Laker writes about how for this year’s conference, he has made all the information available in an HTML app that runs on most smartphones and tablets.

The app will include:

  • Getting to know 12c – a series of video interviews with George Lumpkin, Vice President of Data Warehouse Product Management
  • Your presenters – full biographies and links to social media sites for all the key data warehouse presenters
  • Must see sessions – list of all the most important data warehouse presentations at this year’s conference
  • Our customers – profiles our most important data warehouse customers
  • Must attend labs – list of all the most important data warehouse hands-on labs at this year’s conference
  • Links – a list of links to the most important data warehouse sites

5. Calculation Manager, BSO Planning, and ASO Planning combine for an awesome ASO Essbase procedural calculation hack — Part 3

Cameron Lackpour says, “This is the third and final installment of a three part series on ASO calculations, and specifically, ASO Planning calculations.  Thus far I’ve showed how to use the @CalcMgrExecuteEncryptMaxLFile via Calculation Manager which is pretty cool, and then how to make ASO procedural calculations in MaxL fast, fast, fast.”

6. Migrate Your SQL Developer User Defined Reports

Danny Byrant says, “I’m in the process of upgrading my work computer and in an effort to make sure it is configured the way I want it, I decided to forego the automated “side-by-side” migration.  Everything was going well until I got around to SQL Developer.  The install as we know is easy enough, and I even went so far as to download and configure the Oracle Instant Client (OCI).  You can read more about that on Jeff’s Blog post.”

7. Importing Data from SQL databases into Hadoop with Sqoop and Oracle Data Integrator (ODI)

Benjamin Perez-Goytia says, “This article illustrates how to import data from relational databases into Hadoop Distributed File Systems (HDFS) with Sqoop and Oracle Data Integrator (ODI).  This article features two ODI knowledge modules designed to work with Sqoop: IKM SQL to HDFS File (Sqoop) and IKM SQL to HDFS Hive (Sqoop).”

twitter logoThis week on Twitter

Jeff Smith shared Oracle SQL Developer 4 and Auto Spec – Body Toggles from the archives

Danny Byrant tweeted Migrate Your SQL Developer User Defined Reports

OracleBlogs posted New Oracle Program Eases Common Pains of Cloud Migration

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Daisy Ding shared Grouping and Summarizing Data from Big Text Files in R Language, esProc and Python

Monica Hasebi asks Are you going to Oracle Openworld this year? 

Gerd Aiglstorfer shared New version of Oracle BI Mobile App

Stewart Bryson posted Podcast Show Notes: Redefining Information Management Architecture

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

This week’s OBIEE news included stories from and

Also videos such as Oracle Storage Cloud Service Overview

and Oracle Application Testing Suite 12: Oracle Flow Builder Demo: Create Project Management Flow

OBIEE did not have a Holiday

rssBlogs of the week

Have a look at our blogger database.  Contact us if you would like to be added on.

1. Partnering with Peak Indicators

Kevin and Stewart announce a planned partnership with Peak Indicators in delivering the following courses in North and South America:

  • OBIEE 11g Advanced Bootcamp
  • ODI 11g Advanced Bootcamp
  • OBIEE 11g Advanced Modelling
  • OBIEE Advanced REports and Dashboards
  • OBIEE 11g Advanced SOA Spatial
  • Oracle BI Publisher Basics

2. Privilege to see hidden objects in OBIEE 11g

Vishal Pathak suggested we:

1. Create a power user group 
2. Create a new role
3. Assign the group to the role
4. Assign the desired users to the group
5. Assign the privilege to the role

Read on for more details.

3. So you want to be a Presenter? Abstract selections for 2015 are open!

Kent Graziano says all you have to do is write some awe inspiring abstract with a catchy, SEO’d title and you are on your way to geek super-stardom. Read all about it here.

4. Reporting in SaaS or On Premises Fusion Applications – OTBI, Smart View, OBIA,BI Publisher & Other

Pravin says, “There are number of options for reporting in Fusion Applications. The most commonly used reporting technique in the implementation project is to leverage on BI Publisher. There are various tools and techniques supported by Fusion Application to generate reports for analytical and transactional reporting.”

5. Oracle BI 11g: Verifying Logical Table Sources in Analyses

Alex Hansal says, “Inspired by a nice instance of the Oracle BI 11g Build Repositories class I delivered last week as an LVC, I decided to share a little trick with you.” Read his blog to discover what it is…

6. OBIEE Change Analysis Subject Area

Gerd says, “Assume you created a more or less complex OBIEE analysis with a lot of views and settings. If you want to reuse the analysis and report settings in a new report, then there exists a very fast solution for changing the OBIEE subject area which keeps all the settings.”

7. Enhanced Planning Validations: Part 2

Cameron Lackpour writes, “At the end of July Tyler Feddersen very generously wrote part one of this two part series on data validation in Planning; you now are reading the concluding entry.”

8. An Essbase OBIEE integration walk through with tips and tricks – Finale

This is a continuation from this post.

9. OBIEE and Essbase a few observations

Glenn writes, “This post on OBIEE and Essbase is based on my creation of my KScope 14 presentation and quirks I noticed Note I was using Essbase 1112.3.5 and the latest patched version of OBIEE (I don’t remember the X). I was using a VM instance of the Sample Oracle supplies and was using Essbase Studio with it to create the cube. I then brought the cube back into OBIEE and also into Publisher to create a Mobile dashboard.”

10. My Oracle Data Miner Book

Brendan Tierney says, “Some of you may be aware that I have been writing a book on Oracle Data Miner. Actually the book covers the Oracle Data Miner GUI that is part of SQL Developer, the SQL and PL/SQL functions, procedures and packages that form the Oracle Data Mining option in the database and lots of other topics for the DBA, Developer and BI/DW people.”

11. A Kscope14 Review: Better Late Than Never!? (Ok, that’s debatable…)

Jeremy Harms shares his thoughts on KScope14

12. Enabling Usage Tracking for BI Publisher in OBIEE 11g

This article describes the steps for Enabling Usage Tracking for BI Publisher and how to visualize usage tracking data.

It covers:

  1. How to enable auditing from BI Publisher UI
  2. How to run RCU to create Audit Schemas
  3. How to create JDBC connection with Weblogic console
  4. How configure the Audit Policy Settings
  5. How register the Audit Storage Database to Your Domain
  6. How audit events in an Audit Table

13. BITeamwork 2.8.4 GA – Collaborative BI Focused

This version of the Collaborative BI Framework provides enhanced functionality and bug fixes.

BITeamwork 2.8.4 Features

  • Better Notifications with images and notifications
  • Better Scalability when expanded content exists in Comments
  • Comment Context Single Prompt Focus Sensitivity
  • Splash Page Administration Updates Refresh User’s Prompting Regardless of Hide
  • Print Comments functionality
  • Training Inside of Oracle BI

14. Timesten In-Memory Database – 1. Basics

Raja Malakar writes, “Oracle Timesten is an in-memory database that is either available as a standalone database system or comes bundled with Oracle Exalytics systems. The objective of Timesten is to hold the database in the server’s Main Memory so that data retrieval and processing are extremely fast, when compared to conventional disk-optimized database systems. We have recently implemented a migration of OBIEE reports from Oracle Rdbms to Timesten on Exalytics and have observed an average of 17 times faster data retrieval times, as compared to Oracle 11g database and that too across 92 reports!”

15. #OTNLATour has just started

Gurcan Orhan shares his session lists for each leg of the tour and the video that Bob Rhubart  posted on OTNArchBeat YouTube channel.

twitterThis week on Twitter

Daan Bakboord  shared Twitter Tuesday – Top 10 @ArchBeat Tweets – August 5-11, 2014 Top Tweets included KScope 2014 Preview: Stewart Bryson on OBIEE, ODI

OracleBlogs  tweeted OBIEE Error Correction Support has Ended – What to do to keep receiving bug fixes and enhancements

Gerd Aiglstorfer posted OBIEE Performance Monitoring with Usage Tracking

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Performance Monitoring with Usage Tracking

 asked  if anyone could help?

I have tried following below link in order to setup auditing through database.

Answer him here.

Ian Bristow posted OBIEE Error Correction Support has Ended – What to do to keep receiving bug fixes and enhancements

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.



Stories from and

Videos such as Real Time BI with Kevin & Stewart: Ep 021

and ORACLE TEAM USA – Team Building the Tough Way

Live Racing on the inter web

Addidici and TracTrac have teamed up to provide live tracking. Could you use it for your event?

Addidici Race Tracking is LIVE

For sports fans out there Addidici have teamed up with Race-Face and TracTrac to run the race tracking system at this years Zhik 2014 29er UK National and Open Championships.


You can follow the racing live, play back at the end of the day and re-live those glory moments.


Apps are available to, so you can follow while at work or on the train!


See you at


Tracking systems are available for Sailing, Cycling, Running, Triathlon, Car racing, Walking, dogs.  In Fact, anything that moves.


Back to the OBIEE Future

rssBlogs of the week

Have a look at our blogger database. Is yours there? Contact us if you would like to be added on.



I am planning on heading over to Kscope 15 next year.  Are you?


1. BUCKET_WIDTH: Calculating the size of the bucket

Brendan Tierney writes that he had a query about one of the functions BUCKET_WIDTH. The question was wondering if it was possible to get the width of the bucket in each case. There does not seem to be a build in feature to get this value, so we have to calculate this ourselves. He gives an example of how to calculate this.

2. OBIEE – Fines and Payments (or Orders and Order Lines) with correct totals

Boris Dahav says, “The problem is a “popular” one. You have 2 facts with different levels of aggregation. It’s often Orders fact and Order Lines fact (where there are Order Total in the Orders fact and Lines values in Lines Fact that might not the same due to shipping or general discount). In my case this is Fines fact and Payments fact. In this case they sums often don’t match since they might be only partial payment of the fine.”

3. Capturing Environment Variables in Oracle APEX

The post focuses on the Environmental Variables as they are vital in coding conditional statements , says Vishal Pathak.

4. Oracle BI Mobile App

Gerd lists the changes and new features as:

  • Support for action links, including action link navigation history
  • Support for dashboard sections
  • Support for Briefing Books
  • Add to Favorites now at the dashboard-page level
  • Location support on maps in dashboards
  • Bug fixes

5. Stupid Programming Trick No. 18 — Modifying the Period dimension in Planning

Cameron Lackpour says, “What you will see is how to manipulate custom periods in a Planning Period dimension to get quarter totals.  I will also show how custom Period members outside of YearTotal.”

Read on!

6. How to report on two datasets across different database in OBIEE

Bojie talks about the feature in OBIEE that allows cross db reporting.  He talks us clearly through how to do it, complete with screenshots.

7. ODI Agents

Ram Reddy links to Oracle Data Integrator 12c – Creating a Standalone Agent and Oracle Data Integrator 12c – Creating a Collocated Agent

twitter logoThis week on Twitter

OraNa info tweeted 10 tips for getting started with MAF

Bernard Marr shared The 25 KPIs every manager must know

Doug Correa posted #Kscope14 Video: Ron Dimon

Follow Addidici on twitter for daily OBIEE news and updates.

linkedin logo

This week on LinkedIn

Kevin Hsu posted Keeping big data small 

Gerd Aiglstorfer shared Oracle BI Coaching

Daisy Ding linked to An Illustration of Processing Big Text Files with esProc Cursor

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

OBIEE News – Edition of 28th July

Stories from and

Videos such as

Foiling camp finale: “Everyone has a smile on their face”

and What Does Real-World Performance Mean?

Phew, is it just me or is OBIEE HOT?

12c, more like 30C.


blogBlogs of the week

Have a look at our blogger database. Not listed? Contact us to be added on.

1. OTN The World’s Biggest Oracle Community

Debra posted a link to this infographic

2. Table to Table Mapping in ODI 12C

Praveen told us how to create Table to Table mapping in ODI 12C

3. String Aggregation in OBIEE

Vishal says, “In the BI world, we talk about measures and aggregation, but we don’t talk about string aggregation.”

He says the question is How do we do it?

4. Copy & Paste Imports from Excel to Oracle using SQL Developer

Jeff Smith says, “Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table.”

Read the post and the discussion that results from this post here.

5. Oracle 12c Release 1 is here!

Get it here!

Also, get more detail about In Memory Database

6. Enhanced Planning Validations: Part 1

Cameron recruited Tyler Feddersen of Performance Architects to write about this really clever technique to enhance validations in Hyperion Planning. He concludes, saying, “And there you have it – a really clever way to handle validations in Planning using the functionality built into the tool.  Thanks again Tyler for sharing this.”

7. OBIEE Sum of Average

Gerd’s latest blog post also includes a link to his Oracle BI expert class.

linkedin logoThis week on LinkedIn

Gerd Aiglstorfer shared OBIEE Sum of Average

Nicola Sandoli posted Oracle BI Metadata dictionary

Eduardo Arroyo shared Analytics means business

Join the Oracle Business Intelligence LinkedIn group for the latest OBIEE discussions, news and updates.

twitter logo

This week on Twitter

3 Sixty Analytics shared 6 Tips for Using Big Data to Hunt Cyberthreats

Wes Fang posted ADF Directed Acyclic Graphs

Daan Bakboord tweeted Oracle Endeca Information Discovery Learning Library

Follow Addidici on twitter for daily OBIEE news and updates.


This week’s OBIEE News – Edition of 21st July 

Stories from and

Videos such as:

Fly boys

and Register for Oracle OpenWorld 2014