olap vs rdbms universe

building semantic layer
1

Please let me know what is olap universe and rdbms universe

Thanks

sri9 :india: (BOB member since 2011-05-10)

2

Hi

Olap universe is a universe that uses the processed OLAP-cube, ex Microsoft-cube, Oracle-cube, Essbase-cube. The logic is already created in the cube, and the universe presents the cube layout.

RDBMS-universe is a universe that uses tables from a database. The universe must be built with joins between the tables (if there are many tables).

/Björn

Bjorn :sweden: (BOB member since 2006-02-10)

3

hi
thanks for reply

by creating a secured connection to sql 2008 server (data source) created a universe and does some webi reports

so can i call it as olap universe or rdbms universe

sri9 :india: (BOB member since 2011-05-10)

4

Hi again

You can only call it a OLAP-universe if you are using the Cube that has been processed by MicrosoftAnalysisServices-tool. When creation the OLAP-universe, universedesigner automaticly creates all the dimension-objects and measures, according to the cube-definition. When creating a connection for a cube universe, the connection must refer to the cube. The connection also uses MSAS middleware.

If you have created a universe and added TABLES to your universe, and then created the universe objects, then you have a RDBMS-universe. You also uses SQL-server as th middleware.

In your case it looks like a RDBMS-universe.

/Björn

Bjorn :sweden: (BOB member since 2006-02-10)