BI Publisher - Part 1 - Creating your first Report

In this article, we will create our first report using PS Query and BI Publisher. If you have worked on Crystal reports, you will notice that there are some similarities between Crystal reports and BI Publisher reports. In crystal reports you use a query as data source and create a layout (template) using Crystal Reports application. Here we will use query as the data source and create a template using BI Publisher Desktop. The example has been created and tested on the following software environment:    Peoplesoft Application: FSCM 9.2    Peoplesoft Peopletools: 8.53.02    Peoplesoft Virtual Machine Image id: FSCMDB-85308-PI004    Database: Oracle 11.2.0    MS Office Professional 2010 32-bit We will be logged in as VP1 so we do not have to spend too much time in security. The major sections will be: 1) Setting up BI Publisher on your desktop. 2) Assigning BI Publisher Permissions to Users. 3) Creating a PS Query for using as a data source. 4) Creating BI Publisher template us