Creating universe from scratch

[Former Member]

Is there any case study document or tutorial that lists down the step for creating universe for some specific domain/ project etc.

I am looking for creating symentic layer (what data model do we require/ recommend) and to start creating the webi reports then

[Former Member]

You can refer the below link on Universe Desinger:

http://help.sap.com/businessobject/product_guides/boexir31/en/xi31_designer_en.pdf

What is your database??

Oracle:

1. Open Universe Designer --> After successful log-in.

2. Name the Universe

3. Connection parameter --->> Click New

Now you can see Connection wizard

4. Next-->>

5. In list of Datasources -->> Select Oracle or any datasource(which you have)

6. user credentials and Service Name (You can findit in TNSNAMES.ora file -- only incase of Oracle)

7. Next--Next --Finish

8. Go to Universe Structure pane...

Right-click ===>> Import Tables.(as many you need)

and Join those tables like any schema (STAR, Snow-flake etc...,)

9. Create your classes and objects

10. Export to repository.

Above steps if you are working with Oracle.

Steps may vary in case of other datasources (Exactly from Step:6)

MS-Access/ Excel and SQL Server , you have to create DSN(Data Source Name).

Hope it clears your doubts.

Good luck...

I'm Back

[Former Member]

You find more info here:

I'm Back

[Former Member]

Hi,

Your universe will be more or less a replication of your data model. If you want to build a universe from scratch, Universe Designer document available in http://help.sap.com can be a good start to understand all the basics of the universe design.

Regards,

Sanjay