Defining DeepSee Models
Contents
 
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

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, Plugins, or Worksheets
  • 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