Bash Script to easily start or stop OBIEE 11G on Linux

On linux, starting OBIEE requires to start

  1. Weblogic Server Admin Server
  2. Weblogic Server Node Manager
  3. Weblogic Managed Server
  4. Oracle Instance

All of the servers have to be running before starting the others. Looking at the log waiting for the running state to know when to start another service is a painful and time consuming task. So I wrote a little script. Laziness is sometimes a good thing :)

All you have to do is to modify the configuration variables section with your own values.

Enjoy !

Review: The Data Warehouse Toolkit; The Complete Guide to Dimensional Modeling

dimensionalmodeling

Last year I bought The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by the Kimball Group. Ralph Kimball is known as the father of dimensional modeling. The guy really knows what he is talking about. If dimensional modeling is NOT something you are familiar with, then this book is for you. If you are familiar with dimensional modeling, you should read it anyway! It shows how to build a good data warehouse by using the best patterns.

Each chapters use a different business area including:

  • Retail sales and e-commerce
  • Inventory management
  • Procurement
  • Order management
  • Customer relationship management (CRM)
  • Human resources management
  • Accounting
  • Financial services
  • Telecommunications and utilities
  • Education
  • Transportation
  • Health care and insurance

It covers almost every situation you can face!

The second edition has been released in April 2002, so it’s a bit old.  Some examples have clearly been written a long time  ago (probably in the first edition) but most of the concepts still apply.

The next book in list is from the same authors: The Data Warehouse Lifecycle Toolkit

Download and setup OBIEE 11G Usage Tracking (11.1.1.7)

Activating USAGE TRACKING with OBIEE 11G (11.1.1.7) is not an easy thing to do. The tutorial provided by Oracle is incomplete and contains a lot of errors. So to make your life easier, you can download a fully compatible Usage Tracking repository for OBIEE 11.1.1.7, the Usage Tracking Catalog and the Installation SQL Script.

  

Quick Notes on these files:

To create the repository, I downloaded one from http://total-bi.com/2011/09/obiee-11g-usage-tracking-rpd/ but I had to tweak it a bit to make it compatible with 11.1.1.7.

  • A new Column (ID VARCHAR(50) NOT NULLABLE) in table S_NQ_ACCT
  • All columns in S_NQ_ACCT are now NULLABLE (except for the colums ID ans CACHE_IND_FLG)
  • Many foreign keys were broken so i recreated it
  • The join in the “Measure” logical table have been rebuilt

The SQL Script is the 4 scripts you have to run on your [prefixed]_BIPLATFORM schema (the one created with the rcu setup) t. I have appended them in the good order and I

  • removed some statements that cause errors (2 drop table on tables that don’t exist)
  • added 1 missing CREATE VIEW.

I found the catalog on my server (OBIEE_HOME/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/sample/usagetracking). This is an archive you can import with the Unarchive feature in Catalog Manager.

  • I had to rewrite the filters of every analysis
  • The first page name “Dashboard” is the only dashboard page provided; I created the others..
  • I wrote a few analysis and added it to the pages I made

I created the new dashboard pages because I don’t like to have just a bunch of links.. I recommend to create your own analysis and add it to a new page like I did.

The last thing to do is to activate Usage Tracking within Oracle Enterprise Manager. You can follow the step by step procedure provided by Oracle at http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html  (section Configuring Usage Tracking in Enterprise Manager)

Hope this help.

References:
http://obiee101.blogspot.ca/2008/08/obiee-setting-up-usage-tracking.html
http://paulcannon-bi.blogspot.ca/2012/11/how-to-install-usage-tracking-in-obiee.html
http://adventuresinobiee.blogspot.ca/2013/02/how-to-enable-usage-tracking-on-obiee.html
http://total-bi.com/2011/09/obiee-11g-usage-tracking-rpd/
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html