Skip to main content

AP: Creating Oracle Transactional Business Intelligence (OTBI) Reports

 

26.Creating Oracle Transactional Business Intelligence (OTBI) Reports             
Path: Tools >> Reports and Analytics >> Create >> Analysis >> Choose the Subject Area             
Note: The Suffix should be "Real Time" then only we can fetch the real time data              
*Here from the Dimensions we have to select the columns from which you have to create the report              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Here we can set how we need to see the report             
              
              
              
              
              
              
              
              
              
              
              
              
*Here when you run system will ask you for Business Unit             
*If you want to filter the data by Business Unit you can move this to "Prompt For"             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Save the report to any folder             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Run this report             
Clickon Browse Catalog Button              
              
              
              
              
              
              
              
              
              
              
*Run the report here clickon Open it will run             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*This is the report output             
*The reason we are seeing the business unit here is that we have selected it as "Prompt". So it is displayed here             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
             

Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more