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 - Slicer Expression

September 30th, 2015 | 11:18

Filtering of your pivot is accomplished by the Slicer Expression with either a Where or %Filter clause. A single measure is part of the Slicer Expression.
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 - 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 - 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 - 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.

More Similar Videos