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.
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.
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 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
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
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