DeepSee MDX - Statements - DeepSee MDX - InterSystems Video Portal

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

September 30th, 2015 | 11:58

DeepSee MDX limiting functions restrict the number of elements in the pivot. Functions include, IIF, FILTER, DISTINCT, TOPCOUNT and more.

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 - 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 - Statements

More from DeepSee MDX

DeepSee MDX - Column Expression

DeepSee MDX - Shell

DeepSee MDX - Statements

DeepSee MDX - Limiting Functions

DeepSee MDX - Measure Functions

DeepSee MDX - Row Expression

Share this video

Embed