This article on Fusion Financials Reporting will briefly explain you reporting capabilities in Fusion Financials which are very handy to use. Let us look at brief overview of different types of Reporting available in Fusion Applications and we will try to understand these Reporting Options. These are- 

Oracle Transactional Business Intelligence for Financials

Referred to as OTBI, and allows users to build ad hoc queries or reports using views on transactional business objects. With Fusion Financials, users can build their own reports using the OBIEE tool and subject areas delivered with Fusion.  With simple drag and drop functionality, one can build a report (or ad hoc query) on any transaction without the need for a developer.  There are some pre-built reports delivered in OTBI for Fusion Financials.

BI Publisher

There are cases where a very specific format is required such as printed checks.  BI Publisher is the perfect tool for this, but is has many other great uses.  There are some pre-built reports delivered via BIP as part of Fusion Financials.Also, On this page, a user can enquire about balances & an access toFinanciall Reports.

    Financial Reports

Financial Reports are used to 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 Financial Reporting Studio tool which has many features including hierarchy expansion and drilldown.

Smart View

Smart View is an excel add-in that allows users to query GL Balance data real-time within Excel.  There's a previous blog post here that provides more information.

Oracle Business Intelligence Analytics

OBIA as we typically call it provides information from the pre-built data warehouse. The data here is not real-time based as with the other solutions.  Of all of these solutions, OBIA is not required and is separately licensed.

Below are the different Features and Benefits of Reporting Options-

Reporting Platform with Embedded Multi-Dimensional Data Model-

• Store and organize large quantities of data in a very efficient way that can be accessed and analyzed quickly for intuitive and immediate decision support.
• Perform multi-dimensional analysis from the same system used for operational accounting
• Eliminate the need for a separate, costly data warehouse where data is only as up-to-date as the last-time data was transferred

Real-time Updates to Multi-Dimensional Balances

• Always work with the most up-to-the-second data; multidimensional balances are updated when transactions and journals are posted
• Ensure queries, reports, and analysis are extremely fast as balances are pre-aggregated at every possible summarization level
• Eliminate the need for dual maintenance of chart of accounts; whenever users create or modify chart of accounts and hierarchies, the changes are automatically updated in the corresponding cubeThis

Self-Service Reporting

• Get the right information when you need it
• Securely distribute and access live or pre-published financial reports from a central location
• Reduce dependence on IT

General Accounting Dashboard

• Obtain comprehensive view across functional areas from a central page (i.e., journals requiring attention, intercompany transactions that are incomplete, account balances that have exceeded their thresholds, close status of subledgers and ledgers, etc.)
• Increase user productivity by reducing multiple searches and the need to navigate to multiple pages
• Track the status of self-monitoring processes to help you quickly resolve exceptions, garner approvals and focus on analyzing results

Account Monitor

• Continuously be alerted to sudden changes in account balances based on thresholds you define so you can take corrective action sooner
• Quickly drill down through multiple levels of summarized balances, view different perspectives of the balance, and even drill back to the originating transaction to investigate the root cause

Account Inspector

• Intuitively create complex allocation formulas with the graphical allocation wizard that helps users step by step
• Significantly improve performance by allocating pre-summarized balances
• Retain control and an audit trail

For more details about these reporting options in Fusion Application, Refer to Fusion Financials latest articles.

Add comment