September 30th, 2015 | 9:01
Once you have successfully executed an MDX query using the DeepSee API, you have access to axes information through several methods. You can determine the number of axes and how many tupbles on each axes as well as axis metadata.
September 30th, 2015 | 7:29
Once you have successfully executed an MDX query using the DeepSee API, you can retrieve the value of any cell in the result set as well as the column and row labels for the cell.
September 30th, 2015 | 11:19
The DeepSee API provides a single method to prepare and execute your MDX query. In addition, you can execute a prepared query asynchronously which needs to be checked for completion before using the result set.
September 30th, 2015 | 6:22
An MDX query must be prepared before it can be executed to provide a DeepSee result set for use in your application. Printing the result set is the simplest way to see the results of your DeepSee API use.
September 30th, 2015 | 5:11
Viewing the results of a Drillthrough MDX query is different than viewing a DeepSee result set. Drillthrough returns a listing.
September 30th, 2015 | 11:32
Most extension functions begin with the letter %. Additional extension functions include %ALL, %LABEL, %SPACE, %CELL and %MDX.
September 30th, 2015 | 5:42
Most extension functions in DeepSee MDX begin with the letter %. Those extension functions that are used in a slicer expression include %NOT, %OR and %SEARCH
September 30th, 2015 | 7:12
DeepSee MDX joining functions join two sets of dimensions and will optionally include duplicates. These include CROSSJOIN, EXCEPT, INTERSECT and UNION.
September 30th, 2015 | 5:21
DeepSee MDX time functions work on time and date dimensions. These include CLOSING/OPENINGPERIOD and PERDIOSTODATE. The special time member NOW is included.
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.
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.