DrillDown and Queries

When drilling down from a ledger-based report, you can use predefined queries (built into PeopleSoft Query) in the following ways:

• Use a matrix DrillDown layout that specifies query, rather than ledger, criteria.

  This provides a matrix report that accesses tables other than ledgers, but inherits all the field criteria (business unit, account, and so on) from the parent report.

• Drill down to a tabular layout, inheriting the field criteria from the parent report.

  This is useful for seeing the details of transaction data, such as journals and voucher lines.

• Drill down to a query without a layout.

  The query inherits the criteria and runs to Excel in QueryLink mode.

When drilling down from a query-based report, you can use another query in a matrix layout, in a tabular layout, or without a layout. The query you use must be capable of inheriting the criteria from the cell you are drilling down from.

In any case, PS/nVision bends the rules of inheritance slightly to enable you to see the needed data. The ledger construct (which implies a special query against a specific type of table defined in PeopleSoft General Ledger) is replaced by the query specification. The implied field criteria for the inherited ledger (for example, LEDGER = ACTUALS) may or may not be inherited. While drilling down to journals within the PeopleSoft General Ledger application requires criteria for the LEDGER field (because journals may exist for various ledgers), drilling down to Accounts Payable voucher data only makes sense from the Actuals ledger, and the voucher tables do not include the LEDGER field. PS/nVision thus looks at the records being queried and includes criteria for the Ledger field only if it is present.