Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Dec 2, 2002

Introducing the SQL Server 'MDX in Analysis Services' Series - Page 10

By William Pearson


Coming Up in Our Series...

In this, the first tutorial of the MDX in Analysis Services series, we attempted to present an introduction to MDX by exposing and discussing fundamental concepts and terms. We explored basic MDX syntax, with practical examples of the use of the language to return information from multidimensional data sources. Using illustrated examples, we covered the return of information about numbers, Basic conversion functions, building expressions that return information about related members based upon using the Current Member as a starting point, and the use of simple conditional tests and comparisons in basic expressions.

Our next tutorials deal with more involved MDX concepts, and with MDX queries, as opposed to MDX expressions, such as those we explored in this first tutorial. MDX queries can select many values from cubes, as opposed to the single values we see generated by separate MDX expressions. We will discuss the purposes of MDX queries as well as new terms that come into play.

We will create basic MDX queries together to get a good feel for the steps and considerations involved in query creation. We will explore the process of returning values with MDX, specifically focusing on the specification of dimensions. Moreover, will revisit member reporting, and expose further means of calculating members based upon the Current Member, as well as the process of selecting empty members to suit various needs.


See All Articles by Columnist William E. Pearson, III




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date