What things need to know from User?

[system]

I am Building the universe and would like to know what are the things i need to ask from User before we start building Universe in DB2(database).
how to know which join to implement between tables?If i use context which join should i need to put in that context if i have to implement context?

Thanks
Pooja

---

ktm (BOB member since 2008-11-12)

[system]

Pooja,
Your questions seem to be elementary. If you are not familiar with universe building via Designer, then perhaps a couple of searches on BOB might help you to see and consider more aspects in moving forward.

In addition to your searches, here is one topic that has a lot of meat to it:

Design Debate

I’m seeking expert advice from the gurus We recently had a debate on the Universe design process within our team. Scenario: We have a highly normalized (3NF) database which has about 1000 tables with almost 10-12 subject areas. The debate is that once section including the some IT and business users argue that they prefer a Single BO universe so that it will help them to do adhoc reporting, myself and some IT guys were on the other side of the table were we argued on multiple universes based…

Another helpful text, which you can explore more via the “Shop@BOB” link at the very bottom of all BOB pages, is the text “BusinessObjects The Complete Reference”, written by Cindi Howson. If you read the reviews and would like to purchase your own copy of the book from Amazon.com, then be sure to link to Amazon via Shop@BOB so that a small portion of the profits can be directed back to BOB…

Thanks,
John

---

jsanzone (BOB member since 2006-09-12)

[system]

Hi Pooja,
1.High level design or Technical Specification Document for universe,where in you capture all the details right from the classes and objects which you are going to create in universe,Predefined Condition etc

2.Better to have the Data model of the particular Database ,so it is easy to understand the relationships between the tables.

---

Rajasekar (BOB member since 2004-07-16)