Contents
1 Introduction
2 Subject Areas
- Overview
- Enterprise Contracts - Contracts Real Time
- OTBI Performance Real Time
- OTBI Usage Real Time
- Procurement - Implemented Change Orders Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Security - Audit Real Time
- Security - Roles and Privileges Real Time
- Sourcing - Program Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
- Supplier - Profile Change Request Real Time
- Supplier - Supplier Real Time
- Supplier Import - Supplier Real Time
- Supplier Portal - Invoice Real Time
- Supplier Portal - Purchasing Real Time
- Supplier Qualification - Qualifications and Assessments Real Time
- Supplier Qualification - Question Responses Real Time
- Supplier Qualification - Supplier Eligibility History Real Time
- Supplier Qualification - Supplier Eligibility Real Time
- Supplier Registration - Supplier Registration Real Time
3 Business Questions
- Overview
- What are the active contracts by contract type?
- What are the contracts with named policy deviations?
- What are the contracts with pending invoices?
- What is the count of contracts and of contract amounts for a given supplier?
- What contracts are expiring in the next 30 days?
- What is the count of blanket and contract agreements with implemented change orders?
- What is the count of pending change order headers for blanket agreements?
- What is the count of pending change order lines for purchase orders by procurement business unit and change reason?
- What are the delivered quantities and amounts?
- What are the invoice withholding amounts?
- What are the invoice amounts?
- What are the nonrecoverable exclusive taxes?
- What are the open ordered amounts per purchase order?
- What are the order quantity, amount, purchasing price, and open ordered quantity per purchase order?
- What are the prorated freight amounts?
- What are the recoverable and nonrecoverable exclusive taxes?
- What are the recoverable exclusive taxes per purchase order?
- What are the requested amount and price deviations?
- What are the requested quantity, amount, and price per requisition?
- How long has an agreement been inactive?
- How many blanket agreements will expire in the next six months?
- What is the agreed amount for a contract?
- What is the released amount for a contract?
- What are the open purchase orders with delayed delivery?
- What are the top purchase orders by the number of days for which they are unprocessed?
- What are the top 10 open purchase orders for a given supplier?
- What is the expected delivery schedule for open purchase orders for a given item?
- What are the ordered amount and invoiced amount by purchase order distribution?
- What is the split in the total purchased amount by purchase order charge account?
- Which purchase orders have a nonstandard clause?
- What is the count of days for which a buyer has not processed the requisition lines?
- What are the requisition lines in process for a given buyer by requisition line status?
- What are the unprocessed and processed requisition lines by buyer?
- What is the count of requisition lines across buyers by requisition line status?
- Who are the top 10 buyers in the requisition pool by count of requisition lines?
- What is the spend by item?
- What is the spend distribution by buyer?
- What are the top 10 spends by category?
- What are the top 10 spends by supplier?
- When were the sourcing programs created?
- How many alternate lines were awarded?
- What are the savings from negotiations in the last quarter or year?
- What is the distribution of award amounts across categories?
- Which suppliers received the highest award amounts?
- How many negotiations are in process across various business units?
- What is the count of negotiations across different negotiation owners?
- Which are the top categories being negotiated?
- How many supplier responses have alternate lines proposed?
- How many supplier responses were received for various negotiations in the last year?
- What is the count of suppliers by business classification?
- What is the count of suppliers by supplier geography?
- What is the count of suppliers by supplier relationship?
- What are all the supplier sites in a specific business unit requiring bulk updates?
- What is the total invoice price variance amount for a supplier?
- What is the total unpaid invoice amount for a supplier?
- What is the total open purchase order amount for a supplier?
- What are the qualification details for suppliers by top purchase order amount?
- What are the qualifications for suppliers for a specific business classification?
- What is the count of question responses captured through qualification questionnaires?
- What is the count of question responses captured through sourcing events?
- What is the count of question responses captured through supplier profiles or registrations?
- What is the count of question responses?
- What is the response validity time?
- What is the average duration of supplier registration approval?
- What is the count of supplier registration requests in the first quarter?
- How many change requests were approved in the last N days?
- How many change requests were rejected in the last N days?
- What is the average request approval time in days?
- What is the suppliers' eligibility for transactions?
- What is the history of the suppliers' eligibility for transactions ?
- How many users run OTBI analyses?
- Who are the top N OTBI users?
- What is the weekly OTBI analysis usage trend?
- What are the top N most frequently-run OTBI analyses?
- How many predefined OTBI analyses have been run in the past month?
- How many custom OTBI analyses have been run in the past month?
- How many ad-hoc OTBI analyses have been run in the past month?
- What is the execution history of dashboard X in the past month?
- Which analyses have low usage in the past three months?
- How many OTBI SOAP web services have been run in the past month?
- What are the long-running analyses in the past month?
- What is the OTBI execution time histogram in the past month?
- Which analyses have the longest response time?
- Which analyses have high data row count?
- Which analyses reached OTBI max row limit?
- What are the common execution errors in the past month?
- How many analyses and dashboards failed in the past month?
- What are the most commonly used OTBI subject areas?
- What are the least-used OTBI subject areas?
- Which subject areas are used frequently in ad-hoc OTBI analyses?
- Which analyses have low usage because of poor performance?
- How many database SQLs are executed by an analysis?
- What is the database SQL execution time and row count?
- What is the analysis total execution time and row count?
- Why am I not able to view certain subject areas with my login credentials?
- Which data security policy would provide access to the data I need to see?
- Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?
- I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?
- What are all the data security privileges that a specific user added?
- Which roles were added with a specific functional security policy, and who added them?
4 Job Roles
- Overview
- Accounts Payable Manager
- Accounts Payable Specialist
- Accounts Payable Supervisor
- Application Implementation Consultant
- Buyer
- Category Manager
- Customer Contract Administrator
- Customer Contract Manager
- Customer Contract Team Member
- Enterprise Contract Administrator
- Enterprise Contract Manager
- Enterprise Contract Team Member
- IT Security Manager
- Procurement Contract Administrator
- Procurement Manager
- Purchase Analysis
- Supplier Accounts Receivable Specialist
- Supplier Administrator
- Supplier Contract Administrator
- Supplier Contract Manager
- Supplier Contract Team Member
- Supplier Customer Service Representative
- Supplier Manager
- Supplier Qualification
- Supplier Sales Representative
5 Duty Roles
- Overview
- Agreement Transaction Analysis Duty
- Enterprise Contracts Transaction Analysis Duty Role
- Implemented Change Order Transaction Analysis Duty
- OTBI Report Performance Transactional Analysis Duty
- OTBI Report Usage Transactional Analysis Duty
- Pending Change Order Transaction Analysis Duty
- Purchase Order Transaction Analysis Duty
- Purchase Requisitions Transaction Analysis Duty
- Security Transaction Analysis Duty
- Sourcing Program Transaction Analysis Duty
- Sourcing Transaction Analysis Duty
- Spend Transaction Analysis Duty Role
- Supplier Eligibility History Transaction Analysis Duty
- Supplier Eligibility Transaction Analysis Duty
- Supplier Facing Invoice Transaction Analysis Duty
- Supplier Facing Purchase Order Transaction Analysis Duty
- Supplier Master Data Transaction Analysis Duty
- Supplier Qualification Analysis Duty
- Supplier Question and Responses Analysis Duty