SAP BusinessObjects

Business Objects data

Coming soon

Prepare

Upload SAP BusinessObjects files

Guide

BusinessObjects is a business intelligence platform with a metadata-driven universe layer that defines semantic business models.

Planned Support

Universe metadata extraction (.unv files)
Report definition parsing (.rep files)
Relationship and dimension mapping
Business model documentation

What You Get Out

Once the parser ships, DataMeans will extract your data into multiple modern formats:

Output	Description
`csv/{TableName}.csv`	One CSV file per table with all row data
`xlsx/{TableName}.xlsx`	Excel workbook per table
`xls/{TableName}.xls`	Legacy Excel format per table
`json/{TableName}.json`	JSON array of records per table
`json/{TableName}.jsonl`	Newline-delimited JSON (streaming-friendly)
`postgres.sql`	PostgreSQL CREATE TABLE + INSERT statements
`schema/schema-graph.json`	Relationship graph for visualization
`schema/er-model.json`	ER model for diagram tools
`report.json`	Structured extraction report
`report.md`	Human-readable extraction summary

File Requirements

.unv (universe metadata)
.rep (report files)

Current Status

Parser development is in the planning phase. The complex proprietary format requires specialized reverse-engineering.

Technical Notes

BusinessObjects universes contain complex expression language for calculated members and relationships. Documentation became fragmented after SAP acquisition.

Last updated: January 2026

Technical reference

Overview

SAP BusinessObjects is an enterprise business intelligence and analytics platform that provides self-service reporting, dashboards, and data visualization capabilities. It employs a semantic layer architecture with "universes" that create abstracted business views of underlying data sources, supporting OLAP analysis, ad-hoc queries, and complex calculations. Unlike traditional databases, BusinessObjects focuses on metadata-driven reporting with proprietary formats for storing business logic, data relationships, and presentation layers in enterprise environments.

History and Background

1990: Business Objects founded in France by Bernard Liautaud and Denis Payre; its first product, Skipper SQL 2.0, ships the same year.
1994: BusinessObjects 3.0 released; the company lists on the NASDAQ, the first French software company on a United States exchange.
1996: BusinessObjects 4.0 released as the company enters the OLAP market.
1997: WebIntelligence thin client introduced for web-based reporting.
2000: Business Objects acquires OLAP@Work for approximately $15 million.
2002: Business Objects acquires Acta Technologies.
2003: BusinessObjects Enterprise 6 released.
2003: Business Objects acquires Crystal Decisions for $820 million.
2004: Crystal v10 and BusinessObjects 6.5 released.
2005: BusinessObjects XI released, built on the Crystal Enterprise platform; BusinessObjects Enterprise XI Release 2 follows the same year.
2007: SAP announces its acquisition of Business Objects for $6.8 billion; the deal completes in January 2008.
2011: SAP BusinessObjects BI 4.0 released with the Information Design Tool and the .unx universe format.
2025: SAP BusinessObjects BI 2025 released, retiring the .unv universe format and the Universe Design Tool.

File Format Specifications

BusinessObjects stores universes and report documents in proprietary formats managed through a central repository.

File Extensions:

.unv - Universe created with the Universe Design Tool (semantic layer)
.unx - Universe created with the Information Design Tool (BI 4.0 and later)
.rep - Desktop Intelligence report document
.wid - Web Intelligence document
.biar - Business Intelligence Archive Resource for content import and export
.blx - Business layer resource in an Information Design Tool local project
.dfx - Data foundation resource in an Information Design Tool local project
.cnx - Local connection stored in an Information Design Tool project
.cns - Connection shortcut referencing a connection published to the repository
.lcmbiar - Life Cycle Management archive used by Promotion Management in BI 4.x

File Structure:

Universe (.unv): Proprietary binary file defining classes, objects, and joins
Universe (.unx): Compiled from a business layer, data foundation, and connection resources
Report (.rep): Desktop Intelligence document with query definitions and layout
WebI (.wid): Web Intelligence document containing queries, data, and report layout
Security: Access control through CMS (Central Management Server)
Connections: Metadata for data source connections stored in the repository

Key Components:

Classes: Business groupings of objects
Objects: Dimensions, measures, and details
Joins: Relationships between tables in the schema
Contexts: Resolve join path ambiguities
Prompts: User-defined query parameters
Derived tables: Virtual tables defined by an SQL expression rather than a physical table
Lists of values: Data values associated with an object, used to choose values in query filters

Data Types and Structures

Type	Description	Notes
Character	Text strings	Object data type
Number	Numeric values	Object data type
Date	Date and time values	Object data type
Long Text	Extended text content	Object data type
DateTime	Combined date and time values	Business layer data type (`.unx`)
Boolean	True or false values	Business layer data type (`.unx`)
Blob	Binary large object content	Business layer data type (`.unx`)
Dimension	Focus of analysis, such as customer or year	Object qualification
Measure	Numeric values aggregated by functions such as sum or count	Object qualification
Detail	Descriptive attribute associated with a dimension	Object qualification
Attribute	Descriptive information attached to a dimension, hierarchy, measure, or level	Object qualification in `.unx` universes

Semantic Model:

Universes provide business terminology over technical schemas
Classes organize related objects hierarchically
Objects can be dimensions (grouping), measures (calculations), or details
Predefined conditions and filters restrict query results
Hierarchies support drill-down analysis

Version Differences

Version	Year	Key Changes	Compatibility
4.0	1996	OLAP support	Full-client `.rep` documents
6.5	2004	Released alongside Crystal v10	Final pre-XI platform release
XI	2005	Platform merged with Crystal Enterprise	Internal version 11.0
XI R2	2005	Platform update (codename Jupiter)	Internal version 11.5
XI 3.0	2008	Platform update (codename Titan)	Internal version 12.0
XI 3.1	2008	Final XI-generation platform release	Internal version 12.1
BI 4.0	2011	Information Design Tool, `.unx` universes	Desktop Intelligence (`.rep`) removed
BI 4.1	2013	Desktop Intelligence Compatibility Pack	Internal version 14.1
BI 4.2	2016	Parallel queries, BI Commentary	Supports both `.unv` and `.unx` universes
BI 4.3	2020	Redesigned BI Launch Pad, SAP Analytics Cloud integration	Flash-based Dashboards and Explorer removed
BI 2025	2025	Year-based release naming	`.unv` universes and Universe Design Tool removed

Compatibility Notes:

.unv universes can be converted to .unx using the Information Design Tool
Desktop Intelligence (.rep) documents require conversion to Web Intelligence (.wid) via the Report Conversion Tool
BI 4.1 added a Desktop Intelligence Compatibility Pack, discontinued in BI 4.3
BI 2025 supports only .unx universes, so .unv content must be converted before upgrading
Only relational and stored-procedure .unv universes can be converted to .unx; OLAP .unv universes must be rebuilt in the Information Design Tool
The Upgrade Management Tool imports XI Release 2 and XI 3.x content into BI 4.x, including .biar files created with the Import Wizard
Promotion Management in BI 4.x cannot import .biar files created in XI 3.1

Technical References

To learn how to use this format with DataMeans, see the User Guide.

Convert a SAP BusinessObjects file