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

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
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 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

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

(2) SAP MII Demo Training

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

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