Dimensions can be modified so that the contents of the dimension changes. The impact of these changes can be viewed by end users browsing cubes. End user’s get an added analytical option due to this process.(This option is only available in the Enterprise Edition of Microsoft SQL Server 2000)....   Read Article.

Security of data is of paramount importance to most industries and organizations. All organizations want to restrict access to data hierarchically or define role based access. Analysis Services provides for this need....   Read Article.

The enforcement of security defined by the roles must be preceded by user authentication. When the user connects to the Analysis server, the first thing that happens is authentication. The user login is validated and the user is given access to the data on the server in accordance with the roles. If authentication is unsuccessful, he will not be able...   Read Article.

When a new database is created a default role is created for all OLAP Administrators to have access to the Analysis Manager. However, other users have to be given rights to access the database and its objects. Users can be given rights to Browse the cubes and objects but not to use Analysis Manager. If the user has to be given a right to use both the...   Read Article.

In the Analysis Manager console tree, expand the cubes folder and right click the Sales cube and click Manage roles...   Read Article.

When roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were...   Read Article.

The process of probing into a set of information for descriptive and predictive purposes is called data mining. The purpose is to identify those trends and patterns which indicate the direction of effort to achieve desired outcomes. SQL Server 2000 and Analysis Services, has inbuilt powerful data mining capabilities including algorithms for Clustering...   Read Article.

Let us assume FoodMart wants the members with Golden Membership to be studied. It wants to focus on broadening the membership of the Gold Card. This can be done now using the Decision Tree Model....   Read Article.

The predictive model of the decision tree helps users determine whether similar cases will have a similar behavior. The attributes of the tree can be examined for impact analysis by using the Dependency Network Browser. This can be opened by right clicking on a decision tree data mining model in the Analysis services explorer tree control....   Read Article.

In this tutorial we will learn about the differences between Data Warehouse database and OLTP database and the objectives of a Data warehouse and Data flow....   Read Article.

This tutorial starts with the introduction to Data Warehousing, Defination of OLAP, difference between Data warehouse and the OLTP Database, Objectives of data warehousing and data flow....   Read Article.

The quantitative and numerical columns from a fact table of a cube are the measures of the cube. When the cube is processed the data in the measures get aggregated across the dimensions of the cube. These measures are of primary interest to the end user and are the central values that get analyzed in a cube...   Read Article.

The main object in Online Analytical processing is the cube. A cube is defined as a subset of the data in the data warehouse, organized and summarized into multidimensional structure that consists of dimensions and measures...   Read Article.

A logical dimension created out of the columns of a physical dimension is a virtual dimension. The contents of a virtual dimension are member properties of the physical dimension or columns and tables of a physical dimension. For instance the Store name level of the Store dimension has a member property named Store Sqft. This member property identifies...   Read Article.

Member properties are attributes associated with members. They contain some additional information about a member but cannot be used to create a level in the dimension by themselves. For example each member of the Month level has an associated Boolean number property called Bonus month....   Read Article.

To enable proper aggregation of values along a dimension each member of the dimension needs its own aggregation rule. These rules are provided by custom roll up. Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values. Custom rollup operators assigned to a column during the process of creating...   Read Article.

Time dimensions are part and parcel of OLAP cubes. At the lowest level of detail a time dimension may contain a month, minute or even a second. At the most summarized level it may contain a year, a decade or a century. The repetitive nature of time encourages users to view data in terms of a time dimension....   Read Article.

hierarchy defines the relative positions of members in a dimension. Hierarchies are sometimes represented as pyramidal structures. The members in this structure are arranged in an expansive order—from the most summarized to the most detailed. For instance in a geography dimension the country may the most summarized and the individual cities and localities...   Read Article.

Dimensions are stored in the Multidimensional OLAP or Relational OLAP. The storage mode determines the location and form of the dimensions data. While MOLAP stores data in a multidimensional structure on the Analysis server, ROLAP stores the data in the relational tables. The storage mode can be set using the Dimension or cube editor....   Read Article.

Dimensions are defined as structural attributes of a cube made up of levels arranged in hierarchies. A level is a set of members of a dimension organized such that all members of the set are at an equal distance from the root of the hierarchy. A hierarchy is the set of members in a dimension and their positions relative to one another....   Read Article.