What are the steps involved to design universe ?

building semantic layer
1

Hi All, can anybody help me with, like if i have given some 12 tables, and i have to create some 12 reports based on the user requirement, then please let me know how to proceed with the universe design from begining, i mean what are the steps involved from universe design till report creation ?..

mvijaypurna (BOB member since 2009-11-09)

2

Well, the basic universe design course is 3 days long. So it’s not really useful to supply a simple list of steps. I would strongly advise you to go and do some reading on universe design or possibly even get yoyurself onto a designer course if possible.

pablolee :uk: (BOB member since 2008-07-29)

3

If you haven’t designed a universe before, how come you have been given the work to do :? ?

I suggest that you need to go on a Designer course, for starters.

How good are your report specs, how descriptive are the table names?

Is there anyone that knows the database where you are working?

Mak 1 :uk: (BOB member since 2005-01-06)

4

Hi, Welcome to B:bob:B! As you have seen, general questions on BOB tend to get more general answers. I’ll try to give you some brief steps, but getting someone who is more experienced in universe design would be a big help. Training is also good. That being said…

  1. Establish your connection to the database
  2. Insert your 12 tables into your structure
  3. Create proper joins between your tables
  4. Create classes in a logical business-oriented structure
  5. Create objects from table columns as needed / required by your report specifications

To be honest, there’s a whole lot more, especially for steps 3, 4, and 5. You have to know how to recognize query loops and other SQL traps. You have to know your database functions in order to be able to leverage them during object creation. Hopefully you know SQL and you’re not trying to learn that at the same time.

Bottom line: everyone has to start somewhere, but universe design is generally a task given to someone with experience… or at least training. BOB is not going to be a substitute for training. :sunglasses:

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Surely step 1 is to talk to your users to establish their needs.

Damocles :uk: (BOB member since 2006-10-05)

6

That was mentioned in the opening post, but you’re right, if that hadn’t already been done.