Creating a workcenter in peoplesoft is a pretty easy process. In this post I will teach you a step by step process on how to configure a workcenter in peoplesoft. I completed these steps using PeopleSoft Financials 9.2 with PeopleTools 8.55.15. 1. Configure Navigation Collection PeopleTools > Portal > Portal Utilities > Navigation Collections Click Add Collection …
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 …
Continue reading BusinessObjects Web Intelligence: Combine Small Pie Chart Slices into Other
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 …
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 …
A dimension table is one of the 2 primary building blocks of a dimensional data model. The other primary type of table is the fact table. This post will describe 7 best practices for designing a dimension table. What is the purpose of a Dimension Table A dimension table is the primary way to filter …
John Levandowski 