before universe

Hi All,

I want to build a universe. what steps I must follow.

Note: like initially source system study.

Thanks,
Rakesh K


Rakesh_K :india: (BOB member since 2007-12-11)

  • Make sure you have a good understunding of the Data model
  • Understand the business reporting requirements
  • Who’s your audience: End uses for Adhoc or more technical report writers.
  • Whats the source i.e. Cubes (gives you less universe flexibility) or a “normal” datawarehouse
  • How many universes will be created

Tip: If the universe is meant for end-user adhoc stuff, Keep it simple so that everyone can write simple to medium complex reports.

Make sure the naming of your dimension and measure objects are in line with the actual business.

Use the description field for the objects.

Involve the end-user in the design phase i.e. organise a few workshops so that they can have their say as well. This will make them feel more involved and most of the time more positive.

Keep the universe tidy. Do a regular cleanup so that there are no objects that are not used anymore.

Thats all I can think of on this lovely sunday morning

Regards
Rim Geurts


RGeurts :uk: (BOB member since 2006-12-29)

I highly recommend the universe design class. There is far more to bulding a universe than can be explained here.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I can only agree with Michael. And I often wonder, why a company dashing out money for the software, does not consider dashing out money for training its staff.
Now, if you are a consultant/contractor at a client, then your consulting company should send you to training before you start at the client.


Andreas :de: (BOB member since 2002-06-20)

I am having a sound knowledge on Business Objects, but now I would like to add some ETL tools and Data Modeling things to my profile (in near future), so just I want to know where to start.


Rakesh_K :india: (BOB member since 2007-12-11)

Rakesh, See the Blog post of Josh Universe Design Best Practices.


Arjun (BOB member since 2008-07-28)