{"id":107,"date":"2006-09-05T05:55:51","date_gmt":"2006-09-05T05:55:51","guid":{"rendered":"http:\/\/search.jason695.idv.tw:81\/wordpress\/?p=107"},"modified":"2008-02-25T17:04:33","modified_gmt":"2008-02-25T09:04:33","slug":"universe","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2006\/09\/05\/universe\/","title":{"rendered":"universe(\u8a9e\u610f\u5c64)"},"content":{"rendered":"

What is a universe?<\/strong><\/p>\n

A universe is a file that contains the following:
\n\u2022 Connection parameters for one or more database middleware.
\n\u2022 SQL structures called objects that map to actual SQL structures in the database such as columns, tables, and database functions. Objects are grouped into classes. Objects and classes are both visible to Web Intelligence users.
\n\u2022 A schema of the tables and joins used in the database. Objects are built from the database structures that you include in your schema. The schema is only available to Designer users. It is not visible to Web Intelligence and Desktop Intelligence users.<\/p>\n

Web Intelligence users connect to a universe, and run queries against a database. They can do data analysis and create reports using the objects in a universe, without seeing, or having to know anything about, the underlying data structures in the database.<\/p>\n

What is the role of a universe?<\/strong><\/p>\n

The role of a universe is to provide an easy to use and understand interface for non technical Web Intelligence users to run queries against a database to create reports and perform data analysis.<\/p>\n

As the universe designer, you use Designer to create objects that represent database structures, for example columns and database functions, that users need to access and query, to get the information necessary to meet their business requirements. The objects that you create in the universe must be relevant to the end user business environment and vocabulary. Their role is to present a business focussed front end to the SQL structures in the database.<\/p>\n

The following diagram shows the role of objects as the mapping layer between a database schema and the Query work area in Web Intelligence, that users use to create queries to run against database tables.<\/p>\n

What does a universe contain?<\/strong><\/p>\n

A universe contains the following structures:
\n\u2022 Classes
\n\u2022 Objects<\/p>\n

Classes<\/p>\n

A class is a logical grouping of objects within a universe. It represents a
\ncategory of objects. The name of a class should indicate the category of the
\nobjects that it contains. A class can be divided hierarchically into subclasses.<\/p><\/blockquote>\n

Objects<\/p>\n

An object is a named component that maps to data or a derivation of data in
\nthe database. The name of an object should be drawn from the business
\nvocabulary of the targeted user group. For example, objects used in a
\nuniverse used by a product manager could be Product, Life Cycle, or Release
\nDate. A universe used by a financial analyst could contain objects such as
\nProfit Margin, and Return on Investment.<\/p><\/blockquote>\n

Types of objects<\/strong><\/p>\n

In Designer, objects are qualified as one of three types: dimension, detail, or
\nmeasure.<\/p>\n

\n
    \n
  1. Dimension –> Parameters for analysis. Dimensions typically relate to a
    \nhierarchy such as geography, product, or time. For example
    \nLast Name and City_Id<\/li>\n
  2. Detail –> Provide a description of a dimension, but are not the focus
    \nfor analysis. For example Phone Number<\/li>\n
  3. Measure –> Convey numeric information which is used to quantify a
    \ndimension object. For example Sales Revenue<\/li>\n<\/ol>\n<\/blockquote>\n

    Objects infer SQL structures displayed in a schema<\/strong><\/p>\n

    The objects that Web Intelligence users see in a universe infer SQL
    \nstructures that you have inserted into a database schema. You, as the
    \nuniverse designer, create this schema based on the tables and joins that are
    \nrequired to return the data, needed by users for their analysis and report
    \ncreation.
    \nThe schema is a part of the universe file, but is only visible and accessible in
    \nDesigner.<\/p>\n","protected":false},"excerpt":{"rendered":"

    What is a universe? A universe is a file that contains … \u95b1\u8b80\u5168\u6587 universe(\u8a9e\u610f\u5c64)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-107","post","type-post","status-publish","format-standard","hentry","category-bo","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}