What is a Universe
q A universe is a semantic layer that maps the data structure found in databases (tables, columns, etc) in business terms.
q A universe can represent any specific business area, process, or department. For example, a universe can relate to a department in a company such as marketing or accounting.
Universe Layout...
Class
q A class is a logical grouping of objects within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.
q A class can be further divided into subclasses.
q As a designer, you are free to define hierarchies of classes and subclasses into a model that best reflects the business concepts of your company.
Objects
q An object is the most refined component in a universe. It maps to data or a derivation of data in the database.
q Types of objects -
Ø Dimension Objects -
• Focus of analysis in a query.
• Maps to one or more columns in a database that are key to a query.
Ø Measure Objects -
• Aggregate functions that map to statistics in a database.
• Map to “fact attributes” of a star schema.
Ø Detail Objects -
• Descriptive data about the dimensions.
• Always attached to a dimension.
Universe development process
q User Requirements
Ø Detailed analysis of the information needs of the users.
q Data Analysis
Ø Detailed data analysis of the database breaking it down into functional areas that users can relate to.
q Design
Ø Information from first 2 phases must be amalgamated to create the conceptual design of the Universe, its objects and other components.
q Development and distribution
Ø Create using the Designer module.
Ø Test using the User module.
Ø Distribute to the users via the repository.
q Maintenance
Ø Designer is responsible for updating and maintaining Universe and keeping it up to date with any changes in the User Requirements.
Universe Creation:
No comments:
Post a Comment