BI Publisher - Part 2 - Using Connected Queries

This article is in continuation of a previous article "BI Publisher - Part 1 – Creating First Report using Query ". Here we will create a connected query and use as a data source for a BI Publisher Report. We will also cover some Advanced Report features. Since we covered steps involved in creating a Query and our first BI Publisher report in previous article, we will not go into all the details already covered, including setup and installation. It is assumed that BI Publisher Desktop is correctly installed on your desktop. So it is important that you go through Part 1 if you are new to BI Publisher.   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 We will be logged in as VP1 so we do not have to worry about security administration. The major steps wi