Understanding Reporting in Fusion Financials

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.

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.

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

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.


Comments:

Joe,
This is a nice explanation, the reporting options are extensive and deciding which to use for what is key. Must get this word out!

Posted by David Haimes on May 26, 2012 at 12:33 AM PDT #

In order to use OTBI with Fusion Apps, do you need to have BI foundation suite as well?

Posted by guest on February 22, 2013 at 07:41 PM PST #

Question - are there any out of the box management reports that are standard in Fusion, e.g. income statement, balance sheet, etc.?

Posted by k c peascoe on February 06, 2014 at 03:12 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

This blog will be used by Financials Strategy group to discuss various Fusion Financials topics. Want to know more? Just ask.

Search

Categories
Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today