There is also another job available in the USA – Any Takers?
There are hundreds of other jobs too, but these are worth taking a look at.
Message me if you are currently located and eligible to work in the UK or USA.
The Rugby is on now, so not going to add any more, except:
Blogs of the week
Mike Hallett shares a link to download Data Visualisation Desktop (DVD), and also links to this video:
and the Youtube playlist.
There are also lots of links to reading material and documentation.
2. UKOUG Northern Technology Summit
This summit will take place in the North of England in early 2018 (April). Call for papers is now open.
3. OBIA 11g : Analyzing ODI ETL Load Performance – Part 1
Gunaranjan Vasireddy writes, “When you run an ODI ETL Load plan, it takes certain time. At times, customers would like to understand a split of the time taken by the load plan and analyze the top running maps to see if they can be optimized to run faster. In the first part in this series, we help you understand how you can easily analyze the time taken by the load plan and identify the top running maps.”
4. Essential WebLogic Tuning to Run on Docker and Avoid OOM
Andrejus Baranovskis advises us to read his previous post about how to run ADF on Docker firstly and foremost. Then read on in this current blog to how to do the above.
5. Buffer cache hit ratio–blast from the past
Connor McDonald says, “I was perusing some old content during a hard drive “spring clean” the other day, and I found an old gem from way back in 2001. A time when the database community were trying to dispel the myth that all database performance issues could be tracked back to, and solved via, the database buffer cache hit ratio. Thankfully, much of that folklore has now passed into the realm of fiction, but I remember at the time, as a means of showing how silly some of the claims were, I published a routine that would generate any buffer cache hit ratio you desired. It just simply ran a query to burn through logical I/O’s (and burn a whole in your CPU!) until the required number of operations bumped up the buffer cache hit ratio to whatever number you liked Less performance, more work done…. all to get a nice summary number…”
6. Using D3 and OBIEE
7. Problem loading java datasource OBIEE 18.104.22.168
Boris Dahav shares his experience of the above problem.
8. Using Content and Experience Cloud with your Oracle Intelligent Bots chatbot
Dolf Dijkstra says, “In this blog, I will show how you can use the content items from Content and Experience Cloud in your Oracle Intelligent Bots chatbot.”
He goes through:
9. Go Big…
David Fitzjarrell concludes his ‘Go Big’ blog by saying, “Automatic Big Table Caching can be a performance improvement when large tables are the norm rather than the exception. That it’s also a feature that doesn’t require additional licensing makes it all the more desirable to configure and use.”
10. Comparing ODI Scenario versions using SQL
This blog starts off by saying, “The situation that I’m about to describe often happens in large/old ODI projects. Imagine the following: you received a task to change an ODI component that was created one year ago by someone else that is not even in the company anymore. The code is running fine in PROD and the business want a small fix to it. You open the ODI package and it contains a lot of interfaces, procedures, variables, etc. You need to change the code in one single interface, which seems very simple. You change it, save it, generate a new scenario and move it to PROD. When it gets there, the job fails due to an error in another interface that you did not touch! You start to troubleshoot and figure out that someone else changed something in DEV, saved it, but did not move the code to PROD. Unfortunately this ”unwanted” code change was included by you when you generated your scenario and now the mess is already created. If you already passed through this situation, than this post may help you.”
This week on Twitter
Oracle BI Blogs shared OBIA 11g : Analyzing ODI ETL Load Performance – Part 1
OraNA.info posted UKOUG is coming
Gokhan Atil tweeted Oracle Cloud Day Istanbul
Stories from livingthebi.blogspot.com and www.datavail.com
Videos such as
Tableau Analytics for OBIEE using BI Connector
and Mark Hurd Oracle OpenWorld 2017 Keynote Highlights 10-2-2017]]>
I am especially looking forward to Oracle XE 18.
It’s clear to me that the pace of Oracle change is picking up, and that we all need to embrace that change. This month the DBA role was questioned with the introduction of the self updating database. While some may be sceptical about the ability of Oracle to deliver a self maintaining database, if they do deliver then that could free up the DBA for more ‘productive’ activity, such as performance tuning everything, advising on database design and building framework PL/SQL (error traping etc).
This would help the OBIEE developers so they can focus on more content and less tuning activity.
Another thing that would help the OBIEE developer is to remove project management. The biggest drain on a developer’s time are project managers who insist on pointless meetings, task updates, time estimates and thinking that their job is more important than everyone else’s.
It’s time that companies started trusting the developers more. Let people know what the goal is, and let them get on with it. You are only wasting your money and delaying your project by having a project manager.
Blogs of the week
Opal Alapat talks about the main 4 ideas which have been listened to.
1. New Abstract Deadline
2. Expanding opportunities for volunteers
3. Publishing the ODTUG Kscope Session Evaluation Average
4. New Webcast series
Read the rest of the blog for more details of this, and more.
2. Art of BI: The 6 Greatest Data Integrity Business Challenges
Christian Screen writes, “Clean, correct, consistent, reliable information is the holy grail of data-driven organizations, one of the most important assets that a company can have. In order to achieve data integrity, however, you’ll first have to surmount a number of obstacles.
3. POST Up a BLOB to an Oracle Table via REST
Jeff Smith writes, “Scenario: I want to post up a record to be inserted into a table. The record will consist of a couple of regular values, but also a file, which will be stored as a BLOB.Ok, how does this happen?”
4. OBIEE Security Dashboard
Syed Zubair says, “The following are benefits of having a separate security dashboard.
5. Optimize Oracle response times with Cary Millsap using Method R
This blog shares details of a webinar to take place on 26th October. Register
6. BI Cloud Connector – Download Data Extraction Files
Ulrich Janke gives a short introduction to this tool followed by a focus on the file download capabilities of these data extracts. In case of an enhanced interest, he says that in future blog postings, he will discuss other features and functions in more detail.
7. Freeze Column & Headers Plugin
goes through how to do this and then links to a
8. OBIEE 12c – “CSF error” OR “OFM security error” OR “no matching Authentication Protocol”
Debashis Paul says, “So , Nowhere in OBIEE 12c Installation said that, you need to have certain pre-requisite condition in the DB to ensure successful installation and you end up scratching head why you are getting all the nonsense in OBIEE installation logs when everything you did right !
Yes , unfortunately that life with Oracle tool ! (! Sigh ! ) and if you are the one person who hit this error you can try out the option below to fix.”
Read his blog for the fix option!
9. OpenWorld 2017 – Must-See Sessions for Day 1 – Sunday
Keith Laker details his must see sessions.
10. ADF BC REST Service from ADF Library JAR
Andrejus Baranovskis writes, “I had assignment to enable ADF BC REST for existing ADF application, which was developed with multiple ADF libraries. ADF BC REST was supposed to be enabled for one of the ADF libraries and then accessed through Master application. All ADF BC REST samples usually show how to enable REST inside Master application itself. I was curious if it will work to enable ADF BC REST and package it into ADF library, which is consumed from Master application. It worked and I would like to share sample app.”
This week on Twitter
Oracle BI Blogs shared OBIEE 12c in Docker from scratch
Opal A posted Welcome to ODTUG Kscope18!
Becky Wagner tweeted The @ODTUG BI Community is hosting a meetup in London!
Stories from gianniceresa.com and www.us-analytics.com
Videos such as
My book that is, and these blogs…
Blogs of the week
1. Art of BI: What You’re Missing When You Can’t Visualize Your Data Part I
Bill Anderson asks the following questions:
He refers us also to the following white paper.
2. Call for Papers nlOUG Tech Experience 2018
Daan Bakboord shares the Call for Papers information for Tech Experience (closing date 24th December)
3. Using Oracle’s Baseline Validation Tool with OBIEE — Part 1
Michelle Kolbe writes, “This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE).”
She writes about:
4. Help! Where do you go for help with Oracle?
Jeff Smith asks the above question! He is running a week long poll on Twitter.
He also asks, What do you find most valuable when it comes to solving your Oracle Database problems?
Vote on the blog.
5. Watch this video:
Mark Hurd Oracle Openworld 2017 Keynote Highlights
6. Data Blending Made Easy with Oracle Data Visualization
Philippe Lions shares this youtube video:
Go here for your free trial
7. Securing Subject Areas in Oracle Analytics Cloud
Dayne Carley posts about:
8. Question Time
Jonathan Lewis posts about Question Time at the UKOUG Tech conference
This year there are:
If possible, he would like some advance questions, so if you have any, please comment with them on the blog or send him an email (link on the blog).
9. Review of Big Data Warehousing at OpenWorld 2017 – Now Available
Keith Laker’s review is now available – PDF version available here. (Also available for Apple and Linux users).
10. Oh…another language is too hard”
Connor McDonald answers a question from AskTOM a few days ago asking for an implementation of the XIRR function in PL/SQL.
11. Announcing the 2018-2019 ODTUG Board of Directors
The new members are:
who join existing members:
CONGRATULATIONS to all!
This week on Twitter
Connor McDonald tweeted A silent movie on joins
ODTUG posted Oracle Data Viz details
Philippe Lions shared Oracle DV : What’s new in Oracle DV V4.0 Desktop version ?
Stories from www.redstk.com
Videos such as A Look Back at ODTUG #Kscope17 in San Antonio, TX!
Oracle 12c Release 2 – How to do transparent data encryption ONLINE]]>
There are three Main layers, each with it own strata that work in isolation or in association with the other layers.
The main layers (from bottom to top) are:
The Location layer is quite simple, it’s where you expose the web address and it’s how you decide who can see the web page. For example, In a simple development environment you may have your server on a separate subnet, which is only accessible to developers using computers or virtual machines on that network.
Access to web servers can actually be restricted too, maybe behind a firewall, or to a specific set of IP addresses. Windows Kerberos security can be employed to make sure you only allow access to the server from already authenticated people.
Dont forget the simple controls that the location of a server can bring, and please don’t expose your server to the internet directly (Or Christian will hunt you down!)
The Database layer has a wealth of security measures to protect the data.
A brief glance at the Oracle website, oracle /database /security, will show all the layers available in the database – similar options are available on MS SQL server too.
The simple measures not listed are also important to consider, for example the use of Separate Schema to separate your data. You can keep HR records separate from Finance, separate from Sales etc, by placing the data into separate Users, or separate Pluggable databases even! A common database security measure is Virtual private Database (VPD) which is worth examining, although I prefer to keep this sort of security in the application layer to keep it more flexible.
Data masking and data redaction can help to hide the real values, as well as database vault can keep the real data away from unauthorised users – like DBA’s!
The OBIEE Application layer has a mixture of Object Security and Data level security.
Object security is available in all three layers in the RPD and also available in the catalog. The common theme is that the both use users and groups to determine what you can see. The recent change to remove the very handy Catalog groups from the equation is a real shame, but at least Application Roles can do the job nicely, and could be sourced from corporate directories.
It’s worth pointing out that user roles use a hierarchy of permissions, or inheritance if you like. This can get really confusing if Roles are members of other roles, which have conflicting permissions. I prefer to keep a flat hierarchy of roles (i.e. no parent-child relationships) which makes my life simple.
Data level security is applied to the business layer of the RPD. It magically adds a where clause to your queries, nicely hiding some data, and if you design it right, letting you see the big picture.
The trick with data level security is to secure only those dimensions that need securing.
You can also build your own fine grained security, just by making use of object security or just exposing subsets (using content levels or different views in the source).
In the next article in this series we will look into Object security in the Catalog..
Heres what i found today….
Blogs of the week
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:
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 22.214.171.124 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
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]]>
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:
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:
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 126.96.36.199 and, with a script to replay it, I’d found that it had disappeared by 188.8.131.52.Today I had a reason to rediscover the script, and decided to test it against 184.108.40.206 – 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:
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?
Stories from www.datavail.com and www.eventbrite.com
Videos such as:
KISS series on Analytics: 25 The KEEP clause
Multiplication Table Project: Create ERD with Quick SQL]]>
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
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.
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.
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…]]>
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:
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:
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 220.127.116.11 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
Blogs from www.redstk.com and oaug.org
Videos such as:
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
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:
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:
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’.
9 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
Stories from Red Stack Tech, rittmanmead.com and BI connector
Videos such as:
OBIEE Saved Filters
The beauty of data visualization]]>
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:
Business Intelligence & Reporting
EPM Business Content
Data Warehousing & Big Data
EPM Data Integration
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
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.