1 / 12

OLAP Structures & OLAP Services

OLAP Structures & OLAP Services. Background topics. Introduction to Multidimensional Domain Structure Diagram OLAP Services Dimensions The Structure of Dimensions Multiple Dimensional Hierarchies The All Level and All Member Member Properties Dimensions Type Cube and Measures

mayah
Download Presentation

OLAP Structures & OLAP Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OLAP Structures & OLAP Services

  2. Background topics • Introduction to Multidimensional Domain Structure Diagram • OLAP Services Dimensions • The Structure of Dimensions • Multiple Dimensional Hierarchies • The All Level and All Member • Member Properties • Dimensions Type • Cube and Measures • Regular Cube • Virtual Cube

  3. Introduction to Multidimensional Domain Structure Diagram • The MOLAP storage mode causes the aggregations of the partition and a copy of its source data to be stored in a multidimensional structure on an Analysis server computer.

  4. OLAP Services DimensionsThe Structure of Dimensions • Each Microsoft OLAP services dimension is composed of one or more named levels, each of which holds one or more of the members of the dimension.

  5. OLAP Services DimensionsThe Structure of Dimensions 1 2 Diagram some permutation of dimension structure

  6. Multiple Dimensional Hierarchies

  7. The All Level and All Member • Each hierarchy on each dimension may be configured to have an “ALL” level or to not have one. • The all member has three special properties : • The default member for queries on the cube. • The reference member on which a virtual cube will join a cube to another cube. • All member defined by OLAP services will not correspond to anything in the underlying database.

  8. Member Properties • Member properties are additional pieces of information about each member. • Member properties may be used as : • the basis for virtual dimensions, • dimension of a cube.

  9. Dimensions Type • Dimensions come in different flavors. • Share • Private • Regular • Virtual

  10. Shared dimension • Shared dimensionmay be used by more than one cube. • A Private dimensionis defined within a particular cube and that cube alone. • Regular dimensionmay have one to 64 levels altogether and are based on table column or column expressions. • A virtual dimensionis defined from a member property for a level of a single regular dimension.

  11. Cube and MeasuresRegular Cube • Regular cube define a framework for aggregating input data.

  12. Virtual Cube • Virtual cube are essentially join views of one or more regular cube. • A Virtual cube is created from one or more regular cubes.

More Related