Advanced DeepSee Modeling Guide
Contents
 
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

Preface : 
 
 
Chapter 1: 
 
  • 1.1 Defining SQL Computed Dimensions
  • 1.1.1 Example Computed Dimensions
  • 1.1.2 Defining a SQL Computed Dimension
  • 1.1.3 A Closer Look at the Example
  • 1.1.4 Variations for spec
  • 1.2 Defining MDX Computed Dimensions
  • 1.2.1 Defining a MDX Computed Dimension
  • 1.2.2 %OnGetComputedMembers()
  • Chapter 2: 
     
  • 2.1 Overview
  • 2.1.1 Shared Dimensions
  • 2.1.2 Compound Cubes
  • 2.2 Defining a Formally Shared Dimension
  • 2.3 Defining an Informally Shared Dimension
  • 2.3.1 Examples
  • 2.4 Defining Compound Cubes
  • 2.4.1 Detail Listings for Compound Cubes
  • 2.4.2 Example Compound Cube
  • Chapter 3: 
     
  • 3.1 Overview of Relationships
  • 3.1.1 A Look at a One-Way Relationship
  • 3.1.2 A Look at a Two-Way Relationship
  • 3.2 Defining a One-Way Relationship
  • 3.3 Defining a Two-Way Relationship
  • 3.4 Building Cubes That Have Relationships
  • 3.4.1 Determining the Build Order for Related Cubes
  • 3.4.2 Errors If You Build Related Cubes in the Wrong Order
  • 3.5 Using Model Browser
  • 3.6 Removing Relationships
  • Chapter 4: 
     
  • 4.1 Overview of iKnow/Cube Integration
  • 4.1.1 iKnow Terminology
  • 4.1.2 About iKnow Measures and Dimensions
  • 4.1.3 Generated iKnow Domains
  • 4.2 Setting Up the Aviation Events Demo
  • 4.2.1 Sample Dashboard
  • 4.2.2 A Closer Look at the Aviation Cubes
  • 4.3 Defining an iKnow Measure
  • 4.3.1 Alternative Technique: Using an Existing iKnow Domain
  • 4.3.2 Alternative Technique: Retrieving Unstructured Text from Elsewhere
  • 4.4 Loading and Updating iKnow Dictionaries
  • 4.4.1 Loading iKnow Dictionaries
  • 4.4.2 Updating iKnow Dictionaries
  • 4.5 Defining an iKnow Entity Dimension
  • 4.6 Defining an iKnow Dictionary Dimension
  • 4.7 Adding Member Overrides to an Item Level
  • 4.8 Adding Measures That Use iKnow Plugins
  • 4.8.1 Adding Measures to Quantify Entity Occurrences
  • 4.8.2 Adding Measures to Quantify Matching Results
  • 4.9 Including iKnow Results in Listings
  • 4.9.1 Including an iKnow Summary Field in a Listing
  • 4.9.2 Including a Link from a Listing to the Full Unstructured Text
  • 4.9.3 Creating a Specialized Listing for Use in iKnow Content Analysis Plugin
  • 4.10 iKnow Domain Management in DeepSee
  • 4.11 Advanced Topics
  • 4.11.1 Specifying iKnow Domain Parameters for a Measure
  • 4.11.2 Loading iKnow Black Lists
  • 4.11.3 Updating iKnow Black Lists
  • 4.12 When iKnow Updates Occur
  • Chapter 5: 
     
  • 5.1 Overview of Term Lists
  • 5.2 Accessing the Term List Manager
  • 5.3 Defining a Term List
  • 5.4 Specifying the Pattern for a Term List
  • 5.5 Exporting and Importing Term Lists
  • 5.5.1 Exporting a Term List
  • 5.5.2 Sample Term List File
  • 5.5.3 Importing a Term List
  • 5.6 Deleting a Term List
  • 5.7 Accessing Term Lists Programmatically
  • Chapter 6: 
     
    Chapter 7: 
     
  • 7.1 Overview of Quality Measures
  • 7.2 Introduction to the Quality Measure Manager
  • 7.3 Creating a Quality Measure
  • 7.4 Specifying the Expression for a Quality Measure
  • 7.4.1 Allowed MDX Expressions
  • 7.4.2 How Groups and Elements Are Combined
  • 7.5 Editing Other Information for a Quality Measure
  • 7.6 Defining a Linked Quality Measure (Quality Measure Alias)
  • 7.7 Checking the Expression for a Quality Measure
  • 7.8 Deleting a Quality Measure
  • Chapter 8: 
     
  • 8.1 Introduction to KPIs
  • 8.1.1 Ways to Use KPIs
  • 8.1.2 Comparison to Pivot Tables
  • 8.1.3 Requirements for KPI Queries
  • 8.2 Choosing Between MDX and SQL
  • 8.3 Structure of a KPI Result Set
  • 8.4 Defining a KPI with a Hardcoded Query
  • 8.5 Specifying Class Parameters
  • 8.6 Specifying Ranges and Thresholds for Speedometers
  • 8.7 Disabling the %CONTEXT Filter
  • Chapter 9: 
     
  • 9.1 Introduction to Filters
  • 9.2 Creating Interoperable Filters
  • 9.2.1 Filter Syntax for Pivot Tables
  • 9.2.2 Ways to Create Interoperable Filters
  • 9.3 Defining Filters in an MDX-Based KPI
  • 9.3.1 %OnGetFilterMembers() Details
  • 9.3.2 %GetMembersForFilter() Details
  • 9.4 Defining Filters in an SQL-Based KPI
  • 9.5 Other Options for Defining Filter Names and Items
  • 9.5.1 Specifying the Filter Names at Runtime
  • 9.5.2 Hardcoding the List of Filter Items via the valueList Attribute
  • 9.5.3 Retrieving the List of Filter Items via the sql Attribute
  • 9.5.4 Using Custom Logic to Build the List of Filter Items at Runtime
  • 9.6 Modifying an MDX Query to Use Filter Values
  • 9.6.1 Accessing Filter Values
  • 9.6.2 Converting Filter Values to MDX Expressions for Use in %FILTER
  • 9.6.3 Example
  • 9.7 Modifying an SQL Query to Use Filter Values
  • 9.7.1 %GetSQLForFilter()
  • 9.7.2 SQL KPI Example 1
  • 9.7.3 SQL KPI Example 2
  • 9.8 Additional MDX KPI Examples
  • 9.8.1 DemoMDXAutoFilters KPI
  • 9.8.2 DemoInteroperability KPI
  • 9.9 Defining a Listing for a KPI
  • 9.9.1 Example
  • Chapter 10: 
     
  • 10.1 Defining Manual KPIs
  • 10.1.1 Available Properties
  • 10.1.2 Overriding KPI Properties
  • 10.1.3 Defining a Manual Query
  • 10.2 Defining Cacheable KPIs
  • 10.3 Defining Asynchronous KPIs
  • Chapter 11: 
     
  • 11.1 Introduction
  • 11.1.1 How Plugins Can Be Used
  • 11.1.2 Available Plugin Classes
  • 11.1.3 Samples That Demonstrate Plugins
  • 11.2 Requirements for a Simple Plugin
  • 11.3 Implementing %OnCompute()
  • 11.4 Indicating State of Completion
  • 11.5 Creating a Plugin for Multiple Cubes
  • 11.5.1 Determining the Listing Fields Programmatically
  • 11.6 Filtering the Listing
  • 11.6.1 Example
  • 11.7 Available Error Logging
  • 11.8 Defining a Calculated Member That Uses a Plugin
  • Chapter 12: 
     
  • 12.1 Introduction to Cube Inheritance
  • 12.2 Cube Inheritance and the Architect
  • 12.2.1 Redefining an Inherited Element
  • 12.2.2 Removing an Override
  • 12.2.3 Adding a Local Element
  • 12.3 The %cube Shortcut
  • 12.4 Hiding or Removing Items
  • 12.5 Inheritance and Relationships
  • Chapter 13: 
     
  • 13.1 Defining and Using Intermediate Expressions in Studio
  • 13.1.1 Example
  • 13.2 Defining Intermediate Expressions in Architect
  • Chapter 14: 
     
  • 14.1 Specifying maxFacts in the Cube Definition
  • 14.2 Restricting the Records Used in the Cube
  • 14.2.1 %OnProcessFact() Callback
  • 14.3 Manually Specifying the Members for a Level
  • 14.3.1 XML Reserved Characters
  • 14.4 Adding Custom Indices to the Fact Table
  • 14.5 Customizing Other Cube Callbacks
  • 14.5.1 %OnAfterProcessFact() Callback
  • 14.5.2 %OnGetDefaultListing() Callback
  • 14.5.3 %OnExecuteListing() Callback
  • 14.5.4 %OnAfterBuildCube() Callback
  • 14.6 Filtering a Cube or Subject Area Dynamically
  •  
    Appendix A: 
     
  • A.1 Basic Requirements
  • A.2 Common Attributes in a KPI or Plugin
  • A.3 <kpi>
  • A.4 <property>
  • A.5 <filter>
  • A.6 <action>
  • Appendix B: 
     
  • B.1 Entity Occurrence Cube
  • B.2 Matching Results Cube