1 / 11

OTBI Reporting - Challenges & Solutions

What is OTBI? <br>OTBI reports are standard out-of-the-box reports that Oracle provides when you go live with the SaaS applications.

SoniSplashBI
Download Presentation

OTBI Reporting - Challenges & Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Are you struggling with Cross Subject Area OTBI Reporting?

  2. Agenda What is OTBI Reporting? 1 2 What is Subject Areas? How to Create Reports in OTBI? 3 OTBI Challenges 4 5 How to overcome the OTBI Limitations?

  3. 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: • 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. • Absence Breakdown - This provides visual reports, where you can select your years and see how many hours of absence people have taken. • General Journals Report - 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. 

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

  5. How to Create Reports in OTBI? • Learn Subject Areas • Create reports from Scratch • Learn OTBI formatting/ How to add Prompts • Learn how to do Pivots/Charts • Learn changes in the OTBI Subject areas

  6. OTBI Challenges

  7. So, What are your options? • Use BI Publisher – more of a developer tool than an adhoc reporting solution for the end users. • Continue to use OTBI with its limitations • Buy Oracle Analytics Cloud ($$$) • Rely on an enterprise analytics solution - SplashOC

  8. What is SplashOC? SplashOC powered by SplashBI comes with tons of pre-built reports. Starting from elementary reports to extremely complicated cross-subject area reports. • 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 your Oracle Cloud applications. • There aren’t any RTF templates to be built. • No extreme knowledge of Entity-Relationship is required.

  9. Conclusion • SplashOC 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. • 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 SplashOC ($)

  10. Want to learn more? Check out our Blog to learn more in detail about OTBI & Its Limitations! Link to Blog - Struggling With Cross-Subject Area OTBI Reporting? Contact us or signup for a 14-day free trial! One of our experts will be happy to address your questions!

  11. Europe/Middle East/Africa Unit no 43 Sussex Innovation Centre, Sussex University, Brighton, England BN1 9SB Ph: +44 (0) 7775 653956 India H.NO. 17-1-383/M/31, Vinay Nagar Colony, Saidabad, Hyderabad, Telangana 500059, India Ph: +1 678-248-5756. United States (HQ) 3079 Peachtree Industrial Blvd. Duluth, GA 30097 , USA Ph: +1 678-248-5756.

More Related