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
- 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