Understanding Reporting in Fusion Financials
By Joe G on Apr 24, 2012
When talking with customers and potential customers of Fusion Fiancials, it is clear that they have heard that the reporting capabilities in Fusion Financials is quite extensive. It is not so clear that we have done a great job in explaining the capabilities. I will attempt to explain each of the solutions and point out the acronyms frequently used in conjunction with each solution and when you would use each of these solutions.
Oracle Transactional Business Intelligence for Financials
Frequently referred to as OTBI, this solution allows you to build ad hoc queries or reports using views on transactional 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) on any transaction without the need for a developer. A couple of examples would be Unpaid Supplier Invoices or Payments over $25,000. There are sorting, filtering, formatting capabilities with a variety of output options. 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.
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 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.
Hopefully, this gives a better idea of the reporting functionality within Fusion Financials, but if you have any questions, just leave me a comment, and I will respond or add a new blog post.