|
The following tutorials has been added at http://www.exforsys.com in Learning Center Oracle 9i, ASP .NET, SQL Server 2000 and MSAS trainings.
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.
Tutorial 23: MSAS : Meta data Repository 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.
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
The primary aim of Microsoft was to ease the process of building and using data warehouses. A large number of wizards, editors and tools have been built into the Analysis services to fulfill this objective. The wizards available for use are: The Cube wizard that helps the user build all the structures necessary to create an OLAP cube. It walks the user through the entire cube design and implementation process. The user can map the data sources, create dimensions and define measures using this wizard. The Cube Editor is useful in editing cube structures or in creating new cubes. The simple drag and drop feature makes the operation very easy. It complements the cube wizard and can be used to edit the cubes created in the Cube wizard.
This tutorial explains about Accessing Data with C# with an Overview of ADO.NET, Connecting to Data , Executing Commands , Working with Data and Choosing an ADO.NET Provider along with the Project files used in this.
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.
Latest Ebooks and Tutorials
ITQuestionBank Updated with more ebooks, Tutorials and Articles. Take a look and also please submit any good links you might have to help our fellow friends. http://www.itquestionbank.com
Interview Questions : http://www.geekinterview.com
Thanks,
| ||||||||||||||||||||||