Catching Up with OBIEE News

My mate has been fired from his job at a dress alteration company.

Apparently he didn’t turn up enough.

OK, lets keep up the pace this year. Soo much to learn in the OBIEE world, so little time.

Lets talk about size. How big is your OBIEE? I was recently at an OBIEE presentation and the speaker talked about a ‘large’ obiee user base of 50 users. Sorry, but this is tiny, not even small. Should OBIEE really be used for less than 50 users? How about less than 100? Maybe, maybe not, but I do know it can handle millions of users. Seriously. MILLIONS.
Obviously not all at the same time, concurrent will be depending upon your BI Server hardware – You will obviously have to use Exadata for the database, but should you use a cluster? Well, you could. In fact most do, but whats best for a larger user base is ONE machine. Seriously, ONE.
One Exalytics machine, using as many of the processors as possible and you will have a simple environment that is fast enough for thousands of concurrent users. When you have more than 4,000 users per day, then forget the cluster, buy the Exalytics. If your client/company won’t buy Exalytics then they will spend more money trying to build and maintain the cluster of slower machines. You can go for cluster, and if you do, aim for one machine per 1000 daily users.

BTW Just how do you define concurrent users? Number of people logged in any any one time? Number of people logging in per hour? per day?. Is number of user relevent when some are running more queries than others? Is number of queries relevent when one person runs load intesive and 100 people run a quick query?

My Advice? Ask the users about their experience with the system. Use the Apex Survey app (You have installed that, right?) and monitor averages, Total Server time, Total database time, number of queires per 10 minutes, number of user logins, etc, etc. Develop a rich picture of server stats and make sure your users can let you know easily when the performance is unacceptable.

 

Anyway, read these.

now.

blogBlogs of the week

  1. Uploading a file to Oracle storage cloud service using REST API

Ketan Rout writes the 2nd part of a 2 part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service.

The first part of the article can be found here.

2. APEX 5.2 early outlook

Scott Wesley writes a blog post about the following slide that recently appeared at a conference:

capture

3. Oracle’s Database as a Service in action

Porus Homi Havewala shares the following:

which is a preview lecture of the Udemy Course: Oracle Private Database Cloud. It can be found here.

4. Oracle Conferences

Neil Chandler reviews a few of the conferences he has been able to attend this year.

5. Data Modeler Reports: Templates and Configurations

Heli writes: “I do not understand why there are configurations and templates related to reports in Data Modeler. What is the difference and when are they used?”

6. PL/SQL Security Coding Practices. Introduction to a better architecture part 1.

Robert Lockard says, “I have been seeing this database architecture for over thirty years and it’s high time we stopped using it. Before I go too far, let me tell you I get it, you have pressure to get the application out the door and working in a defined timeframe. I still design and develop systems and the pressure to take shortcuts can be great. This short cut is a security killer.”

7. Oracle Data Visualization Desktop Connecting to Essbase

Wayne D. Van Sluys talks us through how to do this.

8. Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

William Sescu blogs: “Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about Temporary Tablespace Groups. They are already explained in the 12.2 Admin Guide.”

9. Best Practices – Data movement between Oracle Storage Cloud Service and HDFS

Ketan Rout writes, “Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s data center. Big Data Cloud Service ( BDCS ) supports data transfers between Oracle Storage Cloud Service and HDFS. Both Hadoop and Oracle provides various tools and Oracle engineered solutions for the data movement. This document outlines various tools and describes the best practices to improve data transfer usability between Oracle Storage Cloud Service and HDFS.”

10. Loading Data into Oracle BI Cloud Service using BI Publisher Reports and REST Web Services

Dayne Carley says, “This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Extracting Data from Oracle Business Intelligence 12c Using the BI Publisher REST API.This post uses REST web services to extract data from an XML-formatted BIP report.”

twitterThis week on Twitter

UKOUG tweeted UKOUG Conferences 2016 – it’s a wrap and Ria’s journey to the cloud with new Human Capital Management Tool

Rebecca Wagner posted The Rittman Mead Open Source Project

Michael Vickers tweeted this photo from UKOUG_Tech16

capture

LinkedinThis week on LinkedIn

Benjamin Perez-Goytia shared Integrating Big Data Preparation (BDP) Cloud Service with Business Intelligence Cloud Service (BICS)

Kanthikiran Kalagoni posted Repository Upload Procedure in OBIEE 11G and 12C

Tanya Heise shared Business Analytics Monthly Index – October 2016

addidici logoPaper.li

Stories from www.itcentralstation.com, info.tricoresolutions.com and https://speakerdeck.com/

Videos such as A Lookback at #Kscope16 – ODTUG Took Chicago By Storm

and Schema Wars Episode 1: The Unstructured Menace

Best of OBI 2016

My News years resolution is to stop using spray deodorants.

Roll on 2017

So that was an interesting year!
If you ignore all the celebrity deaths, the Brexit, Wars, BI companies imploding, OTN mixing things up a bit, and the rise of the robot, then 2016 was actually a good year for analytics. Not that you would know, because all the magpies have moved onto the next shiney thing.  but look:

  • OBIEE 12c is actually quite good.  Worth upgrading to, and learning about oPatch and DV (or is that VA?).  It installs well, it runs OK and it looks good – Unlike me!
  • OBIEE Books sales were still strong,
  • The limited number of OBIEE related conference talks available were all well subscribed.
  • Companies still need decent Analytics
  • Apex and OBIEE are now best friends

So what is the next shiney thing ?  It’s irrelevant! to me anyway, because I am sticking to my friend OBIEE.  He has served us well for 16 years, and will continue to serve us in 2017.  Don’t forget people – All that glitters is not always gold.

Keep learning OBIEE and keep your customers happy using all those lovely features that you already have, but dont yet know how to use – Database Analytics, Actionable Intelligence, fully interactive

 

If I had one message for the new year – FREE THE DATA.  Get stuck into a Self service model – stop being like IT and start being like entrepreneurs.  Stop messing about with releases, and documentation and testing, and MUD and deploying into god knows which environment, and get on with really delivering, fast useful analytics.  Stop worrying about how things look and start producing intelligent results – stuff that will make the customer happy, because they can make productiove decisions.

Rant over.

 

Enjoy the New Year – Its going to be GREAT!

 

Read these…

blogBlogs of the year

  1. How It’ll Go Down – Upgrading OBIEE 11g to 12c

Neil Achord said, “What are you in for when migrating from OBIEE 11g to 12c? Short answer is there is a lot less pain going from 11g to 12c than there was going from OBIEE 10g to 11g. The upgrade to 12c is an out of place upgrade as was the 10g to 11g which means new software install followed by migrating/upgrading 11g artifacts (web catalog, RPD file and permisssion) to the 12c versions.

If you’re new to these upgrades, here is a super-short outline:

  • Check Software/Hardware Pre-requisites.
  • Install the OBIEE 12c software.
  • Export/migrate the 11g artifacts in the form of an export bundle.
  • Import the export bundle from the 11g system into the 12c system.
  • Test everything out in 12c.
  • Re-mediate any conversion issues.
  • Go Live

2. Art of BI: BITeamwork API In Action – Calling Basic Interactions

Christian Screen looks at the BITeamwork API in action, calling basic interactions for launching the cell annotation process and the dashboard comment editor.

3. OBIEE12c – Pushing-Up Daisies … or more Relevant than Ever in the World of BiModal IT

Mark Rittman shares the slides from his talk “Oracle BI Hybrid BI : Mode 1 + Mode 2, Cloud + On-Premise Business Analytics”

4. WELCOME TO OBIEE 12C – SCRIPTING BAR FILE BACKUPS

Paul Cannon refers to a previous blog and says, “A few months ago I wrote a blog on using BI Application Archive (BAR) files to back up the RPD, web catalog and security model from an OBIEE instance. Since then I’ve been asked by a client how this could be scripted for a regular schedule to run.”

5. Oracle ACE. What Does That Mean?

Michael Rainey asks this question…He shares his journey to becoming an Oracle Ace and says, “I knew deep down, but without really knowing, that an Oracle ACE was something I wanted to become.”

“It’s hard work. It’s not for everyone. But for those of us who choose to put in that effort, I believe it’s a great honor that we’re recognized by Oracle.”

6. Forecast: Partly Cloudy (Part 1)

Phil Goerdt blogs, “One thing that is for certain is that the cloud is here to stay. With more and more offerings having a cloud component, managing data and applications that are not on-premises will become commonplace. Some applications are optimized for this brave new world we’re living in (Oracle BICS comes to mind), but the old guard still remains, and we will need to be ready for integrating these new technologies into the old. In this series of blogs, I’ll walk through two cloud based data sources that I recently connected to OBIEE 11.1.1.7 on Windows VMs.”

7. My Favourite Things

Pete Scott writes, “Apart from the obligatory “raindrops on roses and whiskers on kittens” I must also add analytic functions to my list, and one function in particular, FIRST_VALUE (oh, and its almost identical twin LAST_VALUE.)”

8. Oracle SQLcl, Why?

Jeff Smith actually says, “Why Not??”

9. What should I know about SQL?

Scott Wesley bases this blog post on a question asked on twitter:

“What three things do you think every developer must know about #SQL ?”

and lists the best (in his opinion) responses.

10. Art of BI: Turn your OBIEE Sample App VM into a Development Environment

Sherry Milad asks, “How do you turn your OBIEE Sample App VM into a Development Environment?”

She goes through:

  • Steps to create a Shared Folder
  • Steps to setup ODBC connections
  • Steps to upload the development RPD
  • Steps to loading the development Web Catalog
  • Steps to log into Catalog Manager

and then we’re ready!

11. Groovy, Web Services and OBIEE12c

Stewart Bryson writes, “If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more time implementing.”

12. Adaptive Mayhem

Jonathan Lewis blogs about when you run a query and it gives you a plan with a note that says “This is an adaptive plan”.  He refers to this blog and this blog series.

 

My mate got one of those Dyson Ball Cleaners for Christmas. Unfortunately, he misunderstood what it was, which is why he’s now in hospital.

 

Winter Analytics

My Fireworks didnt go off in the right sequence.

Thats Bang Out of Order!

The nights are drawing in, the leaves have dropped and snow is on the hills. Time to stay in, curl up by the fire, and read a good blog.
So, here’s my Top 10 OBIEE blogs for you to

  1. obiee.info
  2. https://blog.daanalytics.nl/
  3. https://greatobi.wordpress.com/
  4. http://redpillanalytics.com/blog/
  5. http://redpillanalytics.com/dataviz-daily/
  6. http://www.redstk.com/author/paulcannon/
  7. https://www.datavail.com/blog/art-of-bi-new-business-intelligence-tools/
  8. http://www.peakindicators.com/blog
  9. http://www.vlamis.com/blog/
  10. http://stevenfeuersteinonplsql.blogspot.co.uk/
  11. http://rmoff.net/tag/obiee/
  12. http://hekatonkheires.blogspot.co.uk/
  13. https://www.rittmanmead.com/blog/
  14. https://debaatobiee.wordpress.com/category/obiee/

 

This weeks highlights are ….

blogBlogs of the week

  1. Thoughts/Info on Essbase/EssCS after Oracle Open World 2016

Tim Tow gives his thoughts on Essbase after Oracle Open World

2. How to get BI with Excel

Greg Suk writes about using Excel with BI. He concludes by saying, “There are a lot of other benefits to BI as well, but I’m purposefully being brief because I want you conscious. If you are still awake and want to know how to prepare Excel spreadsheets for analysis, click here

3. My OOW16 – My Thoughts and Those From The Analysts I Follow

Debra gives her thoughts on OOW16

4. OBIEE11g: All the Column Values are not shown in Prompts drop down for Check Box, Radio Buttons and List Box

This blog explores the scenario:

“We have created a column prompt on a column which has about 450 values. When we click on the Prompt Drop down all the column values are not displayed in the prompt when we are using Check Box or Radio Buttons or List Box the same prompt is displaying all the values when we select the check boxes option. The prompt shows first 256 values only, there is no option to see or select the values other than these 256.”

5. Known Issues in Oracle Database 12c R1 (12.1.0.2.0)

Ravi shares the following:

Known Issues _12

6. Oracle Process Cloud Service Connectors (Part 2 of 2): REST Service Connector

Antonis writes, “In the previous post we saw how you can use the Web Service Connector in Oracle Process Cloud Service to exchange data with an external application using the SOAP protocol.
Oracle Process Cloud Service also supports the REST architecture to retrieve, create, update and delete data using REST services and this is what we will look into in detail.”

7. Oracle JET and ADF BC REST Security Integration Approach

Andrejus promised to the attendees of his OOW16 session (Building Enterprise-Grade Mobile Apps with Oracle JET and Cordova [CON5731]) to post a blog about ADF BC REST security and integration with Oracle JET. This post is to demonstrate how we could reuse cookie ID generated by ADF BC REST Web session for REST requests from JET.

8. OTN Appreciation Day – Looking for Change

Peter Scott posts his appreciation for OTN, on appreciation day, a day to express thanks to OTN for wealth of technical content that makes our life easier!

twitterThis week on Twitter

Jonathan Lewis tweeted Adaptive Mayhem

Connor McDonald shared Direct mode operations on IOT’s

Mike Fuller posted Kicking with JSON in the Snow

LinkedinThis week on LinkedIn

Yasmin Morrison shared

Demo & Webinar Replay: Oracle BICS Visual Analyzer

Kent Graziano posted

“Yes we still need data modeling – My OTN Interview at OOW16”

addidici logoPaper.li

Stories from speakerdeck.comwww.tricoresolutions.com and www.itcentralstation.com

Videos such as:

Using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Cache to Debug Reports:

Dashboards with Oracle BI Cloud Service:

 

Back to Work Everybody

Club Tropicana. Closed, due to poorly thought out business strategy!

  • OOW IS Over
  • The Summer is Over (for up here in North Earth at least)
  • The Children has been sent of to University (Seems quiet around here!)
  • No more holidays this year (New York was a blast)

So lets get back to Work.
And theres plenty of work to do.

The Oracle BI marketplace is going through one of its ‘interesting’ phases. There are plenty of OBIEE Jobs on offer, and a good proporation of them are permanent (Which is nice). New technology is really helping us deliver great systems, I am particularly liking 12c In Memeory Database, OBIEE 12c and Exalyitcs Machines right now. OBIEE 12c is a far better release than 11g, which should trigger the upgrade programs. The only problem are the vast number of Cloud offerings, which means clients now have to figure out what/how/why they use cloud and therefore do they need to upgrade, or just buy a new BI Cloud Solution?

There are soo many Oracle BI offerings now that we will need massive brains just to understand what they are all for. A quick visit to oracle.com will reveal a huge list of products, all of which we need to trial, test, and decide if we need them in out BI systems. (Do I need R?)

The ETL marketplace is busy trying to figure out what all these new Buzz words are (e.g. Kakfa), and What the hell Big Data is anyway? Do they need it to run their business?

And then there is Apex, the current darling of the developers world. I have been using this tool since 2007 and love the new Apex 5 – So much so I am doing a conmference talk later this year on Apex and OBIEE.

All of which means, keep on Learning… and keep reading those blogs, join in on Twitter, Get into Community.Oracle.com, join the OBIEE Enterprise Group on Google, and buy our book!

New blog of the Month comes from Greg Artinoff – Check out http://www.fusience.com/blog.

 

BTW

This week I was updating our ODI system and wanted to do a simple update on a table, updating one column based upon another column value and another table. The question i posed on Twitter was how to do this in a mapping. Doing it a SQL Statement is easy;

UPDATE mytable t
SET t.is_current= 'Y'
WHERE t.a_column in (SELCT a_column from my_other_table where is_live = 'y');

So, the question is, can you create a simple mapping that does this? The only way I could think of was to have mytable and my_other_table as sources, joining on a_column and having a filter on my_other_table.a_column = 'Y', then add an expression to create a column with ‘Y’ in. Use the key on mytable.
This seems like over kill, but would it run quicker? Your thoughts would be welcome – replies on Twitter.

 

 

blogBlogs of the week

  1. OBIEE 12C MULTIPLE INSTANCES

Paul Cannon blogs about a question he’s been asked a number of times recently: Can OBIEE 12c have multiple instances running from a single installation (aka multi-tenancy)

2. SQLDev at Oracle Open World 2016

Jeff Smith lets you know what you can expect from his team at the world’s largest Oracle event – Oracle Open World.

3. Real World SQL and PL/SQL: Advice from the Experts

Chet Justice writes, “Brendan Tierney and Heli Helskyaho approached me in March 2015 about being an author on this book, along with Arup Nanda and Alex Nuijten. Soon after, we picked up Martin Widlake. To say that I was honored to be asked would be a gross understatement. Rather quickly though, I realized that I did not have the mental energy to devote to the project and didn’t want to put the other authors at risk. Still wanting to be part of the book, I suggested that I be the Technical Editor and they graciously accepted my new role.”

Read on for more details.

4. Smart View and Essbase Runtime Substitution Variables

John Goodwin blogs, “Back in August 2015 when Smart View 11.1.2.5.500 was released the readme had reference to new functionality for runtime substitution variables, the readme contained the following information:

“In Smart View, you can now execute Oracle Essbase calculations that, when launched, prompt you to enter variable information, called runtime prompts. Calculation scripts and runtime prompts are created by your Essbase administrator for your specific system.


Essbase administrators define calculation scripts so that Smart View users can work with runtime prompts. For information on setting up your calculation scripts with runtime prompts, see the Oracle Essbase Database Administrator’s Guide, “Using Calculation Scripts with Runtime Substitution Variables in Smart View.”

5. Groovy, Web Services and OBIEE 12c

Stewart Bryson says, “If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more time implementing.”

 

6. Back to the Future: Time Traveling with Snowflake

Phil Goerdt writes, “In my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE.

7. SAVING YOU 15 MINUTES: OOW16 SCHEDULE BOOKED!

Philip Brown says, “Being keen to make the most out of the opportunity of attending OOW16 I have already booked out my schedule. I’ve allowed a little time for the demo grounds but here are my picks, all 29 of them.”

Read the full blog to find out what he picked.

8. Loading Oracle Service Cloud (RightNow) Data into BICS with Data Sync

Richard Williams goes through:

  • Downloading Latest Version of Data Sync Tool
  • Data Load Methods
  • Setting up the Oracle Service Cloud Connection in Data Sync
  • Data Loading

9. Oracle Database Cloud (DBaaS) Performance Consistency – Part 3

Randolf Geist writes:

This is the third part of this installment, comparing the performance consistency of the DBaaS cloud offering with a dedicated physical host. This time instead of burning CPU using logical I/O only (see part 2) the test harness executes a SQL statement that has to perform physical I/O mostly, and to be more precise this round is a read-only test, so doesn’t include any modification to data (except the logging and any other background system generated write activity, like maintaining ASH /AWR data etc.).

10. Video: Part 4 – Implementing Drag & Drop functionality

twitterThis week on Twitter

Perficient & Oracle shared OBIEE Collaborative Analytics enables Decision making and action

Core Services tweeted Review of Oracle OBIEE by a Consultant

Sandrine Riley shared Data Integration Sessions

LinkedinThis week on LinkedIn

Mark Willems posted More great samples of moving Oracle in the cloud 

Kent Graziano shared Do we still need Data Modelling?

addidici logoPaper.li

Stories from rmoff.net and kanepartners.net

Videos such as:

Adding Hadoop and Big Data to Extend Data Warehouse Capabilities

Oracle IOT Demo featuring Anki Racing Cars

Shake off those Chicago Blues

My mate has written a book about birds
Aparently, it has flown off the shelves.

Life goes on in the OBIEE community. Just as those Chicago Kscope16 memories start to fade, the excitement begins for OpenWorld 16, then on to Tech16 (+Apps16).

The good news is that I finally got a proposal accepted, and I will be there – No not in sunny San Fran, but Beautiful Birmingham, England, Europe.

Tech 16

blogBlogs of the week

  1. What should I know about SQL?

Scott Wesley says that the 3 features he should know to be productive and efficient are:

1. analytics
2. scalar subqueries
3.  with clause

Read the full blog for more.

2. Video:Part 2 – APEX Classic Report Named Column Templates

Part 1 is here. Jorge Rimblas  shares Part 2:

3. Creating ggplot2 graphics using SQL

Brendan Tierney writes, “Did you read the title of this blog post! Read it again. Yes, Yes, I know what you are saying, “SQL cannot produce graphics or charts and particularly not ggplot2 graphics”.You are correct to a certain extent. SQL is rubbish a creating graphics (and I’m being polite).But with Oracle R Enterprise you can now produce graphics on your data using the embedded R execution feature of Oracle R Enterprise using SQL. In this blog post I will show you how.”

4. Getting Started with Oracle BICS – My Services

Sarah Craynon Zumbrum says, “Once you have signed up for Oracle’s Business Intelligence Cloud Service (BICS) either via a trial or by purchasing a BICS subscription, the first thing that will happen is that you will get a couple of emails. The first one will tell you your cloud account details.”

She then details the rest of the process in this blog.

5. OpenWorld 2016 is not far away

Connor McDonald says “See you in San Francisco!” and lists the panels where you can chat to them, ask questions, debate topics and basically have a relaxed 45mins during all the frenzied activity that is OpenWorld!

6. ADF BC REST Authentication with JSESSIONID Cookie

Andrejus writes, “I have described how to apply ADF Security for ADF BC REST in my previous post – Oracle JET and ADF BC REST Basic Authentication. I will show how you can authenticate on first request and for the next requests rely on JSESSIONID cookie from the first request. This is useful for mobile clients and JET, there is no need to keep user credentials during requests (enough to keep cookie), as this is sensitive data.”

7. Create an Empty OBIEE 12c Web Catalog – Easy as 1,2,3

Sherry Milad writes, “In this blog I have used the sample app v511 to demonstrate how straight forward it is to create a blank Web Catalog.”

8. 2016 Kscope -What did I learn?

Debra details her KScope16 experiences

9. Reflections on KScope16

Monty gives us an account of his experiences as an attendee – and also a vendor

10. Why should you apply for ODTUG Leadership Program

DEV EPM tell us why we should get involved with the ODTUG Leadership Program.

twitterThis week on Twitter

Salih Oztop posted How to Solve Complex Business Requirements with ODI-BGOUG 21st November 2015

UKOUG posted a link to Oracle Scene

OTN Arch Beat posted Oracle Business Intelligence Server Caching

LinkedinThis week on LinkedIn

Fereshteh Bayat asked How can I call BI publisher report from jdeveloper ADF using web service?

Yasmin Morrison posted 10 Steps to Eliminate Hard Coding in the Oracle Call Interface

addidici logoPaper.li

Stories from mondaybi.com and www.thatjeffsmith.com

Videos such as An OBIEE Developers Guide to Essbase Integration

and OTN Community Cast LIVE – Oracle ACE Erik Benner – Oracle Cloud Services – Solaris Update

Armagedden Avoided

What kind of Rock is never delivered on time?

Slate

FTSE is up, Exports Up, Government borrowing down.  Mortgage rate down. Crisis over.

Can we now get back to geeking now?

 

While you were all enjoying yourself in Chicago I decided that I couldnt watch enviously from a wet, slightly miserably Post Brexit Vote UK, so headed off to our Villa in Portugal.  It struck me while I was there that I could work anywhere in the World (even in the Europe!), and I didnt need a cloud to make it happen.  Just good ole fashnioned RDP (or Jump for the Applers).

So, dont feel down about not be able to move to the cloud (for security, costs etc reasons), just move to Sunny Portugal and remote to the world.

My Mate cant pronounce the letter ‘S’ when he talks about fruit.

He says its his Peach impediment.

blogBlogs of the week

  1. Turn your OBIEE Sample App VM into a Development Environment

Sherry Milad asks the question, “How do you turn your OBIEE Sample App VM into a Development Environment?”. She goes through the steps to create a Shared Folder and to upload the development RPD until the end of the process. Read the full blog for more details.

2. Upgrading Oracle Business Intelligence to 12c

This blog is based on a talk which had 4 sections:

  1. An overview of the simplicity of the upgrade from 11g to 12c
  2. Organizational mindset while preparing for the upgrade
  3. The new technical infrastructure and the implications for the organization
  4. How to introduce users to the new features and how this might impact governance

3. … Kscope 16 has finished and it was amazing!!!

DEV EPM blog about their KScope16 experiences and link to slides to their talks.

 

4. Video: APEX Classic Report Named Column Templates

Jorge Rimblas shared a video which he also did a talk on at KScope16 (“Hooked on Classic (Reports) ) Watch it here

5. Kscope16 APEX Symposium (live) Log

Christian Rokitta shares a short summary of the highlights from the presentations of the Oracle APEX presentations.

6. Kscope16 in snaps, part 1

Cameron Lackpour shares Part 1 in a series of blogs about his KScope16 experiences.

7. Oracle Business Intelligence 12.2.1.1.0 is available

The documentation is here and the latest release is here to download.

8. Sensitive Data

Heli shows how to design your sensitive data using Data Modeler.

9. Kscope16 in snaps, part 2

Cameron Lackpour shares Part 2 in a series of blogs about his KScope16 experiences.

twitterThis week on Twitter

UKOUG shared Where Oracle Cloud Business is starting to surge

Danny Byrant tweeted KScope16’s Unsung heroes

Simon Greenwood posted: Coming in 2016… Oracle DB Cloud Free Service

LinkedinThis week on LinkedIn

Yasmin Morrison shared Find Hidden Savings in Your Supply Chain with Business Analytics

Kent Graziano posted How to connect OBIEE to Snowflake Elastic Data Warehouse

addidici logoPaper.li

Stories from kentgraziano.comwww.oraworld.co.uk and intellipaat.com

Videos such as:

User Engagement for OBIEE – How to Deliver it, Measure it and Monitor it

and Managing Oracle APEX Lifecycle with Oracle Developer Cloud Service

What Does Brexit Mean for the UK OBIEE Market

May you always live in Interesting Times

Not sure who said that but I am sure he didnt meant this interesting!

Markets plunging, Jobs at risk, political turmoil.

First, if you are analysing the market reactions, then please use OBIEE

If you want to improve the analyse of Polls, then get OBIEE!

Everyone else – Calm Down, Calm Down

Democracy has won, but life will still go on.  Exports will now go up.

Imports may struggle if in dollars – So, if you are buying Oracle product, lets hope they keep the prices at their current levels, or preferably drop them.

In the meantime, travelling to Oracle Open World just got a lot more expensive.  Maybe they could have it here this year instead, you can get loads of pounds to the dollar 🙂

For those at Kscope16, have a great time, and hopefully I’ll be there next year.

blogBlogs of the week

  1. BI Teamwork 3.8.6 Released – Certified for Oracle BI 12C

Christian Screen asks,

  • So what about OBIEE 12c for Oracle BI 11g?

and goes through New features in this release

  • ILC Comment API Enhancements
  • Auto Save Comments
  • Hyperion & OBIEE SmartView Connection Management
  • Splash Page Embedded Images

2. Forecast: Partly Cloudy (Part 1)

Phil Goerdt writes: “In this series of blogs, I’ll walk through two cloud based data sources that I recently connected to OBIEE 11.1.1.7 on Windows VMs.”

3. SQLcl and Query Change Notification

Kris Rice writes, “The database has had Query Change Notification for a while but to use it required a custom program. Such as Tim outlines on his blog.

4. Charting Predictions, al a AskTom

Scott Wesley writes his blog, inspired by this tweet:

Capture

5. Oracle Process Cloud Service – Web Form Design Approaches

Antonis Antoniou writes, “Oracle Process Cloud Service uses a standards-based technology called “Web Forms” for defining the user interface in business processes. It’s based on standards such as XHTML, CSS and JavaScript and allows business analysts and developers to create an end-user interface by just using the browser. There are three approaches that can be employed when designing web forms.”

  • Form-First
  • Data-First
  • Hybrid

6. How to sort attributes?

Heli asks, “I would like to have my attributes in alphabetical order. Do I need to do it manually or is there a way to do it automatically?”

7. Messed-Up App of the Day: Tables of Numbers

Cary Millsap says, “good design is also a very practical matter for you personally, too. If you want your audience to understand your work, then make your information easier for them to consume—whether you’re writing email, proposals, reports, infographics, slides, or software. It’s part of the pathway to being more persuasive.”

8. Kscope16 sessions I want (and maybe even will) attend

Cameron Lackpour goes through the #Kscope16 sessions that he wishes to attend.

9. My Favourite things 

Pete writes, “Apart from the obligatory “raindrops on roses and whiskers on kittens” I must also add analytic functions to my list, and one function in particular, FIRST_VALUE.”

10. Cluster Details with Oracle Data Mining – Part 2

Brendan Tierney blogs, “This is the second blog post of my series on examining the clusters that are predicted for by an Oracle Data Mining model for your data. In my previous blog post I showed you how to use CLUSTER_ID and CLUSTER_PROBABILITY functions. These are the core of what you will be used when working with clusters and automating the process. In this blog post I will look at what details are used by the clustering model to make the prediction.”

twitterThis week on Twitter

UKOUG shared Oracle Scene

KPI Partners posted What you need to know about Oracle Data Integrator 12c

ODTUG tweeted the BI Community Newsletter

LinkedinThis week on LinkedIn

Yasmin Morrison shared What’s the Biggest Challenge in Moving EPM/BI to the Cloud?

Paper.li

Stories from community.oracle.comwww.cptech.com and  attendee.gotowebinar.com

Videos such as:

Cardinal Sins in OBIEE Development | Christian Berg

Tables: Databases for Developers #1

 

Two Minute Tech Tips

The OTN will be at Kscope16 looking for willing Volunteers to video their tech tips.  I cant get there this year, so may have to do a selfie video 🙂

But what subjects would I cover?

  • Use of Advanced SQL?
  • Jquery in OBIEE?
  • Apex and OBIEE?
  • Hidden Cascading Prompts?
  • Result Columns on Union?
  • CSS and Javascript on Dashboards
  • Use of Folders in the Catalog?

This week I had a Birthday 🙂  So i bought myself a couple of Gigabyte BRIX computers.  They are awesome!  for £500 you get i7 CPU, 32Gb RAM, internal Wfi, USB 3 ports, HDMI and two SSD drives.

Check out http://www.gigabyte.com

 

blogBlogs of the week

1. FDMEE and DRM integration – Part 1

John Goodwin adds his simplistic view on the flow between FDMEE and DRM:

pic

Read the whole blog.

2. Announcing the Dodeca Spreadsheet Management System, Version 7 and the Dodeca Excel Add-In for Essbase

Tim Tow writes, “After 18 months of hard work, Applied OLAP is proud to announce the general availability of the Dodeca Spreadsheet Management System, version 7, and the all-new Dodeca Excel Add-In for Essbase.”

3. ACCESSING THE ALERT LOG FROM SQL

Nigel Fowler asks, “Ever wanted a programmatic way to access the alert log?” He shows us how to do it with SQL.

4. Oracle SQLcl, Why?

Jeff Smith says the real question is Why Not? !!

5. Customizing ODI Knowledge Modules

Emilio Soriano says, “The first thing to bear in mind when you start working with ODI is that you really must follow best practices in order to take full advantage of two of the most powerful weapons in the ODI arsenal: the declarative design and the knowledge modules. For those of you that don’t have too much experience with ODI, let me run through these two outstanding features.”

6. Countdown to KScope16

Wayne D. Van Sluys shares some interesting facts about KScope16.  He also shares the session lineup. 

7. How to create a Physical Model?

Heli says, “I have designed the Logical Model, pressed the double-arrow (Engineer to Relational Model) to get the Relational Model. Now I am ready to create a Physical Model for that Relational Model but how to do it?” Read on for more.

8. Snowflake DB Cool Features – Automatic Query Optimization

Kent Graziano names Automatic Query Optimization. No Tuning as number one in his Top 10 Cool Features in the Snowflake Elastic Data Warehouse.

9. PREDICTION_DETAILS function in Oracle

Brendan Tierney blogs, “When building predictive models the data scientist can spend a large amount of time examining the models produced and how they work and perform on their hold out sample data sets. They do this to understand is the model gives a good general representation of the data and can identify/predict many different scenarios. When the “best” model has been selected then this is typically deployed is some sort of reporting environment, where a list is produced. This is typical deployment method but is far from being ideal.”

10. Examining predicted Clusters and Cluster details using SQL

Brendan writes “In a previous blog post I gave some details of how you can examine some of the details behind a prediction made using a classification model. This seemed to spark a lot of interest. But before I come back to looking at classification prediction details and other information, this blog post is the first in a 4 part blog post on examining the details of Clusters, as identified by a cluster model created using Oracle Data Mining.”

twitterThis week on Twitter

OTNArchBeat shared Taking Your OBIEE to the Next Level with SmartView VBA 11.1.1.7.1 [TECH ARTICLE]

ChristianSteven tweeted Under the Covers of OBIEE

Debra Liley posted Oracle Cloud Applications Review

LinkedinThis week on LinkedIn

Yasmin Morrison shared Why’s It So Hard to Maintain Data Consistency Across the Organization?

Kent Graziano posted Report on World Wide Data Consortium

Tanya Heise shared New Knowledgebase Document – Using Custom Styles in OBIEE 12c

addidici logoPaper.li

Stories from community.oracle.com,  www.cptech.com and www.rittmanmead.com

Videos such as: Staying Ahead of the OBIEE Upgrade Wave: Versions, Support and Integration

and COL10: Working with Multilevel (Nested) Collections

 

Deadlines Met and News @ OBIEE

Deadlines. Some are ‘pretend’, you know you can get away with being a little bit late, because the you KNOW the project manager has factored in you being late! Others are very fixed. Like the deadline to submit proposals for speaking at conferences. Luckily I met the two that just passed, one was for Oracle open World in San Francisco, and the other was for Tech 16 – The UKOUG conference coming up in December. Wish me luck, because in 15 years of working in OBIEE I have not presented at a conference. I did a rubbish talk once at a BI Forum – It was terrible due to lack of sleep the night before.
Talking of conferences, the ODTUG KScope16 conference in Chicago looks like it will be another great event – Don’t hold back, register today http://kscope16.com/   It’s worth going for the networking alone!

This week I updated the OBIEE newspaper – you will now find it at news.obiee.info.  Check out and subscribe to this weekly market update.

 

blogBlogs of the week

  1. OBIEE Upgrade – 5 Common Question Areas

Bill Anderson names the 5 common question areas as:

  • Upgrade vs Migrate
  • Versions
  • Importing the 11g bundle
  • The Metadata layer
  • Post Migration Steps

2. WELCOME TO OBIEE 12C – SCRIPTING BAR FILE BACKUPS

Paul Cannon referred to his original blog and then expands on it.

3. Tracking OBIEE reporting data

Rafal Ostaszewski writes, “BI implementations may use hundreds of data warehouse tables and thousands of reports, and one of the most common requirements in a BI project is the ability to track back the data used in reports.”

4. Oracle Data Visualization Desktop – First Impression

Srinivas Malyala links to Data Visualisation and Oracle Community Forum in his blog.

5. Creating a Mobile-Optimized REST API Using Oracle Mobile Cloud Service – Part 4

Steven Davelaar says, “To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption.”

He then goes through:

  • Setting up the storage collection
  • Implementing the GET Jobs Endpoint
  • Testing the GET Jobs Endpoint

6. Analyzing Execution Plans

Ric Van Dyke writes, “The classic suggestion is to look for Full Table Scans and try to eliminate them.  However Full Table Scans can be the right thing to do more often than not.  Indexes are great and the right index can sure make the difference in see your results now or days from now.  But if you’re getting data from most of the table blocks, a full scan can be the right way to go.”

7. UKOUG Tech16 Call For Papers!

Look for the deadline dates and submit papers here.

8. Oracle Documentation permalink creation

This blog says, “Tim Hall of ORACLE-BASE spoke for a lot of people when he (yet again) wrote about Oracle Documentation links changing all the time. There exists a method for a more permanent link to Oracle Documentation, but it can be a hassle to create such a permalink involving manually searching HTML code of the doc source.”

9. APEX Connect 2016, “The Pink Conference”

Heli documents her experiences of APEX Connect in Berlin, Germany.

10. RI Locks 

Jonathan Lewis responds to a a question that came up on the OTN database forum in this blog.

twitterThis week on Twitter

Danny Byrant shared the ODTUG newsletter

Payam Moghtader posted ORCL Data Integration:

Capture2

Christophe Dupupet shared Connecting Oracle Data Integrator (ODI) to the Cloud: Web Services and Security Policies

LinkedinThis week on LinkedIn

Karen Smith shared Calls for Papers for Apps16

Alum Sam asked “What is Quantum Computing?

Michael Rainey asked “Oracle ACE. What does that mean?

addidici logoPaper.li

Stories from eventreg.oracle.com and pptsearch365.com

Videos such as:

Cardinal Sins in OBIEE Development

and Install and configure VirtualBox on Windows 7 x64

Go Self Service or Go Home

Who understands your company Data best?

  1. Is it the OBIEE RPD Developer?
  2. Is it the DBA?
  3. Is it the Warehouse Designer?
  4. How about the source System Architect?
  5. Or the department analyst?

Lets ask the question another way, Who knows what to do with the company Data in your system?

  1. The Data Scientist?
  2. The report distributer?
  3. RPD Developer?
  4. Dashboard Developer?
  5. Dashboard User?
  6. Board Member?

OK, one more question,

Who knows how to transform data into meaning?

  1. Database Developer?
  2. ETL Developer?
  3. RPD Developer?
  4. Excel Guru in the xxx Department?
  5. Board Members?

So, you answered the above, and you probably biased your answer depending upon where you are in the company. You’re in the IT department? Then you think IT is the answer. You work for the finance director producing reports, then you think end users rock!

Despite whatever your opinion is, the truth is demonstrated by what is successful in the front line.

Be honest, how many times does a print out of a dashboard, written by the IT department, get presented in board meetings. The answer is NEVER (and I mean Never). The reality is that Powerpoint and Excel Rule when it comes to end users. Why? because they can manipulate the presentation and the data in the way they need to – They have the skills and therefore love the tools. Lets not forget that MS Access won the battle of the databases. Oracle may well be the best database platform, with SQL Server a close second, but users have MS Access in their desktop, so Access wins. Essbase is another example, where departments get what they want, bypassing the IT department.

Why is this relevant to OBIEE? Well, look whats happening in the technology space – PowerBI from Microsoft, R Studio, Data Visualisation Desktop, BICS, APEX 5.0, Spotfire and dozens of other end user targeted systems. All of which can be bought with departmental budgets, and can be implemented without IT.

So what can you do?

Build your platform well, and let the users free reign to building the content. Give users access to Answers and Dashboards. Ge them to build the Agents and the BI Publisher reports. They understand the data far better than you do. And they have the IT skills.

This is the age of the end user. get over it.

 

blogBlogs of the week

1. Oracle Users in Action (A Collaborate16 Conference Review)

Ian Abramson talked of his experience of the 4 day event. He says, “The 4 day event had many themes and introduced ideas but my thoughts was focused on the messages in the following areas:

  • The upcoming release of Oracle Database 13c. An updated version with expanded features. Still under NDA so we have little to discuss at the moment.
  • The Cloud
  • Business Intelligence (Discussion around the concept of bimodal BI)
  • Security
  • Big Data and Internet of Things

…A big topic of conversation was Cloud. This permeated across all technology and applications. Oracle is focused on becoming the biggest Cloud provider of databases, applications and other components provided through their SaaS and PaaS strategy. ”

2. Getting ready for Collaborate 2016

Elke Phelps provides an overview of their planned activities at the conference. These include ‘Meet the Experts’ sessions, special interest groups, sessions, panels and demos.

3. My first Collaborate

Heli sums up her experiences at Collaborate16

4. Collaborate 2016 Oaktable World Sessions

Another Collaborate16 blog to peruse!

5. How to Install Oracle 11gR2 XE on Ubuntu

Gokhan Atil writes, “I wanted to import a datapump dumpfile to my laptop, and I wondered if I can install Oracle XE to ubuntu guest. I thought it would be easy because I installed Oracle 10g XE to ubuntu for several times, but I saw that Oracle doesn’t provide debian packages for Oracle 11g XE. So I needed to convert the RPM to debian package (and fix incompatibility problems). Therefor, I installed “alien” package and other required tools using apt-get.”

6. Installing OBIEE on Windows

Sarah Craynon Zumbrum says, “Earlier this week I started on the task of installing OBIEE on my Windows machine for the first time ever. And by myself. The software download took around 2 hours (really bad home internet…took <30 minutes in the office for all files) and the install took 4 hours, with most of the time coming from frustrating pauses in the installation process. But, I figured all the nuances out and want to list them here for you so you won’t have the same halts as I had…or they will help you get past where you are currently stuck.”

7. Monitoring ADF 12c Client Request Time with Click History

Andrejus Baranovski writes, “You must be excited to read this post, I will describe one very useful feature, available in ADF 12c. This feature – Click History. You can follow steps described by Duncan Mills, to enable and read click history data in server log. There is one more option available – we can read click history data from ADF request (captured by filter class) and log it in custom way (for later analysis). Click history gives such information as client request start/end time (you can calculate client request duration), component client ID, component type, action event type, etc. All this is useful to understand application performance perceived by the client.”

8. ODI 12c LOOKUP Components

Pete Scott writes, “In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target table and selected where to execute the expression, be it source, stage or target.”

9. Can Oracle SQL Developer do that?

Jeff Smith gives a quick run-down of FAQ’s he gets when doing presentations or demos including How to Extend a Tablespace and How to Debug a stored procedure?

10. OBIEE 12c Required Information: Services, Repository Deployments

A blog that gives some useful information about OBIEE 12C.

Includes:

  • Restart services
  • Main Directories
  • Catalog Upgrade Pre-Requisite

11. Agile Amped Interview

Kent Graziano talks of his experience at Agile Alliance Tech conference (#AATC2016) and shares his interview:

12. Active and Inactive Sessions

Connor McDonald writes, “Most people are aware of the STATUS column in V$SESSION. If it’s ‘ACTIVE’ then that connection is in the process of consuming database resources (running a SQL statement etc). However, a lesser known column which is probably even more useful is the LAST_CALL_ET column.”

13. Kscope16: New Oracle Professional Track

Sarah Craynon Zumbrum shares this opportunity to attend KScope16. She says, “With this New Oracle Professional track, you can take 1-2 year’s worth of learning and condense it into 3 days. I’d say in terms of ROI, it’s kind of like winning the lottery. No waiting 2 years for salary expenses to pay for the knowledge; rather, 50%  off the registration price of Kscope16 is the cost.”

14 . Why PLSQL?

Connor McDonald shares:

twitterThis week on Twitter

 tweeted CL16LV photos

 shared Her first Collaborate

 

LinkedinThis week on LinkedIn

Massimo Sposaro shared OWB to ODI conversion

Michael Rainey posted Oracle Ace, What does that mean?

Tanya Heise shared Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Bundle Patch 11.1.1.9.160419

addidici logoPaper.li

Stories from itcentralstation.comcloud.oracle.com and kscope16.com

Videos such as “Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Tips & Tricks” Webinar Snippet

and Tableau Best Practices for OBIEE