Photo by Scott Graham on Unsplash

Oracle OTBI For Beginners

I am starting a new video series on YouTube, focusing on OTBI (Oracle Transactional Business Intelligence) for beginners. I am hoping this will help anyone who is getting started on Oracle Cloud and wants to learn about creating repors and analysis.

Using BI Composer

The first two videos focus on using BI composer to create and edit an analysis.

  • Create formula columns
  • Add new sorting options
  • Delete existing sorting options
  • Include multiple views in the analysis (table and chart)
  • Provide prompt to the graph section to filter data based on the selection
  • Add and Edit Filters
  • Exclude columns from the view
  • Move columns to Table Prompts
  • Preview Results
  • Export Data for preview in PDF
  1. Column Header Styling Options
  2. Data Formatting
  3. Conditional Formatting
  4. Add Analysis Prompt
  1. Create Summary Analysis
  2. Enable Drill Down from Summary Analysis to Detailed Analysis
  1. Create Summary Analysis
  2. Enable Drill Down from Summary Analysis to Detailed Analysis
  3. Configure conditions for Drill Down

Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store