| Home : Ebooks : MSAS |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
MSAS Listings
|
|
Total:
70 | Displaying: 21 - 30 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
|
This tutorial explains various functions available and the tools available for building and managing data warehouses.
Updated: 05/30/2006
|
|
|
This tutorial explains about the Cube Browser, it's a tool provided within the Analysis Services to display the results of the cube process without the need to add external software.
Updated: 05/30/2006
|
|
|
This tutorial covers the storage modes for the cube before it can be processed. The kind of storage selected will determine the query performance and enhance the cube efficiency.
Updated: 05/30/2006
|
|
|
The next dimension that we need to create is the Time dimension. This is the most common dimension and inevitably forms a dimension of every cube. However, there are certain specific conditions that arise when we create the time dimension. In the Select Dimensions dialog box of the Cube Wizard we will chose time_by_day dimension table. The time dimension table is usually joined to the fact table by a time_id key.
Updated: 05/29/2006
|
|
|
Click ‘New Dimension…’ button to launch the Dimension Wizard. The welcome dialog box of the Dimension wizard appears. The Check box option is to be checked if we want to skip this screen in future. For the present we leave it as it is and click the Next button.
Updated: 05/29/2006
|
|
|
A cube is a multidimensional structure consisting of dimensions and measures. Therefore, we need to know what dimensions we intend to use and what measures will be captured. In short, we need to know what quantitative values we want to analyze or monitor from our database. Usually organizations capture actual measures such as revenues, sales in context of expenses, costs along with “budget”, “Plan” or “forecast” values.
Updated: 05/29/2006
|
|
|
This tutorial explains Setting up the Database in Analysis Server and how to connect and test the connectivity.
The first step in creating a cube is the setting up of the Database. Double click on the server and connect to it. Once the connection is established, the user can proceed to create the database. Right click on the server node and select ‘New Database’. On clicking on “New Database” a tiny window opens prompting the user to enter the name of the database and a description of it. The database has been named Sample and the description entered as “sample cube”.
Updated: 05/29/2006
|
|
|
This tutorial explains the steps to create the cube and the preparation like settip the datasource. A cube is the fundamental unit of data storage and retrieval in the Analysis Server. A cube can be created with either the Cube Wizard or the Cube Editor. The cube wizard provides very limited options as against the options available in the Cube Editor. In this section of the tutorial we propose to concentrate on the Cube Wizard and learn how to create a cube, process a cube and browse the results using the Wizard.
Updated: 05/29/2006
|
|
|
This tutorial covers brief introduction to Analysis Manager Wizards, how to start, Previewing and Defining terms which helps to understand the navigation along with the screen shots.
Updated: 05/29/2006
|
|
|
We are glad to let you know that we are starting with Microsoft Analysis Services Training in the following topics. We will be publishing the tutorials as we complete. Please use discussion board if you have any questions and would like to discuss any. We will be providing step by step screen shots and the sample code.
Updated: 05/29/2006
|
|
|
MSAS Listings
|
|
Total:
70 | Displaying: 21 - 30 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
