This blog talks about a hassle free mechanism of OBIEE security implementation with almost zero overhead.
We will first look at the data level security implementation and then extend it to object level security.Data Level Security:
Data level security is usually implemented using database tables. These tables store the users and the filter (more...)
Spark is an open source Apache project that provides a framework for multi stage in-memory analytics. Spark is based on the Hadoop platform and can interface with Cassandra OpenStack Swift, Amazon S3, Kudu and HDFS. Spark comes with a suite of analytic and machine learning algorithm allowing you to perform a wide variety of analytics on you distribute Hadoop platform. This allows you to generate data insights, data enrichment and data aggregations for storage on (more...)
The following is the fifth and final set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
The following examples illustrate how you can use the Oracle R Enterprise capabilities within SQL and PL/SQL. The following illustrate building a GLM (more...)
The following notes and documents are for the BIWA Summit 2016 attendees who are taking the HOL on using ODM using SQL and PL/SQL.
Getting connected to the Cloud
The following document outlines the steps you need to perform to get connected to the Cloud Database we are using.
If you have attended the HOL (yesterday) then you can reuse the same connection details (and number).
If you didn't attend the HOL yesterday then you (more...)
The annual BIWA Summit 2016 will be next week from the 26-28 January, and it is back in Oracle HQ at Redwood Shores. If you are into the Oracle Database, Business Intelligence, Big Data, Advanced Analytics, etc then this is the conference for you.
Over the 3 days there is an action packed agenda of 5 parallel tracks, plus a full 3 days of Hands-on Labs. The agenda is filled with the whos-who of the (more...)
Een keer in het jaar sta ik samen met Eric van ‘t Zelfde op een hockeyveld in Schiedam. Wij maken beiden deel uit van een illuster gezelschap; Semper Stultior ’96. Elk laatste weekend van augustus komen wij samen om te strijden om de Japie Cup. Naast het feit dat we een hoop lol maken biedt dit ons de…Read more Het bestaande hoeft zich nooit te verdedigen en het nieuwe moet zich constant verantwoorden.
In the last week or so, we placed an updated version of the Next Generation Outline Extractor on our website. This version provides support for some updated Essbase versions, including 18.104.22.168.002, 22.214.171.124.003, and 126.96.36.199.005. More importantly, it addresses a bug where alias names were improperly associated with parent members when using the MaxL extraction source.. This bug was reported to us by a (more...)
This Business Intelligence article discusses one very important question “Have we lost the true meaning and purpose of Business Intelligence?”
In summary, it says that the bottom line for any Business Intelligence is to increase profit and performance and if done wrong it is absolute waste of time and money.
So if your management is hooked on the Big-Data wagon and fantasizing about the hidden gold behind the untapped data sources such as social (more...)
Ever wondered, how may startups or companies did Google acquire so far and how much did it pay for them?
But the main question is, what happened to the acquired companies? Was it all waste of money?
With the recent re-structuring, Google became a subsidiary of Alphabet Inc., which now owns most of the parts.
Using infocaptor kpi dashboard software, we analyze the list of companies, products and services that Google has acquired (more...)
In this analysis, we will visualize the relation between the Age at Presidency, State of Birth and birth sign.
Read more at: www.infocaptor.com/dashboard/presidents-of-usa-and-their-birth-signs-sankey-visualization
One of the features of Dodeca is read-write functionality to SQL databases. We often get questions as to how to write data back to a relational database, so I thought I would post a quick blog entry for our customers to reference.
This example will use a simple table structure in SQL Server though the concepts are the same when using Oracle, DB2, and most other relational databases. The example will use a simple Dodeca (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
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
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
If number of searches were an indicator for gauging the popularity of a drink between Tea, Coffee, Beer and Wine then who wins the contest?
Which drink is gaining popularity and which is losing?
Read more at: http://www.infocaptor.com/dashboard/popularity-of-tea-coffee-beer-and-wine-visualization
Recently while working with a customer we ran into an interesting situation concerning file compression and processing time. For a system like Hadoop, file compression has been always a good way to save on space, especially when Hadoop replicates the data multiple times.
All Hadoop compression algorithms exhibit a space/time trade-off: faster compression and decompression speeds usually come at the expense of space savings. For more details about how compression is used, see https://documentation.altiscale. (more...)