Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 26-07-2017
Search Course Here




Live Chat
Support
MDX Queries Online Training

MDX Queries

overview

Multidimensional Expressions (MDX) lets you query multidimensional objects, such as cubes, and return multidimensional cell sets that contain the cube's data. This topic and its subtopics provide an overview of MDX queries.
prerequisties
  • All attendees should have a basic knowledge of sql server.
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • MDX
    • The Business Intelligence Landscape
    • The Dimensional Model
    • Implementing the Dimensional Model
    • The MDX Language

  • Using the MDX Query Editor
    • SQL Server Management Studio
    • The MDX Query Editor
    • Building a Simple MDX Query
    • Exploring the Step-by-Step Cube
    • Building a More Complex Query

  • Understanding Tuples
    • N-dimensional Space
    • Cube Space
    • Accessing Data with Tuples
    • Understanding Cells
    • Working with Partial Tuples
    • Building Tuples with User-Hierarchies

  • Working with Sets
    • Set Basics
    • Understanding the SELECT Statement
    • Building Sets with Functions
    • Limiting Sets

  • Working with Expressions
    • Expression Basics
    • Calculated Members
    • Building Dynamic Expressions
    • Resolving Contextual Conflicts
    • Building Complex Expressions

  • Building Complex Sets
    • Assembling Ordered Sets
    • Retrieving the First or Last Tuples of a Set
    • Filtering Sets
    • Combining Sets
    • Performing Advanced Set Construction

  • Performing Aggregation
    • Performing Summation
    • Calculating Averages
    • Identifying Minimum and Maximum Values
    • Counting Tuples in Sets

  • Navigating Hierarchies
    • Accessing Immediate Relatives
    • Accessing Extended Relatives
    • Navigating within a Level

  • Working with Time
    • Understanding the Time Dimension
    • Calculating an Accumulating Total
    • Performing Period-over-Period Analysis
    • Combining Time-Based Metrics

  • Enhancing the Cube (Optional)
    • Understanding the MDX Script
    • Constructing Calculated Members
    • Assembling Named Sets

  • Building Reports (Optional)
    • Getting Started
    • Connecting to Analysis Services
    • Designing the Dataset
    • Adding Parameters to the Dataset
    • Presenting the Data in the Report
Videos

MDX Queries Videos will be updated soon
To watch more Videos Click Here

Flash News


AngularJS New Batch Start From 14th JULY & 15th JULY.


Hadoop Dev New Batch Start From 15th JULY & 16th JULY.


IBM COGNOS TM New Batch Start From 16th JULY & 17th JULY.


Informatica Dev New Batch Start From 17th JULY & 18th JULY.


Mean Stack New Batch Start 18th JULY & 19th JULY.

SAP BODS new Batch Starting From 19th JULY & 20th JULY.

SAP S/4 HANA New Batch Start From 20th JULY & 21st JULY
.

Tableau New Batch Start From 21st JULY & 22nd JULY

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th JULY & 07:00A.M IST on 14th JULY

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings