Delivered Report Content for the Financials Warehouse
This chapter discusses the delivered Discoverer reports for the Financials Warehouse.
Delivered Report Content for the Financials Warehouse
PeopleSoft delivers the Financials Warehouse Discover reports with the Discoverer End User Layer (EUL). Reports are built on worksheets and grouped into workbooks. This chapter provides detailed information about the Discoverer reports delivered with the Financials Warehouse, listed by subject area.
The PeopleSoft Financials Warehouse Discoverer Workbooks group reports by the following subject areas:
Advanced Cost Accounting
Accounts Payable
Accounts Receivable
Enterprise Service Automation
Global Consolidation
General Ledger
Real Estate
PeopleSoft assumes that you are familiar with Discoverer and understand how to use this business intelligence reporting tool.
See Oracle Business Intelligence Discoverer Plus User's Guide
See Understanding Report Content.
Advanced Cost Accounting Delivered Discoverer Reports
PeopleSoft provides the following Advanced Cost Accounting Discoverer reports:
Direct Cost Analysis by Product
Customer Activity Costs as a Percentage of Revenue
Customer Profitability Overview
Product Profitability Overview
Direct Cost Analysis by Product Report
The Direct Cost Analysis by Product report is based on the Activity and Cost Analysis business area. This report shows the relationship of direct costs of an enterprise by product.
With this report you can answer business questions such as “What is the direct material as a percentage to direct cost?” and “How much is the direct costs by ledger?’
This section discusses the data element within the Direct Cost Analysis by Product report.
Direct Cost Analysis by Product Report Content
This table lists the content in the Direct Cost Analysis by Product report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Inventory Item ID |
Attribute |
Dimension Item.Item ID |
|
|
Ledger ID |
Attribute |
Dimension Ledger.Ledger ID |
|
|
Top X Products |
Calculated Attribute |
RANK() OVER(PARTITION BY "Activities and Cost Analysis".Inventory Item ID ORDER BY "Activities and Cost Analysis".Direct Costs DESC ) |
|
|
Direct Costs |
Metric |
CASE WHEN "Activities and Cost Analysis".Level4 Object = '6000' THEN SUM("Activities and Cost Analysis".Net Balance Transaction Amount) ELSE 1 END |
|
|
Direct Labor as a Percentage of Direct Costs |
Metric |
"Activities and Cost Analysis".Direct Labor/"Activities and Cost Analysis".Direct Costs |
|
|
Direct Machinery as a Percentage of Direct Costs |
Metric |
"Activities and Cost Analysis".Direct Machinery/"Activities and Cost Analysis".Direct Costs |
|
|
Direct Materials as a Percentage of Direct Costs |
Metric |
"Activities and Cost Analysis".Direct Material/"Activities and Cost Analysis".Direct Costs |
Filter Elements
This table lists the filter elements in the Direct Cost Analysis by Product report:
|
Name |
Type |
Definition |
|
Top X Number of Products |
Prompt |
Qualifies for X number of top products for the Direct Cost Analysis by Product report. |
|
View ID |
Prompt |
Qualifies for the item by view IDs for the Direct Cost Analysis by Product report. |
|
Fiscal Period |
Prompt |
Selects the fiscal period for the Direct Cost Analysis by Product report. |
Additional Features
This section describes the additional analysis features in the Direct Cost Analysis by Product report:
Page-by on Ledger ID.
Customer Activity Costs as a Percentage of Revenue Report
The Customer Activity Costs as a Percentage of Revenue report is based on the Activity and Cost Analysis business area.
With this report you can answer business questions such as “What are the total activities as a percentage of revenue?” and “What is the activity costs information for the top ‘X’ customers?”
This section discusses the elements in the Customer Activity Costs as a Percentage of Revenue report.
Report Content
This table lists the content in the Customer Activity Costs as a Percentage of Revenue report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Customer ID |
Attribute |
Dimension Customer.Customer ID |
|
|
Ledger ID |
Attribute |
Dimension Ledger.Ledger ID |
|
|
Top X Customers |
Calculated Attribute |
RANK() OVER(PARTITION BY "Activities and Cost Analysis".Customer Id ORDER BY "Activities and Cost Analysis".Gross Revenue DESC ) |
|
|
Total Activities Cost |
Metric |
SUM(CASE WHEN "Activities and Cost Analysis".Activity Id IN ('10010','10020','10030','1000','10050','10060','10070') THEN "Activities and Cost Analysis".Net Balance Transaction Amount ELSE 0 END) |
|
|
Total Activities as a Percentage of Revenue |
Metric |
"Activities and Cost Analysis".Total Activities Cost/"Activities and Cost Analysis".Gross Revenue |
Filter Elements
This table lists the filter elements in the Customer Activity Costs as a Percentage of Revenue report:
|
Name |
Type |
Definition |
|
Top X Number of Customers |
Prompt |
Qualifies for X number of top customers for the Customer Activity Costs as a Percentage of Revenue report. |
|
View ID |
Prompt |
Qualifies for the item by View IDs for the Customer Activity Costs as a Percentage of Revenue report. |
|
Fiscal Period |
Prompt |
Selects the fiscal period for the Customer Activity Costs as a Percentage of Revenue report. |
Additional Features
This section describes the additional analysis features in the Customer Activity Costs as a Percentage of Revenue report:
Page-by on Ledger ID
Customer Profitability Overview Report
The Customer Profitability Overview report is based on the Customer Profitability Analysis business area.
With this report you can answer business questions such as:
“What is the profitability for the top customers?”
“What is the net balance and percentage of revenue by customers?”
This section discusses the elements in the Customer Profitability Overview report.
Report Content
This table lists the content in the Customer Profitability Overview report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Customer ID |
Attribute |
Dimension Customer.Customer ID |
|
|
Ledger ID |
Attribute |
Dimension Ledger.Ledger ID |
|
|
Top X Customers |
Calculated Attribute |
RANK() OVER(PARTITION BY "Activities and Cost Analysis".Customer Id ORDER BY "Activities and Cost Analysis".Gross Revenue DESC ) |
|
|
Total Activities Cost |
Metric |
SUM(CASE WHEN "Activities and Cost Analysis".Activity Id IN ('10010','10020','10030','1000','10050','10060','10070') THEN "Activities and Cost Analysis".Net Balance Transaction Amount ELSE 0 END) |
|
|
Total Activities as a Percentage of Revenue |
Metric |
"Activities and Cost Analysis".Total Activities Cost/"Activities and Cost Analysis".Gross Revenue |
Filter Elements
This table lists the filter elements in the Customer Profitability Overview report:
|
Name |
Type |
Definition |
|
Top X Number of Customers |
Prompt |
Qualifies for X number of top customers for the Customer Profitability Overview report. |
|
View ID |
Prompt |
Qualifies for the item by View IDs for the Customer Profitability Overview report. |
|
Fiscal Period |
Prompt |
Selects the fiscal period for the Customer Profitability Overview report. |
Additional Features
This section describes the additional analysis features in the Customer Profitability Overview report:
Page-by on Ledger ID.
Product Profitability Overview Report
The Product Profitability Overview report is based on the Customer Profitability Analysis business area.
With this report you can answer business questions such as “What is the net balance and percentage of revenue value by product?” and “What are the top products?”
This section discusses the elements in the Product Profitability OVerview report.
Report Content
This table lists the content in the Product Profitability Overview report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Ledger ID |
Attribute |
Dimension Ledger.Ledger ID |
|
|
Product Profitability Overview |
Calculated Attribute |
CASE WHEN Profitability Analysis.Product Profitability Label IN ('Gross Revenue','Customer Trade Terms') THEN 'Profitability Overview' WHEN Profitability Analysis.Product Profitability Label IN ('Direct Materials','Direct Labor','Direct Overhead','All Other Direct Costs') THEN 'Direct Costs' WHEN Profitability Analysis.Product Profitability Label IN ('Warehouse Activities','Transportation Activities') THEN 'Distribution' WHEN Profitability Analysis.Product Profitability Label IN ('Marketing Support Activities','Engineering Activities','Customer Service Activities','Merchandising Activities','Sales Force Activities') THEN 'SG_A' END |
|
|
Top X Products |
Calculated Attribute |
RANK() OVER(PARTITION BY Profitability Analysis.Inventory Item Id ORDER BY Profitability Analysis.Gross Revenue DESC ) |
|
|
Product Profitability Label |
Calculated Attribute |
CASE WHEN Profitability Analysis.Level4 Object Account = '5000' THEN 'Gross Revenue' WHEN Profitability Analysis.Level6 Object Account = '8823' THEN 'Customer Trade Terms' WHEN Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary IN ('A1','A2') THEN 'Direct Materials' WHEN Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary = 'B1' THEN 'Direct Labor' WHEN Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary IN ('C1','C2','C3','C4') THEN 'Direct Overhead' WHEN ( ( ( ( ( Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary IN ('X1','X2','X3','X4','X5','X6','X7') OR Profitability Analysis.Level7 Object Account IN ('5020','5070','5120','5170','5220','5270','5320') ) OR Profitability Analysis.Level7 Object Account = '6010' ) OR Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary IN ('D1','D2','D3','D4') AND Profitability Analysis.Level6 Object Account = '8540' ) OR Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary = 'X3' ) OR Profitability Analysis.Level4 Object Account = '6000' AND Profitability Analysis.Subsidiary = 'B3' ) THEN 'All Other Direct Costs' WHEN Profitability Analysis.Activity Id = '10010' THEN 'Warehouse Activities' WHEN Profitability Analysis.Activity Id = '10020' THEN 'Transportation Activities' WHEN Profitability Analysis.Activity Id = '10030' THEN 'Engineering Activities' WHEN Profitability Analysis.Activity Id = '10040' THEN 'Marketing Support Activities' WHEN Profitability Analysis.Activity Id = '10070' THEN 'Customer Service Activities' WHEN Profitability Analysis.Activity Id = '10060' THEN 'Merchandising Activities' WHEN Profitability Analysis.Activity Id = '10050' THEN 'Sales Force Activities' END |
|
|
Net Balance |
Metric |
SUM(Profitability Analysis.Net Balance Transaction Amount) |
|
|
Percentage of Revenue |
Metric |
Profitability Analysis.Net Balance/Profitability Analysis.Gross Revenue |
Filter Elements
This table lists the filter elements in the Product Profitability Overview report:
|
Name |
Type |
Definition |
|
Top X Number of Products |
Prompt |
Qualifies for X number of top products for the Product Profitability Overview report. |
|
View ID |
Prompt |
Qualifies for the item by view IDs for the Product Profitability Overview report. |
|
Fiscal Period |
Prompt |
Selects the fiscal period for the Product Profitability Overview report. |
Additional Features
This section describes the additional analysis features in the Product Profitability Overview report:
Page-by on Ledger ID
Accounts Payable Delivered Discoverer Reports
PeopleSoft provides the following Accounts Payable Discoverer reports:
Percentage of Electronic Payments
Payables Aging Analysis by Business Unit
Payments Made to Vendors
Percentage of Matching Exceptions
Payables Aging Analysis by Supplier
Percentage of Electronic Payments Report
The Percentage of Electronic Payments report is based on the Vouchers and Payments business area.
With this report you can answer business questions such as “What is the percentage of purchases were by electronic payment by business unit?”
This section discusses the elements in the Percentage of Electronic Payments report.
Report Content
This table lists the content in the Percentage of Electronic Payments report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AP.Business Unit |
|
|
Percentage Electronic Payment |
Metric |
SUM(CASE WHEN Dimension Payment Method.Payment Method Id = 'ACH' THEN Fact AP Transaction.Payment Count ELSE 0 END)/NULLIF(Payment Count SUM,0) |
Filter Elements
This table lists the filter elements in the Percentage of Electronic Payments report:
|
Name |
Type |
Definition |
|
Transaction Date |
Prompt |
Selects the transaction date for the Percentage of Electronic Payments report. |
Additional Features
This section describes the additional analysis features in the Percentage of Electronic Payments report:
Drillable hierarchy
Composite Business Unit
Business Unit
Page-by on Business Unit
Payables Aging Analysis by Business Unit Report
The Payables Aging Analysis by Business Unit report is based on the Aging Process business area.
With this report you can answer business questions such as “What are the balance base and discount amount by business unit?” and “How does the gross base amount compare to the prepaid base amount for a specified supplier?”
This section discusses the elements in the Payables Aging Analysis by Business Unit report.
Report Content
This table lists the content in the Payables Aging Analysis by Business Unit report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit AP.Business Unit |
|
|
Aging Category |
Attribute |
Dimension Aging Category.Aging Category Desc |
|
|
Supplier |
Attribute |
Dimension Supplier.Supplier Desc |
|
|
Balance Base Amount SUM |
Metric |
Grand sum for Balance Base Amount |
|
|
Discount Base Amount SUM |
Metric |
Grand sum for Discount Base Amount |
|
|
Gross Base Amount SUM |
Metric |
Grand sum for Gross Base Amount |
|
|
Prepaid Base Amount SUM |
Metric |
Grand sum for Prepaid Base Amount |
Filter Elements
This table lists the filter elements in the Payables Aging Analysis by Business Unit report:
|
Name |
Type |
Definition |
|
Supplier |
Prompt |
Qualifies the supplier name for the Percentage of Electronic Payments report. |
Additional Features
This section describes the additional analysis features in the Payables Aging Analysis by Business Unit report:
Page-by on the following attributes:
Business Unit
Supplier
Payments Made to Vendors Report
The Payments Made to Vendors report is based on the Vouchers and Payments business area.
With this report you can answer business questions such as “What is the gross paid base amount by business unit?” and “How are the payments compared for different payment methods within a supplier?”
This section discusses the elements in the Payments Made to Vendors report.
Report Content
This table lists the content in the Payments Made to Vendors report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit Desc |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AP.Business Unit |
|
|
Supplier Region Desc |
Attribute |
Dimension Supplier.Supplier Region Desc |
|
|
Supplier Desc |
Attribute |
Dimension Supplier.Supplier Desc |
|
|
Payment Method |
Attribute |
Dimension Payment Method.Payment Method Desc |
|
|
Bank Account |
Attribute |
Dimension Bank Account.Bank Account Desc |
|
|
Transaction Date |
Attribute |
Dimension Day Transaction Date. Transaction Day Date |
|
|
Gross Paid Base Amount |
Metric |
Fact AP Transaction. Gross Paid Base Amount |
Filter Elements
This table lists the filter elements in the Payments Made to Vendors report:
|
Name |
Type |
Definition |
|
Transaction Start Date |
Prompt |
Selects the transaction start date for the Payments Made to Vendors report. |
|
Transaction End Date |
Prompt |
Selects the transaction end date for the Payments Made to Vendors report. |
Additional Features
This section describes the additional analysis features in the Payments Made to Vendors report:
Drillable hierarchy:
Composite Business Unit Desc > Business Unit
Supplier Region Desc > Supplier Desc
Page-by on Business Unit.
Percentage of Matching Exceptions Report
The Percentage of Matching Exceptions report is based on the Percentage of Matching Exceptions Analysis business area.
With this report you can answer business questions such as “What is the percentage of matching exceptions by business unit?” and “What is the percentage of matching exceptions for a given transaction date?”
This section discusses the elements in the Percentage of Matching Exceptions report.
Report Content
This table lists the content in the Percentage of Matching Exceptions report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit Desc |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AP.Business Unit |
|
|
Match Rule |
Attribute |
Dimension Match Rule.Match Rule Desc |
|
|
Supplier |
Attribute |
Dimension Supplier.Supplier Desc |
|
|
Transaction Date |
Attribute |
Dimension Day Transaction Date. Transaction Day Date |
|
|
Percentage Matching Exceptions |
Metric |
Percentage of Matching Exception Analysis.Voucher Match Exp Dcount Voucher/NULLIF(Percentage of Matching Exception Analysis.AP Transaction Dcount Voucher,0) |
Filter Elements
There are no the filter elements in the Percentage of Matching Exceptions report.
Additional Features
This section describes the additional analysis features in the Percentage of Matching Exceptions report:
Drillable hierarchy: Composite Business Unit Desc > Business Unit.
Page-by on Business Unit.
Payables Aging Analysis by Supplier Report
The Payables Aging Analysis by Supplier report is based on the Aging Process business area.
With this report you can answer business questions such as “What are the balance amounts by supplier?” and “How many suppliers are in certain aging buckets?”
This section discusses the elements in the Payables Aging Analysis by Supplier report.
Report Content
This table lists the content in the Payables Aging Analysis by Supplier report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Aging Category |
Attribute |
Dimension Aging Category.Aging Category Desc |
|
|
Supplier Region Desc |
Attribute |
Dimension Supplier.Supplier Region Desc |
|
|
Supplier |
Attribute |
Dimension Supplier.Supplier Desc |
|
|
Balance Amount |
Metric |
Fact AP Aging.Balance Base Amount |
Filter Elements
There are no filter elements in the Payables Aging Analysis by Supplier report.
Additional Features
There are no additional analysis features in the Payables Aging Analysis by Supplier report:
Accounts Receivable Reports
PeopleSoft provides the following Accounts Receivable Discoverer reports:
Receivables DSO (Daily Sales Outstanding) Analysis
Write Off Analysis
Bad Debt Analysis
Receivables Aging Analysis by Customer
Receivables Aging Analysis by Business Unit
Receivables DSO Analysis Report
The Receivables DSO Analysis report is based on the Activity and Cost Analysis business area.
With this report you can answer business questions such as “What is the daily sales outstanding (DSO) by business unit, by customer?” and “What is the DSO for a specified detail period?”
This section discusses the elements in the Receivables DSO Analysis report.
Report Content
This table lists the content in the Receivables DSO Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit AR.Business Unit |
|
|
Detail Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Accounts Receivable Credit Risk |
Attribute |
Dimension Credit Risk.AR Credit Risk |
|
|
Accounts Receivable Credit Class |
Attribute |
Dimension Credit Class.AR Credit Class |
|
|
Accounts Receivable Collector |
Attribute |
Dimension Person AR Collector.AR Collector |
|
|
Accounts Receivable Credit Analyst |
Attribute |
Dimension Person AR Credit Analyst.AR Credit Analyst |
|
|
Sales Person |
Attribute |
Dimension Person Sales Person.Sales Person |
|
|
Days Sales Outstanding |
Metric |
Fact AR Days Sales Outstanding.Days Sales Outstanding |
Filter Elements
This table lists the filter element in the Receivables DSO Analysis report:
|
Name |
Type |
Definition |
|
Detail Period |
Prompt |
Selects the detail period for the Receivables DSO Analysis report. |
Additional Features
This section describes the additional analysis features in the Receivables DSO Analysis report:
Drillable hierarchy: Customer Group > Customer
Page-by on the following attributes:
Business Unit
Detail Period
Write Off Analysis Report
The Write Off Analysis report is based on the Items and Receipts business area. With this report you can answer business questions such as “What is the percent write off by business unit?” and “How are two sales persons compared in terms of percent write off?”
This section discusses the elements in the Write Off Analysis report.
Report Content
This table lists the content in the Write Off Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit Desc |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AR.Business Unit |
|
|
Transaction Month |
Attribute |
Dimension Day Transaction Date.Transaction Month Number |
|
|
Accounts Receivable Document Type |
Attribute |
Dimension AR Document Type.AR Document Type |
|
|
Entry Type |
Attribute |
Dimension Entry Reason Type.Entry Reason Type |
|
|
Sold To Customer |
Attribute |
Dimension Customer Cold Customer.Sold To Customer |
|
|
Accounts Receivable Credit Analyst |
Attribute |
Dimension Person AR Credit Analyst.AR Credit Analyst |
|
|
Accounts Receivable Collector |
Attribute |
Dimension Person AR Collector.AR Collector |
|
|
Sales Person 1 |
Attribute |
Dimension Person Sales Org1.Sales Org1 |
|
|
Sales Person 2 |
Attribute |
Dimension Person Sales Org2.Sales Org2 |
|
|
Percent Write Off |
Metric |
SUM(CASE WHEN Dimension Entry Reason Type.Entry Type = 'WO' THEN Fact AR Transaction.Remaining Base Amount ELSE 0 END)/NULLIF(( SUM(Fact AR Transaction.Transaction Base Amount) ),0) |
Filter Elements
There are no filter elements in the Write Off Analysis report.
Additional Features
This section describes the additional analysis features in the Write Off Analysis report:
Drillable hierarchy:
Composite Business Unit Desc > Business Unit
Customer Group > Customer
Page-by on the following attributes
Business Unit
Transaction Month
Bad Debt Analysis Report
The Bad Debt Analysis report is based on the Items and Receipts business area. With this report you can answer business questions such as “What is the percent of bad debt by business unit?” and “How do two sales organizations compare in terms of percent of bad debt?”
This section discusses the elements in the Bad Debt Analysis report.
Report Content
This table lists the content in the Bad Debt Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit Desc |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AR.Business Unit |
|
|
Transaction Month |
Attribute |
Dimension Day Transaction Date.Transaction Month Number |
|
|
Accounts Receivable Document Type |
Attribute |
Dimension AR Document Type.AR Document Type |
|
|
Entry Type |
Attribute |
Dimension Entry Reason Type.Entry Reason Type |
|
|
Sold To Customer |
Attribute |
Dimension Customer Sold Customer.Sold To Customer |
|
|
Accounts Receivable Credit Analyst |
Attribute |
Dimension Person AR Credit Analyst.AR Credit Analyst |
|
|
Sales Organization1 |
Attribute |
Dimension Person Sales Org1.Sales Org1 |
|
|
Sales Organization2 |
Attribute |
Dimension Person Sales Org2.Sales Org2 |
|
|
Accounts Receivable Collector |
Attribute |
Dimension Person AR Collector.AR Collector |
|
|
Percent Bad Debt |
Metric |
SUM(CASE WHEN Dimension Entry Reason Type.Entry Type = 'BD' THEN Fact AR Transaction.Remaining Base Amount ELSE 0 END)/NULLIF(( SUM(Fact AR Transaction.Transaction Base Amount) ),0) |
Filter Elements
There are no filter elements in the Bad Debt Analysis report.
Additional Features
This section describes the additional analysis features in the Bad Debt Analysis report:
Drillable hierarchy: Composite Business Unit Desc > Business Unit
Page-by on the following attributes:
Business Unit
Transaction Month
Receivables Aging Analysis by Customer Report
The Receivables Aging Analysis by Customer report is based on the Aging Process business area.
With this report you can answer business questions such as “What is the percent aging category for a specified customer group?” and “How are different aging categories compared in terms of the Percentage Aging Category metric?”
This section discusses the elements in the Receivables Aging Analysis by Customer report.
Report Content
This table lists the content in the Receivables Aging Analysis by Customer report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Composite Business Unit Desc |
Attribute |
Dimension Business Unit Composite.Business Unit |
|
|
Business Unit |
Attribute |
Dimension Business Unit AR.Business Unit |
|
|
Aging Category |
Attribute |
Dimension Aging Category.Aging Category |
|
|
Sales Person |
Attribute |
LTRIM(RTRIM(Dimension Person Sales Person.Sales First Name))||' '||LTRIM(RTRIM(Dimension Person Sales Person.Sales Last Name)) |
|
|
Accounts Receivable Credit Class |
Attribute |
Dimension Credit Class.AR Credit Class |
|
|
Accounts Receivable Credit Risk |
Attribute |
Dimension Credit Risk.AR Credit Risk |
|
|
Customer Group |
Attribute |
Dimension Customer.Customer Group |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Accounts Receivable Collector |
Attribute |
Dimension Person AR Collector.AR Collector |
|
|
Accounts Receivable Credit Analyst |
Attribute |
Dimension Person AR Credit Analyst.AR Credit Analyst |
|
|
Percent Aging Category |
Metric |
SUM(Fact AR Aging.Balance Base Amount)/NULLIF(Total AR Aging Balance.Total Balance Base Amount,0) |
Filter Elements
This table lists the filter elements in the Receivables Aging Analysis by Customer report:
|
Name |
Type |
Definition |
|
Aging Category |
Prompt |
Qualifies the aging category for the Receivables Aging Analysis by Customer report. |
Additional Features
This section describes the additional analysis features in the Receivables Aging Analysis by Customer report:
Drillable hierarchy:
Composite Business Unit Desc > Business Unit
Customer Group > Customer
Page-by on the following attributes:
Customer
Aging Category
Receivables Aging Analysis by Business Unit Report
The Receivables Aging Analysis by Business Unit report is based on the Aging Process business area.
With this report you can answer business questions such as “What is the balance amount by business unit?” and “What is the balance amount by aging category?”
This section discusses the elements in the Receivables Aging Analysis by Business Unit report.
Report Content
This table lists the content in the Receivables Aging Analysis by Business Unit report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit AR.Business Unit |
|
|
Aging Category |
Attribute |
Dimension Aging Category.Aging Category |
|
|
Customer Type |
Attribute |
Dimension Customer.Customer Type |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Customer Short Name |
Attribute |
Dimension Customer.Customer Short Name |
|
|
Customer ID |
Attribute |
Dimension Customer.Customer ID |
|
|
Balance Amount |
Metric |
Fact AR Aging.Balance Base Amount |
Filter Elements
There are no filter elements in the Receivables Aging Analysis by Business Unit report.
Additional Features
This section describes the additional analysis features in the Receivables Aging Analysis by Business Unit report:
Drillable hierarchy: Customer Type > Customer > Customer Short Name > Customer ID.
Page-by on the following attributes:
Business Unit
Aging Category
ESA Delivered Discoverer Reports
PeopleSoft provides the following ESA Discoverer reports:
Contract Forecast
Employee Time Forecast
Proposal Pipeline
Project Profitability
Forecast Utilization
Actual Utilization
Customer Profitability Overview
Contract Forecast Report
The Contract Forecast report is based on the Contract Forecast Analysis business area.
With this report you can answer business questions such as “What is the current contract forecast amount by business unit, account, and department?” and “What is the probability that each of these contract forecasts will occur?”
This section discusses the elements in the Contact Forecast report.
Report Content
This table lists the content in the Contract Forecast report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Contract |
Attribute |
Dimension Contract.Contract Desc |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Department |
Attribute |
Dimension Department.Department |
|
|
Product |
Attribute |
Dimension Product.Product |
|
|
Contract Forecast Probability |
Attribute |
AVG(Contract Forecast Analysis.Contract Forecast Probability Percentage) |
|
|
Accounting Date |
Attribute |
Dimension Day Accounting Date.Accounting Day Date |
|
|
Contract Line Forecast Amount |
Metric |
SUM(Contract Forecast Analysis.Contract Forecast Amount) |
Filter Elements
This table lists the filter elements in the Contract Forecast report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects contract forecasts from this year for the Contract Forecast report. |
Additional Features
This section describes the additional analysis features in the Contract Forecast report:
Drillable hierarchy:
Customer > Contract
Level 1 Desc > Level 2 Desc > Level 3 Desc > Account
Page-by on Business Unit.
Employee Time Forecast Report
The Employee Time Forecast report is based on the Employee Forecast Analysis business area.
With this report you can answer business questions such as “What are the forecasted employee billable hours and total forecasted hours by business unit?” and “How is my department performance on employee billable hours?”
This section discusses the elements in the Employee Time Forecast report.
Report Content
This table lists the content in the Employee Time Forecast report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Department |
Attribute |
Dimension Department.Department |
|
|
Employee (person) |
Attribute |
Dimension Person.Person Name |
|
|
Forecast Begin Date |
Attribute |
Dimension Employee Forecast.Forecast Begin Date |
|
|
Forecast End Date |
Attribute |
Dimension Employee Forecast.Forecast End Date |
|
|
Employee Forecast Billable Hours |
Metric |
SUM(CASE WHEN "FMS - ESA - Employee Time Forecast Analysis".Time Reporting Code Sid = 2147483646 THEN "FMS - ESA - Employee Time Forecast Analysis"."Total Work Hour Number" ELSE 0 END) |
|
|
Employee Forecast Policy Hours |
Metric |
SUM(CASE WHEN "FMS - ESA - Employee Time Forecast Analysis".Time Reporting Code Sid <> 2147483646 THEN "FMS - ESA - Employee Time Forecast Analysis"."Total Work Hour Number" ELSE 0 END) |
|
|
Forecast Total Hours |
Metric |
SUM("FMS - ESA - Employee Time Forecast Analysis".Total Work Hour Number) |
Filter Elements
This table lists the filter elements in the Employee Time Forecast report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects contract forecasts from this year for the Employee Time Forecast report. |
Additional Features
This section describes the additional analysis features in the Employee Time Forecast report:
Page-by on Business Unit.
Proposal Pipeline Report
The Proposal Pipeline report is based on the Proposal Pipeline Analysis business area.
With this report you can answer business questions such as “What is the revenue forecast amount for my pipeline by business unit, department and customer?” and “How is my department performance on employee billable hours?”
This section discusses the elements in the Proposal Pipeline report.
Report Content
This table lists the content in the Proposal Pipeline report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit Project.Project Business Unit |
|
|
Conversion Confidence Percentage |
Attribute |
AVG(Proposal Pipeline Analysis.Conversion Confidence Percentage) |
|
|
Contract |
Attribute |
Dimension Contract.Contract Desc |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Department |
Attribute |
Dimension Department.Department |
|
|
Product |
Attribute |
Dimension Product.Product |
|
|
Proposal Due Date |
Attribute |
Dimension Day Due Date.Due Day Date |
|
|
Revenue Forecast Amount |
Metric |
SUM(Proposal Pipeline Analysis.Proposal Forecast Revenue Amount) |
Filter Elements
This table lists the filter elements in the Proposal Pipeline report:
|
Name |
Type |
Definition |
|
Proposal Due Date in Year |
Prompt |
Selects project proposals due on or later than this year for the Proposal Pipeline report. |
Additional Features
This section describes the additional analysis features in the Proposal Pipeline report:
Drillable hierarchy: Customer > Contract
Page-by on Business Unit.
Project Profitability Report
The Project Profitability report is based on the Project Profitability Analysis business area.
With this report you can answer business questions such as “What is the gross profit margin percentage for a given business unit?” and “What is my project revenue and cost by customer?”
This section discusses the elements in the Project Profitability report.
Report Content
This table lists the content in the Project Profitability report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Chartfield 1 |
Attribute |
Dimension Chartfield1.Chartfield1 |
|
|
Chartfield 2 |
Attribute |
Dimension Chartfield2.Chartfield2 |
|
|
Chartfield 3 |
Attribute |
Dimension Chartfield3.Chartfield3 |
|
|
Contract |
Attribute |
Dimension Contract.Contract Desc |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Project |
Attribute |
Dimension Project.Project |
|
|
Project Activity |
Attribute |
Dimension Project Activity.Activity |
|
|
Project Manager |
Attribute |
Dimension Project.Project Manager |
|
|
Operating Unit |
Attribute |
Dimension Operating Unit.Operating Unit |
|
|
Accounting Date |
Attribute |
Dimension Day Accounting Date.Accounting Day Date |
|
|
Project Cost |
Metric |
SUM(CASE WHEN " Project Profitability Analysis".Analysis Group Category = 'ACTL' THEN " Project Profitability Analysis".Resource Amount ELSE 0 END) |
|
|
Project Revenue |
Metric |
SUM(CASE WHEN " Project Profitability Analysis".Analysis Group Category = 'PSREV' THEN " Project Profitability -Analysis".Resource Amount ELSE 0 END) |
|
|
Gross Profit |
Metric |
" Project Profitability Analysis".Project Revenue-" Project Profitability Analysis".Project Cost |
|
|
Gross Profit Margin |
Metric |
CASE WHEN " Project Profitability Analysis".Project Revenue = 0 THEN NULL ELSE " Project Profitability Analysis".Gross Profit/" Project Profitability Analysis".Project Revenue END |
Filter Elements
This table lists the filter elements in the Project Profitability report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects projects with accounting dates on or later than this year for the Project Profitability. |
Additional Features
This section describes the additional analysis features in the Project Profitability report:
Drillable hierarchy:
Customer > Contract
Business Unit > Project > Project Activity
Page-by on Business Unit.
Forecast Utilization Report
The Forecast Utilization report is based on the Forecast Utilization Analysis business area.
With this report you can answer business questions such as “What is the forecast utilization rate for my project?” and “How are my employee forecast billable hours for this year compared to last year?”
This section discusses the elements in the Forecast Utilization report.
Report Content
This table lists the content in the Forecast Utilization report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Department |
Attribute |
Dimension Department.Department |
|
|
Job Code |
Attribute |
Dimension Jobcode.Jobcode |
|
|
Project Role |
Attribute |
Dimension Project Role.Project Role Desc |
|
|
Employee (Person) |
Attribute |
Dimension Person.Person Name |
|
|
Location |
Attribute |
Relate Project Activity Location.Location Code |
|
|
Forecast Begin Date |
Attribute |
Dimension Employee Forecast.Forecast Begin Date |
|
|
Forecast End Date |
Attribute |
Dimension Employee Forecast.Forecast End Date |
|
|
Employee Forecast Billable Hours |
Metric |
SUM(CASE WHEN Forecast Utilization Analysis.TRC Sid = 2147483646 THEN Forecast Utilization Analysis."Total Work Hour Number" ELSE 0 END) |
|
|
Employee Forecast Policy Hours |
Metric |
SUM(CASE WHEN Forecast Utilization Analysis.TRC Sid <> 2147483646 THEN Forecast Utilization Analysis."Total Work Hour Number" ELSE 0 END) |
|
|
Forecast Total Hours |
Metric |
SUM(Forecast Utilization Analysis.Total Work Hour Number) |
|
|
Forecast Utilization Rate |
Metric |
CASE WHEN Forecast Utilization Analysis.Forecast Capacity Hours <> 0 THEN Forecast Utilization Analysis.Employee Forecast Billable Hours/Forecast Utilization Analysis.Forecast Capacity Hours ELSE Forecast Utilization Analysis.Employee Forecast Billable Hours/8 END |
Filter Elements
This table lists the filter elements in the Forecast Utilization report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects forecast utilization on or after this year for the Forecast Utilization report. |
Additional Features
This section describes the additional analysis features in the Forecast Utilization report:
Drillable hierarchy: Business Unit > Project > Project Activity
Page-by on Business Unit
Actual Utilization Report
The Actual Utilization report is based on the Actual Utilization Analysis business area.
With this report you can answer business questions such as “What is the actual utilization rate by business unit and department?” and “What are my department time report billable hours for this year compared to other departments?”
This section discusses the elements in the Actual Utilization report.
Report Content
This table lists the content in the Actual Utilization report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Department |
Attribute |
Dimension Department.Department |
|
|
Employee (Person) |
Attribute |
Dimension Person.Person Name |
|
|
Location |
Attribute |
Relate Project Activity Location.Location Code |
|
|
Report Date |
Attribute |
Dimension Day Reporting Date.Reporting Day Date |
|
|
Time Report Billable Hours |
Metric |
SUM(CASE WHEN Actual Utilization Analysis.TRC Sid = 2147483646 THEN Actual Utilization Analysis.Time Report Hours ELSE 0 END) |
|
|
Time Report Policy Hours |
Metric |
SUM(CASE WHEN Actual Utilization Analysis.TRC Sid <> 2147483646 THEN Actual Utilization Analysis.Time Report Hours ELSE 0 END) |
|
|
Time Report Hours |
Metric |
SUM(Actual Utilization Analysis.Time Report Hours) |
|
|
Capacity Hours |
Metric |
NVL(Actual Utilization Analysis.Work Day Hour Sum*Actual Utilization Analysis.Count Report Dt Sid,8) |
|
|
Actual Utilization Rate |
Metric |
- |
CASE WHEN Actual Utilization Analysis.Capacity Hours <> 0 THEN Actual Utilization Analysis."Time Report Hours "/Actual Utilization Analysis.Capacity Hours ELSE NULL END |
Filter Elements
This table lists the filter elements in the Actual Utilization report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects the actual utilization from this year for the Actual Utilization report. |
Additional Features
This section describes the additional analysis features in the Actual Utilization report:
Drillable hierarchy: Business Unit > Project > Project Activity
Page-by on Business Unit
Customer Profitability Overview Report
The Customer Profitability Overview report is based on the Customer Profitability Analysis business area.
With this report you can answer business questions such as “What is the number of forecasted employee billable hours and total forecasted hours by business unit?” and “How is my department performance on employee billable hours?”
This section discusses the elements in the Customer Profitability Overview report.
Report Content
This table lists the content in the Customer Profitability Overview report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit General Ledger.GL Business Unit |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Chartfield 1 |
Attribute |
Dimension Chartfield1.Chartfield1 |
|
|
Chartfield 2 |
Attribute |
Dimension Chartfield2.Chartfield2 |
|
|
Chartfield 3 |
Attribute |
Dimension Chartfield3.Chartfield3 |
|
|
Project |
Attribute |
Dimension Project.Project |
|
|
Project Activity |
Attribute |
Dimension Project Activity.Activity |
|
|
Accounting Date |
Attribute |
Dimension Day Accounting Date.Accounting Day Date |
|
|
Project Transaction Actual Amount |
Metric |
SUM(CASE WHEN "FMS - ESA - Customer Profitability Analysis".Analysis Group Category = 'ACTL' THEN "FMS - ESA - Customer Profitability Analysis".Resource Amount ELSE 0 END) |
|
|
Project Transaction Budget Amount |
Metric |
SUM(CASE WHEN "FMS - ESA - Customer Profitability Analysis".Analysis Group Category = 'BUDG' THEN "FMS - ESA - Customer Profitability Analysis".Resource Amount ELSE 0 END) |
Filter Elements
This table lists the filter element in the Customer Profitability Overview report:
|
Name |
Type |
Definition |
|
Accounting Date in Year |
Prompt |
Selects projects with accounting year on or greater than this value for the Customer Profitability Overview report. |
Additional Features
This section describes the additional analysis features in the Customer Profitability Overview report:
Drillable hierarchy:
Customer > Contract
Business Unit > Project > Project Activity
Page-by on Business Unit
Global Consolidation Reports
PeopleSoft provides the following Global Consolidation reports:
Balance Sheet Analysis
Budget Versus Actual Analysis by Period
Budget Versus Net Sales Analysis
Cash Flow Analysis
Income Statement Analysis
Customer Segment Analysis
Balance Sheet Analysis Report
The Balance Sheet Analysis report is based on the Balance Sheet and Income Statement Analysis business area.
With this report you can answer business questions such as “How is the company balance sheet for this accounting period?” and “How much are the assets and liabilities?”
This section discusses the elements in the Balance Sheet Analysis report.
Report Content
This table lists the content in the Balance Sheet Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Performance Business Unit |
Attribute |
LTRIM(RTRIM("Dimension Performance Business Unit ".Performance Business Unit)) |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Balance |
Metric |
SUM(CASE WHEN ( GC Balance Sheet Analysis.Scenario Type = '1' ) THEN GC Balance Sheet Analysis.Posted Base Amount ELSE 0 END) |
Filter Elements
This table lists the filter elements in the Balance Sheet Analysis report:
|
Name |
Type |
Definition |
|
Performance Business Unit |
Prompt |
Qualifies the performance business unit for the Balance Sheet Analysis report. |
|
Reporting Period |
Prompt |
Qualifies the reporting period for the Balance Sheet Analysis report. |
Additional Features
This section describes the additional analysis features in the Balance Sheet Analysis report:
Drillable hierarchy:
Level 1 Desc > Level 2 Desc > Level 3 Desc > Account
Year > Quarter > Fiscal Period
Budget Versus Actual Analysis by Period Report
The Budget Versus Actual Analysis by Period report is based on the Budget versus Actual Analysis by Period business area.
With this report you can answer business questions such as “What is the actual amount for this period by account?” and “How does the actual amount for this period compare to last period by performance business unit?”
This section discusses the elements in the Budget Versus Actual Analysis by Period report.
Report Content
This table lists the content in the Budget Versus Actual Analysis by Period report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Performance Business Unit |
Attribute |
"Dimension Performance Business Unit ".Performance Business Unit |
|
|
Account |
Attribute |
Dimension Account.Account |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Actual Amount |
Metric |
SUM(CASE WHEN "GC Budget vs Actuals Analysis by Period".Scenario Type = '1' THEN "GC Budget vs Actuals Analysis by Period".Posted Base Amount ELSE 0 END) |
|
|
Budget Amount |
Metric |
SUM(CASE WHEN "GC Budget vs Actuals Analysis by Period".Scenario Type = '3' THEN "GC Budget vs Actuals Analysis by Period".Posted Base Amount ELSE 0 END) |
|
|
Actual Amount Last Period |
Metric |
SUM(CASE WHEN "GC Budget vs Actuals Analysis by Period".Scenario Type = '1' THEN "GC Budget vs Actuals Analysis by Period"."Posted Transaction Amount Last Period" ELSE 0 END) |
|
|
Budget Amount Last Period |
Metric |
SUM(CASE WHEN "GC Budget vs Actuals Analysis by Period".Scenario Type = '3' THEN "GC Budget vs Actuals Analysis by Period"."Posted Transaction Amount Last Period" ELSE 0 END) |
|
|
Actual to Budget Variance |
Metric |
"GC Budget vs Actuals Analysis by Period".Budget Amount-"GC Budget vs Actuals Analysis by Period".Actual Amount |
|
|
Actual to Last Year Actual Variance |
Metric |
"GC Budget vs Actuals Analysis by Period".Actual Amount-"GC Budget vs Actuals Analysis by Period"."Actual Amount Last Period" |
Filter Elements
There are no filter elements in the Budget Versus Actual Analysis by Period report.
Additional Features
This section describes the additional analysis features in the Budget Versus Actual Analysis by Period report:
Drillable hierarchy: Level 1 Desc > Level 2 Desc > Level 3 Desc > Account
Page-by on Performance Business Unit
Budget Versus Net Sales Analysis Report
The Budget Versus Net Sales Analysis report is based on the Budget versus Net Sales Analysis business area.
With this report you can answer business questions such as “What is the budget versus actual variance on net sales?” and “What is the percentage of actual amount to overall net sales?”
This section discusses the elements in the Budget Versus Net Sales Analysis report.
Report Content
This table lists the content in the Budget Versus Net Sales Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Performance Business Unit ".Business Unit |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Budget Amount |
Metric |
SUM(CASE WHEN Consolidation Budget vs Net Sales Analysis.Scenario Type = '3' THEN Consolidation Budget vs Net Sales Analysis.Posted Base Amount ELSE NULL END) |
|
|
Actual Amount |
Metric |
SUM(CASE WHEN Consolidation Budget vs Net Sales Analysis.Scenario Type = '1' THEN Consolidation Budget vs Net Sales Analysis.Posted Base Amount ELSE 0 END) |
|
|
Actual to Budget Variance Amount |
Metric |
SUM(CASE WHEN Consolidation Budget vs Net Sales Analysis.Scenario Type = '3' THEN Consolidation Budget vs Net Sales Analysis.Posted Base Amount ELSE 0 END)-SUM(CASE WHEN Consolidation Budget vs Net Sales Analysis.Scenario Type = '1' THEN Consolidation Budget vs Net Sales Analysis.Posted Base Amount ELSE 0 END) |
|
|
Percentage Variance to Budget |
Metric |
Consolidation Budget vs Net Sales Analysis.Actual to Budget Variance Amount/Consolidation Budget vs Net Sales Analysis.Budget Amount |
|
|
Percentage Budget Amount to Net Sales |
Metric |
Consolidation Budget vs Net Sales Analysis.Budget Amount/Consolidation Budget vs Net Sales Analysis.Net Sales |
|
|
Percentage Actual Amount to Net Sales |
Metric |
Consolidation Budget vs Net Sales Analysis.Actual Amount/Consolidation Budget vs Net Sales Analysis.Net Sales |
Filter Elements
There are no filter elements in the Budget Versus Net Sales Analysis report.
Additional Features
This section describes the additional analysis features in the Budget Versus Net Sales Analysis report:
Drillable hierarchy: Level 1 > Level 2 > Level 3 > Account
Page-by on Business Unit.
Cash Flow Analysis Report
The Cash Flow Analysis report is based on the Cash Flow Analysis business area.
With this report you can answer business questions such as “How much is the actual amount by business unit?” and “What is the actual amount variance between this period and last period?”
This section discusses the elements in the Cash Flow Analysis report.
Report Content
This table lists the content in the Cash Flow Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
"Dimension Performance Business Unit ".Business Unit |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Actual Amount |
Metric |
SUM(CASE WHEN Consolidation Cash Flow Analysis.Scenario Type = '1' THEN Consolidation Cash Flow Analysis.Posted Base Amount ELSE 0 END) |
|
|
Actual Amount Last Period |
Metric |
SUM(CASE WHEN Consolidation Cash Flow Analysis.Scenario Type = '1' THEN Consolidation Cash Flow Analysis."Posted Base Amount Last Period" ELSE 0 END) |
|
|
Actual Variance |
Metric |
Consolidation Cash Flow Analysis.Actual Amount-Consolidation Cash Flow Analysis."Actual Amount Last Period" |
Filter Elements
There are no filter elements in the Cash Flow Analysis report.
Additional Features
This section describes the additional analysis features in the Cash Flow Analysis report:
Drillable hierarchy: Level 1 > Level 2 > Level 3 > Account
Page-by on Business Unit.
Income Statement Analysis Report
The Income Statement Analysis report is based on the Balance Sheet and Income Statement Analysis business area.
With this report you can answer business questions such as “What is the total expense amount by account?” and “How is the revenue for a specific account compared for different reporting periods?”
This section discusses the elements in the Income Statement Analysis report.
Report Content
This table lists the content in the Income Statement Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Performance Business Unit |
Attribute |
LTRIM(RTRIM("Dimension Performance Business Unit ".Performance Business Unit)) |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Balance |
Metric |
SUM(CASE WHEN ( GC Income Statement Analysis.Scenario Type = '1' ) THEN GC Income Statement Analysis.Posted Base Amount ELSE 0 END) |
Filter Elements
This table lists the filter elements in the Income Statement Analysis report:
|
Name |
Type |
Definition |
|
Performance Business Unit |
Prompt |
Qualifies the performance business unit for the Income Statement Analysis report. |
|
Reporting Period |
Prompt |
Qualifies the reporting period for the Income Statement Analysis report. |
Additional Features
This section describes the additional analysis features in the Income Statement Analysis report:
Drillable hierarchy:
Level 1 > Level 2 > Level 3 > Account
Year > Quarter > Fiscal Period
Customer Segment Analysis Report
The Customer Segment Analysis report is based on the Consolidated Ledger business area.
With this report you can answer business questions such as “What is the cost amount by accounts?” and “How is the amount compared by different channels?”
This section discusses the elements in the Customer Segment Analysis report.
Report Content
This table lists the content in the Customer Segment Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Customer |
Attribute |
Dimension Customer.Customer |
|
|
Channel |
Attribute |
Dimension Channel.Channel Desc |
|
|
Amount |
Metric |
Fact Consolidation Ledger.Posted Base Amount |
Filter Elements
There are no filter elements in the Customer Segment Analysis report.
Additional Features
This section describes the additional analysis features in the Customer Segment Analysis report:
Drillable hierarchy:
Level 1 Desc > Level 2 Desc > Level 3 Desc > Account
Customer Group > Customer Short Name > Customer > Customer ID
General Ledger Delivered Discoverer Reports
PeopleSoft provides the following General Ledger Discoverer reports:
Balance Sheet Analysis
Budget Versus Actual Analysis by Period
Budget Versus Net Sales Analysis
Income Statement Analysis
Period Over Period Performance Analysis
Balance Sheet Analysis Report
The Balance Sheet Analysis report is based on the Period Balances − Analysis business area.
With this report you can answer business questions such as “What is the balance sheet for a specified business unit by quarter?” and “What is the balance information by accounting period?”
This section discusses the elements in the Balance Sheet Analysis report.
Report Content
This table lists the content in the Balance Sheet Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Business Unit |
Attribute |
LTRIM(RTRIM(Dimension Business Unit.Business Unit)) |
|
|
Balance |
Metric |
SUM(CASE WHEN ( Balance Sheet Analysis.Scenario Type = '1' OR Balance Sheet Analysis.Ledger Id = 'AA' ) THEN Balance Sheet Analysis.Net Base Amount ELSE 0 END) |
Filter Elements
This table lists the filter elements in the Balance Sheet Analysis report:
|
Name |
Type |
Definition |
|
Business Unit |
Prompt |
Qualifies the business unit for the Balance Sheet Analysis report. |
|
Reporting Period |
Prompt |
Qualifies the reporting period for the Balance Sheet Analysis report. |
Additional Features
This section describes the additional analysis features in the Balance Sheet Analysis report: Drillable hierarchy:
Level 1 Desc > Level 2 Desc > Level 3 Desc > Account
Business Unit > Department > Operating Unit > Fund
Year > Quarter > Accounting Period
Budget Versus Actual Analysis Report
The Budget Versus Actual Analysis by Period report is based on the Period Balances − Analysis business area.
With this report you can answer business questions such as “What is the variance between actual and budget amount for a given business unit?” and “What is the actual amount compared to the budget amount by account?”
This section discusses the elements in the Budget Versus Actual Analysis report.
Report Content
This table lists the content in the Budget Versus Actual Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Reporting Actual Amount |
Metric |
SUM(CASE WHEN ( "Budget Vs Actuals Analysis by Period".Scenario Type = '1' OR "Budget Vs Actuals Analysis by Period".Ledger Id = 'AA' ) THEN "Budget Vs Actuals Analysis by Period".Net Base Amount ELSE 0 END) |
|
|
Reporting Budget Amount |
Metric |
SUM(CASE WHEN ( "Budget Vs Actuals Analysis by Period".Scenario Type = '3' OR "Budget Vs Actuals Analysis by Period".Ledger Id = 'BA' ) THEN "Budget Vs Actuals Analysis by Period".Net Base Amount ELSE 0 END) |
|
|
Variance Reporting Amount |
Metric |
"Budget Vs Actuals Analysis by Period".Reporting Budget Amount-"Budget Vs Actuals Analysis by Period".Reporting Actual Amount |
|
|
Variance Reporting Percentage |
Metric |
( "Budget Vs Actuals Analysis by Period".Variance Reporting Amount/"Budget Vs Actuals Analysis by Period".Reporting Budget Amount Divisor )*100 |
|
|
Comparison Actual Amount |
Metric |
SUM(CASE WHEN ( "Budget Vs Actuals Analysis by Period".Scenario Type = '1' OR "Budget Vs Actuals Analysis by Period".Ledger Id = 'AA' ) THEN "Budget Vs Actuals Analysis by Period".Net Base Amount Comparison Period ELSE 0 END) |
|
|
Comparison Budget Amount |
Metric |
SUM(CASE WHEN ( "Budget Vs Actuals Analysis by Period".Scenario Type = '3' OR "Budget Vs Actuals Analysis by Period".Ledger Id = 'BA' ) THEN "Budget Vs Actuals Analysis by Period".Net Base Amount Comparison Period ELSE 0 END) |
|
|
Variance Comparison Amount |
Metric |
"Budget Vs Actuals Analysis by Period".Comparison Budget Amount-"Budget Vs Actuals Analysis by Period".Comparison Actual Amount |
|
|
Variance Comparison Percentage |
Metric |
( "Budget Vs Actuals Analysis by Period".Variance Comparison Amount/"Budget Vs Actuals Analysis by Period".Comparison Budget Amount Divisor )*100 |
Filter Elements
This table lists the filter elements in the Budget Versus Actual Analysis report:
|
Name |
Type |
Definition |
|
Reporting Period |
Prompt |
Qualifies the reporting period for the Budget versus Actual Analysis report. |
|
Comparison Period |
Prompt |
Qualifies the comparison period for the Budget versus Actual Analysis report. |
Additional Features
This section describes the additional analysis features in the Budget Versus Actual Analysis report:
Drillable hierarchy:
Business Unit > Department > Operating Unit > Fund
Level 1 > Level 2 > Level 3 > Account
Page-by on Business Unit.
Budget Versus Net Sales Report
The Budget Versus Net Sales report is based on the Period Balances − Analysis business area.
With this report you can answer business questions such as “What are the actual and budget amounts for a given project by accounting period?” “What is the percentage of actual to budget variance for a given account?” and “What is the percentage of actual and budget with net sales?”
This section discusses the elements in the Budget Versus Net Sales Report report.
Report Content
This table lists the content in the Budget Versus Net Sales report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
LTRIM(RTRIM(Dimension Business Unit.Business Unit)) |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Project |
Attribute |
Dimension Project.Project |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Actual Amount |
Metric |
SUM(CASE WHEN ( Budget vs Net Sales Analysis.Scenario Type = '1' OR Budget vs Net Sales Analysis.Ledger Id = 'AA' ) THEN Budget vs Net Sales Analysis.Net Base Amount ELSE 0 END) |
|
|
Budget Amount |
Metric |
SUM(CASE WHEN ( Budget vs Net Sales Analysis.Scenario Type = '3' OR Budget vs Net Sales Analysis.Ledger Id = 'BA' ) THEN Budget vs Net Sales Analysis.Net Base Amount ELSE 0 END) |
|
|
Percentage of Actual to Budget Variance |
Metric |
( ( Budget vs Net Sales Analysis.Budget Amount-Budget vs Net Sales Analysis.Actual Amount )/Budget vs Net Sales Analysis.Budget Amount Divisor )*100 |
|
|
Actual to Net Sales Percentage |
Metric |
( Budget vs Net Sales Analysis.Actual Amount/Budget vs Net Sales Analysis.Net Sales Denom )*100 |
|
|
Budget to Net Sales Percentage |
Metric |
( Budget vs Net Sales Analysis.Budget Amount/Budget vs Net Sales Analysis.Net Sales Denom )*100 |
Filter Elements
There are no filter elements in the Budget Versus Net Sales report.
Additional Features
This section describes the additional analysis features in the Budget Versus Net Sales report:
Drillable hierarchy:
Business Unit > Department > Operating Unit > Fund
Level 1 > Level 2 > Level 3 > Account
Year > Quarter > Accounting Period
Page-by on Business Unit.
Income Statement Analysis Report
The Income Statement Analysis report is based on the Period Balances − Analysis business area.
This report business questions such as “What is the balance for a specified accounting period by account?” and “What are the expense and revenue for a specified business unit?”
This section discusses the elements in the Income Statement Analysis report.
Report Content
This table lists the content in the Income Statement Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
LTRIM(RTRIM(Dimension Business Unit.Business Unit)) |
|
|
Accounting Period |
Attribute |
Dimension Det Period.Pattern Period Desc |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Balance |
Metric |
SUM(CASE WHEN ( Income Statement Analysis.Scenario Type = '1' OR Income Statement Analysis.Ledger Id = 'AA' ) THEN Income Statement Analysis.Net Base Amount ELSE 0 END) |
Filter Elements
This table lists the filter elements in the Income Statement Analysis report:
|
Name |
Type |
Definition |
|
Business Unit |
Prompt |
Qualifies the business unit for the Income Statement Analysis report. |
|
Reporting Period |
Prompt |
Qualifies the reporting period for the Income Statement Analysis report. |
Additional Features
This section describes the additional analysis features in the Income Statement Analysis report:
Drillable hierarchy:
Level 1 > Level 2 > Level 3 > Account
Year > Quarter > Accounting Period
Business Unit > Department > Operating Unit > Fund
Period Over Period Performance Analysis Report
The Period Over Period Performance Analysis report is based on the Period Balances − Analysis business area.
With this report you can answer business questions such as “What is the actual amount for this period by business unit?” and “How does the actual amount for this period compare to last period?”
This section discusses the elements in the Period Over Period Performance Analysis report.
Report Content
This table lists the content in the Period Over Period Performance Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Account |
Attribute |
Dimension Account.Account Desc |
|
|
Actual Amount |
Metric |
SUM(CASE WHEN ( "Period Over Period Performance Analysis".Scenario Type = '1' OR "Period Over Period Performance Analysis".Ledger Id = 'AA' ) THEN "Period Over Period Performance Analysis".Net Base Amount ELSE 0 END) |
|
|
Actual Amount Last Period |
Metric |
SUM(CASE WHEN ( "Period Over Period Performance Analysis".Scenario Type = '1' OR "Period Over Period Performance Analysis".Ledger Id = 'AA' ) THEN "Period Over Period Performance Analysis"."Net Base Amount Last Period" ELSE 0 END) |
|
|
Variance Actual Amount |
Metric |
( ( "Period Over Period Performance Analysis"."Actual Amount (Last Period)"-"Period Over Period Performance Analysis".Actual Amount )/"Period Over Period Performance Analysis"."Actual Amount (Last Period) Divisor" )*100 |
Filter Elements
There are no filter elements in the Period Over Period Performance Analysis report.
Additional Features
This section describes the additional analysis features in the Period Over Period Performance Analysis report:
Drillable hierarchy:
Business Unit > Department > Operating Unit > Fund
Level 1 > Level 2 > Level 3 > Account
Page-by on Business Unit.
Real Estate Delivered Discoverer Reports
PeopleSoft provides the following Real Estate Discoverer reports:
Space Utilization by Building
Top 20 Tenants by Square Feet
Budget Rent Versus Actual Rent Analysis
Property Value by Building
Leasing Operations by Building
Average Rental Rate Analysis by Building
Space Utilization by Building Report
The Space Utilization by Building report is based on the Real Estate Area Analysis business area.
With this report you can answer business questions such as “What are the number of vacant units by business unit?” and “What is the vacancy ratio for a given unit within a business unit?”
This section discusses the elements in the Space Utilization by Building report.
Report Content
This table lists the content in the Space Utilization by Building report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Unit |
Attribute |
Dimension Unit.Unit Desc |
|
|
Number of Vacant Units |
Metric |
COUNT(Space Utilization by Building.Unit) |
|
|
Square Feet of Vacant Units |
Metric |
SUM(Space Utilization by Building.Area Square Feet) |
|
|
Vacancy Ratio |
Metric |
SUM(Space Utilization by Building.Area Square Feet)/Space Utilization by Building.Square Feet Total |
Filter Elements
This table lists the filter elements in the Space Utilization by Building report:
|
Name |
Type |
Definition |
|
Occupancy Date |
Prompt |
Qualifies the occupancy date for the Space Utilization by Building report. |
|
Area Type |
Prompt |
Qualifies the area type for the Space Utilization by Building report. |
|
Unit Type |
Prompt |
Qualifies the unit type for the Space Utilization by Building report. |
Additional Features
This section describes the additional analysis features in the Space Utilization by Building report:
Page-by on Business Unit.
Top 20 Tenants by Square Feet Report
The Top 20 Tenants by Square Feet report is based on the Lease Analysis business area.
With this report you can answer business questions such as “What is the rank by square footage for a specified business unit?” and “What is the area square footage by area type?”
This section discusses the elements in the Top 20 Tenants by Square Feet report.
Report Content
This table lists the content in the Top 20 Tenants by Square Feet report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Area Type |
Attribute |
Dimension Area Type.Area Type Desc |
|
|
Tenant Name |
Attribute |
Dimension Tenant.Tenant Name |
|
|
Area Square Feet |
Metric |
Fact Lease.Area Sqft |
|
|
Rank by Square Feet |
Metric |
RANK() OVER(PARTITION BY Lease.Business Unit ORDER BY Area Sqft SUM DESC ) |
Filter Elements
There are no filter elements in the Top 20 Tenants by Square Feet report.
Additional Features
This section describes the additional analysis features in the Top 20 Tenants by Square Feet report:
Page-by on Business Unit.
Budget Rent Versus Actual Rent Analysis Report
The Budget Rent Versus Actual Rent Analysis report is based on the Real Estate Billing business area.
With this report you can answer business questions such as “What are the rent budgeted, billed and paid amounts for all business units?” and “What is the annual rent per square foot for a specified business unit?”
This section discusses the elements in the Budget Rent Versus Actual Rent Analysis report.
Report Content
This table lists the content in the Budget Rent Versus Actual Rent Analysis report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Rent Budgeted |
Metric |
SUM(Budget Rent vs Actual Rent by Building Analysis.Ledger Net Base Amount) |
|
|
Rent Billed |
Metric |
SUM(Budget Rent vs Actual Rent by Building Analysis.Cust Ledger Gross Base Amount) |
|
|
Rent Paid |
Metric |
SUM(Budget Rent vs Actual Rent by Building Analysis.AP Ledger Gross Base Amount)-SUM(Budget Rent vs Actual Rent by Building Analysis.AP Ledger Open Base Amount) |
|
|
Annual Rent per Sqft |
Metric |
SUM(Budget Rent vs Actual Rent by Building Analysis.Annual Sqft Transaction Rate) |
Filter Elements
This table lists the filter elements in the Budget Rent Versus Actual Rent Analysis report:
|
Name |
Type |
Definition |
|
Period |
Prompt |
Qualifies the period for the Budget Rent versus Actual Rent Analysis report. |
|
Invoice Date Lower Limit |
Prompt |
Selects the lower limit for invoice date for the Budget Rent versus Actual Rent Analysis report. |
|
Invoice Date Upper Limit |
Prompt |
Selects upper limit for invoice date for the Budget Rent versus Actual Rent Analysis report. |
|
General Ledger Date Lower Limit |
Prompt |
Selects the lower limit for general ledger date for the Budget Rent versus Actual Rent Analysis report. |
|
General Ledger Date Upper Limit |
Prompt |
Selects upper limit for general ledger date for the Budget Rent versus Actual Rent Analysis report. |
|
Recurring Billing Date |
Prompt |
Qualifies the recurring billing date for the Budget Rent versus Actual Rent Analysis report. |
|
General Ledger Offset(s) |
Prompt |
Qualifies for a list of general ledger offsets for the Budget Rent versus Actual Rent Analysis report. |
Additional Features
This section describes the additional analysis features in the Budget Rent Versus Actual Rent Analysis report:
Page-by on Business Unit.
Property Value by Building Report
The Property Value by Building report is based on the Journal Entries Analysis business area.
With this report you can answer business questions such as “What is the leverage ratio for a specified business unit?” and “What is the property tax versus investment valuation comparison for a specified business unit?”
This section discusses the elements in the Property Value by Billing report.
Report Content
This table lists the content in the Property Value by Building report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Leverage Ratio |
Metric |
Journal Entries."Mortgage and Other Debt on Property"/( Journal Entries.Property Book Value ) |
|
|
Property Tax Versus Investment Valuation |
Metric |
Journal Entries.Property Tax/( Journal Entries.Investment Valuation ) |
Filter Elements
This table lists the filter elements in the Property Value by Building report:
|
Name |
Type |
Definition |
|
Journal Date |
Prompt |
Qualifies the journal date for the Property Value by Building report. |
|
Ledger |
Prompt |
Qualifies the ledger for Budget Rent Versus Actual Rent Analysis report. |
Additional Features
This section describes the additional analysis features in the Property Value by Building report:
Page-by on Business Unit.
Leasing Operations by Building Report
The Leasing Operations by Building report is based on the Lease Analysis business area.
With this report you can answer business questions such as “What is the number of pending move ins and move outs by business unit?” and “What is the square footage of pending move ins and move outs by business unit?”
This section discusses the elements in the Leasing Operations by Building report.
Report Content
This table lists the content in the Leasing Operations by Building report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit |
Attribute |
Dimension Business Unit.Business Unit |
|
|
Number of Pending Move Ins |
Metric |
CASE WHEN Lease.Move In Date BETWEEN :Lower Limit Date AND :Upper Limit Date THEN COUNT(Lease.Unit) ELSE 0 END |
|
|
Number of Pending Move Outs |
Metric |
CASE WHEN Lease.Move Out Date BETWEEN :Lower Limit Date AND :Upper Limit Date THEN COUNT(Lease.Unit) ELSE 0 END |
|
|
Square Feet of Pending Move Ins |
Metric |
SUM(CASE WHEN Lease.Move In Date BETWEEN :Lower Limit Date AND :Upper Limit Date THEN Lease.Area Sqft ELSE 0 END) |
|
|
Square Feet of Pending Move Outs |
Metric |
SUM(CASE WHEN Lease.Move Out Date BETWEEN :Lower Limit Date AND :Upper Limit Date THEN Lease.Area Sqft ELSE 0 END) |
Filter Elements
This table lists the filter elements in the Leasing Operations by Building report:
|
Name |
Type |
Definition |
|
Move In Date Lower Limit |
Prompt |
Selects the lower limit for move in date for the Leasing Operations by Building report. |
|
Move In Date Upper Limit |
Prompt |
Selects the upper limit for move in date for the Leasing Operations by Building report. |
|
Area type |
Prompt |
Qualifies the area type for the Leasing Operations by Building report. |
|
Unit type |
Prompt |
Qualifies the unit type for the Leasing Operations by Building report. |
Additional Features
This section describes the additional analysis features in the Leasing Operations by Building report:
Page-by on Business Unit.
Average Rental Rate Analysis by Building Report
The Average Rental Rate Analysis by Building report is based on the Real Estate Area Analysis business area.
With this report you can answer business questions such as “What is the rent area square footage for a particular area type?” and “What are the monthly transaction amount and average rental rate by unit type?”
This section discusses the elements in the Average Rental Rate Analysis by Building report.
Report Content
This table lists the content in the Average Rental Rate Analysis by Building report:
|
Name |
Type |
Folder/Item |
Derivation |
|
Business Unit Classification |
Attribute |
Dimension Business Unit.Business Unit Classification |
|
|
Area Type |
Attribute |
Dimension Area Type.Area Type Desc |
|
|
Unit Type Desc |
Attribute |
Dimension Unit.Unit Type Desc |
|
|
Rent Area Square Foot |
Metric |
Fact RE Billing.Rent Area Square Feet |
|
|
Monthly Transaction Amount |
Metric |
Fact RE Billing.Monthly Transaction Amount |
|
|
Average Rental Rate |
Metric |
Monthly Amount/Area Square Feet |
Filter Elements
This table lists the filter elements in the Average Rental Rate Analysis by Building report:
|
Name |
Type |
Definition |
|
Billing begin date |
Prompt |
Selects the billing begin date for the Average Rental Rate Analysis by Building report. |
|
Area type |
Prompt |
Qualifies the area type for the Average Rental Rate Analysis by Building report. |
|
Unit type |
Prompt |
Qualifies the unit type for the Average Rental Rate Analysis by Building report. |
Additional Features
This section describes the additional analysis features in the Average Rental Rate Analysis by Building report:
Page-by on Business Unit Classification.