Business Intelligence

With BusinessObjects Web Intelligence it is relatively straight forward to create a pie chart. Often the data you are working with will create a pie chart that displays hundreds of unique slices, many of which are so small that you can’t see them. How do you go about combining these smaller pie slices into an “Other” category? Consider a BusinessObjects Web Intelligence Document with the following data in a Block Turning this data into a pie chart will display 19 unique slices....

The process to install MySQL on Mac OS X is a pretty straight forward process. MySQL is one of the most popular open source databases. It is used in a wide variety of applications. Download MySQL Installer First you will need to download the DMG archive from http://dev.mysql.com/downloads/mysql/ Install MySQL from the downloaded DMG archive as you would normally a typical application. Additional Configuration For maximum compatibility you should create a symbolic link to where MySQL places the socket....

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 SQLite. SQLite is an excellent lightweight database that is extremely fast and a great tool for a data analyst....

If the goal of your business intelligence project is to deliver a dashboard, you should have warning bells going off in your head. What is a Dashboard An easy to read graphical presentation of the current status and historical trends of an organization’s key performance indicators (KPIs) to enable instantaneous and informed decisions to be made at a glance. Business Processes and KPIs The key performance indicators (KPIs) of your dashboard will result from multiple business processes....

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 to create a security table and add it to your universe data foundation. The security table has 2 fields:...