Each object in the properties pane of the Cube Editor has its own set of properties which can be used to modify the settings of the object. The properties of a cube defined in the properties pane are as tabulated below. In this section we shall use these properties to set the properties of our cubes...   Read Article.

The Storage Design Wizard helps the user set the storage options and design the aggregations for a cube. While choosing from the three available storage modes the user has to keep certain factors in mind....   Read Article.

Online Analytical Processing (OLAP) is essentially data presented as Cubes, dimensions, hierarchies and measures. Users can navigate a complex set of data intuitively using these objects. In this context, consistent response times for each view or slice of data become important. Therefore modes of storing and retrieving data became the key tenet of...   Read Article.

Pre-calculated summaries of data that improve query response time are called aggregations. OLAP technology organizes data into the multidimensional structures of cubes. The dimensions and their hierarchies define the queries that can be asked of the cubes....   Read Article.

This tutorial explains the usage of the Usage Based Optimization Wizard, The Server Cache , Query Usage and Manipulating the query log. Using the Usage Based Optimization Wizard...   Read Article.

SQL Server 2000 Analysis services comes with certain features that optimize performance without the intervention of the Administrator. The Storage Engine is optimized by incorporating the following features;...   Read Article.

The Analysis server is like a black box. Everything that happens in the server is recorded, but the end user sees a multidimensional cube created out of the data in the data warehouse and has very little taste of what really goes on behind the scenes. In this section we will be examining this black box to understand how the Analysis server processes...   Read Article.

As stated earlier, maps are created when a dimension is processed. However, existing maps of a dimension are destroyed when it is processed and new maps are created. Consequently all cubes accessing the dimension will find it inaccessible and the cube will be invalid. The dimension will become accessible only when the cube is reprocessed....   Read Article.

Cubes are made up of a fact table and several dimensions. Optimizing cube processing therefore, involves optimizing dimensions also. Let us look at two scenarios. One in which the dimensions are not optimized and the cube is processed and another in which the dimensions are optimized and the cube is processed....   Read Article.

Microsoft SQL Server 2000 Analysis Services provides the user with many ways of tracking and solving errors. A large number of error logs built into the service help the user pinpoint the exact nature of errors and find solutions for them...   Read Article.

The cube is a storage container that contains data and aggregations of data. Every cube must have at least one partition which must be stored in the Analysis server in which the cube is defined. Partitions are stored as separate files in the Partitions folder under the cube....   Read Article.

Cubes with multiple partitions can be extremely confusing. Users may like to organize the cubes into a cube with fewer partitions by merging some of the partitions together. The preconditions to the merger of cubes is that the Storage and aggregation design should be the same in the partitions being merged....   Read Article.

In this tutorial we will be learning about Calculated members, Creating Calculated Members, Using Function Libraries to Build Calculated Members and Calculated Member Builder....   Read Article.

In this part 2 of Implementing Calculations Using MDX, we will be learning about Renaming Calculated members, Creating Non Measure Calculated members, Using Functions in Calculated Members, Setting calculations at Member level and Setting a Calculation for a subcube or a selection of cells....   Read Article.

Before understanding what is solve order it is essential to understand the concept of Pass order. Solve order and pass order together determine the manner in which a cube is resolved in Analysis services....   Read Article.

This tutorial explains about Defining Virtual cubes, Benefits of using virtual cubes, Working with Virtual Cubes and Obtaining logical results....   Read Article.

In the above section we studied some of the reasons why we would want to create virtual cubes and how logical results can be obtained by making such cubes. We also saw that a virtual cube can be built quickly and easily by using the Virtual Cube Wizard....   Read Article.

Calculated members can be imported into virtual cubes from their component cubes. New calculated members also can be created directly into virtual cubes. The Calculated member Builder can be used to build the members or calculated members created in component cubes can be imported and then the same can be edited....   Read Article.

This tutorial explains about defining Auctions, Creating Auctions, Creating Actions in Regular Cubes, Creating and Maintaining Actions in Virtual Cubes, Importing an Action into a Virtual Cube and Editing an Action in a Virtual Cube....   Read Article.

Actions used by end users to select a single cube cell and retrieve a result set from the source data of the cell are known as Drillthrough actions. Drillthrough has to be enabled if administrators want to drillthrough in a Cube Browser and the Cube Editor data tab....   Read Article.