PreviousNext JavaScript must be enabled to correctly display this content
  • Title and Copyright Information
  • Get Help
  • 1 Introduction
    • About This Guide
  • 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
    • 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?
    • Can I view and edit the manage employment screen, if yes, which functional security policy do I need to provide to the user?
    • How long has an agreement been inactive?
    • How many OTBI SOAP web services have been run in the past month?
    • How many ad-hoc OTBI analyses have been run in the past month?
    • How many alternate lines were awarded?
    • How many analyses and dashboards failed in the past month?
    • How many blanket agreements will expire in the next six months?
    • How many change requests were approved in the last N days?
    • How many change requests were rejected in the last N days?
    • How many custom OTBI analyses have been run in the past month?
    • How many negotiations are in process across various business units?
    • How many predefined OTBI analyses have been run in the past month?
    • How many supplier responses have alternate lines proposed?
    • How many supplier responses were received for various negotiations in the last year?
    • How many users run OTBI analyses?
    • I have not added the Compensation analyst role to user, however the user seem to have this job role, can I trace how has this been inherited by the user?
    • I haven't 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?
    • List all the Data Security Privileges that were added by a specific user
    • What are all the data security privileges that a specific user added?
    • What are all the supplier sites in a specific business unit requiring bulk updates?
    • What are the active contracts by contract type?
    • What are the common execution errors in the past month?
    • What are the contracts with named policy deviations?
    • What are the contracts with pending invoices?
    • What are the delivered quantities and amounts?
    • What are the invoice amounts?
    • What are the invoice withholding amounts?
    • What are the least-used OTBI subject areas?
    • What are the long-running analyses in the past month?
    • What are the most commonly used OTBI subject areas?
    • What are the nonrecoverable exclusive taxes?
    • What are the open ordered amounts per purchase order?
    • What are the open purchase orders with delayed delivery?
    • What are the order quantity, amount, purchasing price, and open ordered quantity per purchase order?
    • What are the ordered amount and invoiced amount by purchase order distribution?
    • What are the prorated freight amounts?
    • What are the qualification details for suppliers by top purchase order amount?
    • What are the qualifications for suppliers for a specific business classification?
    • 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?
    • What are the requisition lines in process for a given buyer by requisition line status?
    • What are the savings from negotiations in the last quarter or year?
    • What are the top 10 open purchase orders for a given supplier?
    • What are the top 10 spends by category?
    • What are the top 10 spends by supplier?
    • What are the top N most frequently-run OTBI analyses?
    • What are the top purchase orders by the number of days for which they are unprocessed?
    • What are the unprocessed and processed requisition lines by buyer?
    • What contracts are expiring in the next 30 days?
    • What is the OTBI execution time histogram in the past month?
    • What is the agreed amount for a contract?
    • What is the average duration of supplier registration approval?
    • What is the average request approval time in days?
    • What is the count of blanket and contract agreements with implemented change orders?
    • What is the count of contracts and of contract amounts for a given supplier?
    • What is the count of days for which a buyer has not processed the requisition lines?
    • What is the count of negotiations across different negotiation owners?
    • 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 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 count of requisition lines across buyers by requisition line status?
    • What is the count of supplier registration requests in the first quarter?
    • 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 is the current predicate vs prior predicate values of the data security policy?
    • What is the database SQL execution time and row count?
    • What is the distribution of award amounts across categories?
    • What is the execution history of dashboard X in the past month?
    • What is the expected delivery schedule for open purchase orders for a given item?
    • What is the history of the suppliers' eligibility for transactions ?
    • What is the released amount for a contract?
    • What is the response validity time?
    • What is the spend by item?
    • What is the spend distribution by buyer?
    • What is the split in the total purchased amount by purchase order charge account?
    • What is the suppliers' eligibility for transactions?
    • What is the total invoice price variance amount for a supplier?
    • What is the total number of updates that have happened on a data security policy?
    • What is the total open purchase order amount for a supplier?
    • What is the total unpaid invoice amount for a supplier?
    • What is the weekly OTBI analysis usage trend?
    • What is total number of changes done on a functional security policy during the day?
    • When were the sourcing programs created?
    • Which analyses have high data row count?
    • Which analyses have low usage because of poor performance?
    • Which analyses have low usage in the past month?
    • Which analyses have the longest response time?
    • Which analyses reached OTBI max row limit?
    • Which are the top categories being negotiated?
    • Which data security policy would provide access to the data I need to see?
    • Which data security policy would provide access to the talent profile data ?
    • Which purchase orders have a nonstandard clause?
    • Which roles were added with a specific functional security policy and who added it?
    • Which roles were added with a specific functional security policy, and who added them?
    • Which subject areas have large data volume?
    • Which subject areas have slow performance?
    • Which suppliers received the highest award amounts?
    • Which user has added/removed the specific functional security policy?
    • Who are the top 10 buyers in the requisition pool by count of requisition lines?
    • Who are the top N OTBI users?
    • Why am I not able to view certain subject areas with my login credentials?
    • Why am I not able to view succession management subject areas with my login?
  • 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