DeepSee MDX - Statements - DeepSee MDX - 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.

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 - 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 - Basic Concepts

September 30th, 2015 | 9:10

MDX queries can have up to 7 axes. An aggregate value in a cell is the aggregate of the intersection of the axes. Specifing dimensions and measures in an MDX query defines the axes and aggregates.

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 - Relative Functions

September 30th, 2015 | 9:12

Relative functions in MDX allow you to move from a member of a level to its relatives. Relatives include, parent, child, cousing, ancestor

DeepSee MDX - Statements

More from DeepSee MDX

DeepSee MDX - Statements

DeepSee MDX - Shell

DeepSee MDX - Syntax Overview

DeepSee MDX - Basic Concepts

DeepSee MDX - Measure Functions

DeepSee MDX - Relative Functions

Share this video

Embed