You can also create a Universe on top of an OLAP cube or query. When a connection is selected pointing to an OLAP cube, it creates a Universe automatically. Connection to an OALP data source can be created using connection wizard.

Following OLAP data sources can be used to create OLAP Universe automatically −

SAP Business Warehouse
Microsoft Analysis Service MSAS
Hyperion Essbase

While using SAP BW as an OLAP data source for Universe creation, you can create Universe directly on an Info Cube, Bex or on an info Provider. You can use standard and transactional info cubes to create OLAP Universe or you can also use virtual info cubes.

In an OLAP Universe built on SAP BW data source, different Universe features are supported. Below table lists common supported features −

Characteristics (incl. Time and Unit)	InfoCube/BEx Query
Hierarchies	InfoCube/BEx Query
Basic Key Figures	InfoCube/BEx Query
Navigational Attributes	BEx Query only
Display Attributes	InfoCube/BEx Query
Calculated Key Figures / Formulas	BEx Query only
Restricted Key Figures	BEx Query only
Custom Structures	BEx Query only
Variables	BEx Query only

You can see Bex queries supported more Universe features as compared to InfoCube and InfoCube requires more effort to customize Universe.

While using MSAS as data source, you can see features supported in an OLAP Universe in the below table −

Cube	Supported
Local cube	Supported
Virtual cube (MSAS 2000)	Supported
Perspective (MSAS 2005)	Supported
Dimensions	Supported
Virtual dimensions (MSAS 2000)	Supported
Hierarchies	Supported
Levels	Supported
Level Property	Supported
Attributes (MSAS 2005)	Supported
Measures	Supported
Measure group (MSAS 2005)	Supported
Calculated measures	Supported
Display folder (MSAS 2005)	Supported
KPI (MSAS 2005)	Not Supported

While using Hyperion Essbase as data source, you can see features supported in an OLAP Universe in the below table −

Block storage mode	Supported
Aggregate storage mode	Supported
Hybrid mode	Not Supported
Alias tables	Supported
Dimensions	Supported
Attribute dimensions	Supported
Duplicate members	Supported
Generations	Supported
Levels	Not Supported
User Define Attributes (UDA)	Not Supported
Dynamic Time Series (DTS)	Not Supported
Essbase Integration Services (EIS) Drill-through	Not Supported
Substitution variables	Not Supported
Linked partitions	Not Supported

Using Connection Wizard

You can open connection wizard by clicking on New button in the New Universe creation page or you can navigate to Tools → Connections. Click Add in the “Wizard Connection” dialog box.

In the next window, you need to select Connection Type. The following connection types are supported by SAP Universe −

Secured
Shared
Personal

Connection Type

Select Secured for controlled access to the connection (recommended).

Select Shared to allow uncontrolled access to the connection to all users.

Select Personal to restrict access to the universe creator. You can use personal connections to access personal data on a local machine only.

sap 97

When you click on Next button → You can see the list of available data access drivers.

You can also launch connection wizard from Quick Design wizard. Click on Begin button as shown below and it will take you to Define Universe parameter window.

sap 98

To open connection wizard, click on New button.

sap 99

You can also check connection properties of an existing connection. Connection properties window of a connection shows the below fields −

General
Login Parameters
Configuration Parameters
Custom Parameters
Rights

So, this brings us to the end of blog. This Tecklearn ‘OLAP Data Sources in SAP Universe Designer’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP IDT and UDT and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

799