1. Prepare and Analyze Before you touch the Universe Designer
Well, Most of the designers make this mistake and they jump directly on designer. But this might end up you in future Universe Maintenance problems. Understanding the data source on top which universe to be developed is very important. The Universe designer must understand the tables, type of data stored in those tables, relationship between tables, Business terms and their meaning, any specific formula which will be used to derive the measures. Understand Reporting need and what all tables are required to feed the data to reports.
2. Plan the Universe.
Before you actually start building the Universe plan it well in advance. Identify number of universes required for reporting. Identify mesures, dimensions and details objects. Try to document it well and in detail. This would be a Universe blueprint which will help while actually desiging the universe.
3. Implementation or Actual Design of Universe.
Once you have completed first two stages, start building the universe using Universe designer. The planning document created in planning stage will help you a lot while building the universe. While building the universe its always better to create a Unit testing document for universe and create unit tests fof every object you create in universe. Test each and every object in universe as soon as you create it. This will minimize the possible errors and bugs. Frequently use the universe integrity test tool to identify SQL traps, join path problems.
4. Test once its built.
This is one of the very important stage of Universe building process. have very detailed universe testing plan ready for this stage. Test universe against different scenarios, for SQL traps by creating sample reports, test measures, compare the data against manual SQL data. if possible ask few business users to use the universe for creating some sample ad hoc reports.
5. Deploy it.
Once all above stages are completed and well documented, Its time to deploy it for actual use for creating reports. You can deploy universe using BIAR tool. if production Business Objects Server is available from development environment you can directly export the universe to production servers.
6. Maintenance.
Since nothing is prefect issues are supposed to come frequently after deployment. Change the Universe for possible resolution and re-deploy it. Make sure you document every change you made in universe against the change request.
Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!
Related posts:
