MDX Query Basics (Analysis Services 2012)

preview_player
Показать описание
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here:

In this video, we walk through the basics of the MDX Query language. It is a very logical language, however, is somewhat large in syntax. If you enjoy writing Transact-SQL, you will really enjoy the MDX language. The AdventureWorks2012 multidimensional models need to be installed on your SSAS Multidimensional mode instance from the CodePlex web site.

Highlights from this video:

- The basics of an MDX query
- What is the basic format of the MDX query language?
- Is it necessary to have a WHERE clause in an MDX query?
- How to signal the end of a statement in the MDX query language
- Using the Internet Order Count

and much more...
  1. LearnItFirst.com
  2. multi-line comment
  3. single-line comment
  4. NONEMPTY
  5. SQL Server 2012
  6. Analysis Services
Рекомендации по теме
MDX Query Basics 0:13:09

MDX Query Basics (Analysis Services 2012)

MDX 101 1:02:32

MDX 101

Ssas basics|mdx queries 0:09:45

Ssas basics|mdx queries in SSAS

SSAS MDX Queries 0:50:20

SSAS MDX Queries

12 SQL Server 0:01:57

12 SQL Server Management Studio - browsing the cube (MDX query)

Analysis Services Tutorial 0:12:27

Analysis Services Tutorial - MDX (Lesson 8)

MDX Introduction | 0:19:14

MDX Introduction | what is mdx in ssas | ssas mdx queries | mdx queries examples

MDX-Part-1-MDX Query Basics 0:15:56

MDX-Part-1-MDX Query Basics

SSAS - Creating 0:39:55

SSAS - Creating your First Cube with MDX.

SSAS-SQL SERVER ANALYSIS 1:16:38

SSAS-SQL SERVER ANALYSIS SERVICES||INTRO TO MDX|||ZERO TO HERO||START TO BEGIN||SSAS WITH SQL SERVER

Cascade Parameters with 0:24:09

Cascade Parameters with MDX in SSRS Report using SSAS

MDX 101 0:27:34

MDX 101 MDX Basics and Structure

Understanding Multidimensional Expressions 0:40:03

Understanding Multidimensional Expressions (MDX) I MSBI | Edureka

SSAS – My 0:12:05

SSAS – My First SSAS Cube with MDX Queries

How the SELECT 0:13:34

How the SELECT Statement Works in MDX

MSBI - SSAS 0:50:02

MSBI - SSAS - MDX Queries

MDX-Part-3-Sorting Results 0:21:05

MDX-Part-3-Sorting Results

MDX tutorial, introduction 0:09:03

MDX tutorial, introduction to Multidimensional Expressions

A SQL Developer’s 0:58:11

A SQL Developer’s Guide to MDX Basics - Shabnam Watson 9/14/2016

SSAS Part10 - 0:59:51

SSAS Part10 - MDX Queries, Set and Tuple - Session 2

SSAS MDX Interview 0:01:22

SSAS MDX Interview Questions: Difference between Aggregation and Sum in MDX Query

Rank Function in 0:17:15

Rank Function in MDX | mdx queries rank | ssas rank function

SSAS Part9 - 0:43:56

SSAS Part9 - Intro to MDX Queries - Session 1

Introduction to SQL 1:03:31

Introduction to SQL Server Analysis Services (SSAS)

Комментарии
Автор

this is the best way to go for a starter

deepak
Автор

Thank you Sir, for providing a great introduction into MDX usage!

BartillaAndPartners
Автор

AMAZING TUTORIALS, A MUST SEE FOR EVERY BEGINNER, ONE OF THE BEST ON YOUTUBE!

scratchacat
Автор

Hi. Thanks for the video. It makes MDX look very simple to a beginner like me! I have a question however; could you please tell me whether there is a way to aggregate only those internet orders which are over a certain value (say 50)? In this case the condition is on the measure rather than the dimension. How can we do that?

tvikramsingh
Автор


How can I access other videos in the series please ?

freddy
Автор

Thanks for this video it’s very help full

gayathrirokkam
Автор

Just a comment....

I think the install video was not before, but after this one...

PlonkTeeVee
Автор

Hi. I like your trigger videos too. So dramatic

DJReeRee