Understanding Ledger-Based Matrix Layouts

A ledger is a special type of query in PS/nVision, with an implied aggregate operation (sum) and record and field names specified through the ledger definition. In PS/nVision, a ledger-based layout is essentially a matrix layout that uses the ledger table in place of a query. Typically, you use ledger-based layouts with applications such as PeopleSoft General Ledger or Enterprise Performance Management. Although you can use ledgers and queries in the same report, ledger and query specifications are mutually exclusive for a row or column, because a row, column, or cell can have only one data source.

These topics discuss the differences between ledger-based layouts and reports and query-based matrix layouts.