What was the 1Z0-591 exam?
1Z0-591 was “Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials.” Per Oracle’s own product data, it ran 120 minutes with a 63 percent passing score and listed at 245 US dollars. It was a partner-facing Implementation Essentials credential covering Oracle Business Intelligence Enterprise Edition 11g. The exam is retired, and Oracle succeeded OBIEE with Oracle Analytics, whose exam 1Z0-1041 covers the same ground plus a substantially wider scope.
The Best-Documented of the Retired Oracle Exams
Most retired Oracle exams are difficult to research because Oracle’s exam pages loaded their details through JavaScript, so archived copies preserved the field labels but not the values. 1Z0-591 is an exception: Oracle’s product data for it was captured intact, which is why this page can state its format with confidence where the others cannot.
From Oracle’s own data:
- Exam title: Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials
- Duration: 120 minutes
- Passing score: 63 percent
- Price: 245 US dollars, with a separate Japanese SKU listed at a different price
Oracle’s recommended preparation for the exam included the courses “Oracle BI 11g R1: Build Repositories” and “Oracle BI 11g R1: Create Analyses and Dashboards”, alongside the Oracle Business Intelligence Learning Subscription.
Those two course titles describe the exam’s two halves neatly, and they map onto the genuinely distinct skills OBIEE required.
The Two Halves of OBIEE Work
Building the repository was the harder and more distinctive half. The OBIEE repository, edited in the Administration Tool and stored as an RPD file, defined a three-layer model: a physical layer describing the actual data sources, a business model and mapping layer expressing the logical dimensional model, and a presentation layer controlling what end users saw.
That layered model was the platform’s defining idea. Business users wrote queries against friendly subject areas, and the server translated those into SQL against whatever physical sources actually held the data. Getting the middle layer right, defining logical tables, dimensions, hierarchies, and aggregate navigation correctly, determined whether the whole system worked. A poorly modelled repository produced wrong numbers or unusable performance, and neither was obvious until users hit it.
Building analyses and dashboards was the consumption half: creating reports, assembling dashboards, applying prompts and filters, and setting up delivery. More approachable, and closer to what most people picture when they hear business intelligence.
The Essentials designation marked this as a partner-facing implementation credential, aimed at people deploying OBIEE for customers rather than at end users.
What Replaced It
Oracle succeeded OBIEE with Oracle Analytics, delivered as Oracle Analytics Cloud and, for on-premises deployments, Oracle Analytics Server.
The current exam covering that ground is 1Z0-1041, which encompasses the 1Z0-591 material and extends well beyond it, adding Essbase, dimensional modelling, spatial intelligence, and machine learning. That is a genuinely broader credential rather than a rebadged version of the old one.
This continuity is worth emphasising because it is unusual. Many retired vendor certifications point at products that were sold to another company or discontinued outright. OBIEE was succeeded within Oracle by a product line that a holder of the old credential can recognise and build on.
What This Knowledge Is Worth Today
As a current certification, it is expired, being version-locked to 11g.
As evidence of dimensional modelling capability, it holds up genuinely well, because the hard part of OBIEE was never the tool.
What transferred:
The repository modelling skill is the durable asset. Understanding facts and dimensions, grain, conformed dimensions, slowly changing dimensions, and aggregate navigation is dimensional modelling theory, not Oracle product knowledge. That theory underpins every modern semantic layer, and semantic layers came back into fashion after a period when the industry tried to do without them. Anyone who has built a working OBIEE repository has done the thing that modern semantic layer tools ask for, under a different name.
The discipline of separating physical sources from a logical business model from a presentation layer is exactly the separation modern analytics stacks reintroduce.
What did not transfer: the OBIEE Administration Tool itself, the RPD file format, the 11g deployment and patching model, and the assumption of on-premises infrastructure.
How to present it. Name it accurately with its version: “Oracle Business Intelligence Foundation Suite 11g Essentials (1Z0-591).” If dimensional modelling is relevant to the role you are pursuing, say that explicitly in an experience bullet, because a reader unfamiliar with OBIEE will not infer it from the exam title, and it is the part that still matters.
Where the Path Leads
If you still work in the Oracle analytics ecosystem, 1Z0-1041 on Oracle Analytics is the direct continuation. Your 11g modelling knowledge is real preparation for it, and the gaps are the newer areas the current exam adds.
If you moved to a modern analytics stack, your background is more relevant than the product’s age suggests. Cloud data warehouses paired with semantic layer tooling ask the same modelling questions OBIEE asked. The vocabulary changed and the tools are different, but defining a business model over physical data so that non-technical users can query it safely is the same problem.
If you moved toward data engineering, the modelling half transfers and the delivery half matters less. Understanding grain and conformed dimensions makes warehouse design substantially easier.
Verify current Oracle exam codes and requirements directly with Oracle before planning study, since its certification catalogue changes and its exam pages are dynamically generated.
Frequently Asked Questions
Can I still take 1Z0-591? No. The exam is retired and version-locked to OBIEE 11g.
What was the exam format? Per Oracle’s own product data: 120 minutes with a 63 percent passing score, listed at 245 US dollars.
What replaced OBIEE? Oracle Analytics, delivered as Oracle Analytics Cloud and Oracle Analytics Server. The current exam is 1Z0-1041, which covers the 1Z0-591 material plus Essbase, dimensional modelling, spatial intelligence and machine learning.
What did the exam actually cover? Oracle’s recommended preparation was “Oracle BI 11g R1: Build Repositories” and “Oracle BI 11g R1: Create Analyses and Dashboards”, reflecting the two halves of OBIEE work: repository modelling and report and dashboard construction.
Is the knowledge still relevant? The dimensional modelling half is, strongly. Facts and dimensions, grain, conformed dimensions and aggregate navigation underpin modern semantic layer tooling. The OBIEE Administration Tool and RPD specifics are not.
Does the Essentials designation mean it was introductory? It indicated a partner-facing implementation credential, aimed at people deploying OBIEE for customers rather than at end users.
References
Oracle. Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials, exam 1Z0-591. Oracle Education product data, archived August 2020. https://web.archive.org/web/20200827183440/https://education.oracle.com/ccstoreui/v1/products/pexam_1Z0-591 (Primary source for the exam title, 120-minute duration, 63 percent passing score, 245 US dollar list price, and the recommended preparation courses)
Oracle. Oracle Analytics. https://www.oracle.com/business-analytics/ (Current product line succeeding OBIEE, delivered as Oracle Analytics Cloud and Oracle Analytics Server)
Oracle. Oracle Certification. https://education.oracle.com/certification (Current Oracle certification catalogue, including the Oracle Analytics exam 1Z0-1041)