Subject Areas allow you to create a subset of an existing cube for use in Analyzer. You can filter the cube data and modify the cube members for the specific needs of your users.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes
00
0 0 0

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.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

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.

API InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

Related cubes allow the sharing of dimensions between cubes. Dimension sharing can be one-way or two-way.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes
00
0 0 0

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.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

DeepSee Analyzer creates pivots to analyze your cubes and subject areas. Analyzer generates MDX queries and can drill down into levels of a hierarchy. Filters and formating can be applied. Pivots can appear as either tables or charts.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Analyzer
00
0 0 0

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.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

Pivot tables created in DeepSee Analyzer can be used in user dashboards. Pivot tables analyze the data based on the dimensions and measures defined in the cube or subject area. Column and row totals can be added to a pivot table in a variety of ways.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Analyzer
00
0 0 0

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.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

Paul Grabscheid, InterSystems Vice President of Strategic Planning, talks about embedded real-time business intelligence capabilities and InterSystems DeepSee.

InterSystems IRIS Analytics (DeepSee)
00
0 0 0
Article
Community Manager · Oct 2, 2015
DeepSee MDX - Shell

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.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

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

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

Joe Gallant, Product Manager for DeepSee, describes the new DeepSee dashboards available in 2013.1. Prerequisite: experience with DeepSee's earlier dashboards and dashboard editing tools.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Dashboards
00
0 0 0

Applying filters in the DeepSee Analyzer restricts the rows that are used for the pivot table. Simple and advanced filtering is supported using dimension levels as well as searchable measures.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Analyzer
00
0 0 0

DeepSee MDX navigation functions allow you to move to another member of a level based on the current member.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0

Unstructured data analysis is critical to decision-making processes. Benjamin De Boe, Product Specialist for iKnow, talks about the how to analyze unstructured data with DeepSee and iKnow.

Caché InterSystems IRIS Analytics (DeepSee) Unstructured Data iKnow
00
0 0 0

DeepSee dashboards are the way end users interact with analytics. While pivot tables are the most common, analytics can also be in the form of scorecards and meters. Dashboards can be accessed directly from your application via a url.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Dashboards
00
0 0 0

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

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0