Defining DeepSee Models
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Preface : 
 
 
Chapter 1: 
  1.1 Purpose of DeepSee
1.2 Introduction to DeepSee Models
1.3 Introduction to the Model Development Process
1.4 Introduction to the DeepSee Architect
1.4.1 Class Viewer
1.4.2 Model Viewer
1.4.3 Details Area
Chapter 2: 
  2.1 Introduction to Cubes
2.1.1 The Source Class of a Cube
2.2 Dimensions, Hierarchies, and Levels
2.2.1 Levels and Members
2.2.2 Member Names and Keys
2.2.3 Source Values
2.2.4 Hierarchies and Dimensions
2.2.5 The All Level and the All Member
2.2.6 List-Based Levels
2.2.7 See Also
2.3 Properties
2.4 Measures
2.5 Listings
2.6 Calculated Members
2.6.1 Calculated Measures
2.6.2 Non-Measure Calculated Members
2.6.3 See Also
2.7 Subject Areas
2.8 Filters
2.8.1 Filter Mechanisms
2.8.2 Using Filters
2.9 How DeepSee Builds and Uses Fact Tables
2.9.1 Structure of a Fact Table
2.9.2 Populating the Fact Table
2.9.3 Using a Fact Table
2.10 How DeepSee Generates Listings
Chapter 3: 
  3.1 Items That You Can Use in Pivot Tables
3.1.1 Items That Group or Filter Records
3.1.2 Items That Behave Like Measures
3.1.3 Properties
3.1.4 Items That You Cannot Access Directly in the Analyzer
3.2 Items That You Can Use in Calculated Members and Measures
3.3 Comparison of Possible Widget Data Sources
3.4 High-Level Summary of Options
Chapter 4: 
  4.1 Choosing a Base Table
4.2 Choosing the Form of the Base Table
4.3 Avoiding Large Numbers of Levels and Measures
4.4 Defining Measures Appropriately
4.4.1 Measures from Parent Tables
4.4.2 Measures from Child Tables
4.5 Understanding Time Levels
4.6 Defining Hierarchies Appropriately
4.6.1 What Happens if a Hierarchy Is Inverted
4.6.2 Time Hierarchies
4.7 Defining Member Keys and Names Appropriately
4.7.1 Ways to Generate Duplicate Member Keys
4.7.2 Ways to Generate Duplicate Member Names
4.8 Avoiding Very Granular Levels
4.9 Using List-Based Levels Carefully
4.10 Handling Null Values Correctly
4.10.1 Null Values in a Measure
4.10.2 Null Values in a Level
4.11 Usability Considerations
4.11.1 Consider How Dimensions, Hierarchies, and Levels Are Presented
4.11.2 Consider How to Use All Members
4.12 Considerations with Multiple Cubes
4.13 Recommendations
Chapter 5: 
  5.1 Defining a Cube
5.1.1 Generating the Cube Class
5.1.2 Changing the Base Class for a Cube
5.2 Possible Source Classes for a Cube
5.3 Other Cube Options
5.4 Adding Items to a Cube
5.5 Names for Model Elements
5.6 Other Common Options
5.7 Compiling and Building a Cube
5.8 Opening a Cube in the Analyzer
5.9 Deleting a Cube
Chapter 6: 
  6.1 When to Recompile and Rebuild
6.2 Compiling a Cube
6.3 Building a Cube
6.4 Building the Cube Programmatically
6.5 Minimizing Cube Size During Development
6.6 Using Parallel Processing During a Cube Build
6.6.1 Specifying the Agent Count
6.7 Build Errors
6.7.1 Seeing Build Errors
6.7.2 Checking the Fact Count
6.7.3 Possible Causes of Build Errors
6.7.4 Recovering from Build Errors
6.8 DeepSee Task Log
Chapter 7: 
  7.1 Overview
7.2 Creating a New Dimension, Hierarchy, and Level
7.3 Adding a Hierarchy and Level
7.4 Adding a Level
7.5 Defining the Source Values for a Dimension or Level
7.5.1 Specifying a Source Value when Using a Data Connector
7.6 Details for Source Expressions
7.6.1 Using a Term List
7.6.2 Using an Ensemble Business Rule
7.7 Changing the Order of Dimensions in the Cube
7.8 Changing the Order of Levels in a Hierarchy
7.9 Validating Your Levels
Chapter 8: 
  8.1 Ensuring Uniqueness of Member Keys
8.2 Specifying the Null Replacement String for a Level
8.3 Defining a List-Based Level
8.3.1 Defining a Level When the Source Value Is in a Standard Format
8.3.2 Defining a Level When the Source Value Is in Another Format
8.3.3 Examples
8.4 Defining a Time Level
8.4.1 Introduction
8.4.2 Defining a Time Level
8.4.3 Time Levels and Hierarchies
8.4.4 Handling a Calendar That Has a Date Offset
8.4.5 Examples
8.5 Defining Custom Time Levels
8.5.1 Example
8.6 Defining an Age Level
8.7 Specifying a Range Expression
8.7.1 Defining Numeric Bins
8.7.2 Defining String Replacements
8.7.3 Examples
8.8 Configuring a Level to Use Display Values
8.8.1 Examples
8.9 Using Property Values as the Member Names
8.9.1 Examples
8.10 Specifying Tooltips for Members
8.11 Specifying the Sort Order for Members
8.11.1 For a Data Level
8.11.2 For a Time Level
8.12 Making the Member Names Localizable
8.13 Defining Dependencies Between Levels in Different Hierarchies
8.13.1 Example
8.14 Specifying the Field Names in the Fact Table
Chapter 9: 
  9.1 Adding a Property
9.1.1 Defining a Property for a List-Based Level
9.1.2 Specifying a Format String
9.2 Getting a Property Value at Runtime
9.3 Changing the Order of Properties in a Level
9.4 Specifying the Column Names in the Dimension Tables
9.5 Special Uses for Properties
Chapter 10: 
  10.1 Adding a Measure
10.2 Specifying the Measure Type
10.3 Specifying How to Aggregate a Measure
10.4 Specifying a Searchable Measure
10.5 Specifying a Format String
10.5.1 Format String Field
10.5.2 Color Piece
10.6 Specifying a Format String for a Date Measure
10.7 Changing the Order of Measures in the Cube
10.8 Specifying the Field Names in the Fact Table
10.9 Specifying Additional Filtering for Listings
10.9.1 Example
Chapter 11: 
  11.1 Adding a Listing
11.2 Defining a Simple Listing
11.2.1 Additional Options
11.3 Defining a Data Connector Listing
11.4 Defining an SQL Custom Listing
11.5 Defining a Map Listing (Geo Listing)
Chapter 12: 
  12.1 About User-Defined Custom Listings
12.2 Creating a Listing Field
Chapter 13: 
  13.1 Defining a Calculated Measure
13.2 MDX Recipes for Calculated Measures
13.2.1 Measures Based on Other Measures
13.2.2 Measure That Uses a Pivot Variable As a Multiplier
13.2.3 Percentages of Aggregate Values
13.2.4 Distinct Member Count
13.2.5 Semi-Additive Measures
13.2.6 Filtered Measures
13.2.7 Measures That Use KPIs or Plugins
13.3 Defining a Calculated Member (Non-Measure)
13.4 MDX Recipes for Non-Measure Calculated Members
13.4.1 Defining Age Members
13.4.2 Aggregating Members
13.4.3 Aggregating Ranges of Dates
13.4.4 Defining an Aggregation of Members Defined by a Term List
13.4.5 Defining a Member for Filtering on Multiple Dimensions
13.5 Specifying Additional Filtering for Listings for a Calculated Measure
Chapter 14: 
 
Chapter 15: 
  15.1 Introduction to Subject Areas in the Architect
15.1.1 Model Viewer
15.1.2 Details Area
15.2 Defining a Subject Area
15.3 Filtering a Subject Area
15.3.1 Building a Filter in the Analyzer and Copying It into Your Model
15.3.2 Writing Filter Expressions
15.4 Specifying Other Subject Area Options
15.5 Adding Items to a Subject Area
15.6 Defining an Override for a Measure
15.7 Defining an Override for a Dimension, Hierarchy, or Level
15.8 Redefining a Listing or Adding a New Listing
15.9 Compiling a Subject Area
Chapter 16: 
  16.1 Introduction to Listing Groups
16.2 Accessing the Listing Group Manager
16.3 Adding a Listing Group
16.3.1 Modifying Details of the Listing Group
16.4 Displaying a Listing Group
16.5 Adding a Listing to a Listing Group
16.6 Modifying a Listing
16.7 Removing a Listing from a Listing Group
16.8 Compiling a Listing Group
16.8.1 Possible Compile Errors
16.9 Deleting a Listing Group
 
Appendix A: 
  A.1 Requirements for a Cube Class
A.2 Common Attributes in a Cube
A.3 <cube>
A.4 <measure>
A.4.1 %COUNT Measure
A.4.2 Measures Dimension
A.4.3 formatString Details
A.5 <dimension>
A.6 <hierarchy>
A.7 <level>
A.7.1 Linking to Another Table
A.7.2 Specifying a Date Offset
A.7.3 Defining a Basic Range Expression
A.7.4 Defining a Compact Multi-Range Expression
A.8 <member>
A.9 <property>
A.9.1 Intrinsic Properties
A.10 <listing>
A.11 <listingField>
A.12 <calculatedMember>
A.13 <namedSet>
A.14 <relationship>
A.15 <expression>
A.16 <index>
Appendix B: 
  B.1 Requirements for a Subject Area Class
B.2 Common Attributes in a Subject Area
B.3 <subjectArea>
B.3.1 Filtering a Subject Area
B.4 <measure>
B.5 <dimension>
B.6 <hierarchy>
B.7 <level>
B.8 <listing>
B.9 <calculatedMember>
B.10 <namedSet>
Appendix C: 
  C.1 Fact Table
C.1.1 Field Names
C.1.2 Reuse of a Source Property in the Fact Table
C.2 Dimension Tables
C.2.1 Name of Dimension Table
C.2.2 Columns in a Dimension Table