Select Page

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...

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...

Some useful SQL Scripts

The SQL scripts have been created and tested on the following software environment.   Peoplesoft Application: Financial and Supply Chain Management 9.2   Database: Oracle The SQL scripts have been grouped in the following categories.   Components, Component-Interfaces...

Application Engine – Part 3 – Tracing and TraceMagic

In this article we will discuss tracing Application Engine with an example. We will also see a utility called TraceMagic to interpret the trace results in a neat manner. This part of the Application Engine article is in continuation for Part-I in the series of...

Application Engine – Part 2 – Debugging

In this article we will discuss Debugging Application Engine with an example. This part of the Application Engine article is in continuation for Part-I in the series of Application Engine articles posted on my blog. We will use the Application Engine AJ_AE_SAMPLE that...

Application Engine – Part 1 – Development & Execution

We will develop a simple Application Engine program covering Sections, Steps, Actions, State records, Meta-SQLs, etc. in their simple forms using this example. We will discuss four ways to execute an Application Engine as well. Once you have the basic idea, you will...