Home > MDX > Multi – Dimensional Queries (MDX)

Multi – Dimensional Queries (MDX)

MDXMulti Dimensional Expressions . MDX used to query OLAP (Online Analytical Processing) databases.

SQL is used to query relational database like that MDX is used to query OLAP database/ Cubes.

MDX looks like T-SQL but in MDX we can define axis where we can do slice and dice of the data.

Basic Structure of MDX

SELECT
{Measures} ON Columns,
{<Set> or <Tupple> } ON Rows
FROM [Cube]

Please follow the below link for more details

Multi-dimensional-queries (MDX)

More technical stuff can be found in http://msbitips.com

 

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: MDX Tags:
  1. Sudhira
    September 10, 2012 at 11:06 pm

    nice blog..

  2. September 12, 2012 at 7:18 pm

    goog going prasad, keep on coming good stuff…..

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: