The universe design is divided into one planning phase and three design phases.
I. planning phase:
1. Business problem analysis and planning of the universe Solution
Ii. design phase:
1. Design Mode
2. Build universe
3. Distribute universe to users
Each implementation phase is based on the assumptions of the initial planning phase you have completed. You do not need to use designer to complete the planning phase, and this phase determines the success or failure of universe. If universe is not built based on a survey of user reporting requirements and is poorly planned, it will be difficult to design, implement and maintain and will be useless to target users.
A. Plan universe before using designer
Before you start the first phase, you should spend part of the time allocated for creating a project for universe (Up to 80%) To plan the universe. Pay attention to the following points:
•Data analysis and report of the target user of universe must be analyzedRequirement. The structure you use to create a mode should be based on clearly defined user requirements so that you can access the data contained in those tables and columns.
• Objects to be created should have a clear concept before using designer.Do not create an object by viewing available columns in the database,However, you need to identify the columns that match the objects you have identified through user requirement analysis.
B. Design Model
Create a schema for the basic database structure of universe. This mode contains the tables and columns of the target database, and links to these tables and columns. You may need to use aliases or context to solve possible connection problems in the structure, suchCycle, fault trap, and slice trap. Test the integrity of the overall structure.
C. Construct universe
Create a universe object to export select statements of Schema-based elements. Organize these objects into classes. These are the objects you have determined through the analysis of user report requirements. You can create many types of objects to improve your reporting capabilities, multidimensional analysis, and query performance. Test the integrity of the universe structure. Tests should be performed by running reports in Web Intelligence.
D. Distribute universe
Universe can be distributed to users for testing and ultimately used for production by exporting them to the central management system (CMS) resource library.