Sunday, October 11, 2015

Oracle Fusion Applications Reporting Tools:

-Fusion Financials Reporting:
-Smart View
-Account Monitor
- Account Inspector
- OTBI-Oracle Transnational Business Intelligence
- Business Intelligence Publishers (BI Publisher)


Data Sources  for Reporting Tools in Fusion:










Different Roles have different Reporting needs:
















  1.  Financial Reports When we speak about Financial Reports, we are talking about reports that look solely at GL balances.  These reports utilize the essbase cube to present financial data in a real-time environment without having to "run" a report.  These reports are defined using the FR Studio tool which has many features including hierarchy expansion and drill down
  2. Smart View is a desktop tool, available as a plugin to Excel. It is a more re-usable tool for your analysis – ie you can save your spreadsheet layout as a template for future use, and then refresh it with the latest GL balances whenever you reopen it. It can be used to construct ad-hoc analysis too, but is useful for inquiries that you perform regularly.
  3. Account Inspector is an online tool available from within Fusion Applications, so you can use it directly within Fusion GL. For example, when you are investigating account balance changes using the Account Monitor, you can choose whether to view the amounts in a table / graph, or whether to open them up in Account Inspector so you can manipulate the data to understand it differently. It is useful for ad-hoc inquiries against an account. 
  4. OTBI: Allows you to build ad hoc queries or reports using views on transnational business objects. With Fusion Financials, you can build your own reports using the OBIEE tool and subject areas delivered with Fusion.  With simple drag and drop functionality, you can build a report (or ad hoc query)