Oracle BI
OBIEE, RPD modeling, dashboards, BI Publisher, OAC & ETL
Oracle Business Intelligence interview questions on OBIEE architecture, RPD data modeling, analytics dashboards, BI Publisher, Oracle Analytics Cloud, ETL processes, and administration.
OBIEE10 topics
OBIEE Architecture & Components
Understand the layered architecture of OBIEE — Presentation Services, BI Server, and the underlying data sources — and how a request flows through them.
BI Server (NQSServer) Query Processing
Explain how the BI Server turns logical SQL into an optimized physical query plan, including navigation, aggregate awareness, and federation.
Presentation Services & Catalog
Understand the role of Presentation Services and the web catalog in storing dashboards, analyses, and permissions.
OBIEE Caching Strategy
Explain how BI Server query result caching works, including cache hit criteria, seeding, purging, and its trade-offs versus real-time reporting needs.
Security Model: Authentication & Authorization
Distinguish authentication (who you are) from authorization (what you can see/do) in OBIEE, and how Application Roles, groups, and RPD security tie together.
Usage Tracking & Query Auditing
Explain how OBIEE captures query-level usage statistics for performance tuning, adoption analysis, and auditing.
OBIEE vs Oracle Analytics Server (OAS) vs OAC
Clarify the product lineage and key differences between legacy OBIEE, on-premise Oracle Analytics Server, and cloud-based Oracle Analytics Cloud.
Session & Repository Variables
Distinguish repository (static) variables from session (dynamic/system/non-system) variables and how each is used in security, personalization, and dynamic filtering.
iBots / Agents & Alerts
Explain how scheduled agents (formerly iBots) deliver proactive, condition-based alerts and content distribution in OBIEE.
High Availability & Clustering
Explain how OBIEE scales horizontally and achieves high availability through clustered BI Server and Presentation Services instances behind a load balancer.
RPD10 topics
RPD Three-Layer Architecture
Explain the Physical, Business Model & Mapping (BMM), and Presentation layers that make up the OBIEE repository and why the separation matters.
Physical Layer Joins & Connection Pools
Understand how physical table joins, keys, and connection pools are configured to enable correct and efficient query generation.
Business Model & Mapping: Logical Joins & Fact-Dimension Design
Explain how logical dimension and fact tables are modeled in the BMM layer with logical joins, and why this differs fundamentally from physical joins.
Aggregate Tables & Aggregate Navigation
Explain how aggregate tables are registered in the RPD so the BI Server automatically routes queries to the smallest sufficient grain.
Hierarchies, Levels & Drill-Down
Explain how dimensional hierarchies and levels enable both business-user drill-down and aggregate navigation in the RPD.
Logical Table Sources & Fragmentation
Explain how fragmentation content rules split logical fact/dimension data across multiple physical sources (e.g., by region or date range) for query efficiency.
Presentation Layer Design & Subject Areas
Explain best practices for organizing the Presentation layer into intuitive subject areas, folders, and columns for business users.
Slowly Changing Dimensions in the RPD
Explain how Type 1 and Type 2 slowly changing dimension patterns are modeled and reported on within the RPD's logical layer.
Multi-Fact Modeling & Chasm/Fan Traps
Explain how combining multiple logical fact tables at different grains in one query can produce chasm or fan traps, and how OBIEE's BMM design avoids them.
RPD Development Workflow: Multiuser Development & Deployment
Explain how teams collaborate on a single RPD using Multiuser Development (MUD) and how changes are deployed across environments.
Analytics8 topics
Building Analyses: Criteria, Layout & Views
Explain the core workflow of building an OBIEE analysis — selecting criteria columns, adding filters, and composing views for presentation.
Filters, Prompts & Presentation Variables
Distinguish column filters, dashboard prompts, and presentation variables, and explain how they interact to create dynamic, interactive dashboards.
Action Links & Navigation
Explain how Action Links enable navigation between analyses/dashboards and invocation of external processes directly from report values.
Calculations: EVALUATE, FILTER, and Level-Based Measures
Explain how EVALUATE, FILTER, and level-based (context-changing) formulas let analysts write calculations OBIEE's standard aggregation model can't express directly.
Time Series Functions: AGO, TODATE, PERIODROLLING
Explain OBIEE's built-in time-series calculation functions and how they depend on a properly modeled Time hierarchy.
Scorecards & KPIs
Explain how OBIEE Scorecard functionality models KPIs, targets, strategy trees, and initiatives for performance-management reporting.
Conditional Formatting & Data Visualization Best Practices
Explain how conditional formatting rules and visualization choices communicate insight effectively rather than just displaying numbers.
Dashboard Design & Performance Optimization
Explain how dashboard structure, page layout, and query design choices affect load performance and user experience at scale.
Publisher8 topics
BI Publisher Architecture & Data Model Basics
Explain BI Publisher's core architecture — data models, layout templates, and the report engine that merges them — and how it differs from OBIEE Answers.
RTF Templates & Word Plugin Syntax
Explain how BI Publisher's RTF template syntax (for-each loops, conditionals, placeholders) is embedded in Microsoft Word to produce data-driven documents.
Data Model: SQL, Sub-Queries & Multiple Data Sets
Explain how BI Publisher data models combine multiple queries, parameters, and linked sub-queries into a single structured XML output.
Bursting: Splitting and Delivering Reports at Scale
Explain how BI Publisher's bursting engine splits a single large report into per-recipient documents and delivers each via different channels automatically.
Scheduling & Job Management
Explain how BI Publisher schedules recurring report jobs, manages job history/retries, and integrates with enterprise schedulers.
Sub-Templates, Style Templates & Reusability
Explain how sub-templates and style templates promote reuse and consistency across many BI Publisher report layouts.
Integrating BI Publisher with OBIEE and E-Business Suite
Explain the common integration patterns connecting BI Publisher with OBIEE subject areas and Oracle E-Business Suite/ERP data sources.
Output Formats, Fonts, Barcodes & Localization
Explain how BI Publisher handles multiple output formats, embedded barcodes/special fonts, and multi-language/locale-aware document generation.
OAC7 topics
OAC Data Visualization: Projects, Workbooks & Canvases
Explain the core Data Visualization (DV) building blocks in Oracle Analytics Cloud — projects, datasets, and canvases — and how they differ from RPD-based subject areas.
OAC Datasets: Preparation, Joins & Data Enrichment
Explain how OAC datasets are prepared, cleaned, joined, and enriched before being used in Data Visualization projects.
Data Flows: Building Reusable Data Pipelines in OAC
Explain how OAC Data Flows let users build reusable, multi-step data transformation and machine learning pipelines without writing ETL code.
Machine Learning & Auto Insights in OAC
Explain OAC's built-in machine learning capabilities — Auto Insights, Explain, and custom ML models within Data Flows — and how they augment traditional BI analysis.
OAC Connectivity: Remote Data Gateway & Cloud Data Sources
Explain how OAC connects securely to on-premise data sources via the Remote Data Connector/Gateway, alongside native cloud data source connectivity.
OAC Security: Roles, Application Roles & Data Access
Explain how OAC's cloud-native security model (Identity Cloud/OCI IAM roles, Application Roles, and dataset-level access) compares to on-premise OBIEE security.
Migrating from On-Premise OBIEE to OAC
Explain the technical and organizational considerations involved in migrating an existing OBIEE/OAS deployment to Oracle Analytics Cloud.
ETL7 topics
Star Schema Design for BI Reporting
Explain star schema design principles — fact and dimension tables, grain, conformed dimensions — as the foundation for OBIEE/OAC reporting performance and usability.
Slowly Changing Dimensions: ETL Implementation Patterns
Explain how SCD Type 1, Type 2, and Type 3 patterns are actually implemented in an ETL load process, complementing the RPD-side SCD topic.
Incremental Loads & Change Data Capture
Explain how incremental load strategies and change data capture (CDC) avoid full table reloads while keeping a warehouse current and consistent.
Oracle Data Integrator (ODI): Architecture & Knowledge Modules
Explain ODI's E-LT architecture and its Knowledge Module concept, and how it differs from traditional ETL tool architectures.
Data Quality & Cleansing in the ETL Pipeline
Explain where and how data quality checks and cleansing rules are enforced in an ETL pipeline before data reaches BI reporting layers.
Fact Table Design: Additive, Semi-Additive & Non-Additive Measures
Explain the difference between additive, semi-additive, and non-additive measures and why this distinction determines correct aggregation logic in a warehouse and RPD.
ETL Orchestration, Error Handling & Restartability
Explain how production ETL pipelines are orchestrated with dependency management, error handling, and restart/recovery capability.
Admin5 topics
Catalog Management: Permissions, Archiving & Cleanup
Explain how BI administrators manage catalog folder permissions, perform archive/migration operations, and keep a large web catalog clean and performant.
Performance Tuning: End-to-End Diagnosis
Explain a systematic approach to diagnosing OBIEE performance problems across the full stack — network, Presentation Services, BI Server, RPD, and database.
WLST Scripting for OBIEE/OAS Administration
Explain how the WebLogic Scripting Tool (WLST) is used to automate common OBIEE/OAS administrative tasks that would otherwise require manual console operations.
Patching, Upgrades & Environment Promotion
Explain the operational process and risk considerations for applying patches, performing version upgrades, and promoting changes safely across OBIEE/OAS environments.
Monitoring, Alerting & Capacity Planning
Explain how a production OBIEE/OAC deployment is proactively monitored for health and capacity, closing the loop from reactive troubleshooting to preventive operations.