InterSystems Video Portal

DeepSee MDX - Statements

September 30th, 2015 | 10:26

DeepSee MDX supports several statements to generate a pivot or listing. SELECT is the most used statement. DRILLFACTS and DRILLTHROUGH return detail row information from the fact table and source table respectively.

Tags: 2013.1, 2014.1, advanced, deepsee, drillfacts, drillthrough, mdx, select, statements

More from DeepSee MDX

DeepSee MDX - Syntax Overview

September 30th, 2015 | 10:02

Using the MDX Query window of Analyzer, the syntax of MDX can be viewed. This is a great way to become comfortable with writing your own MDX queries.
DeepSee MDX - Measure Functions

September 30th, 2015 | 13:00

Measure functions work with measures defined in a DeepSee cube. In addition to the aggregation functions (SUM, AVG, MIN, MAX and COUNT) there are several others to perform additional calculations.
DeepSee MDX - Shell

September 30th, 2015 | 10:52

The DeepSee MDX Shell allows execution of MDX statements in a terminal session. The WITH clause, as well as the CREATE and DROP MEMBER and CREATE and DROP SET statements are also demonstrated.
DeepSee MDX - Row Expression

September 30th, 2015 | 5:54

The row expression defines what dimensions and measures appear on the rows of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
DeepSee MDX - Column Expression

September 30th, 2015 | 7:59

The column expression defines what dimensions and measures appear on the columns of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
DeepSee MDX - Additional Concepts

September 30th, 2015 | 13:50

MDX provides several functions for use with dimensions and measures. There are also several DeepSee specific functions. Sets and tuples can be included in your MDX query. Filters limit the scope of the dimensions and aggregates in the cube.

More Similar Videos