Docstoc

MDX tutorial_ a guide to MDX

Document Sample
MDX tutorial_ a guide to MDX Powered By Docstoc
					MDX is a data processor and the data which are analyzed by MDX tutorial happen to
be a bit more intuitive and a bit easier regarding all dimensions. Data in a multi
dimensional expression are normally manipulated and defined through languages like
SQL, JAVA and such other languages. This activity of retrieving a data is done
following two ways one of them is row dimension and the other is column dimension.
In MDX the data base is stored using the traditional method of relational data base.
  The method of column dimension and row dimension is based on the organization of
tables. This arrangement consists of a set of table and a set of two dimensional data is
represented by each table. Now in each and every table there is a point of intersection
where a specific element of the stored data in both the column dimension and row
dimension get intersected. This point of intersection of the column dimension and row
dimension is termed as field. The analysis if a data in an MDX tutorial follows a
particular organization of the facts and the order of all the organizing elements.
Normally SQL is used to analyze the queries in a MDX; those particular columns
which a user wants to view for quenching his SQL query are specifically marked with
a SELECT statement. While on the other hand the rows which the user wants to
retrieve are limited and specified with a where clause.

  Multi dimensional data on the contrary can be portrayed by a structure which is
multi dimensional that is they have tow or more than two dimensions. The name
given to this structure is cube and they are usually multi dimensional in structure. In a
cube there is a point of intersection where the rows and columns get intersected, this
point of intersection may be more than one at some time; these points of intersection
is called measure. There are cubes which have three or more dimensions like route,
time, service and two intersection point called measure.
  Author:- Carlos Quijada is an IT professional associated with the field since the last
20 years. His core area of ecialization is programming. Besides working with one of
the leading IT services, he writes about technology and its benefits, MDX tutorial.

				
DOCUMENT INFO