Skip to main content

AP: Creating BI Reports - SQL

 

25.Creating BI Reports - SQL             
*This is Technical People Job              
              
Things to Watch             
1. How to write SQL Queries             
2. Create BI Report             
3. Creation of Custom Enterprise Scheduler Service (ESS) Job             
4. Assign ESS Job to Role             
              
1. How to write SQL Queries             
*In Oracle Oer we can find all the tables under "Tables and Views for Financials".             
Path: Tools >> Reports and Analytics >> Create >> Report >> New >> Data Model >> Diagram >> SQL Query             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Here we have to write the query and clickon 'OK'             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now system has created this as group             
              
              
              
              
              
              
              
              
              
              
              
*Now goto structure and set when you run this report how we need to see column names             
              
              
              
              
              
              
              
              
              
              
              
              
              
*Here we can set how many rows we can see in the report (Rough)             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now clickon "Save as Sample Data             
              
              
              
              
              
              
              
              
              
              
              
              
*Now clickon "Save"             
              
              
              
              
              
              
              
              
              
              
              
              
              
*Save it on shared folders so that other users can also see              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now we have to create the report              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Copy Data Model Path             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Here select the layout options of the report             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now drag and drop the columns             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now clickon Finish             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Save the report             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Now system has created the report             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
3. Creation of Custom ESS Job             
*If the Technical people has developed the report and if we want to schedule the report then we have run ESS Job so that the report can be generated.             
Task: Define Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Run ESS Job "Import User and Role Application Security Data             
*If you run this job then only we can find this new job in the security console             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
*Run Import User and Role Application Security Data             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
             

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