SQLite for Data Analysis

Before I started using a Mac as my main computer, I would often find myself using Microsoft Access to do some data analysis for a one-off project. Now that I'm using a Mac, I needed to find a tool to do what I used to do with Microsoft Access. In my search I came across …

Continue reading SQLite for Data Analysis

Business Objects

Business Objects Universe Row Level Security

If you are a business objects universe designer that needs to implement row level security in your universe, here is a simple method. The following are the steps necessary when using the business objects information design tool. Similar steps can be done in the legacy universe designer tool. Create security table The first step is …

Continue reading Business Objects Universe Row Level Security


Flattening PeopleSoft Summer Tree

If you need to denormalize or flatten PeopleSoft summer trees (trees with leaves) in your data warehouse, here is an ETL process for you to follow. Typical PeopleSoft summer tree structure SQL to flatten the PeopleSoft summer tree Substitute TREE_NAME with the name(s) of your summer tree(s) on line 54 below. Result of the SQL …

Continue reading Flattening PeopleSoft Summer Tree

Business Intelligence Data Warehousing

Oracle Disable Indexes and Constraints During Insert

If you are attempting to insert millions of rows into an oracle database, you may want to temporarily disable indexes and constraints to improve the speed of the load. Here are 5 steps to follow that will disable constraints and make indexes unusable. You need to substitute the OWNER and TABLE on line 5 and …

Continue reading Oracle Disable Indexes and Constraints During Insert