Mario Talavera Writes

- My Development Journal

Archive for the ‘Data Warehousing’ Category

Installing Oracle DB 12c in Linux OEL6 (In One Sitting)

leave a comment »

Because I will have to do this again in no time, here I jot down the quickest way for me to install 12c.  This is the usual series of following steps, running into an error, searching for a fix, lather, rinse repeat.

Step One – Install oracle-rdbms-server-12cR1-preinstall.

Source – http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html.

Step Two – …gets us all the way here – [FATAL] PRVF-0002 : Could not retrieve local nodename

Source -  http://www.krenger.ch/blog/fatal-prvf-0002-could-not-retrieve-local-nodename/

Step Three -  … cannot write oradata change to /home/oracle/oradata

Source – http://blog.ronnyegner-consulting.de/2009/09/14/oracle-11g-release-2-install-guide-%E2%80%93-grid-infrastructure-installation/

Step Four – Swapfile … I used 10000

Source – https://community.oracle.com/thread/2189824?tstart=0

image

Step Five – Then I see installer is bent on putting oradata directory in /home.  Just revise to suit your install.

Image(1)

Presto!

Image(2)

Written by mariotalavera

April 30, 2014 at 8:10 pm

Posted in Data Warehousing, SQL

OBIEE Reporting From Transactional Databases

leave a comment »

This blog post is about OBIEE reporting.  Specifically, it is about skipping the data warehouse and reporting from the transactional database instead.  Oracle’s OBIEE, like most BI reporting tools, is designed to use star/snowflake schemas as the underlying structures to report from.   Additionally, OBIEE’s metadata layer is very rich and extensively well thought out, allowing for a great deal of flexibility.  Oracle’s metadata tool (Admin Tool) allows us to leverage this flexibility and features to bridge the gap between an OLTP and an OLAP model.  I am not negating the need for a data warehouse, I am just wondering if all BI reporting projects merit one.

So the question to ask is: Is OBIEE up to the task?

Read the rest of this entry »

Written by mariotalavera

June 4, 2013 at 7:12 am

Flex OLAP Cube – updated

leave a comment »

I’ve added ability to consume URLs whose output is XML as a data-source for Flex OLAP Cube. Check it out :)

Going thru this exercise has helped me understand a bit about creating data cubes and the uses they serve. This is but one of the many interesting (to me) things I am exposed to at work. Doing this from scratch provides me with insight unattainable with a ‘shrink-wrap’ tool.

Note – I had originally fetched data from accross the web but had to store xml files internally for show and tell. Enjoy.

Written by mariotalavera

September 30, 2010 at 2:31 am

Movielens OLAP Cube Slicing And Dicing On Demand

leave a comment »

I wanted to write the post ‘Slicing Your Own OLAP Cube’ but I am not there yet. From my last post, a recurring theme in my friends comments was that the dimensions and measures that can be inspected where set in stone. I thought I was doing fairly well but I can see their point. Having a cube and having it sliced in a way you don’t need is kinda useless.

Read the rest of this entry »

Written by mariotalavera

September 28, 2010 at 12:17 am

Movielens – Movie Ratings Analysis with OLAP Cubes

with one comment

For this post, I will describe how to use the previously provided database to create data cubes from the Movielens Dataset.  With these cubes, I will then create a few reports using Adobe Flex to illustrate the advantages of using data cubes for reporting instead of the more traditional ‘query and report’ practices from live databases, etc.

Read the rest of this entry »

Written by mariotalavera

August 23, 2010 at 4:25 pm

Movielens OLAP – Database Download – updated

leave a comment »

UPDATE -
1. I have broken down mysql dump file to a set of individual files per table. I got some complaints on unreasonable file size.
2. I’ve now included 10 million movie ratings as well which I hadn’t because of size as well. Now its a file to itself and you can skip if you find it difficult to import.

I’ve finally gotten around to posting the database online to share. This olap database is a star schema of movie ratings and movie topic tags as described on previous posts (here and here).

The set can be downloaded from Infochimps here. I will post any updates there as well.

Written by mariotalavera

August 16, 2010 at 11:33 am

Real Time Dashboards 3 – Backend

leave a comment »

For a quick refresh, just go back to the intro post where we state what we intend to do.

Or do this instead and get up to speed faster.  All components are linked to for if you do not have the software we’re using…

Read the rest of this entry »

Written by mariotalavera

May 26, 2010 at 2:53 am

Follow

Get every new post delivered to your Inbox.

Join 58 other followers

%d bloggers like this: