| 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: 11 - 20 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
|
This tutorial explains how to create Shared dimension using Dimension Editor , Private dimension using Dimension Editor and the differences between them.
Updated: 05/30/2006
|
|
|
This tutorial explains Building Dimensions using Dimensions Editor. Dimensional modeling is the conceptualization and visualization of numerical data models as a set of measures that are derived from the common parameters used in a business. It summarizes and rearranges data and presents views of data to support data analysis. Dimensional modeling focuses on data such as counts, weights, balances and occurrences.
Updated: 05/30/2006
|
|
|
PivotTable component in Office 2000 is the PivotTable report feature. It allows the user select and cross tabulate numerical values in ways that are similar to the processes of a cube. The earlier versions of this report in Excel could only extract values from relational data sources. The version under reference can present data directly form an OLAP cube.
Updated: 05/30/2006
|
|
|
The PivotTable Service: The interfaces used by client applications to access OLAP data and data mining data on the server are provided by the PivotTable Service. The PivotTable service is a set of tools that enable the transfer of OLAP cubes to client applications from the OLAP server. Two programming interfaces for querying data are available to the developer from the PivotTable Services:--The OLE DB for OLAP and the ActiveX Data objects Multidimensional (ADO MD). Tools such as those available in VisualStudio.Net are harnessed to create applications that query multi dimensional data sources. The figure below illustrates the relationship scenario.
Updated: 05/30/2006
|
|
|
In the first tutorial of this series “Introduction to Data Warehousing and OLAP” we briefly touched upon storage options that are used in data warehousing. In the second chapter “ Introducing Analysis Manager Wizards” we learnt how to use the cube Storage wizard to set storage options for the cube we had created. In this section of the tutorial we will be going into a little more detail on the various kinds of storage options available in Analysis Services and will be touching on the pros and cons of the different storage modes.
Updated: 05/30/2006
|
|
|
Metadata is a description of data. It provides a consistent way to describe data structures. It is used to describe data as it is being transformed and gives a clear explanation of the meaning of different fields, measures, levels and dimensions. All releases of Microsoft development and data management tools support and allow access to the Repository. The storage of data about data in a central location has some advantages.
Updated: 05/30/2006
|
|
|
Analysis services provides various tools that can be programmatically used to extend its functionality. Analysis services supports OLE DB to meet the OLAP specific requirements and is also designed to meet the requirements for Data mining specifications. The Analysis services is made compatible with the ActiveX Data Objects(ADO) and its multidimensional counterpart ADO MD. User defined functions for creating Component Object Model(COM) libraries enable the Analysis services to extend its capabilities of using automation languages such as Microsoft Visual Basic or Microsoft Visual C++. These libraries can be registered and the functions can be used in calculated member definitions and other expressions written in Multidimensional Expressions(MDX).
Updated: 05/30/2006
|
|
|
Analysis services is the middle tier server component of the MS SQL 2000. It manages multidimensional OLAP cubes of data and ease of access to such data to end users. It also enables user to create data mining models from the data in the cubes or in the relational databases.
Updated: 05/30/2006
|
|
|
This is part 2 of MSAS : The Data warehousing framework of SQL Server 2000. It's very important that you understand the concepts if you are really trying to get job in Data Warehousing field.
Updated: 05/30/2006
|
|
|
The Data warehousing framework is a set of components and API’s that implement the data warehousing features of the SQL server 2000. The common interface of the server known as the Enterprise Manager can be used by various components to build and use the data warehouse or a data mart.
Updated: 05/30/2006
|
|
|
MSAS Listings
|
|
Total:
70 | Displaying: 11 - 20 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
