Defining DeepSee Models

• About This Book
• Introduction
• Purpose of DeepSee
• Introduction to DeepSee Models
• Introduction to the Model Development Process
• Introduction to the DeepSee Architect
• Basic Concepts
• Introduction to Cubes
• Dimensions, Hierarchies, and Levels
• Properties
• Measures
• Listings
• Calculated Members
• Subject Areas
• Filters
• How DeepSee Builds and Uses Fact Tables
• How DeepSee Generates Listings
• Summary of Model Options
• Items That You Can Use in Pivot Tables
• Items That You Can Use in Calculated Members and Measures
• Comparison of Possible Widget Data Sources
• High-Level Summary of Options
• Principles and Recommendations
• Choosing a Base Table
• Choosing the Form of the Base Table
• Avoiding Large Numbers of Levels and Measures
• Defining Measures Appropriately
• Understanding Time Levels
• Defining Hierarchies Appropriately
• Defining Member Keys and Names Appropriately
• Avoiding Very Granular Levels
• Using List-Based Levels Carefully
• Handling Null Values Correctly
• Usability Considerations
• Considerations with Multiple Cubes
• Recommendations
• Defining Cubes
• Defining a Cube
• Possible Source Classes for a Cube
• Other Cube Options
• Adding Items to a Cube
• Names for Model Elements
• Other Common Options
• Compiling and Building a Cube
• Opening a Cube in the Analyzer
• Deleting a Cube
• Compiling and Building Cubes
• When to Recompile and Rebuild
• Compiling a Cube
• Building a Cube
• Building the Cube Programmatically
• Minimizing Cube Size During Development
• Using Parallel Processing During a Cube Build
• Build Errors
• DeepSee Task Log
• Defining Dimensions, Hierarchies, and Levels
• Overview
• Creating a New Dimension, Hierarchy, and Level
• Adding a Hierarchy and Level
• Adding a Level
• Defining the Source Values for a Dimension or Level
• Details for Source Expressions
• Changing the Order of Dimensions in the Cube
• Changing the Order of Levels in a Hierarchy
• Validating Your Levels
• Details of Defining Levels
• Ensuring Uniqueness of Member Keys
• Specifying the Null Replacement String for a Level
• Defining a List-Based Level
• Defining a Time Level
• Defining Custom Time Levels
• Defining an Age Level
• Specifying a Range Expression
• Configuring a Level to Use Display Values
• Using Property Values as the Member Names
• Specifying Tooltips for Members
• Specifying the Sort Order for Members
• Making the Member Names Localizable
• Defining Dependencies Between Levels in Different Hierarchies
• Specifying the Field Names in the Fact Table
• Defining Properties
• Adding a Property
• Getting a Property Value at Runtime
• Changing the Order of Properties in a Level
• Specifying the Column Names in the Dimension Tables
• Special Uses for Properties
• Defining Measures
• Adding a Measure
• Specifying the Measure Type
• Specifying How to Aggregate a Measure
• Specifying a Searchable Measure
• Specifying a Format String
• Specifying a Format String for a Date Measure
• Changing the Order of Measures in the Cube
• Specifying the Field Names in the Fact Table
• Specifying Additional Filtering for Listings
• Defining Listings
• Adding a Listing
• Defining a Simple Listing
• Defining a Data Connector Listing
• Defining an SQL Custom Listing
• Defining a Map Listing (Geo Listing)
• Defining Listing Fields
• About User-Defined Custom Listings
• Creating a Listing Field
• Defining Calculated Members
• Defining a Calculated Measure
• MDX Recipes for Calculated Measures
• Defining a Calculated Member (Non-Measure)
• MDX Recipes for Non-Measure Calculated Members
• Specifying Additional Filtering for Listings for a Calculated Measure
• Defining a Named Set
• Defining Subject Areas
• Introduction to Subject Areas in the Architect
• Defining a Subject Area
• Filtering a Subject Area
• Specifying Other Subject Area Options
• Adding Items to a Subject Area
• Defining an Override for a Measure
• Defining an Override for a Dimension, Hierarchy, or Level
• Redefining a Listing or Adding a New Listing
• Compiling a Subject Area
• Defining Listing Groups
• Introduction to Listing Groups
• Accessing the Listing Group Manager
• Adding a Listing Group
• Displaying a Listing Group
• Adding a Listing to a Listing Group
• Modifying a Listing
• Removing a Listing from a Listing Group
• Compiling a Listing Group
• Deleting a Listing Group
• Reference Information for Cube Classes
• Requirements for a Cube Class
• Common Attributes in a Cube
• <cube>
• <measure>
• <dimension>
• <hierarchy>
• <level>
• <member>
• <property>
• <listing>
• <listingField>
• <calculatedMember>
• <namedSet>
• <relationship>
• <expression>
• <index>
• Reference Information for Subject Area Classes
• Requirements for a Subject Area Class
• Common Attributes in a Subject Area
• <subjectArea>
• <measure>
• <dimension>
• <hierarchy>
• <level>
• <listing>
• <calculatedMember>
• <namedSet>
• Details for the Fact and Dimension Tables
• Fact Table
• Dimension Tables