DeepSee MDX - Statements - DeepSee MDX - InterSystems Video Portal

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

September 30th, 2015 | 4:11

MDX is the query language for cubes. DeepSee analyzer generates MDX queries that can be viewed and modified if needed. A DeepSee result set can be returned to your application via the %DeepSee API.