Struggling with Cross-Subject Area OTBI Reporting?

Oracle’s cloud market shares are growing day by day. The three primary applications that are expanding very fast are: HCM Cloud, Oracle ERP Cloud and SCM Cloud.

Today we’re going to focus on OTBI, which comes as a part of your Oracle Application. And the agenda is – what are the challenges? Are you struggling with cross subject area reporting in OTBI? What are the solutions? What can you do? And we’re going to make some recommendations on how we can ease some of the struggles and pain points you experience while using.

What is OTBI?

OTBI reports are standard out-of-the-box reports that Oracle provides when you go live with the SaaS applications. There are several out of the box reports across different areas, such as:

1. HR reports

This is a detailed report which shows all the details of employees in the organization from an HR standpoint – their HR attributes, the location, job, etc.

2. Absence Breakdown

This provides visual reports, where you can select your years and see how many hours of absence people have taken.

3. General Journals Report

Similarly, there are other reports on the financial areas and supply chain. GL journal reports is when you export one of the standard OTBI reports to excel. It just shows you all the journal entries, and you can look at what entries are made in a time Range and for what organizations. They cover a wide area of your SaaS applications.

What is Subject-Areas?

All these reports that come out of the box are built on something called subject areas. Oracle has provided these pre-built subject areas, which are logical collections of similar attributes. Let’s say all the financials or all the general Ledger attributes are combined into one subject area and all the HR in another subject area.

It’s an approximate collection of all the data items you would want to report on, and these are all pre-built. And the expectation is that you can choose through these subject areas and build your reports if you like. You can use the Oracle out-of-the-box reports, or if it doesn’t meet your needs, you can create your own reports using these standardized subject areas.

When you choose a subject area after the fact, you are presented with this list of facts and dimensions: the folders and subfolders inside those, and there are individual fields. If you look at the bottom, you can drag and drop and build your own reports in OTBI if necessary.

OTBI Challenges

The OTBI cross-subject out-of-the-box reports are few and far between borderline non-existent, but only if you build your own. It takes quite some expertise to make it happen if you can do it, but it takes some time to learn to make it up. Once those reports are built, you run into other challenges, and that’s what we are hearing from our customers who have been in OTBI for several years.

• Missing data sets in the OTBI
• Cross subject area operational reports
• Cannot report off legacy/other applications
• No on-the-fly report modifications
• Payroll reports must be run from Payroll “flows”
• No multi-threaded reports
• 75,000-row limits
• Inability to add more subject areas
• No Excel Plug-in
• High Time-to-Value

BI Publisher and its Limitations

To overcome the OTBI limitations and challenges, BI Publisher is your answer. But to use BI Publisher you need –

• Comprehensive SQL Knowledge – It requires thorough SQL knowledge as you’ll have to write the actual SQL statements, which also requires the SQL syntax, experience, and understanding.

• Entity Relationship Knowledge – you also need to understand the entity-relationship between those different entities that the SAS application has. You must learn how those entities relate to each other.

• Data Security Missing – Unlike OTBI, the BI Publisher does not automatically inherit the data security profiles. So it’s on us as developers to build those security profiles back into the reports & if that extra care is not taken, the security will just not work. Everybody gets to see all data in those cases.

• No multi-threaded Reports – Just like OTBI, there is no straightforward way to do multi-threaded reports.

• RTF Templates Needed in Most Cases – RTF templates are required in most cases, once you write these data models. So once you create these SQL statements, to give them a visual appearance, we’re supposed to create RTF templates that feed off this data model and show data in a kind of a layout.

• Very High time-to Value – This also has a very high time to value because you first have to build these SQL statements with no defects. Because it’s so technical, it’s very easy to get defects around these. It takes a while to resolve the problems, and if it will, we have to build RTF templates that will produce the visual reports for you.

It looks like the first option is OTBI and the second option is the BI Publisher.
BI Publisher is quite technical in some cases, but then the other option is to limit it. So, there isn’t a middle ground, apparently that you want to be on that. So, what is the other option that you want to go for?

The other option that we are proposing, and many of our customers have been using already, is SplashBI. It has developed a so-called middle ground that overcomes a lot of these challenges and simplifies all of these problems.

Enters…. SplashBI for Oracle Fusion Cloud powered by SplashBI

SplashBI for Oracle Fusion Cloud powered by SplashBI comes with tons of pre-built reports. Starting from elementary reports to extremely complicated cross-subject area reports.

Key-Highlights –

• These reports don’t have 75,000-row limits.
• There’s also an Excel Plugin that does complete ad hoc changes in Excel and still reports off of your Oracle Fusion Cloud applications.
• There aren’t any RTF templates to be built.
• No extreme knowledge of Entity-Relationship is required.

So all of those problems disappear because these reports are pretty much pre-built out of the box to execute.

It also shows you the past executions of the report, so it remembers the history.
Once your report is completed, you can see the results in these many formats: HTML, PDF, CSV…But usually, Excel is the most popular one. So in which case, if you click on Excel, it downloads a spreadsheet just like any other ordinary spreadsheet, and then you can pop it open, just like any other spreadsheet does. So it brings in all of your Oracle SaaS application data into one simplified view.

Also, we have about 563 reports to be precise, that are pre-built out of the box, which will run off the SAS application in SplashBI. There are 233 HCM reports, 169 for financials. And these numbers are growing, and we add more reports as the new functionality comes in.

We keep an eye on how Oracle is evolving the ERP application or the HCM application. And we go and manage & maintain these reports. So the burden of management and maintenance is not on you as customers, it’s on us to keep them up to date with all of the progress in the Oracle Applications per se. So you don’t have to keep an eye on all the subject area evolution yourselves.

Conclusion

In conclusion, these are the available options –

• Continue to use OTBI?
• Learn SQL and use BI Publisher.
• Buy Oracle Analytics Cloud ($$$)
• Oracle Cloud Reports with SplashBI for Oracle Fusion Cloud ($)

SplashBI for Oracle Fusion Cloud fills and complements the gaps that you’re experiencing right now with OTBI using the SplashBI cloud reports. OTBI provides you the real-time analytical capability of the current state of your business based on the latest and greatest information from the transactional system. However, it falls short when we start talking about historical snapshots of the data, cross-subject reporting, trending off your KPIs tracking changes over time.

SplashBI fixes all those problems & fills the gap that OTBI cannot do.