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
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! “
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.
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?”
Kris Rice goes through:
- GitHub Project
- The Build Structure
- Optional Software
- Running The Image
- The build
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.
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.”
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:
The Oracle Analytics Cloud is all the above and much more.
He also links to these white papers
Daan Bakboord wrote of his experience at nl-OUG Tech Experience which took place in ‘De Rijtuigenloods’.
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…
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.”
ODTUG celebrate their 20th birthday!
Red Stack Tech tweeted OBIEE 11G – USING ACTION LINKS IN ANALYSES & DASHBOARDS
Philippe Lions shared the following video:
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
Videos such as:
OBIEE Saved Filters
The beauty of data visualization