Active directory configuration in OBIEE 11.1.1.7


We will learn about configuring Active Directory (AD) for OBIEE 11.1.1.7 today.

We will create a new security realm and configure the default authenticator as well as the AD authenticator. Configuring 2 authentication providers will ensure that users such as weblogic continue to function (since they will be authenticated by the default authenticator) and users from the AD are also able to login (authenticated by the AD authentication provider). We will mark (more...)

Holiday Sales by category

Image

Fresh and Frozen Fruit consumption – U.S. Bureau of Labor Statistics

The south and the West consume highest amount of Fruits.

Image

Here is more individual breakdown by Quarterly expenditure on Fruits (figures in 100 million)

Image

Image

Image

Visualization on How the undergraduate tuition has increased over the years

Average undergraduate tuition and fees and room and board rates

Source: http://nces.ed.gov/

Image

These figures are inflation adjusted and look how just the tuition fees have increased compared to the Dorm and Board rates

Now comparing the rate increase for 2-year program

Image

So for the 2 year program, the board rates have remained at the same level compared to the dorm rates.

Now check out the interesting graph for 4 year program below

Image

 

(more...)

OUG Ireland 2015 : Now open for Submissions

OUG Ireland Call for submissions is now open.

The closing date for submissions is 5th January, 2015.

and the submission webpage can be found here.

Ougire15 hp cfp v2

The OUG Ireland conference will be on Thursday 19th March. Yes it is only a one day conference :-( but we will be 5 or 6 or more streams. So there will be something for everyone and plenty of choice.

On Friday 20th March we will have Maria Colgan, formally (more...)

Approximate Count Distinct (12.1.0.2 new feature)

With the release of the Oracle Database 12.1.0.2 there was a number of new features and options. Most of the publicity has been around the in-Memory option. But there was lots of other features for the DBA and a few for the developer.

One of the new SQL functions is the APPROX_COUNT_DISTINCT(). This function is different to the tradition count distinct, COUNT(DISTINCT expression), in that is performs an approximate count distinct. (more...)

ODMr : Graph Node: Zooming in on Graphs

When Oracle Data Miner (ODMr) 4.0 (which is part of SQL Developer) came out back in late 2013 there was a number of new features added to the tool. One of these was a Graph node that allows us to create various graphs and charts that include Line, Scatter, Bar, Histogram and Box plot.

I've been using this node recently to produce graphs and particularly scatter plots. I've been using the scatter plots to (more...)

50 years of killing Deer – Data visualization and analysis

Virginia maintains the summary of Deer kills way back from 1947

The stack bar gives a total view of the killings and how it has grown over the years

Image

 

By comparing the killings on a line chart we see that the female Deer killings has an uptick from 2008 onwards

Image

USA War Casualties

iCasualties.org maintains documented list of all fatalities for Iraq and Afghanistan wars.

Analysing the USA dataset, we summarize the results by the year

 

Image

USA war fatalities by year

We are approaching the levels of 2002 and hope for the best that we don’t have to suffer another wars.

Here is another view by year and month

 

 

The dataset contains the age of each (more...)

Something new in 12c: FETCH FIRST x ROWS

In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query.

See the bottom of this post for the background and some of the reasons for this post.

Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we (more...)

github DMCA takedown notices in the rise!

GitHub maintains a list of all DMCA takedown notices along with counteractions and retractions if any.

Analysing all the notices from 2011, it seems that the takedown notices are on the rise.

Year View : Notice the sharp increase in 2014

Image

 

Quarterly view : Now looking at the quarterly breakup, seems like the takedowns are cooling off in the later quarters.

Image

 

So who is issuing these DMCA takedowns?

Here is the complete list (more...)

Fastest growing and rapidly declining job industry

Data source : http://www.bls.gov/emp/tables.htm#occtables

 

Fastest growing job industry

Image

Original Visualization

Most rapidly declining job industry

Image

Rapidly declining jobs link

ShareThis

Facts and Dimensions – a Perfect Couple

With Oracle BI EE (OBIEE) you are able to report against various different data models. There are several different interesting blogposts to prove that. Let me Google that for you; Transactional Schemas, Data Vault. In the end the Business Model and Mapping Layer (Logical Layer) ‘needs’ a Star Schema to construct the model we can report upon.…Read more Facts and Dimensions – a Perfect Couple

Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Last week Oracle released a Statement of Direction (SOD) for Oracle Business Intelligence Analytics (OBIA). The message from Oracle to their Customers is clear; Move away from OBIA 7.9.6.x and move to OBIA 11g, either in the Cloud or On Premise. Let us have a look what the actual message is. Find below a picture would find in a…Read more Statement of Direction for Oracle Business Intelligence Analytics (OBIA)

Where is the online Oracle BI SampleApp V406?

For those of you who are familiar with the Oracle BI SampleApp V406, it might not be a secret. The online version has been offline since a couple of weeks / months. This due to the fact that the online SampleApp has to comply with Oracle Security Rules. @rmoff @Nephentur Public urls to OBIEE SampleApp…Read more Where is the online Oracle BI SampleApp V406?

Top 100 analytics companies ranked and scored by Mattermark

Let us move on from Grass Eating Sauropods and talk about who’s who in the analytic space.

For every dime there are dozen analytic companies. Everybody who provides a freaking dashboard is an analytic company. Anybody that merely mentions Google, Facebook, Hadoop etc in the same sentence is somehow into BigData. Haven’t you stumbled across company pages where they claim to be expert in analytics and big data but they want you to schedule a (more...)

Y Combinator companies has more funding than the sum total of all remaining accelerators

After finishing our call with Bed Bugs , we decided to check out what the startup scene looks like. We used the data from seed-db to let our analytical juices flowing.

First we asked what is the top most program (duh!!) but by how much and who are next in the list and so on.

Like most Data scientists who believe in the power of simple bar graphs we used our first “chart (more...)

Bed bugs in Boston – Analysis of Boston 311 public dataset

Digging into the Boston public Dataset can reveal interesting and juicy facts.

Even though there is nothing juicy about Bed bugs but the data about Boston open cases for Bed bugs is quite interesting and worth looking at.

We uploaded the entire 50 mb data dump which is around 500K rows into the Data Visualizer and filtered the category for Bed Bugs. Splitting the date into its date hierarchy components we then plotted the month (more...)

Are you ready for Windows 10? Dodeca Is Ready!

Microsoft recently released it first preview version of their next desktop operating system, Windows 10. In our business, we have seen many large companies just migrate to Windows 7 and the general consensus seems to be that Windows 8 is a 'consumer' operating system. In other words, it will be a while before you have to think about Windows 10, but it is our business to be thinking about this now. We have the Windows (more...)

Kscope15 Abstract deadline is Wednesday, October 15!

Kscope15 abstract submission will close in just a few days and the ODTUG content teams want you!

I am sure there are many of you who have never done a presentation at a conference and may not feel comfortable speaking in public. Well, I have a secret for you, despite the fact that I won the Best Speaker Award at Kscope14, I share your discomfort with speaking. What works for me, however, is that I (more...)