Advanced DeepSee Modeling Guide
- About This Book
- Defining Computed Dimensions
- Defining Shared Dimensions and Compound Cubes
- Overview
- Defining a Formally Shared Dimension
- Defining an Informally Shared Dimension
- Defining Compound Cubes
- Defining Cube-Cube Relationships
- Overview of Relationships
- Defining a One-Way Relationship
- Defining a Two-Way Relationship
- Building Cubes That Have Relationships
- Using Model Browser
- Removing Relationships
- Using Unstructured Data in Cubes (iKnow)
- Overview of iKnow/Cube Integration
- Setting Up the Aviation Events Demo
- Defining an iKnow Measure
- Loading and Updating iKnow Dictionaries
- Defining an iKnow Entity Dimension
- Defining an iKnow Dictionary Dimension
- Adding Member Overrides to an Item Level
- Adding Measures That Use iKnow Plugins
- Including iKnow Results in Listings
- iKnow Domain Management in DeepSee
- Advanced Topics
- When iKnow Updates Occur
- Defining Term Lists
- Overview of Term Lists
- Accessing the Term List Manager
- Defining a Term List
- Specifying the Pattern for a Term List
- Exporting and Importing Term Lists
- Deleting a Term List
- Accessing Term Lists Programmatically
- Defining Worksheets
- Defining Quality Measures
- Overview of Quality Measures
- Introduction to the Quality Measure Manager
- Creating a Quality Measure
- Specifying the Expression for a Quality Measure
- Editing Other Information for a Quality Measure
- Defining a Linked Quality Measure (Quality Measure Alias)
- Checking the Expression for a Quality Measure
- Deleting a Quality Measure
- Defining Basic KPIs
- Introduction to KPIs
- Choosing Between MDX and SQL
- Structure of a KPI Result Set
- Defining a KPI with a Hardcoded Query
- Specifying Class Parameters
- Specifying Ranges and Thresholds for Speedometers
- Disabling the %CONTEXT Filter
- Defining KPIs with Filters and Listings
- Introduction to Filters
- Creating Interoperable Filters
- Defining Filters in an MDX-Based KPI
- Defining Filters in an SQL-Based KPI
- Other Options for Defining Filter Names and Items
- Modifying an MDX Query to Use Filter Values
- Modifying an SQL Query to Use Filter Values
- Additional MDX KPI Examples
- Defining a Listing for a KPI
- Defining Advanced KPIs
- Defining Plugins
- Introduction
- Requirements for a Simple Plugin
- Implementing %OnCompute()
- Indicating State of Completion
- Creating a Plugin for Multiple Cubes
- Filtering the Listing
- Available Error Logging
- Defining a Calculated Member That Uses a Plugin
- Using Cube Inheritance
- Introduction to Cube Inheritance
- Cube Inheritance and the Architect
- The %cube Shortcut
- Hiding or Removing Items
- Inheritance and Relationships
- Defining Intermediate Expressions
- Defining and Using Intermediate Expressions in Studio
- Defining Intermediate Expressions in Architect
- Other Options
- Specifying maxFacts in the Cube Definition
- Restricting the Records Used in the Cube
- Manually Specifying the Members for a Level
- Adding Custom Indices to the Fact Table
- Customizing Other Cube Callbacks
- Filtering a Cube or Subject Area Dynamically
- Reference Information for KPI and Plugin Classes
- Generating Secondary Cubes for Use with iKnow