OBIEE Beats the Holiday Blues- Again!


The great thing about working on OBIEE projects is that when you come back from holiday (Got back last night from Croatia), you can get excited wbout going bck into the office. In fact, I cant wait til Monday – So I am going in tomorrow.

Heres what i found today….

Blogs of the week

 

  1. Check out the 2017 UKOUG Conference agendas

Daan Bakboord shows us the agenda for Tech17

2.  ORDS 17.3 Beta – Introducing REST enabled SQL

Kris Rice shows us where to download then writes about:

  • Versioning
  • REST Enabled SQL
  • The Fine Print
  • What’s coming next

3. Swagger Doc for ORDS RESTful Services

Jeff Smith shows us where to download then says, “There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls.”

He posts this video:

4. Data Visualization with R ggplot2 – Part 2

Nandoo’s blog writes, “In my previous post Data Visualization with R ggpplot2 – Part 1, I detailed the pre-requisites for getting started with using ggplot2 with R. In this post, I will focus more on the usage of R package – ggplot2 and various visualizations that can be generated using this package.”

He finishes by saying that there are several other options available to plot various charts using R.  See the cheatsheet for all the  available options:   Data Visualization with R

5. Build ATG Commerce applications in Oracle Developer Cloud

Michael Shanley says: “This post will demonstrate how to setup and build an Oracle ATG Commerce application in Oracle Developer Cloud Service (devCS)”

Read on for more details.

6. High Five POUG: Polish Oracle User Group Conference?

Neil Chandler says, “I’ve just returned from presenting at the 2nd annual POUG Conference, this time in Krakow, Poland (the first was in Warsaw). This is the Polish Pint with Oracle User Group conference and is exactly what a conference should be. Educational, Informative, Well-executed and Fun.  It was based in a lovely city, with a wonderful friendly people, good food and great beer!”

Read the whole post for his full account, plus photos!

7. DYNAMIC_SAMPLING SQL Plan Directive in the cloud or not

Ric Van Dyke writes:  “With 12, Oracle introduced SQL Plan Directives, which in my view is really giving the optimizer a
chance to learn from its mistakes.   This is a step in the direction of a leaning optimizer.  In a way the optimizer is taking notes on how something ran and if not quite right, this note will help it not make the same mistake again.  It’s limited in 12.1 to just one type DYNAMIC_SAMPLINGand in 12.2 another one appears DYNAMIC_SAMPLING_RESULT.  Right now I’m going to focus on the first one.”

8. SystemTap and Oracle RDBMS: Page Faults

Bertrand Drouvot writes, “Now that I am able to aggregate SytemTap probes by Oracle database, let’s focus on page faults.”

His blog covers:

This blog links to the

10. ODTUG Leadership ProgramOBIEE 12.2.1.3 is available

Boris Dahav links to the download page and talks about the new features and changes.

This week on Twitter

Red Stack Tech tweeted Welcome to OBIEE 12C: File Locations

Oracle BI Blogs shared OBIEE 12c Custom Style via EAR file

ODTUG posted the guidelines for Board of Directors nominations

Paper.li

Stories from www.redstk.com and www.biconnector.com

Videos such as Tableau Analytics for OBIEE using BI Connector

and GoldenGate What is it; Who & What to Learn; How It Works

OBIEE is not dead, just has a new name

With just one more holiday to get through before back to work, there’s just enough time to catch up with the latest blogs we read this month.

Also happening this month were the speaker announcements for UKOUG, and unfortunately I didn’t make the cut. With so many submissions for a limited number of slots, I know it’s hard for them to decide, I have been there before on the Kscope selection panel, and there is always someone who is going to be disappointed – this time it was me.

I could speculate that it’s because my topic was not what they wanted this time, or because OBIEE is not their focus, or my submission was poor, or the sponsors took up lots of spaces, or the conference wanted more newbie speakers (or the same ones we normally see), or I annoyed the selection panel chair!  Unfortunately that’s all I can do – speculate.

So, how do I go forward from here?

In some ways it’s good to have been rejected, because the memberships fee, travel cost, hotel bill, loss of client billing, buying special equipment and software, all add up.  I was wondering why I was paying so much to give away my knowledge for free?

Then there’s the time saved, not having to work so hard to prepare the presentation.

But I guess the biggest benefit is that I reminded to constantly review the market and make sure I adapt to where it’s going  – no doubt that the Analytics  space is evolving and I need to evolve with it.  There isn’t even an Analytics track on Super Sunday – Just Apex, Database and fusion.

For the main event there is still an Analytics track, featuring Cloud (of course), Data warehousing (Good Old DW), Visualizations (New stuff) and what they call Advanced Analytics (Not sure which session this is).  There is little mention of last years trendy word (BIG DATA), and only a few mentions of data lakes, but we are still seeing lots of the Cloud word and Data Viz.  My biggest concern is there are only 2 (yes TWO) session that mention OBIEE.  Down on last year.

I still think the conference will be good, and worthwhile going if you can get your company to pay, but if I was going I think I would have trouble knowing which session to attend – the tracks conflict with each other, so I would find it difficult to decide whether to go to Apex, Database or Analytics sessions!

One speaker I would have liked to have seen is Daan Bakboord, and to quote his blurb

“Change is the law of life. And those who look only to the past or present are certain to miss the future.”

So I will take his advice and guess that in the future companies will still need Oracle Business Intelligence, some in the cloud, some cloudless, some with visualisations, some without, some advanced, some basic.  Oracle Business Intelligence will still need great database design, some customisations, and most importantly, will still need integrating into the client.  We may use new toys, new functions, new apps etc, but we will still be doing “Business Intelligence implementations”, and hopefully with great Oracle products, like OBIEE.

Hopefully all needing experts like me to be right on the cutting edge, and also fully up to speed with the current tech (i.e. OBIEE 11g/12c on site).

 

Anyway, start here, and learn!

 

Blogs of the week

1. Installing Oracle Data Integrator Cloud Service (ODICS)

Travis Brannan names Part 1 of this blog series , “Creating the Database and Java Cloud Service”. and goes through:

  • Creating the database
  • Creating the Java Cloud Service

2. Art of BI: OBIEE 12c RCU Installation – Invalid Credentials Error

Sherry Milad writes that this blog is to guide you through getting around an error you may face during the OBIEE 12c RCU Installation on a Windows 2012 R2 environment.

3. OAC Backup Issue

Robert Gideon writes about a backup issue with OAC and how to get round it!

4. Look and Feel – Feel Free to Go Crazy

Jeff Smith asks and answers: How can I make SQL Developer look…different?

5. Real Time Business Intelligence with Oracle Technologies

Iñigo Hernáez recommends going through the previous blog post first, then covers:

  • Traditional and Real Time BI
  • Case Study Overview
  • Solutions Design and Development
  • On Premise
  • Azure
  • Power BI Cloud
  • Scenario Analysis and Conclusions

6. Code Based Access Control, #securecoding #oracle #plsql #MultipleSchemas

Robert Lockard tells us to download the code here. Then says, This example depends on the HR Demo schema being loaded. We will be building on this example over the next several months to present a full blown application that includes many of the secure coding features I have been talking about.

7. Join Elimination Bug

Jonathan Lewis says, “A few years ago a bug relating to join elimination showed up in a comment to a post I’d done about the need to keep on testing and learining. The bug was visible in version 11.2.0.2 and, with a script to replay it, I’d found that it had disappeared by 11.2.0.4.Today I had a reason to rediscover the script, and decided to test it against 12.2.0.1 – and found that the bug was still present.”

8. Something Going Up Is Not Always Good

Stephen Few starts off by saying, “Even though our unique ability to deal with complexity propelled humans to the top of the evolutionary heap, we still crave simplistic (i.e., overly simple) explanations. I promote the value of simplicity in my work, but never simplicity that sacrifices truth. Simple things can and should be explained simply. Complex things can and should be explained as simply as possible, but never in a way that disregards or misrepresents their complexity.” Read on!

9. Oracle Big Data Cloud Service CE: Working with Hive, Spark and Zeppelin 0.7

Gokhan Atil points us towards his previous blog post  and looks at working with Hive, Spark and Zeppelin 0.7

10. Auto enabling APPROX_* function in the Oracle Database

Brendan Tierney opens his blog by saying:

“With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include:

  • APPROX_COUNT_DISTINCT
  • APPROX_COUNT_DISTINCT_DETAIL
  • APPROX_COUNT_DISTINCT_AGG
  • APPROX_MEDIAN
  • APPROX_PERCENTILE
  • APPROX_PERCENTILE_DETAIL
  • APPROX_PERCENTILE_AGG

These functions can be used when approximate answers can be used instead of the exact answer.” Read the rest of the blog!

11. Grammar of Graphics

This week on Twitter

Opal A tweeted ‘Women in Technology Scholar’

UKOUG shared a conference sneak peek

Kent Graziano posted What is a data warehouse, and why should you care?

Paper.li

Stories from www.datavail.com and www.eventbrite.com

Videos such as:

KISS series on Analytics: 25 The KEEP clause

and:

Multiplication Table Project: Create ERD with Quick SQL

OBIEE 12c Security

Security of Data, Integrity of Systems and Ease of Use are fundamental cornerstones of any system,
-and OBIEE is no exception.

This is the first blog in a series which demonstrates security features and design choices that can made when building your secure Oracle Business Intelligence system.

In the series of blogs I will cover

  1. Data Security
  2. System Integrity
  3. Code Security

Data Security

The security of data covers a wider spectrum from Legal requirement (Data Protection Laws), to simple need to know rules.  On the one hand, the penalty for exposing data to the wrong people could result in serious consequences, while on the other you get to annoy your customers/users.  The severe consequences include legal cost and fines, major damage to your company reputation and the loss of customer revenue.  These all apply internally too, so just because your OBI project is only on the company intranet, dont be lax with the data.

Just to confirm, for Data Security we mean making sure we know the right people have access to the right data.  What they do with that data, e.g. downloading, emailing etc, is up to your company policies and controls, but for us we will focus on who can see what.

 

System Integrity

Anyone running an internet facing business knows just how many people are trying, on a daily basis, to break in.  Whether its kids, fraudsters or government agencies they all have the potential to take down your system.

For internal based systems you could think that the chance of people hacking into your code are reduced, this is up for debate, but the possibility is still there, and what if rival companies have sent in spies to work in your company!

The system intregrity blogs will cover Authentication as well and Authorisation as well as the protocols in place to safeguard access to the components.

 

Code Security

 

Finally I will cover my thoughts on code development and therefore security of code.  This is mainly to ensure that you can develop in a fast way, unincumbered by too much overhead, but still leaves your system code safe and reliable.

 

 

The next blog will cover the many layers of data security…

Summer Fun with OBIEE

I used to get earache on flights, but not any more
… this year I’m booking my kids five rows back

Why don’t mummies go on summer vacation?
They are afraid to relax and unwind!

The sun has got his hat on in Europe this week – time to head indoors, and enjoy the shade, with a cool drink and a computer full of OBIEE blogs!

Blogs of the week

1. Art of BI: OBIEE 12c Upgrade Gone Wrong? Bring in Datavail

Bill Anderson talks about when things go wrong. He says the aspects of OBIEE that can be adversely affected by an improper upgrade are:

  • Technical deployment
  • Infrastructure
  • Core Oracle Analytics
  • Security
  • Report Development
  • High availability sets

2. Trying out the Oracle Cloud Platform

Daan Bakboord links to the download page  and tells us to try out the Oracle Cloud Platform!

3. Enforcing Naming Standards for Your Data Models

Jeff Smith answers this question:

“We tried also to apply some naming conventions but I think we didn’t understand something….
Having a logical model with a table having the column X, and a glossary having the standard name as Y. Can I apply some checks based on the glossary directly in the logical or relational model?”

4. Extending Oracle DVD Map functionality

Irina Bakardzhieva goes through:

  • The Challenge
  • DVD 12.3 plugin
  • The ClearPeak’s Solution
  • Demo
  • Conclusion

5. SQLPLUS, login.sql and 12.2 in the cloud or not

Ric Van Dyke talks about a little hiccup in 12.2  with SQLPlus in this blog.

6. Sans Kscope

Scott Wesley talks about NOT going to KScope!

7. Multi-Instance Subprocess in Oracle Process Cloud Service

Antonis Antoniou says, “The May 2017 Oracle Process Cloud Service release on-boarded a very useful and powerful on-prem feature, that of multi-instance subprocesses. In a nutshell, multi-instance subprocesses allow you to execute a specific set of actions a specified number of times either in sequence or in parallel. What shouldn’t be confused is the difference between repetitions and multi-instances. Multi-instances will create a snapshot of a specific set of actions and data, and run it a specified number of times, with each instance living in it’s own private memory space.”

8. #Oracle #sqldev 17.2.0.188 MAJOR improvement

A quick blog about SQL Developer Instance Viewer!

This week on Twitter

ODTUG shared the following video:

A Birthday This Big Deserves an Entire Year of Celebrations – Happy Birthday ODTUG!

Daan Bakboord posted Trying out the Oracle Cloud Platform (Try it here)

 

Ricardo Giampaoli‏ shared A look back at ODTUG Kscope17

This week on LinkedIn

Andy Jorgensen shared The Future of EPM is upon us

Paper.li

Blogs from www.redstk.com and oaug.org

Videos such as:

and

 

Summer Holiday Reading for OBIEE Fans.

This week we have a great collection of updates – Including a great blog from Stephen Few, and some free stuff from Oracle.

We also see some more tips from the prolific Red Stack team – keep them coming guys!

I hope this week finds you on a beach, refreshing yourselves, and learning new stuff – I have just bought the latest books from Brendan Tierney, so look forward to getting sunburnt while loading more knowledge 🙂

Anyway, enjoy, wherever you are…

Blogs of the week

  1. Hunters Eat Better Than Gatherers

    Phil Goerdt discusses how we can better implement analytic solutions by challenging the convention of requirements gathering.

He says: Don’t “Gather Requirements”. Hunt for Questions.

“My take aways for consumers: Think about what data you need, the data you don’t have and what questions you can’t answer. From there, brainstorm how you can help the data suppliers understand these pain points. An export or data dump is a failing answer in my classroom!

My advice for suppliers: Try to read between the lines and understand what the consumers are really gunning for. Once you understand that, try to find ways to deliver it! “

2. Trial Subscription to Oracle Process Cloud Service

Antonis says, “Oracle has simplified the previously long and complicated process of subscribing to its Cloud Services, making it much simpler and quicker to get access to any of its Cloud Services.”

Go here and click on the Free Trial button.

3. Basta, Big Data: It’s Time to Say Arrivederci

Stephen Few blogs about why he’s had enough of Big Data.

He concludes by saying, “Let’s say “goodbye” to the term Big Data. It doesn’t mean anything in particular and all of the many things that people have used it to mean merely refer to data. Do we really need a new term to promote the importance of evidence-based decision making?”

4. Oracle REST Data Services and Docker

Kris Rice goes through:

  • TL;DR
  • GitHub Project
  • The Build Structure
  • Optional Software
  • Running The Image
  • The build

5. Unpivot

Jonathan Lewis blogs about an interesting observation that appeared recently as a side-channel on a question on the OTN database forum – how does Oracle execute an unpivot()operation. He gives an example of such a query in this blog.

6. BI Publisher 12C: Running reports via the REST API

Paul Cannon writes, “BI Publisher 12c comes with a suite of REST APIs allowing you to manage and run reports via URL calls, primarily to allow you to make automated calls from custom applications. The APIs provide a wide range of functionality from creating reports & templates, updating definitions & xliff translation files to viewing the report definition & sample data, plus of course actually running the report.

In this blog I’ll go through the basics of viewing the report definition and running a report – providing parameters and downloading the report.”

7. What is Oracle Analytics Cloud and why should you care?

Christian Screen asks us to imagine that you don’t have to worry about hosting the necessary infrastructure in terms of servers, software, and storage space, and can concentrate on using the functionality and getting results in an environment that is:

  • Scalable
  • Flexible
  • Comprehensive
  • Secure

The Oracle Analytics Cloud is all the above and much more.

He also links to these white papers

8. nl.OUG Tech Experience 15 June 2017

Daan Bakboord wrote of his experience at nl-OUG Tech Experience which took place in ‘De Rijtuigenloods’.

How to Update the ORDS_PUBLIC_USER Password

Jeff Smith writes, “ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one.

When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER to user HR, and runs the SQL or PL/SQL.

So, now imagine what happens when you let the ORDS_PUBLIC_USER password expire?” Read on for more…

10. Online Index Rebuild Problem in 12C

Neil Chandler blogs, “When building an index in Oracle Enterprise edition using the keyword “ONLINE”, if the index build fails for whatever reason a messy set of extents can get left behind.”

 

This week on Twitter

ODTUG celebrate their 20th birthday!

Red Stack Tech tweeted OBIEE 11G – USING ACTION LINKS IN ANALYSES & DASHBOARDS

Philippe Lions shared the following video:

This week on LinkedIn

Divya Kalro asked, “Does anyone have experience in using Smartview with OBIEE?” Answer her here

Vishal Pathak shared a link to the blog post OBIEE 11G RPD bypass using Private Variable Columns

Dave Moini asked if anyone has an automated process with Oracle R12.1 or R12.2, to please share it with him

Paper.li

Stories from Red Stack Techrittmanmead.com and BI connector

Videos such as:

OBIEE Saved Filters

The beauty of data visualization

#Kscope17

I was stuck in Bermuda last month while everyone had a great time at Kscope17!

So, for me, and everyone else who missed the fun, here are a selection of post event blogs, and some links to the actual content.

Next year I will certianly try to go over for Kscope18 – http://www.kscope18.odtug.com/ which will be held in Orlando, Florida – USA (Hone of Disneyworld!). You can book your room now, for 219 dollars – which is currently GBP169 – per night. The rate is good up to Mya next year, but will the British Pound fall further against the dollar!

 

Slides from some of the talks are available here.

San Antonio Revisited

Joel R Kellman writes about his fourth Kscope (third as a speaker!)

He writes about the Food and Swag, the Sessions and Sharing, The People! and Gratitude.

Kscope17 Exhibit Hall Fun

Kscope17, it’s a wrap

Cameron Lackpour talks about his lack of sleep, dinner, presentations and the people.

Using R for Data Profiling – Michelle Kolbe, Red Pill Analytics

KSCOPE 17 – San Antonio, Texas

Debra Lilley talks about how she loves the community service day, the sessions she delivered and geek game night!

Kscope18 – Call for extracts

Click the link to submit extracts for:

Application Express
Business Intelligence & Reporting
Database
EPM Business Content
Data Warehousing & Big Data
EPM Infrastructure
EPM Data Integration
Essbase
Financial Close
Planning
Data Visualization & Advanced Analytics

Open Source PL/SQL Utility Tools for Oracle

Martin Giffy D’Souza shares his slides

Alexa! How Do You Work with Oracle REST Data Services? – Jonathan Dixon, JMJ Cloud

ODTUG KSCOPE NEWS

ODTUG share the booking link for Kscope18.  You have a matter of days left to catch the Early Early Bird!

The APEX Community & ODTUG Kscope

Joel R Kallman talks about the APEX presence at Kscope17

ODTUG Kscope17 Award Winners Announced

The award winning speakers are listed here!

KScope17: A Newbie’s Perspective

Jazmin Ribeiro shares her experience of Kscope from a newbie’s perspective.  She tells other newbies not to be afarid – you will meet people!!

Kscope17 – a week full of fun and learning

Celvin Kattookaran shares lots of pictures of the event!

ODTUG KSCOPE17: THE FUN NEVER STOPS

Opal A shares a comprehensive recap of the entire week.

Kaleidoscope 17 Half Time report

Kaleidoscope Second Half Report

Two blogs from Ludovic De Paz about this year’s Kscope.

 

Data Visualisation Desktop and Data Visual Analyzer

This week we have a look at some DV blogs

If you would like to trial – and you should – then download free here:http://www.oracle.com/technetwork/middleware/oracle-data-visualization/index.html

By far the best way to learn DV is to watch the Data Viz Daily series from Kevin McGinley. Available on You Tube https://www.youtube.com

1. Adel Naser compares the Two products.

Oracle Data Visualisation Desktop Vs. OBIEE 12C Visual Analyzer

Adel Naser provides a comparison between Oracle Data Visualization Desktop (DVD), and Oracle Visual Analyzer (VA). He names some of the great qualities of DVD as:

  • Stunning rich interactive visuals, 22 visuals including geo mapping capability.
  • Easy to get started with the tool. Upload an excel file with the data to be analyzed and visualized, then start dragging and dropping columns to create your visuals.
  • Take snapshots of visualizations insights that are important to the business.
  • Integration between different data sources into one visual.
  • DVD is free for customers who have visual cloud solutions or an on premise version such as VA.

 

2. Heres a video!

 

3. The 10 Best Data Visualization Articles of 2016 (and Why They Were Awesome)

Evan Sinar says:

“2016 was an astounding year for insightful, informative data visualization articles — here were the top 10 I saw all year (in no particular order), in each case including a representative quote from the piece and a brief note of why it was at the top of my must-read list.” Read the full blog here.

4. Oracle DV – New filtering options in Oracle DVD 12.2.2

OracleBITECH Demo  posts the following video in their blog:

5.  Data Viz Daily playlist

6. Childhood Cancer Research Gets Investment Boost From Oracle

This press release tells how two big data PhD research projects received an investment boost from Oracle. The research projects will be conducted by Western Sydney University’s School of Computing, Engineering and Mathematics.  The studies will look at new ways of using visual analytics across two fields: using visualisation to help better interpret data in the cancer treatment of children; and how the use of virtual and augmented reality can make large scale visual analytics more accessible. Read the full press release for more details.

7. Is Data Visualization A Separate Market Or Just A Feature Of BI Platforms?

Boris Evelson says:

“If what you are looking for includes requirements for data visualization administration, security, data management, version control, collaboration, etc, you really need a BI platform with data visualization capabilities.”

8. DATAVIZ AS MAPS: EUROPE ON THE BRINK

Michael Sandberg shows an example of data visualization as a map from Adam Green.

9. A 6 monthly review of the best of data visualisation

These are named as:

  • The Aftermath of the US Election
  • The Impact of Dear Data
  • Data Sketches
  • Evolution in Action
  • Ship Map
  • Profiling the Parks
  • Jonni Walker
  • Joy Division Charts
  • Map Containers
  • The NYT’s Composite ‘PhotoVizzes’

10. Data Visualization Blogs You Might Not Know About

Nathan Yau shares some of the visualization (and mapping) blogs that he enjoys.

 

 

 

OBIEE 12c Book Published

Finally, our follow up to Oracle Business Intelligence Enterprise Edition 11g: A Hands On Tutorial has been released. The new book is named Oracle Business Intelligence Enterprise Edition 12c – Second Edition.

Co-authored with myself, Christian Screen and Haroun Khan, Oracle Business Intelligence Enterprise 12c – Second Edition is described as “A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight.”

The book covers the following:

Chapter 1:  Oracle BI 12c Architecture

Chapter 2: Installing the Prerequisite Software

Chapter 3:  Installing on Windows Server 2012

Chapter 4: Reviewing the Features of the Reporting Repository

Chapter 5: Installing and Configuring Client Tools

Chapter 6: Understanding the Systems Management Tools

Chapter 7: Developing the BI Server Repository

Chapter 8: Creating Dashboards and Analyses

Chapter 9: Agents and Action Framework

Chapter 10: Developing Reports using BI Publisher

Chapter 11: Usage Tracking

Chapter 12: Improving Performance

Chapter 13: Using the BI Admin Change Management Utilities

Chapter 14: Ancillary Installation Options

Chapter 15: Reporting Databases

Chapter 16: Customizing the style of Dashboards

Chapter 17: Upgrading to 12c

A wide variety of users will find this book valuable. If you are an IT professional, business analyst, project manager, and/or newcomer to Business Intelligence who wish to learn from self-paced professional guidance and actual implementation experience, this book is for you.

OBIEE, You’re soo cool

Auto-correct can be your own worst enema.

Charles Dickens walks into a bar and orders a Martini.
The Barman says: “Olive or Twist?”

Claustrophobic people are at their best when thinking outside the box.

Seriously, have a look out of the window. Its sunny, the economy is doing great, there are lots of OBIEE Jobs in the UK, and our friends at Peak Indicators won the Partner of the Year Award. Life is good. OBIEE is good. You are good at OBIEE (if you read our book)

Smile!

Blogs of the week

1.  Which version was it again?

Phil Goerdt writes, “Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out I was right, but for thoroughness sake, I’ll cover both approaches.”

2. Oracle Management Cloud – Finding the needle in the haystack

Red Stack Tech blogs: “Director of Cloud Strategy, Philip Brown has recently written an article which has been published in the 2017’s first edition of Oracle Scene. In the article, he explores the Oracle Management Cloud Log Analytics service. Phil demonstrates how this service enables you to work across infrastructure and application tiers to provide a better understanding of errors and issues and turn the huge volumes of operational log data into a useful commodity.”

3. OBIEE 11g: Setting multiple values to Presentation variables through goURL and conditional filtering

Vishal says that he is writing this blog after a long gap and it is worth the wait!!

4. SQLcl – Setting Up the Formatter

Jeff Smith says, “Just because you’re in a command line interface doesn’t mean you’re stuck with ugly code!”

5. Getting Started with GoldenGate

Neil Chandler posts a link to his article in Oracle Scene

6. @Oracle 12.2.0.1 Cool new features to improve security. Part 1 Enhanced Whitelists PL/SQL

This blog states, “In Oracle 12.1 the ACCESSIBLE BY clause was introduced to the PL/SQL language. This gives the developer the ability mark a package, procedure, function, or type with what was allowed to call it. 12.2 gives us fine grained control over what can the specific functions and procedures in a package.”

7. Deception

Jonathan Lewis writes, “One of the difficulties with trouble-shooting is that’s it very easy to overlook, or forget to go hunting for, the little details that turn a puzzle into a simple problem.”

8. Integrating with Taleo Enterprise Edition using Integration Cloud Service (ICS)

Mani Krishnan says, “Integration Cloud Service (ICS) provides Oracle SaaS customers with pre-defined to connections to most SaaS subscriptions and zero-code integration features to quickly connect SaaS applications. Oracle Taleo provides talent management functions as Software as a service (SaaS). Taleo often needs to be integrated with other human resource systems.”

9. How Enterprise Manager Detects the Version of Oracle Databases

Gokhan Atil says, “You know that patch numbering has been changed since November 2015, and the new format replaces the numeric 5th digit of the bundle version with a release date in the form “YYMMDD”. Let’s say you applied PSU 160719 to your 11.2.0.4 database, the exact version of your database becomes 11.2.0.4.160799. We also know that PSUs do not change the Oracle release version information that can be queried from v$version (Doc ID 861152.1), so when you query your database, you still see 11.2.0.4.0”

He then goes on to elaborate on this.

10. Head in the Essbase Cloud No. 1 — The Blessed Event

Cameron Lackpour writes, “No, Yr. Hmbl., Fthl., & Obt. Svt. has not suddenly changed sex and really and truly had one of life’s miracles bestowed upon him but instead something almost as great has happened:  Essbase Cloud has launched.” !!

11. My query just got faster – brief introduction to 12.2 in-memory cursor duration temp tables

Keith Laker blogs, “This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2. All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes?
So in this post I am going to focus on the new In-Memory “cursor duration” temporary table feature. Let’s start by looking at cursor duration temp tables.”

12. How to find Oracle DVD log files

Dan Vlamis starts his blog by saying, “Hey, folks, I ran into a DVD error message that referenced a log and thought I would share where I found the log file in case others were wondering this.”

13. Presentations from OUGN17

Brendan Tierney shares some of his slides, including:

and:

This week on Twitter

ODTUG shared OAC Series: Finally Released!

Robin Moffat posted (Still) No Silver Bullets : OBIEE 12c Performance in the Real World

Red Stack Tech shared OBIEE 11G – Using dashboard prompts to view analyses 

This week on LinkedIn

Vishal Pathak shared OBIEE 11G: Setting multiple values to Presentation Variables through goURL and conditional filtering

Paper.li

Stories from  www.itcentralstation.com,  dynasoftusa.com and  snuviktechnologies.com

Videos such as Tableau Analytics for OBIEE using BI Connector

and What is Oracle Analytics Cloud (OAC)?

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