5/19/2018 Universe Creation

1/16

Universe Creation by using SAP

Query & Info cube as Data source

5/19/2018 Universe Creation

2/16

2

Available Data Sources

SAP BW Query.

SAP BW Info cube /Multiprovider

SAP BW Data Store Object SAP InfoSet

5/19/2018 Universe Creation

3/16

SAP BW Query as Data Source

To serve as a data source and become available through the

OLAP interface to Business Objects universes, BW queries

must be released for OLE DB for OLAP.

You allow external access to the BW Query in the SAP BW

Query Designer, on the Extended tab of the Query Properties

dialog box.

All Info Objects in the BW query selected as rows, columns,

and free characteristics are visible in the universe, includes

characteristics, hierarchies, key figures, structures, andvariables.

5/19/2018 Universe Creation

4/16

SAP BW Queries as recommended Data

Source

Not all BW metadata features can be retrieved on an InfoCube level.

5/19/2018 Universe Creation

5/16

SAP BW Info Cube as Data Source

Types of Info Cubes supported for Universes

are Standard , Transactional Info Cube and

Remote Info cube.

All the characteristics, hierarchies, key figures,

including time and unit, in the Info Cube are

visible in the universe.

5/19/2018 Universe Creation

6/16

Creating Universe using SAP Query

Start Designer (Start > Programs > Business Objects XI 3.1>Business objects Enterprise Client tools >Designer).

Enter BO

Credentials

5/19/2018 Universe Creation

7/16

Universe Parameters

Give the name of

the Universe

Click on the New

tab to create an

New Connection

5/19/2018 Universe Creation

8/16

Click Next

5/19/2018 Universe Creation

9/16

Name of theConnection

Click on the

SAP

5/19/2018 Universe Creation

10/16

Enter SAP BI Logon

Credentials and click

Next

5/19/2018 Universe Creation

11/16

Select the

Query

dependingupon the

Cube

Test the

connection and

click Next

5/19/2018 Universe Creation

12/16

Configuration

Parameters for

connection Time

Out and click Finish

5/19/2018 Universe Creation

13/16

Click on ok

5/19/2018 Universe Creation

14/16

Click on Save .

Its saves in the

Universes .uni as

file extension

Documents and Settings\Application Data\Business Objects\Business

Objects

5/19/2018 Universe Creation

15/16

File >Export

Now we can see

the Universe which

is created

5/19/2018 Universe Creation

16/16

File >Import

Below in the window

you can see theImporting been Done