Over the last few months we have been looking at User Engagement and recently asked people take part in a global usage survey so we could create a series of benchmark metrics detailing how organisations used OBIEE.
We had a great response and have started to process the data. One of the first things that struck us was that the average user logs into their OBIEE system about once per week.
We derive the (more...)
One of the sessions I’m delivering at the upcoming Oracle Openworld 2015 in San Francisco is entitled “Oracle Business Intelligence Cloud Service—Moving Your Complete BI Platform to the Cloud [UGF4906]”, and looks at how you can now migrate your entire OBIEE11g platform into Oracle Public Cloud including data warehouse and data integration routines. Using Oracle BI Cloud Services’ new on-premise RPD upload feature you can upload an existing RPD into BICS and run it from there, (more...)
A little-known new feature of OBIEE 11g is a web service interface to the BI Server. Called the “BI Server Metadata Web Service” it gives a route into making calls into the BI Server using SOAP-based web services calls. Why is this useful? Because it means you can make any call to the BI Server (such as SAPurgeAllCache) from any machine without needing to install any OBIEE-related artefacts such as nqcmd, JDBC (more...)
I wrote recently about the OBIEE BI Server Cache and how useful it can be, but how important it is to manage it properly, both in the purging of stale data and seeding of new. In this article I want to show how to walk-the-walk and not just talk-the-talk (WAT? But you’re a consultant?!). ODI is the premier data integration tool on the market and one that we are great fans of (more...)
The OBIEE BI Server cache can be one of the most effective ways of improving response times of OBIEE dashboards. By using data already in the cache it reduces load on the database, the network, and the BI Server.
Should you be using it? I always describe it as the “icing on the cake” – it’s not a fix for a badly-designed OBIEE system, but it does make a lot of sense to use once (more...)
At the beginning of the year, I wrote a couple of posts about Oracle Enterprise Metadata Management, one about how to install the tool and another one explaining the harvesting (importing) and stitching (relating) processes. A lot of things have happened since then, including a new version of OEMM released on May with some nice features as HTML 5 support, a workflow for business glossary and including the concept of groups in security.
OEMM is the (more...)
The hourly rate in any consulting business or practice increases by the years of experience in the field.
Read more at: http://www.infocaptor.com/dashboard/us-consumer-law-attorney-rates
One of our current client projects uses Cloudera Impala to provide fast ad-hoc querying to the data we’re loading into their Oracle Big Data Appliance Hadoop environment. Impala bypasses MapReduce to provide faster queries than Hive, but to do so it does a lot of processing in-memory and runs server processes on each node in the cluster, leading in some cases to runaway queries blocking other workloads in the same way that OBIEE queries on (more...)
Bigfoot and UFO remain elusive but know their ways to make news from time to time.
Read more at: http://www.infocaptor.com/dashboard/bigfoot-vs-ufo-analytics
Our next BA & Big Data SIG will be on Thursday 24th September. This event will be held in Jurys Inn, Customs House, in Dublin.
It is the ideal opportunity for you to learn, share and network with other users.
Here is the agenda for this full day event.
As you can see this a really good agenda. So I hope to see you there.
You need to book your place for this SIG. To (more...)
The new Oracle Big Data Discovery 1.1 release went GA a couple of weeks ago, and came with a bunch of features that addressed show-stoppers in the original 1.0 release; the ability to refresh and reload datasets from Hive, compatibility with Cloudera CDH and Hortonworks HDP Hadoop platforms, Kerberos integration, and the ability to bring in datasets from remote JDBC datasources. If you’re new to Big Data Discovery I covered the initial release (more...)
La semana pasada y en el contexto del OTN Tour LA 2015 dimos nuestros primeros cursos en Español en Quito, Ecuador y Cali, Colombia.
Se trató de un workshop en este caso de un día (8 horas) sobre Desarrollo Front-End de OBIEE 11g.
En esta oportunidad los cursos fueron presenciales, dónde todo el material teórico-práctico era en español y cada alumno tenía a su disposición durante el entrenamiento una máquina virtual exclusiva donde realizar la (more...)
It’s that time of year again for the UKOUG Partner of the Year Awards. This year we have been nominated for 4 awards:
- Engineered Systems Partner of the Year Award
- Business Analytics Partner of the Year Award
- Training Partner of the Year Award
- Emerging Partner of the Year Award
The awards are decided by “end users of Oracle-related products or services” i.e. you, so we would like to ask you to vote for us (more...)
Oracle Open World is coming at the end of October. Lots of people are starting to get excited as Oracle Open World is the number one place for all the Oracle geeks from around the World to hang out for a week.
This year I will be giving 2 presentations. Both of them are on the Sunday. That means I get to really enjoy the rest of the conference. These presentations are:
Sunday 13:30-14:15 & (more...)
Olive Garden is one of the favorite destination for Italian food and today we got hold of the entire Olive Garden menu along with their nutrition data.
A typical meal at Olive Garden starts with a drink, appetizers [free bread sticks], main dish and finally the desert.
So going in the same sequence let see what the data menu for Wine and Beer has to offer.
Amount of Carbs per serving in your favorite Wine (more...)
If we look into the SEC data for Microsoft and other tech companies, Microsoft spends the most in Research and Development from [by dollar]
Read more at: http://www.infocaptor.com/dashboard/list-of-acquisitions-by-microsoft-a-data-journey
This is mainly a note to myself to save me from looking up the details very time I need it. I can just go to my own post.
To use Autotrace in SQL you need to grant the schema the PLUSTRACE role.
But in SQL Developer you need the PLUSTRACE role that has a few additional privileges.
Connect to SYS as sysdba and run the following.
grant select on v_$session to plustrace;
grant select on (more...)